Question

Can't find specific Google Sheet

  • 26 July 2021
  • 1 reply
  • 11 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.


1 reply

Userlevel 7
Badge +9

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}}

Reply