Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello, I have a task board in smartsheet that my team uses to track work. We have a third part application we use to track metrics and it only integrates with google sheets. Not smartsheet. Is there a way to have smartsheet data sync to a google sheet?
Yes! You could consider using something like Zapier - they have done a lot of the "heavy lifting" for you with connections pre-built and then it's a matter of defining the trigger and action. For example, I have used zapier to integrate Smartsheet + Airtable for storing data and then sending client facing emails (using a html template) which looks a lot better than the standard Smartsheet generated emails!
See example screenshot.
Sean
@sean59916 I can't seem to figure out Zapier's triggers to appropriately sync google sheets with a simple smartsheet. Any chance you'd be willing to discuss off here?
Hi @Ryan Matthews
Did you get it working or do you still need help?
Be safe and have a fantastic weekend!
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!
Has anyone tried the Smartsheet Live Data Connector?
This is hot on our todo list.
I have a workspace that I am looking to move items from into a new workspace. The reason I want to do this is becasue there are individuals that have access to the original workspace that do not need access to everything that is currently in the workspace. In the original workspace is a MAIN document that holds all…
I'm looking for a way to attach notes to a sheet that isn't attached to a specific row. Rows for many of my sheets are cleared out in preparation for the next iteration of the project, and I need a notes/comments field that remains with the sheet even when the rows do not.
How to use Smartsheet AI/automation to automically write project status?