About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Duplicate events created in AddEvent - Find Event in AddEvent step not working as expected

Zapathon
Userlevel 1

Find Event in AddEvent -
 

The zap triggers with new or updated spreadsheet row in Google sheets and should update an event or create a new one where an event doesn't already exist.

BUT I'm having some difficulty with duplicate events being created


- the find Event in AddEvent step doesn't seem to be working

(I have this working sweetly in a similar zap for Google Calendar - but for Addevent it isn't the same set up)

To get this to work for the Google calendar I created an internal event ID which I output into the event description so that this would stay with the event even if other fields (like the event name) changed - this seems to work and then you are able to use the output of this 'find step' as the search term. (example attached)
 



For addevent the Find step doesn't really make sense as there is no actual search term - it asks for the Event Id or invites you to add a search step (except this is the search step) = I must be missing something here!


Interestingly For AddEvent there is actually an Event ID which you are able to select from the list of fields But only in Update event step - it is listed under the output of the Find Event in AddEvent - which seemed a good choice as each event record when created seems to have this ID on it. (see pic) This unique event id is created in addevent for each event that is created - so it seems like a useful bit of data.


So I think the problem is in the previous step - Find Event in AddEvent - as the action will create event if it doesn't exist yet. So if the find is unsuccessful as new event is added. It is always unsuccessful! 
 

ANY SUGGESTIONS AS TO WHAT I AM MISSING?

 

icon

Best answer by christina.d 6 April 2023, 01:31

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.

5 replies

ken.a
Userlevel 7
Badge +6

Hey there @Zapathon,

Welcome to the Community! 🎉

My hunch here is that you’re missing a Filter step after the “Find Event in AddEvent” action step. Could you please try adding a Filter step and map the “Zap data was found” field to the first column of the Filter and map the condition as “(Boolean) Is True.” This way the Zap will only update the event if it is found. The Filter step should look like this:

919fe60131e2c556c1e4e4190a868237.png
(view larger)

Kindly give it a try and keep us posted!

Thanks! 😊

 

Zapathon
Userlevel 1

Thank you for the suggestion.

I have added that step in but unfortunately it hasn’t helped.

The problem is that a new event is being created in the step before this - it is the Find Event in AddEvent that is failing to find the existing event and then creating a new one every time. The update event in add event step has never been triggered


I feel like I don’t know what to put in the Event Id field in the Find Event in AddEvent action step.

Is there a way of filling this field with the Event Id where one has been created?
 

christina.d
Userlevel 7
Badge +9

Huh, that’s interesting! 🤔

I wonder if we swap out the “Find Event” action with the “List of All Events” (or whichever “List” action applies for you) if it’ll pull the Event ID for us? From there we may be to use Paths by Zapier to either update or create the Event.

Do you think that could work? Let us know!

Zapathon
Userlevel 1

Thank you @christina.d 
You are a genius! 

I used the list events  - Searched for our meeting ID

and then set the 2 paths true and false and used the update event (with the meeting ID from the list step) and the create event accordingly.


Tested it and it works! 
 

christina.d
Userlevel 7
Badge +9

🔥🔥🔥

Yess, love to hear it! Thanks for updating the thread with how you solved this! 

Happy zapping! ⚡️

Terms & Conditions