Smartsheet sync with Google Sheets?
Was wondering if there is a way to sync or connect Google Sheets & Smartsheet's to where if I made changes to my google sheet it would make those changes in Smartsheet. I tried using the Sheet Director Add-on for google sheets and worked fairly well in terms of whenever a user adds a row in Google Sheets it would post/update Smart Sheets, however if one was to delete a row that change would not show in SS. I'm not having any luck finding information on how to integrate the two applications, as I would like Smart Sheet to update based on changes to google sheet either add or delete data.
Any help on this subject matter would be greatly appreciated.
John C.
Answers
-
Hi John,
Bidirectional changes with Google Sheets isn't possible at this time. If you have Data Uploader you can automate loading your Google Sheet changes into Smartsheet, link below.
Mark
https://www.smartsheet.com/marketplace/premium-apps/data-uploader
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's lin…
- Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form conne…
- I setup a new Smartsheet and am connecting it to Jira Cloud. All fields are syncing properly except the Team field. I have the column set up as text number but have also tried it as a Drop Down list. …
