Using Python to connect to READ, ADD, UPDATE, DELETE from Smartsheet

FOttolini

Dear Colleagues,

I definitely need your help.

I am using the example https://github.com/smartsheet-samples/python-read-write-sheet/blob/master/python-read-write-sheet.py to connect to Smartsheet, but the end is always a new Sheet ID with the data I retrieved from Excel.

What I want to do:

Connect to a specific Sheet ID;

Retrieve rows, columns, cells as needed (READ);

ADD, UPDATE, DELETE cells, columns, rows to a specific Sheet ID.

I have tried my best to try to make it work. I just can't. Can you please help? It is really important for a project I am working on.

Thanks in advance for all your help.

Kind Regards,

Fabio Ottolini

Genevieve P.

Hi @FOttolini

It sounds like you're using the API to Import a sheet, which will always create a new sheet, as you've found (see the UI explanation, here: Import Files to Create New Sheets)

Instead you'll want to use Get Sheet to retrieve information, and then use one of the Update commands for when you want to update that specific sheet.

• Get Sheet
• Update Rows
• Update Column

Cheers,

Genevieve

FOttolini

Thanks a lot! Very useful indeed. The problem with the example I have sent is that as an inexperienced Smartsheet user, it seems there is something obscure going on. Again, thank you!

SteveW

Hi Genevieve,

I'm looking for a solution similar to the above. Would like to automate (daily) updating a sheet, report, then widget on the Dashboard. Sounds like this can be done through the API (at least mostly), but not through the UI.. Am I correct? I see references to using Data Shuffle but would rather code it and have some flexibility in use and customization.

Thanks,

Steve

Genevieve P.

Hi @SteveW

If you update an underlying sheet, that will automatically update a Report and Dashboard using that sheet as the source. 🙂

The way that you automate updating the sheet will depend on where your data is stored. You can use the API, yes!

Cheers,
Genevieve

SteveW

Hi Genevieve,

Thank you so much for the feedback, and so quickly! Now I know the path forward we need to take. No doubt you'll be hearing from me. Thanks again for the fast update!

Steve