Google Sheets module returning 403 PERMISSION_DENIED error when selecting spreadsheet

Questions
,
1

:bullseye: What is your goal?

Google Sheets module returning 403 PERMISSION_DENIED error when selecting spreadsheet

:thinking: What is the problem & what have you tried?

I want to connect my Google Sheets module in Make to read and update rows from my spreadsheet, but the module fails when trying to select or browse the file.

:clipboard: Error messages or input/output bundles

I tried reconnecting and reauthorizing the Google account connection in Make, and checked my Google Cloud permissions. However, clicking on the spreadsheet dropdown still triggers a 403 error. I haven’t mapped the Spreadsheet ID manually yet.

:link: Create public scenario page

403: Caller is not authorized or method not allowed / PERMISSION_DENIED

3

Hey Mohamad,

are you connecting a personal or business account? And did you follow Sam’s guide on how to do it?

5

The fact that the 403 appears when you open the spreadsheet dropdown is useful: first separate the file-browsing step from access to the sheet itself. In the module, change Search method to Enter manually, copy the spreadsheet ID between /d/ and /edit in the sheet URL, and run the module. Make documents Enter manually as a supported search method and shows how to extract the ID: Google Sheets modules - Apps Documentation

If the module works with the manual ID, the failure is limited to the browse/list path. If the module also returns 403 with the manual ID, please add whether this is a personal Google account or a Workspace account, and whether you used Make’s standard connection or custom OAuth. Those details are needed before blaming a specific Google Cloud permission.