Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Here’s what I’m trying to do:

 

  1. a member joins my facebook group and types their email, as a response to question 3 which collects contact info
  2. upon accepting them into group, GroupKit (a chrome extension) updates a google sheets with a new row containing name and other info (including question 3 answer, their email)
  3. that triggers a zap which SHOULD create a new form - which is the lead magnet - and add that name+email to my contacts list automatically as soon as i approve within facebook

the problem is this:

 

when I test the zap I get the error:

 

Failed to create a submission in Kajabi

Required field "Email" (email) is missing.

 

the email field within the google sheet is actually called “Q3” because when they type their email, it’s the answer to the third question in the fb group. i dont want to break anything by renaming rows in the spreadsheet that zapier is using. so not sure how to fix this?

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. 🙂

i emailed them. 

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:

  1. Trigger Google Sheets: New or Update Spreadsheet Row
  2. Action (Filter by Zapier): allow the next step to continue if the "Q3 Answer" field contains an email address
  3. 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:

  1. Trigger Google Sheets: New or Update Spreadsheet Row
  2. Action (Filter by Zapier): allow the next step to continue if the "Q3 Answer" field contains an email address
  3. 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

Terms & Conditions