Connect Smartsheet with Datastudio

Corentin Dal Farra
Corentin Dal Farra ✭✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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