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?
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, position 0." error when using the C# SDK. the full log message is: - 2025-09-18 09:58:54 *** Exception in 'ProcessShares(Entity, EntityName, EntityId, Counter, ssWorkspace)' 2025-09-18 09:58:54 1 'ShareResources.ListShares()'…