0

Google Sheets + Circuit Python
Moderators: adafruit_support_bill, adafruit

Please be positive and constructive with your questions and comments.

Google Sheets + Circuit Python

by Freeno83 on Tue Feb 09, 2021 4:17 pm

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

Freeno83
 
Posts: 8
Joined: Sat Apr 04, 2020 6:31 pm

Re: Google Sheets + Circuit Python

by kattni on Tue Feb 16, 2021 5:11 pm

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.

kattni
 
Posts: 91
Joined: Fri Aug 18, 2017 6:33 pm

Re: Google Sheets + Circuit Python

by snahtajain on Wed Feb 17, 2021 5:02 am

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.

snahtajain
 
Posts: 1
Joined: Wed Feb 17, 2021 4:55 am

Please be positive and constructive with your questions and comments.