Skip to main content
Best answer

Zapier Not showing Spreadsheet as option to select even though is connected to my Google Drive

  • May 12, 2020
  • 1 reply
  • 2077 views

I am connected to my Google Drive & trying to select a Spreadsheet in the “Spreadsheet “ section below. It does not show the Spreadsheet that I want even though I can see another Spreadsheet in my Drive. 

 

 

 

Best answer by AndrewJDavison_Luhhu

@milankc 

A few things to run through first:

Are *any* spreadsheets showing in that list, or is it just one particular one missing?

Have you tried the “Load More” button?

Is the spreadsheet definitely in Google Sheet format and not an uploaded XLS format, for example?

Did you create the sheet, or was it shared with you?

 

One other thing to try is to open the sheet and copy this part from the URL:

 

Then, reopen the “Spreadsheet” dropdown in the zap editor, click the “Custom” tab and paste in the ID you just copied.

If you see any errors after doing that, then we’ve got an issue with Zapier finding that sheet and we can try some other things.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

AndrewJDavison_Luhhu
Forum|alt.badge.img+11

@milankc 

A few things to run through first:

Are *any* spreadsheets showing in that list, or is it just one particular one missing?

Have you tried the “Load More” button?

Is the spreadsheet definitely in Google Sheet format and not an uploaded XLS format, for example?

Did you create the sheet, or was it shared with you?

 

One other thing to try is to open the sheet and copy this part from the URL:

 

Then, reopen the “Spreadsheet” dropdown in the zap editor, click the “Custom” tab and paste in the ID you just copied.

If you see any errors after doing that, then we’ve got an issue with Zapier finding that sheet and we can try some other things.