Sync / integration of Google Sheet with Smart Sheet

Anne Bolsius

Hi all,

I'd like to update a sheet in Smartsheet automatically with data from a Google Sheet where we maintain finance data. When the Google Sheet is updated, I'd like the sheet in Smartsheet and also the dashboard connected to it, refresh automatically. Is there a good solution for this?

Thanks!

Kind regards,

Anne

Bassam Khalil

Hi @Anne Bolsius 

Hope you are fine, please check the following add Connect Critical Enterprise Systems with Data Uploader

https://www.youtube.com/watch?v=czfaNTMG0T0&feature=emb_logo

Anne Bolsius

Hi Bassam,

Thanks for this! I wasn't aware of this data uploader, looks good and seems to solve my issue, but I don't think I will go to a Premium package (not sure how much that would be....) just to link 1 Google Sheet.

Any other ideas? :-)

Thanks!

Anne

Andrée Starå

Hi @Anne Bolsius

I hope you're well and safe!

To add to Bassam's excellent advice/answer.

How much information is there in the Google Sheet, and how often is it updated?

As a possible workaround, you could use a method I used with a client recently. A so-called Import/Update Sheet, or a 3rd party solution like Zapier.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

JeremiahHorstick

Hi Anne Bolsius. My team successfully completed this today!

Very simply populate a G Sheet from a Smart Sheet.

nRJetic_Solutions

@JeremiahHorstick I think she wanted a Google Sheet to populate a Smartsheet Sheet. Personally I would just like to build a stock index connected sheet for managing my covered call investment strategies. I’m probably going to drop my Smartsheet account in favour of G-Suite, no reason to have both. Even though I think Smartsheet is better in so many ways. Unless I develop my own tools just for Smartsheet.