"JSON.parse: unexpected character at line 1 column 1 of the JSON data" on deploy

[kixxalot]

I followed the "nocode" guide to deploy using Netlify. When accessing the deployed app, the following error is displayed:

something went wrong, see below for error

JSON.parse: unexpected character at line 1 column 1 of the JSON data

please reload the page

I do believe I correctly entered the environment variables.

[kixxalot]

Never mind, the Google sheet had not actually been shared with the google service account. Fixing this solved the issue.