Datapipe
Mailchimp

Live with your own API key

Mailchimp to Google Drive

Datapipe writes Date (send_time), Email (campaign_title), Sent (emails_sent), Opens (opens.unique_opens), Clicks (clicks.unique_clicks), Revenue (ecommerce.total_revenue) into Google Drive as CSV and Excel, with JSON if you turn it on. You pick the folder with the Google Picker. The app then creates Datapipe and a folder for the client. The file can overwrite the last copy or add the date to the name. It refreshes hourly, daily, or weekly. This uses the Drive API with drive.file only.

Start free See every Mailchimp field

Columns in this handoff

Plan fit

Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly. Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts.

FAQ

How does Mailchimp get to Google Drive?

Datapipe writes Date (send_time), Email (campaign_title), Sent (emails_sent), Opens (opens.unique_opens), Clicks (clicks.unique_clicks), Revenue (ecommerce.total_revenue) into Google Drive as CSV and Excel, with JSON if you turn it on. You pick the folder with the Google Picker. The app then creates Datapipe and a folder for the client. The file can overwrite the last copy or add the date to the name. It refreshes hourly, daily, or weekly. This uses the Drive API with drive.file only.

Which plan do I need?

Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.

What if the source is not connected yet?

The report still opens with sample rows and a Sample data label. It switches to live rows after the credential is accepted.

Other ways out of Mailchimp

Mailchimp to Google Sheets · Mailchimp to Looker Studio · Mailchimp to BigQuery · Mailchimp to AI and MCP · Mailchimp to the API