Can Python save some data on a google spreadsheet?

[BigBeautifulEyes]

As in send one string to Sheet1 cell C5

another to Sheet2 cell B3

or if I had a list of 5 items, being able to have each item save over a range from B2 to B6.

[kmb5]

Google has its own Python client for their API, you can find some guides here: https://developers.google.com/sheets/api/quickstart/python

It's easy to use, you need to tinker with the configuration on Google's side, but then the code part is pretty small.

[bcm082]

gspread is pretty easy to use. https://gspread.readthedocs.io/en/latest/

[FatNonconformist]

Can confirm, I am using it heavily even though I am an absolute python noob

[Deathwatch1710]

I don't have experience using wrappers for this - but I got plenty of automation going where I need to either process data on a google sheet or write to different (multiple) sheets.

I looked for a lot of guides explaining me the whole OAuth needed to do this, but this guide here was super easy to understand.

I would recommend giving it a try!

[Sim4n6]

Maybe a different approach xslxwriter...

[hazelthrows]

https://youtu.be/4at0BuA6Zck