Skip to main content

Hey Community, 

 

I’m trying to take a form submission from my website (hosted by squarespace) to Google Sheets and then auto-generate an email to the form submitter. I’m getting all the way through this seeing the information go through to sheets but no email is being sent. 

I think the easiest thing to do would be to do this all in a single 3 step Zap, however, I’m on the free plan right now. Do you all think that breaking this up into 2 separate Zaps is causing the mix up? 

The second zap that is having trouble is: triggered by new sheet row - email column - email. Is there a step there that I’m missing? 

Thanks for the help. 

@NickS. -

Apart from paid plans being totally worth it, your steps appear to be correct. I personally prefer to fire emails from a proper marketing automation platform or Airtable, rather than Email by Zapier. For instance, you could:

  • IF new submission
  • THEN create a record in Airtable

Airtable itself can automate the email send. One less system in play.


Thanks Adam!

I didn't even think about adding our CRM into the equation but that should be a step. Thanks for the feedback. I'll keep playing with it. Maybe if I add a step to mailchimp things will smooth out…

Fingers crossed!


Mailchimp is a great idea. It’s a dedicated email system, which has a quality all its own. Use Zapier to get the data in there and let Mailchimp do what it does best.


Thanks for the feedback and follow up, Adam!