Hi Zapier Team,
We’re currently facing an issue while trying to connect our Google Sheets account in one of our Zaps.
Here’s the exact flow setup:
-
Trigger: Meta (Facebook) Lead Ads — New Lead
-
Action: Google Sheets — Create Spreadsheet Row
After connecting the Google Sheets account successfully, in the “Spreadsheet” dropdown, it shows:
“No options are available. Confirm if you connected the right account or have permission to the data in the partner app.”
We have verified the following:
✅ The connected Google account has full edit access to the target sheet.
✅ The sheet exists and contains data (test rows and headers).
✅ The Zapier connection is refreshed, and permissions are re-granted.
✅ Tried “Refresh fields” and “Load more” multiple times — still nothing shows up.
✅ Tried both personal and shared drives — same result.
We’ve also tested by creating a new Google Sheet, but it still doesn’t appear in the dropdown.
Could you please help us troubleshoot why Zapier is not fetching available Google Sheets under our connected account?
Any guidance or fix would be really helpful — this issue is currently blocking our lead automation workflow between Meta Ads and Sheets.
Thanks in advance,
MC
