Send template Mailchimp Transactional emails when new rows are added to Google Sheets
If you receive contact email addresses from external sources, collate those contacts in a Google Sheets spreadsheet and use Zapier to automatically send template Mailchimp Transactional emails to those contacts as you add them. After this integration is set up, new spreadsheet rows created from that point forward will generate an email to the contact.
With this integration, you can also use spreadsheet columns to record other email header data, or to set variables in the email template. And you can even schedule the email for a future date and time.
Note: This Zapier integration doesn't create emails for existing spreadsheet rows, only new rows (contacts) after you've set it up.
How It Works
- A new contact address is added to a Google Sheets spreadsheet.
- Zapier sends a template email to that contact.
What You Need
- A Google Sheets account
- A Mailchimp Transactional account
- When this happens...New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
- automatically do this!Send TemplateSend an email via a template.
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Google Sheets and Mailchimp Transactional
Discover other triggers and actions you can use with Google Sheets and Mailchimp Transactional
- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerPolling- Drive
Try ItTriggerPolling- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerInstant- Drive
- SpreadsheetRequired
Try ItTriggerPolling
- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerInstant- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerPolling- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerInstant- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionWrite









