I am trying to maintain a gear spreadsheet for our raid roster.
This pulls data from the character API and displays it in a GoogleSheet.
I’m now getting 403 when trying to pull the data.
I suspect this is due to using the client credentials flow.
I am unable to use the authorization code flow due to everything running inside a spreadsheet. Redirecting to a Blizzard player login page is not an option, nor is hard-coding a BNET username/password inside the sheet.
I find myself stuck at this point.
Any suggestions, or is our guild’s spreadsheet dead?