Sign in to join the conversation:
I am looking at ways I can automate export a smartsheet to excel at regular frequencies.
I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content.
Any ideas?
Hi Sudeep,
You can probably use a third-party solution like Zapier or similar. Zapier has an action that can send a sheet as an Excel attachment.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
The question is whether you'd like to just pull data from your sheet to excel on regular basis or create excel export to new file?
If just pull data, then you can do it within excel's power query functionality which is quite easy if you learn how to do it.
If create export to excel file each time, then as Andree said, you have to use some 3rd party solution or some api plugin.
@ Marcin P - Could you explain how to connect power query to Smartsheet? I’ve attempted to do so in the past and was unsuccessful.
Appreciate your input in advance.
Justin
@jdupes
I found this Reddit post outlining how to pull smartsheet data into Excel via Power Query. Hopefully that helps!
https://www.reddit.com/r/excel/comments/97tsbs/how_to_connecting_excel_power_query_to/
Hi Erik,
Excellent resource!
Thanks for sharing!
Workflow Consultant / CEO @ WORK BOLD
Does anyone know the coding that would be needed to connect to a report rather than a sheet?
Reviving this old thread. There is a premium App - Data shuttle that can automate an import AND EXPORT . You map the columns that you want to export, i.e. pick and choose which get import/exported
You can have the files export - local, GDrive, or OneDrive
https://www.smartsheet.com/marketplace/premium-apps/data-shuttle
I also just got the Smartsheet Live Data Connector working for this very situation. I needed to automatically update a report for pickup by an automated FTP upload process. Works perfectly from a Smartsheet report to an Excel file via an ODBC connection and Excel PowerQuery.
Smartsheet Live Data Connector (smartsheet-platform.github.io)
It took a good bit of head banging, but I figured out how to get report data into Excel via power query by setting up the source like this:
= Web.Contents("https://api.smartsheet.com/2.0/reports/YOUR_REPORT_ID?level=3&include=objectValue", [Headers=[Authorization="Bearer YOUR_API_TOKEN", Accept="application/vnd.ms-excel"]])
Just sub your Report ID and your API Token in the script above. The query brought in two tables for me, one for the report data and another for the comments, I just picked the one I wanted and went on from there.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
