Send data from Ardunio nano 33 IoT to google sheet

Projects General Guidance
1

Hello community,

I’ve been working on a project for several hours and haven’t been able to find a solution. I hope someone can help me.

I’m trying to send temperature data to a Google Sheets from an Arduino Nano 33 IoT. I’ve created a Google Apps Script that receives the data and puts it into the sheet, and it works fine if I authenticate myself, but when I try to send the data from the Arduino, it doesn’t work because I can’t authenticate, and I don’t know how to do it.

Does anyone know how to send this data from the Arduino?

Thanks in advance!

2

Maybe ask the same question in the Google Apps support site.

3

Take a look at this article: Sending ESP8266 sensordata to GoogleSheet – Arduino, ESP8266, ESP32 & Raspberry Pi stuff
They then updated it here: Sending sensor data to Googlesheets – Arduino, ESP8266, ESP32 & Raspberry Pi stuff

It talks about settings to allow your arduino to talk to the app.