Hello! I’m hoping to find help with this matter:
I have an event (new hire orientation) that occurs every 2 weeks. The event place and time are the same so we have a recurring event set up in Google.
I’d like to add new hires to the next upcoming occurance of orientation once they’re added to a Google Sheet. Is that possible in Zapier?
Best answer by christina.d
View original
+9
Hi
This should be doable, need to try some different methods, one way I can think of is:
+9
Hiya
+9
Hey
Tried to create a Zap to share: https://zapier.com/shared/a4ddab761eb6d05b17fe5fa1252d5877b62709d3
Never seen what a Zap looks like from the share link, but this one has a +1d in the “Start Time” for the “Find Event in Google Calendar” because otherwise it’ll look backwards first. Just make the search the name of the event (assuming it’s unique and won’t find other events on your calendar).
For adding attendees, make sure you’re using the same calendar as from Find Event, for Event use the dynamic ID field from step 2, and for attendees, add the dynamic field email from step 1.
I tested it out and it added me to the next calendar event, not any of the recurring events.
What might be causing an issue is that new row is instant, so if you create a new row, but it doesn’t have an email address, the Zap will trigger and even if you add an email shortly after, it has already sent the row information through the Zap. You need to add the email address as part of creating the new row. That is one of the reasons I prefer Airtable for these kinds of things, I find it easier to create dependencies that require an email before the new record will trigger the Zap.
You could probably create another Sheet within the Worksheet that is for this Zap, and it only adds new rows from another row when an email is included.
Hey
It isn’t set up at all right now - I gave up and walked away after spending hours trying to make it work :( I’m less concerned with a specific Zap process. I really just want to be able to add a group of new hires to a single instance of a recurring calendar event.
Without seeing a screenshot of a ran Zap, my bet would be that the new row is triggering the Zap before an email has been added to the row.
Tried to create a Zap to share: https://zapier.com/shared/a4ddab761eb6d05b17fe5fa1252d5877b62709d3
Never seen what a Zap looks like from the share link, but this one has a +1d in the “Start Time” for the “Find Event in Google Calendar” because otherwise it’ll look backwards first. Just make the search the name of the event (assuming it’s unique and won’t find other events on your calendar).
For adding attendees, make sure you’re using the same calendar as from Find Event, for Event use the dynamic ID field from step 2, and for attendees, add the dynamic field email from step 1.
I tested it out and it added me to the next calendar event, not any of the recurring events.
What might be causing an issue is that new row is instant, so if you create a new row, but it doesn’t have an email address, the Zap will trigger and even if you add an email shortly after, it has already sent the row information through the Zap. You need to add the email address as part of creating the new row. That is one of the reasons I prefer Airtable for these kinds of things, I find it easier to create dependencies that require an email before the new record will trigger the Zap.
You could probably create another Sheet within the Worksheet that is for this Zap, and it only adds new rows from another row when an email is included.
Tried to create a Zap to share: https://zapier.com/shared/a4ddab761eb6d05b17fe5fa1252d5877b62709d3
Never seen what a Zap looks like from the share link, but this one has a +1d in the “Start Time” for the “Find Event in Google Calendar” because otherwise it’ll look backwards first. Just make the search the name of the event (assuming it’s unique and won’t find other events on your calendar).
For adding attendees, make sure you’re using the same calendar as from Find Event, for Event use the dynamic ID field from step 2, and for attendees, add the dynamic field email from step 1.
I tested it out and it added me to the next calendar event, not any of the recurring events.
What might be causing an issue is that new row is instant, so if you create a new row, but it doesn’t have an email address, the Zap will trigger and even if you add an email shortly after, it has already sent the row information through the Zap. You need to add the email address as part of creating the new row. That is one of the reasons I prefer Airtable for these kinds of things, I find it easier to create dependencies that require an email before the new record will trigger the Zap.
You could probably create another Sheet within the Worksheet that is for this Zap, and it only adds new rows from another row when an email is included.
Testing returns “Bargle...”
You need to find an event first. So add a Find Event action between those two actions.
+9
Hey there,
I’ll summarize some of CarlL’s responses below as well:
Never seen what a Zap looks like from the share link, but this one has a +1d in the “Start Time” for the “Find Event in Google Calendar” because otherwise it’ll look backwards first. Just make the search the name of the event (assuming it’s unique and won’t find other events on your calendar).
For adding attendees, make sure you’re using the same calendar as from Find Event, for Event use the dynamic ID field from step 2, and for attendees, add the dynamic field email from step 1.
I tested it out and it added me to the next calendar event, not any of the recurring events.
What might be causing an issue is that new row is instant, so if you create a new row, but it doesn’t have an email address, the Zap will trigger and even if you add an email shortly after, it has already sent the row information through the Zap. You need to add the email address as part of creating the new row. That is one of the reasons I prefer Airtable for these kinds of things, I find it easier to create dependencies that require an email before the new record will trigger the Zap.
You could probably create another Sheet within the Worksheet that is for this Zap, and it only adds new rows from another row when an email is included.
If there aren’t any events to select:
You need to find an event first. So add a Find Event action between those two actions.
Keep us posted!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
