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'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.

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.

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? 

@Virginia 

Depends on how the GSheet is configured.

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

 

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

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.

 

Reply


Terms & Conditions