Hi,
I’m new to Zapier, and experimenting with automating a workflow between Google Sheets and Google Calendar.
Problem: The trigger options I see in Zapier seem to need be to reference a specific worksheet in a workbook. I would like to trigger off of any change off of any of the worksheets in a workbook.
Details:
I manage a worksheet that tracks guests to a group home I help manage. I have a separate workbook for each year, and within those workbooks, I have a separate tab for each month of the year.
Whenever any record in any worksheet within the workbook gets updated, I’d like Zapier to take the updated record, and create a google calendar event. Each record has an arrival and departure date which I’d use to create the event.
How do I create a trigger that listens to any change to a workbook, rather than a change to a specific worksheet?
Cheers,
Jovial