A few dozen tries and a lot less hair, but I’m now pushing data to Google Sheets.
I’m tired, but happy. I’ll explain tomorrow but in short it was a script editor thing, how you run and deploy/update scripts is important.
Going to sleep like a rock tonight
Thanks everyone for your help