About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Why do I not have access to my Google Spreadsheets?

  • 18 July 2023
  • 5 replies
  • 379 views
Pebje01

I'm currently trying to set up a Zap that involves my Google Sheets. (E-mail a back-up of the sheet with MaxScheduler)

However, when I try to select a spreadsheet, I only see spreadsheets that are not owned by me. I have already given Zapier permission to access my Google Sheets, and I've made sure that I'm using the correct Google account. Despite this, I can't seem to find or select my own spreadsheets from my Google Drive when setting up a Zap. Could anyone please help me understand why this is happening and how I can make my own spreadsheets visible in Zapier? Thank you.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Pebje01 

Good question.

The spreadsheet I want to use doesn't appear in the dropdown menu

If your spreadsheet doesn't appear in the Spreadsheet dropdown menu, check its file format.
Google Sheets can open and edit .XLSX files, but Zapier can't open them. To fix this:

  1. In Google Sheets, save the file as a Google spreadsheet.
  2. In Zapier, click the Spreadsheet dropdown menu.
  3. If your spreadsheet doesn’t appear in the dropdown menu, click Load More.
  4. Select your spreadsheet name.
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
V

Hi!  I have done all these steps.  My sheet STILL does not appear in the list of spreadsheets.
I watched a video and the person indicated that spreadsheets with formulas won’t work. Therefore, they won’t show up in the list of spreadsheets.  Is this a fact?  There is no workaround? 

Troy Tessalone
Userlevel 7
Badge +14

@Virginia 

Depends on how the GSheet is configured.

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
BiteBack

Hi,

 

I am having the same issue. We use google as a standard so the sheet is already definitely a google sheet.

 

I was also an editor in the sheet. But just to be sure I then created my own Google Sheet but this one also did not appear. It does not appear when I click load more nor when I search for the spreadsheet by its name.

 

Can you help?

 

Christin

Troy Tessalone
Userlevel 7
Badge +14

Hi @BiteBack 

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Might be best to post your own topic and include screenshots.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions