Connect Smartsheet with Datastudio

Corentin Dal Farra

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

Alex Argumedo

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.

Corentin Dal Farra

Hi @Alex Argumedo

Thank you for your reply,

I will look at the API possibility in that case.

Have a nice day,

Corentin