How to capture RSVP responses in Mailchimp using Squarespace

This post gives a full explanation of how this feature has been implemented.

If you just want to use this feature in a Mailchimp campaign, all you need to do is make a copy of a Mailchimp campaign that already uses this feature (and probably the save to Calendar feature as well)

Once the user clicks on the Yes or Sorry buttons, they are redirected to a Squarespace page where they are asked to confirm

Screen Shot 2018-06-25 at 5.58.49 pm.png
Screen Shot 2018-06-25 at 6.21.46 pm.png

This will result in an email being sent to info@repowernoosa.com, and an entry being created in a shared Google Sheet - RSVP

Screen Shot 2018-06-25 at 6.24.53 pm.png

Details about how this is implemented are described below.

THE PROBLEM

We use Mailchimp to let people know about meetups.
It's difficult to know who's going to come.  Often we've then sent out Mailchimp/email, then had to followup with a text message asking for a reply which may or may not come, so then revert to phone call, which is all too time consuming.
Need a simple way for folks to respond with Yes or No if they're coming to a meeting.
Also need a reliable way to know if someone has read or opened their email about the event.

A SOLUTION

Add a "I'm coming" and "Sorry can't come" button to the Mailchimp campaign.
The button takes them to a simple Squarespace RSVP page with a Form where they confirm their attendance.
Squarespace records their response & can generate an email, and/or save the response in a Google Sheet.

 What you see in Mailchimp Email

What you see in Mailchimp Email

 Result of clicking on Yes I'm Coming.  Note fields passed in URL

Result of clicking on Yes I'm Coming.  Note fields passed in URL

 Confirmation email received by administrator, eg info@repowernoosa.com

Confirmation email received by administrator, eg info@repowernoosa.com

 Response can also be recorded in a Google sheet (GSuite)

Response can also be recorded in a Google sheet (GSuite)

 A Form with only hidden fields is used on the repowernoosa.com/RSVP page.  On button click the fields passed in the URL are stored - options are email, GSuite google sheet

A Form with only hidden fields is used on the repowernoosa.com/RSVP page.  On button click the fields passed in the URL are stored - options are email, GSuite google sheet

 The Mailchimp "Yes I'm Coming" button links to the Squarespace page.  Use Mailchimp merge codes

The Mailchimp "Yes I'm Coming" button links to the Squarespace page.  Use Mailchimp merge codes

Here is the Web address (URL) to include for the Yes I'm coming Button

https://www.repowernoosa.com/rsvp/?SQF_CAMPAIGN=*|MC:SUBJECT|*&SQF_EMAIL=*|EMAIL|*&SQF_FNAME=*|FNAME|*&SQF_LNAME=*|LNAME|*&SQF_REPLY=Yes

 

And for the No Button

https://www.repowernoosa.com/rsvp-no/?SQF_CAMPAIGN=*|MC:SUBJECT|*&SQF_EMAIL=*|EMAIL|*&SQF_FNAME=*|FNAME|*&SQF_LNAME=*|LNAME|*&SQF_REPLY=No

 

Mailchimp merge codes can be found here.

Probably only need to use

*|MC:SUBJECT|*
*|EMAIL|*
*|FNAME|*
*|LNAME|*

for email and name of the Mailchimp recipient, and the campaign's subject line.  Squarespace will add the date & time.

Folks creating Mailchimp campaigns would just need to copy a simple sample campaign that includes the RSVP buttons, and so wouldn't have to be concerned about the URL encoding.

Read about Squarespace hidden fields in forms here.

See other post about how to create events and be able to save them to your calendar from the MailChimp email.

This is cheap and cheerful and should fulfil the purpose of recording RSVPs

That's it!

 

Print Friendly and PDF