Best answer

Can't find specific Google Sheet

  • 26 July 2021
  • 1 reply
  • 1298 views

Hi, new to Zapier here!

 

I’ve created an account and starting my first Zap. I connected my Google account and I see a number of my Google worksheets in the dropdown list. But the particular worksheet I want to use is not appearing in the list, nor can I search it from the search bar (comes up with nothing found). 
What do I need to do in order for the worksheet to appear in the list?

 

My ultimate goal is to create new Google Calendar events from time shift entries in my Google Sheet doc.

icon

Best answer by GetUWired 26 July 2021, 22:57

View original

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

Userlevel 7
Badge +12

HI @jono_SK 

The fastest way to use it would be to paste the id of the sheet directly into the input. You can get the id for the Google Sheet by opening the sheet and looking in the URL 

https://docs.google.com/spreadsheets/d/{{THIS IS THE SPREADSHEET ID}}/edit 



if you need a specific worksheet, it would appear at the end of the url something like gid={{This is the worksheet id}}