Here is the working project…
https://x.thunkable.com/copy/8f9209b8af7ecad132a27d0eb4253bc3
To use it you will need to go to https://console.developers.google.com/apis/credentials and create both an API key and a OAuth 2.0 client ID which is authorized for a web application. You’ll also need a spreadsheet ID and a sheet name (the default is “Sheet1”).
To be honest, I don’t remember which steps were important versus those which led me in the wrong direction since there is more bad advice out there than good advice.
If anyone out there wants to figure out the minimum number of steps and create documentation, I’m sure a lot of people would appreciate it.