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?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…