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 need to connect Google Excel (Google Drive) to Smartsheet so that I can have updated data on Smartsheet.
I need to know what is the best solution.
Smartsheet connector is a one way connection - From Smartsheet to Excel(or other App). It cannot pull info from External sources. For that you need to use other Apps. Which is best for you will depend on what you need to do and what your budget is. Some example s are:
Azuqua :https://www.smartsheet.com/apps/azuqua
Zapier :https://www.smartsheet.com/apps/zapier
Appsheet: https://www.smartsheet.com/apps/appsheet
There are Others depending on exactly what you need to achieve.
Visit :https://www.smartsheet.com/apps
Hi @Mark99 - This is a great post! I work at an iPaaS company called Azuqua which works to solve automation and integration problems like this. Would you mind telling me what exactly you're looking to do with Google Drive and Smartsheet?
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
This solution updates a column formula across multiple sheets in a workspace. The script finds all sheets with a certain string in the name, finds a certain column by name on those sheets, and then updates all column formulas to a new column formula. At the time of posting, Control Center Global Updates did not allow me to…
We have a webhook created in one of our Smartsheets, and we've been noticing lately that the webhook callbacks immediately disables the webhook after 1 try, causing data discrepancies between the Smartsheet and the system it sends the data to. Here's an excerpt JSON message received from Smartsheet showing the callback…