GSheetsToMC is a script written for Google Sheets that allows you to send edits on your spreadsheet to Mailchimp merge fields instantly. In this case, this script was written to accomodate my on-campus organization's needs (UNICEF at Illinois Tech).
At UNICEF, we use a point system to keep track of members' volunteering hours, attendance, and eligibility for prizes. This point system is updated via a private spreadsheet on Google Drive accessible only to our executive board. We also use Mailchimp for our weekly newsletters and heavily rely on merge fields to update each member about their points. The biggest problem was the lack of synchronization between Mailchimp and Google Sheets (no, we weren't interested in paying Zapier to automate the task). We often forgot to re-import the spreadsheet and thus, received complaints about outdated points from our members.
The spreadsheet's layout is as follows:
| First Name | Last Name | Total Points | Event 1 | Event 2 | More Events | |
|---|---|---|---|---|---|---|
| Pratik | Sampat | [email protected] | 5 | 2 | 3 | 0 |