I’ve been trying to set up a Google Sheets trigger, but the sheet I uploaded to Google Drive doesn’t appear in the list. Instead, it shows files that I don’t even have. I have no idea where this trigger is pulling its information from. Please help!
I have granted all four permissions and reconnected, but the issue persists. I have also enabled all three APIs:
Cloud Resource Manager API, Google Sheets API, and Google Drive API.
Try accessing the sheets document by ID.
You will find the doc’s ID in its url. It is a string of 44 random characters between two / characters in the url.
If you still cannot access the file by its ID then most likely the account you use to connect has no access to that file.
Other files in the list that you can see could be those shared with you by someone. Identifying a file by ID is a more reliable option.