Skip to main content

​
Prerequisites

  • Node.js installed on your machine
  • A Mailchimp account
  • A Notion account

​
Step 1: Get Your API Keys

Mailchimp API Key
1
Log in to your Mailchimp account.
2
Navigate to your profile by clicking on your account name in the lower-left corner.
3
Go to Profile.
4
Click on the Extras dropdown and select API keys.
5
Click on Create A Key.
6
Copy the generated API key.
Notion API Key
1
Log in to your Notion account.
2
Go to Notion Connections.
3
Click on New Connection.
4
Fill in the required details and click Submit.
5
Copy the generated Installation access token.

​
Step 2: Set Up Your Notion Database

1
Create a new database in Notion with the following properties:
  • Campaign Name (Title)
  • Name (Text)
  • Email (Email)
2
Share the database with your connection:
  • Click on the three dots in the top-right corner of the page.
  • Under Connections, click on Connect to and search for your connection and invite it.

​
Step 3: Project Structure

This step is not necessary but we suggest projects to be structured like so: 
project-root/
├── src/
│   ├── config/
│   │   └── mailchimp.js
│   │   └── notion.js
│   ├── integrations/
│   │   ├── mailchimpIntegration.js
│   │   └── notionIntegration.js
│   ├── main.js
├── .env
├── package.json

​
Step 4: Create .env file

Create a .env file in your project directory with the following content, replacing the placeholders with your actual credentials:
YAML
NOTION_TOKEN='you_notion_api_key'
MAILCHIMP_API_KEY='your_mailchimp_api_key'
NOTION_DATABASE_ID='your_database_id'

​
Step 5: Packages

Install the required Node.js packages using the following command:
Shell
npm install @notionhq/client dotenv
Create a package.json file and add the following:
JSON
{
    "name": "mailchimp_notion_integration",
    "version": "1.0.0",
    "main": "src/main.js",
    "scripts": {
      "start": "node src/main.js"
    },
    "dependencies": {
      "@notionhq/client": "^1.0.0",
      "dotenv": "^8.2.0"
    }
  }

​
Step 6: Configure Mailchimp and Notion API clients

Create mailchimp.js to set up the Mailchimp API client. Ensure your credentials are being passed here.
JavaScript
// mailchimp.js
const Mailchimp = require('mailchimp-api-v3');
const dotenv = require('dotenv');

dotenv.config();

const mailchimp = new Mailchimp(process.env.MAILCHIMP_API_KEY);

module.exports = mailchimp;
Repeat to create notion.js :
JavaScript
// notion.js
const { Client } = require('@notionhq/client');
const dotenv = require('dotenv');

dotenv.config();

const notion = new Client({ auth: process.env.NOTION_TOKEN });
const databaseId = process.env.NOTION_DATABASE_ID;

module.exports = { notion, databaseId };

​
Step 7: Set Up Connections

Create mailchimpIntegrations.js to fetch campaigns and subscribers from Mailchimp:
JavaScript
// mailchimpIntegration.js
const mailchimp = require('../config/mailchimp');

async function getMailchimpCampaigns() {
  try {
    const response = await mailchimp.get('/campaigns');
    const campaigns = response.campaigns;
    return campaigns.map(campaign => ({
      id: campaign.id,
      list_id: campaign.recipients.list_id,
      campaign_name: campaign.settings.title
    }));
  } catch (error) {
    console.error('Error fetching Mailchimp campaigns:', error);
    return [];
  }
}

async function getMailchimpSubscribers(list_id) {
  try {
    const response = await mailchimp.get(`/lists/${list_id}/members`);
    return response.members.map(member => ({
      name: member.full_name,
      email: member.email_address
    }));
  } catch (error) {
    console.error('Error fetching Mailchimp subscribers:', error);
    return [];
  }
}

module.exports = { getMailchimpCampaigns, getMailchimpSubscribers };
Additionally, create notionIntegrations.js to populate the Notion Database:
JavaScript
// notionIntegration.js
const { notion, databaseId } = require('../config/notion');

async function addToNotionDatabase(databaseId, campaignName, name, email) {
  try {
    await notion.pages.create({
      parent: { database_id: databaseId },
      properties: {
        'Campaign Name': {
          title: [
            {
              text: {
                content: campaignName
              }
            }
          ]
        },
        'Name': {
          rich_text: [
            {
              text: {
                content: name
              }
            }
          ]
        },
        'Email': {
          rich_text: [
            {
              text: {
                content: email
              }
            }
          ]
        }
      }
    });
  } catch (error) {
    console.error('Error adding to Notion database:', error);
  }
}

module.exports = { addToNotionDatabase };

​
Step 8: Main Script

Create a main.js file that uses the modules created above to execute the connection logic.
JavaScript
require('dotenv').config();

const { getMailchimpCampaigns, getMailchimpSubscribers } = require('./integrations/mailchimpIntegration');
const { addToNotionDatabase } = require('./integrations/notionIntegration');

const NOTION_DATABASE_ID = process.env.NOTION_DATABASE_ID;

async function fillNotionDatabase() {
  const campaigns = await getMailchimpCampaigns();

  for (const campaign of campaigns) {
    const subscribers = await getMailchimpSubscribers(campaign.list_id);

    for (const subscriber of subscribers) {
      await addToNotionDatabase(NOTION_DATABASE_ID, campaign.campaign_name, subscriber.name, subscriber.email);
      console.log(`Added to Notion: Campaign: ${campaign.campaign_name}, Name: ${subscriber.name}, Email: ${subscriber.email}`);
    }
  }
}

fillNotionDatabase();

​
Step 9: Run the Connection

Execute the connection script by running the following command:
Shell
npm start
Customize the code to match your Notion database structure and desired properties for each campaign or subscriber. Add error handling and further customization as needed for your specific requirements.