How to write a python script to manipulate google spreadsheet data

python google-sheets gspread
GeminiDNK picture GeminiDNK · Mar 4, 2010 · Viewed 14k times · Source

I am able to get the feed from the spreadsheet and worksheet ID. I want to capture the data from each cell.

i.e, I am able to get the feed from the worksheet. Now I need to get data(string type?) from each of the cells to make a comparison and for input.

How exactly can I do that?

Answer

Warwick picture Warwick · Dec 12, 2011

There's another spreadsheet library worth to look at: gspread. I've used Google's data libary mentioned above and to me the provided api is weird. You need to extract spreadsheet's key to start working with this spreadsheet.

Here it's a way simpler. If you need to fetch the data from a cell you can just open a worksheet and get the value:

g = gspread.login('[email protected]', 'password')

worksheet = g.open('name_of_the_spreadsheet').get_worksheet(0)

# Say, you need A2
val = worksheet.cell(2, 1).value

# And then update
worksheet.update_cell(2, 1, '42')

Related questions

Python/gspread - how can I update multiple cells with DIFFERENT VALUES at once?

To update a range of cells, you use the following command. ## Select a range cell_list = worksheet.range('A1:A7') for cell in cell_list: cell.value = 'O_o' ## Update in batch worksheet.update_cells(cell_list) For my …

Read More
How to delete/remove row from the google spreadsheet using gspread lib. in python?

I want to delete a record from a google spreadsheet using the gspread library. Also, how to can I get the number of rows/records in google spreadsheet? gspread provides .row_count(), which returns the total number of rows, including …

Read More
How do I access (read, write) Google Sheets spreadsheets with Python?

I am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet using python. I did look at google docs API here https://developers.google.com/google-apps/spreadsheets/ but not sure if …

Read More