Hi! I’ve got a Zap setup sending signups from Acuity to a Google Spreadsheet. But it seems to be firing a lot of duplicates, slash we just have people who signup a lot and so we don’t need the Zap to fire for them. Can anyone help me figure out how to create a filter for duplicates. Is there a way to? Thanks in advance!
How to filter duplicate Acuity signups in Zapier to Google Spreadsheet?
Hi
Use this Zap action: GSheets - Lookup Row
There is a checkbox option to create a row if not found.
Doing so results in a Zap step that is find/create row.
Thanks, Troy! I think I’ve done it correctly now. I put it before the create row, so that hopefully it catches duplicates and doesn’t create a row when already found. If I took a screenshot of the setup, would you mind making sure it looks okay? I’m very new to Zapier. Thanks!
Feel free to post screenshots with how your Zap steps are outlined and configured in EDIT mode to give us context.
When in doubt, test it out!
Thanks again, Troy! Unfortunately, I don’t pay for Zapier, so I can’t add the third step. Thanks for the info though!
You don’t need a Filter step.
Zap Steps
- Trigger: Acuity - New Appointment
- Action: GSheets - Lookup Row
- Check the checkbox for create row if not found
Zap step 2 will either find an existing row or create a new row.
Meaning if an existing row is found, then no new row is added, thus preventing duplicates.
Ok, I think I did this correctly:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/d21d771a-5978-404a-b7a2-a81788444a09.png)
Can you post screenshots with how the top 3 rows of your GSheet?
You likely don’t need a Supporting Lookup Column selected.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6b041754-74d0-4701-9199-123c47fc89ff.png)
Hi Troy,
Here’s the screenshot you requested. As you can see, there’s not a header row or anything. I’m parsing through these now and there are a ton of duplicates. I can’t tell if it’s Zap or Acuity throwing the duplicates.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/402f9494-2aad-42c2-9ecc-c66fff74504a.png)
To use GSheets in Zaps, Row 1 needs to have Headers.
Help: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps
Ok, I figured out that it’s likely on Acuity’s side: the repeats are based on the number of sessions signed up for by that same person. I’m still not sure how to fix this, if you have any thoughts I’m all ears. Thank you!
Make sure the GSheet has Headers in Row 1.
Zap Steps
- Trigger: Acuity - New Appointment
- Action: GSheets - Lookup Row
- Check the checkbox to create if not found
- Thus step logic is find row else create row if not found
- Action: Filter
- Action: GSheets - Update Row
- Map the Row/ID from Step 2
Thank you for following up
I can’t add a filter because I don’t pay for Zapier, but I did the other steps. The test it sent is a record that is a duplicate (x4). So I’m not sure I did it right. Here’s the screenshot:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/69b3b5cc-2d5d-4488-9d2f-cf9db158d28e.png)
In the GSheet, Row 1 needs to be a Header row with labels for each field.
Reference this help link: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps
Then you can refresh your Zap GSheet step to see each of the columns to map variables to.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/37781f91-b689-4f82-a5cb-b296421c79e5.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a70e1170-f586-4a7b-acef-7e0f5d830e67.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4939794e-6620-47ec-ae06-e519008127bd.png)
And it still duplicated.
In the Zap, you would need to refresh the GSheet step for it to detect the Header Row.
Then you can map each Acuity variable from step 1 to the correct column.
And you likely would need to reconfigure the Lookup logic in the GSheet Zap step to reference the correct lookup column.
If you still need help, post updated screenshots with how your Zap steps are outlined and configured in EDIT mode.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/79e124f6-af77-450f-8808-4deb1a504414.png)
Thanks again,
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.