How to get opt-in to be sent when added to Google Sheets

Ask a question
1

Ok so here’s the deal, I have my website on Squarespace and use the newsletter block, so in order to add subscribers to my AC list, I have to integrate SquareSpace and AC using a zap that adds subscribers via Google Sheets or MailChimp. I had originally done it so that SquareSpace would store subscriber info on Mailchimp and the zap would bring that info in AC (sorry if I’m repeating myself).

Everything was working fine and the AC opt-in was sending out like planned, but then a few days ago, I noticed I was getting new subscriber alerts from MailChimp and upon testing out the sign up on SquareSpace, I realized that people were now getting the confirmation email from MailChimp. I’ve been trying to figure out the issue and it doesn’t seem to be on MailChimp’s or AC’s side, but possibly something going on with Squarespace, or more likely Zapier since they made the zap instant.

So my question is, if I switch to using Google Sheets to collect the info, how do I trigger AC’s opt-in email to be sent instead?

1 Like
2

Hi there!

By opt-in email, do you mean a double opt-in email for the contacts to confirm their subscription? If so, you can go the Google Sheets route to add them to a list, and then set up an automation that sends the “opt-in” email. If they do not click the link within 7 days, they will be unsubscribed from the list. Here is a quick example of that automation:

opt-in automations
opt-in automations1092×1041 54.3 KB

The link in the email can be back to your site, or to a landing page of your choice, as we’re really just asking them to open the email and confirm their email address by clicking.

Please let us know if you have any questions!

Meghan