💡 Are you an SME looking to automate your email list and welcome emails—for FREE? Forget expensive tools! Here's a step-by-step guide to set up a completely free Mailchimp automation using Google Sheets & Apps Script.

🔹 Why should you do this?

✅ Automatically collect subscribers from Mailchimp into Google Sheets 📊

✅ Send personalized welcome emails instantly 💌

✅ No paid plans, No Zapier—Just pure automation 🔥

🚀 Step-by-Step Guide (Takes 10 Minutes!)

💡 What You Need:

✔️ A free Mailchimp account

✔️ A Google Spreadsheet to store subscribers

✔️ Google Apps Script (no coding required—just copy-paste!)

Step 1️⃣: Get Your Mailchimp API Key & Audience ID

🔹 Mailchimp API Key: Go to Mailchimp → Account → Extras → API Keys → Generate a new key.

🔹 Audience ID: Navigate to Audience → Settings → Audience Name & Defaults, and copy your Audience ID.

Step 2️⃣: Set Up Google Sheet

1️⃣ Open Google Sheets and create a sheet with these columns:

• A → Name
• B → Email
• C → Phone
• D → Signup Date