79434325

Date: 2025-02-12 20:10:43
Score: 1.5
Natty:
Report link

Since drive.file scope only lets your app interact with files that have been created by the app or explicitly shared with the app, you need to manually share the two sheets with your app’s service account.

Go to Google Drive->Locate both spreadsheets->Share them with your app's service account email (found in the Google Cloud Console under IAM -> Service Accounts)->Grant Editor access for the sheet you want to write to and Viewer access for the one you want to read from

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: DushKritoKari