Anyone had success with Google Sheets?

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.

Hi,

Our apologies for the delay. We’ve responded to your emails—please check your inbox.

This has been resolves. Thanks for your email. I went back through the entire process of setting up Google again and it now works.