Hi @Ajmiller
Good question.
Based on the returned errors, it seems like you may need to remap the email variable in the Zap step.
Please post screenshots with how each of your Zap steps is configured in order for us to have proper context, thanks.
Hey there, @Ajmiller! I wanted to swing by and see if you were able to get this sorted?
It looks like you were able to open a ticket with my friends in support - which is perfect! After identifying the email formats from the spreadsheet were missing or had incorrect formatting they recommended giving this a try:
You mentioned that the data in your spreadsheet comes from Facebook. Are you running a lead ad on Facebook by any chance? If that's the case, you may want to consider using the Facebook Lead Ads app integration in Zapier. That way, the email address of the lead is captured.
I’d recommend continuing to troubleshoot in your ticket if you have additional questions.
Definitely keep us in the loop though - we’d love to know your final solution!
hi, im using -
GroupKit extension - which creates a spreadsheet entry whenever i approve a new member in my fb group
kajabi - when a new entry appears on the above spreadsheet, it’s supposed to create a new form and add the contact’s name and email
there’s no ads or anything like that, just groupkit, google sheets, kajabi, and zapier trying to work together
Gotcha, @Ajmiller! I’d definitely recommend you passing this along in your ticket. It’s going to be the best way to get to the bottom of this.
Hey friends! I wanted to swing by and update the thread with a few details from the support topic:
Sounds like the recommended zap looks like this:
- Trigger Google Sheets: New or Update Spreadsheet Row
- Action (Filter by Zapier): allow the next step to continue if the "Q3 Answer" field contains an email address
- Action (Kajabi): Create Form Submission
That way, only contacts with an email address are added to Kajabi. To learn more about Filter by Zapier, kindly click here: https://zapier.com/help/create/customize/add-conditions-to-zaps-with-filters.
I hope this helps!
Hey friends! I wanted to swing by and update the thread with a few details from the support topic:
Sounds like the recommended zap looks like this:
- Trigger Google Sheets: New or Update Spreadsheet Row
- Action (Filter by Zapier): allow the next step to continue if the "Q3 Answer" field contains an email address
- Action (Kajabi): Create Form Submission
That way, only contacts with an email address are added to Kajabi. To learn more about Filter by Zapier, kindly click here: https://zapier.com/help/create/customize/add-conditions-to-zaps-with-filters.
I hope this helps!
thanks, i am going to see if i get any more error notices