Google Sheets + Circuit Python Moderators: adafruit_support_bill, adafruit

[Freeno83]

I am researching how to read and write from google sheets using circuit python. So far the example which I think is closest to what I'm looking for is here:

https://github.com/artem-smotrakov/esp32-weather-google-sheets

I wanted to ask here if anyone has any other good examples for working with google sheets from circuit python.

Thanks,

Nick

[kattni]

This is an example of parsing Google Sheets data using CircuitPython. https://learn.adafruit.com/collaborativ ... -to-magtag

I am unaware of an example of writing to a spreadsheet, but that does not mean it isn't possible.

[snahtajain]

Hi,

Installation pip install pygsheets.
Authorization import pygsheets. ...
Authorize and open a spreadsheet import pygsheets. ...
Get spreadsheet title sh.id # Returns id of spreadsheet.
Get spreadsheet id sh.title # Returns title of spreadsheet.
Get spreadsheet url sh.url # Returns url of spreadsheet.