Add a database row in Notion when a subscriber’s details change in Mailchimp

What each client fills in

Notion: Database ID

For example the 32 characters in the database URL

Notion: Title column

For example Name

Mailchimp: Audience ID

Audience → Settings → Audience name and defaults: the Audience ID.

The accounts it needs

Each is the client’s own, stored encrypted and never copied between clients. Until one is added the client’s checklist shows it, and nothing runs.

• 

  In the client’s Mailchimp: Profile → Extras → API keys → Create A Key. The server prefix is the part after the dash (us21).

• 

  notion.so/profile/integrations → New integration (Internal) in the client’s workspace → Capabilities: Read content, Insert content and Update content (the row update needs the last) → copy the secret. Then open the database → ••• → Connections → add the integration.

After you install it

It lands switched off. The client’s checklist holds exactly this:

1. Connect the client’s Mailchimp, for “A subscriber’s details change”
2. Connect the client’s Notion, for “Add a database row”
3. Fill in Mailchimp: Audience ID (Audience → Settings → Audience name and defaults: the Audience ID)
4. Fill in Notion: Database ID (For example the 32 characters in the database URL)
5. Fill in Notion: Title column (For example Name)