Can I importrange data from a Smartsheet into a Google Sheet?

Darianna Mills

Hi There,

Is it possible to have an importrange in a googlesheet that is pulling live data from a Smartsheet? This is what I am trying to achieve:

We need to implement a consultant request process. Requester fills out form with all necessary information, that is routed for approval from Ppl Ops, Finance, and Dept. Head, and then once approved, that info needs to feed into Legal's already established tracker in google sheets. I would set up an importrange on Legal's spreadsheet that would pull the approved data from Smartsheet (after approval, I can set it up in SS to have that line item move to a different SS so legal does not get the info while it is in the approval process).

Genevieve P.

Hi Darianna,

Smartsheet has a Premium Application called Data Uploader that can automatically pull rows from Google Sheets into Smartsheet, however there currently isn't a way to do the opposite from Smartsheet (live-syncing and exporting specific rows into Google Sheets).

You may want to look into using a third-party application like Zapier (see here). Hope this helps!

Cheers,

Genevieve

Genevieve P.

Hi Darianna,

Smartsheet has a Premium Application called Data Uploader that can automatically pull rows from Google Sheets into Smartsheet, however there currently isn't a way to do the opposite from Smartsheet (live-syncing and exporting specific rows into Google Sheets).

You may want to look into using a third-party application like Zapier (see here). Hope this helps!

Cheers,

Genevieve

Darianna Mills

Thank you, Zapier ended up doing the trick!