Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am currently setting up an automation using Zapier, where I want to connect Facebook Lead Ads to Google Sheets. The goal is to automatically send new lead data into a specific Google Sheet whenever a form is submitted on Facebook. However, I am facing an issue where my desired Google Sheet is not appearing in the list of available spreadsheets within Zapier.

I have already connected my Google Drive account to Zapier, and I have confirmed that the Google Sheet exists in my drive. I have full access to the sheet, and I am logged into the correct Google account that owns the file. Despite refreshing the list multiple times and even trying to search the sheet by its exact name, Zapier is still unable to detect or display it.

The spreadsheet is not located in a Shared Drive and is stored directly under “My Drive.” I have also verified that the file is not hidden, protected, or restricted in any special way. It is a regular Google Sheet with at least one worksheet tab inside.

I have tried clicking "Refresh results" and "Load more" several times within Zapier’s interface, but my Google Sheet still does not appear in the list of options. I’ve also checked for any permission issues, but everything seems to be in order.

At this point, I’m unable to proceed with creating my automation due to this issue. I would greatly appreciate any help in resolving this, or if there are any additional steps I should take to make the Google Sheet visible in Zapier.

The issue is not solved."

Hi ​@Cynor digital 

Help links for using GSheets in GDrive: https://zapier.com/apps/google-sheets/integrations#help

Make sure to select a Drive.

You can try using the GSheet ID (from the browser URL) in the Spreadsheet field using the [...] button to switch to “Custom” mode, then enter a static value of the GSheet ID.

 

Terms & ConditionsAccessibility statement