smartsheet API

Greetings

Can someone please explain to me how APIs work ?

I am not familiar with many of the technical jargons used on the SMARTSHEET API link.

I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ?

Can I somehow read and write into my Smartsheet, using APIs ?

Thank you

Find more posts tagged with

Sheets

API and Developers

Healthcare

IT & Operations

Project Management

Comments

Andrée Starå

Hi,

API's can probably do what you need.

https://smartsheet-platform.github.io/api-docs/

What do you want to do? Can you describe it in more detail?

I would recommend starting to look at a third-party tool like Zapier or similar and if it can do what you need.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

C. Srinidhi Ragunathan

Greetings

I am handling a number of projects and making Gantt charts to track their progress.

The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem.

I was thinking if writing a code to read and write from my Excel files to update the Gantt charts would be possible so that, every time a change is made in the excel sheet, the Gantt chart gets updated.

Since Smartsheet is a cloud based platform, I would have to save my Excel sheets in Onedrive or Dropbox write? Or is it possible to link my Excel sheet when it is present in my Local C Drive ?

I am relatively new to coding so I am having difficulties understanding the terms in the link you have attached (atleast the introductory part).

Please let me know if APIs can be used. I was also looking into the new Data Uploader feature. Howver, since its a paid add on, I want to see if APIs can be used.

Thank you

Andrée Starå

Happy to help!

How did it go? Did you find a solution?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
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…
How to access the new end points via SDK
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, pos"
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()'…