Connector guide
Connect Mailjet to Google Sheets both ways
Connect Mailjet to Google Sheets both ways — push new rows into a Mailjet contact list, or pull opens, clicks, and bounces into a sheet for reporting. Make.com, n8n, Zapier.
How to connect Mailjet to Google Sheets
Connecting Mailjet to Google Sheets keeps your email-marketing data and your spreadsheets in step, in whichever direction you need. Push new spreadsheet rows into a Mailjet contact list so sign-ups and imports are added automatically, or pull Mailjet event data — sends, opens, clicks, bounces, and unsubscribes — back into a sheet for reporting. Both flows use Mailjet's v3 REST API with your API key and secret on one side and Google Sheets on the other, so there's no CSV export or manual import in between. Marketing teams use the inbound flow to build a live subscriber source of truth: a form or another workflow drops a row in the sheet, and the contact lands in the right Mailjet list with name and custom properties mapped. They use the outbound flow to feed a Looker Studio dashboard with campaign stats, or to keep a suppression list in a sheet that updates the matching Mailjet contacts automatically. Syncs run on a schedule or in real time via a Mailjet event webhook, and because everything goes through the API you can map custom contact properties alongside the standard name and email fields. The result is the best of both tools — the ease of editing rows in Sheets and the sending power of Mailjet — with the plumbing handled by a workflow you set up once on Make.com, n8n, or Zapier.
The exact trigger and action
Trigger
A new Google Sheets row, or a Mailjet event webhook (open, click, bounce, unsubscribe)
Action
A Mailjet API module (add contact to list) or a Google Sheets "Add a Row" for event logging
Set it up in 5 steps
- 1
Pick your platform and open the Mailjet module; in Mailjet, copy your API Key and Secret Key from Account → API Key Management.
- 2
For contact sync, add the "Add a contact to a list" action and choose the target Mailjet list; for reporting, add the Mailjet event webhook or a scheduled stats pull.
- 3
Connect your Google account and add the Google Sheets "Add a Row" or "Search Rows" module on the other side of the flow.
- 4
Map the fields — email, name, and any custom properties for contact sync, or event type, timestamp, and campaign ID for reporting.
- 5
Run a test: add a row or trigger a test event, confirm it appears on the other side, then activate the workflow.
The outcome
Subscribers and campaign stats stay in sync automatically — new rows become Mailjet contacts, and every open, click, and bounce lands in a sheet ready for reporting, with no manual CSV exports.
Common use cases
New row → Mailjet contact list
Adds each new spreadsheet row — from a form, an import, or another workflow — to a chosen Mailjet contact list with name and custom properties mapped.
Mailjet events → Sheets reporting
Logs every send, open, click, bounce, and unsubscribe to a sheet so you can build campaign dashboards without exporting CSVs.
Sheet-driven suppression list
Reads a suppression sheet and updates the matching Mailjet contacts, keeping your sends compliant without manual list edits.
Related templates
Build it on your stack
Frequently asked questions
Which direction does this sync?
Both. One flow pushes new Google Sheets rows into a Mailjet contact list; the other pulls Mailjet event and campaign data into a sheet for reporting. You can run them together.
What Mailjet credentials do I need?
Your Mailjet API Key and Secret Key, found under Account → API Key Management. No OAuth app or password is required — the workflow calls Mailjet's v3 REST API directly.
Can I map custom contact properties?
Yes — the contact-sync flow maps any spreadsheet column to a Mailjet contact property, including custom properties you've defined, as the setup guide shows.