Best way to grab rows from a column and add their value to a list or dictionary in Python?

DougSmartsheetDev

There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?

Genevieve P.

Hi @DougSmartsheetDev

It sounds like you're using Get Sheet to grab the sheet content, is that correct?

If so, you can then use the Column ID to get data from that specific column. If it's a Contact column, the email in each cell will show up as the "value" under that Column ID in the Rows array (with the name associated with the contact set as the "displayValue").

Here's the API documentation on this: https://smartsheet.redoc.ly/tag/sheets#operation/getSheet

Cheers,

Genevieve