I want to start zapping partial entries from Gravity Forms. The issue is that by definition, partial entries creates multiple entries for a given form. So I’m wondering if Zapier can update a row when it finds the same email, OR add a row if the email field is unique.
Best answer by DanversView original
This is definitely doable using a Lookup Row in Google Sheets step and Paths by Zapier :)
What you need to do is the following:
let me know if this works for you :)
Thanks for the quick response. Sounds promising. Will give it a try next week and report back
@cb2022 - checkin in to see how you got along with @MohSwellam’s suggestion? Would love to hear if it worked for you or if there is anything else we can do to help you!
Looking forward to hearing back-
Thanks for checking in. I have not had the opportunity to try it yet. I’ll be sure to report back when I have
I can see that
@MohSwellam has given you a great way of using Paths to add conditional logic into your Zap, but there is an easier way to do what you need in this particular case.
I’ll explain it in more detail, but to give you an overview, you need to use the following steps in your Zap:
The Lookup Spreadsheet Row will either find an existing row or, if one doesn’t exist, it will create one. The Update Row step will update the Row that was just found (or created) in the previous step. This option will be better for you if your Zapier plan isn’t Professional or higher as you can’t use Paths with a starter plan. It also uses less tasks than adding Paths.
Here’s how to set up those actions in your Zap
I hope that’s clear, let us know if you have any questions!
Thank you both for your detailed replies.
I see what you are saying in step 3 to update if true, or create if false but cant get past #2
@cb2022, hope you’re doing well!
With regards to the error on the screenshot, this happens when the Update Spreadsheet Row step is not getting the Row ID that is needed to do the update. Based on the error, I believe that an email field was mapped instead of the Row ID.
To fix this, remap the Row field from the Lookup Spreadsheet Row step onto the Row field on the Update Spreadsheet Row step to match the requirement. Please refer to this help doc for more details on setting up the Updated Spreadsheet Row step: https://help.zapier.com/hc/en-us/articles/8495978803213-Finding-and-Updating-Rows-in-Google-Sheets#update-the-row-0-3
Please give that a try and let me know if you run into issues.
@Paolo. That was the issue. I misunderstood @Danvers last instruction