Nope, still stuck. I’ve tried a no-auth and an auth data source and get two different errors:
Error connecting to REST Data Source at URL “https://spreadsheets.google.com/feeds/list/(sheetID)/od6/public/full”: DriveSorry, unable to open the file at this time. Please check the address and try again. Get stuff done with Google DriveApps in Google Drive make it easy to create, store and share online documents, spreadsheets, presentations and more.Learn more at Personal Cloud Storage & File Sharing Platform - Google.
Error connecting to REST Data Source at URL “https://spreadsheets.google.com/feeds/list/(sheetID)/od6/public/full”: Unable to authenticate to data source “REST-drive-auth”: Login has been cancelled
It’s highly likely I made an error configuring authentication, so I’d prefer to keep hammering on the no-auth option, which should be fine since the sheet is published on the web and can be retrieved using Postman and opening in anonymous browsers.
Would love any tips.
-John
