Connect Smartsheet with Datastudio
Hello everyone,
I have a use case and I don't know how to proceed and find the best way to solve my problem.
Here is the use case :
I have a sheet in Smartsheet for request management.
I would like this sheet to automatically be pushed into a Datastudio report.
I was thinking about the following options, but maybe do you have some suggestions or feedback on this use case ?
- Use a dedicated connector made by a third party app (not free)
- Use live data connector ?
- Create an API development (extraction toward a Google Sheet that is the Datastudio data source)
- Use Data Shuttle to export the sheet into Google Sheet (currently we can only do an export on Excel or csv if I am right)
Please let me know if you have any ideas,
Have a great day, Corentin
Answers
-
It depends on your resources, API is the best from my point of view, because it will allow me to parse data at will due to a few restrictions (https://help.smartsheet.com/articles/770623-exporting-sheets-reports-from-smartsheet#google) in order to send to Google Sheet, you can extract the data from smartsheet, convert JSON to what ever is the best format for Google Sheet to consume it.
-
Thank you for your reply,
I will look at the API possibility in that case.
Have a nice day,
Corentin
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives