I’ve had a WiFi IOT device sending data to Google sheets from an ESP32 for 6 months. I’m trying to migrate to cellular for a number of sites. I followed the Google Sheets instructions from Sixfab to the letter. I actually tried it a total of 5 separate times on two different Google accounts (nonprofit and personal). I cannot get it to work but also found that it will not allow me to push the project to production stating
“Access Blocked: SensorData has not completed the Google verification process”. I get it but this is just using the add_row.py example from Sixfab. There is nothing to get verified. It looks like they want a privacy statement, Youtube video of the app walthrough, write-up, etc. There has to be an easier way. With Wifi on Arduino IDE I just went to the Google Console and created a service account. Why can’t this API work with those credentials?
I’m at a loss and may have to cancel the entire project. Any assistance would be greatly appreciated. I know it’s the holidays but I’m under a tight deadline just to evaluate the PicoLTE and I’ve not heard anything from Sixfab support.
1 Like
Hi,
Our apologies for the delay. We’ve responded to your emails—please check your inbox.
1 Like
This has been resolves. Thanks for your email. I went back through the entire process of setting up Google again and it now works.
1 Like