I have a script that collects data from an API and sends it to Google Sheets. However, every time I run it I get the 403 insufficient auth scopes error. My service account has Editor and Viewer roles, I even added Owner permissions for testing purposes but the code still fails with the same error. I have service account json in the same folder as my script thus i assumed the path is pretty straightforward. What could be wrong?

I have several projects in Google cloud that I am using to extract the data from Google Sheets using python. They run daily and refreshes the data in destination. Now this morning, one of the job failed and started throwing the error ‘{'code': 500, 'message': 'Internal error encountered.', 'status': 'INTERNAL'}’ in both staging and prod env.