ESP8622 Google Spreadsheet

All ESP8266 boards running MicroPython.
Official boards are the Adafruit Huzzah and Feather boards.
Target audience: MicroPython users with an ESP8266 board.
Post Reply
marestudio2004
Posts: 16
Joined: Thu Sep 30, 2021 9:45 am

ESP8622 Google Spreadsheet

Post by marestudio2004 » Thu Sep 30, 2021 10:10 am

Hello,

I am a beginner when it comes to microPytons and ECU.

Maybe someone has the basic code (as simple as possible) to read and write the Google spreadsheet.

I have activated the Google API for sheet and drive, it does everything right for me in Python, but via micropiton, not at all!

I searched a lot of codes on the net and I couldn't run any ...

This is my last attemp:

import network
import urequests

sta_if = network.WLAN(network.STA_IF)
if not sta_if.isconnected():
print('connecting to network...')
sta_if.active(True)
sta_if.connect('Skola_Azbresnica_WiFi', 'Seloazbresnica5')
while not sta_if.isconnected():
pass
print('network config:', sta_if.ifconfig())

res = urequests.get(url='https://docs.google.com/spreadsheets/d/ ... xxxxx.json')

print(res)

xxxxxxxxxx - my information about spreadsheet and .json security file...

Thanks!

Post Reply