Google Sheet to Mailchimp Automation

Name: Google Sheet to Mailchimp Automation
Rating: 4.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

30 views

0 downloads

Integrationsautomationcrmemail marketinggoogle sheetsmailchimpsync

Import email addresses from a Google Sheet to a Mailchimp list.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of syncing email addresses from a specified Google Sheet into a Mailchimp audience. It's designed for users who want to easily manage their email marketing list by leveraging data already present in a spreadsheet.

Key Features

Reads data from a Google Sheet.
Subscribes contacts to a Mailchimp list.
Configurable interval for automation.

How To Use

Import the workflow.
Configure Google Sheets credentials. Ensure your Google Cloud Project has the Sheets API enabled and provide the necessary credentials.
Configure Mailchimp credentials. Connect your Mailchimp account.
Set up the Google Sheets node. Specify the sheetId and the range of your target Google Sheet.
Set up the Mailchimp node. Select your desired Mailchimp list and ensure the email field correctly maps to the column containing email addresses in your Google Sheet.
Set the Interval node. Define how often you want the workflow to run (e.g., every 2 hours).
Execute the workflow. Click 'Execute' to start the automation.

Apps Used

automation

crm

email marketing

google sheets

mailchimp

sync

Workflow JSON

{
  "id": "afa363a3-008a-49b2-bb49-d5f757e78ce6",
  "name": "Google Sheet to Mailchimp Automation",
  "nodes": 0,
  "category": "Integrations",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.