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, I came across a blog mentioning that the Sheets folder feature has been deprecated. As SmartSheet users, we now need to migrate our sheet files and folders into workspaces. Additionally, when calling the API to list sheets, it returns all sheets within the account or profile. So, until it will be migrated to a…
Hello community, I'm experiencing several issues when using token-based pagination (paginationType=token) with the /workspaces API endpoint in Smartsheet: Using the same API Key (so same user), traditional pagination (page and pageSize) correctly returns the full result set (over 300 workspaces) and allows access to all…
In Smartsheet, I generate a token under my personal account settings and paste it into Tableau > More > Other Databases (ODBC) > Driver:Smartsheet Live Data Connector > Connect > Use API token for SSO login. However, the token doesn't work and I am returned with the following error: Your Access Token is invalid". How can I…
