Integration guide
The Google Sheets and Mailjet integration, explained
Most teams keep their subscriber lists in a spreadsheet because it is easy to edit and easy to share, then do their sending in Mailjet because it handles deliverability. The Google Sheets and Mailjet integration keeps those two in step so you stop exporting and importing CSVs by hand. It runs in whichever direction you need: new rows become Mailjet contacts, and Mailjet events flow back into a sheet for reporting. Everything goes through Mailjet's v3 REST API with your API key and secret, so there is no plugin to install and nothing to maintain once it is running.
What does the Google Sheets Mailjet integration connect?
It connects your spreadsheet and your Mailjet account through Mailjet's API, in two flows you can run separately or together. The inbound flow watches for a new row in Google Sheets and adds that person to a Mailjet contact list, mapping the email, the name, and any custom contact properties you use. The outbound flow reads Mailjet event and campaign data, sends, opens, clicks, bounces, and unsubscribes, and writes it to a sheet you can chart. Because both flows use the same API key and secret, you set up credentials once and reuse them, and you can map custom properties on the contact side rather than being limited to email and name.
How do you set up the Google Sheets Mailjet integration?
- 1
In Mailjet, open Account settings and go to API Key Management. Copy your API Key and Secret Key. These authenticate every call, so no OAuth app or password is needed.
- 2
Decide which flow to build first. For list building, use a 'new Google Sheets row' trigger. For reporting, use a Mailjet event webhook or a scheduled stats pull.
- 3
For contacts, add the 'Add a contact to a list' action and select the target list. For reporting, add the event webhook or the campaign statistics call.
- 4
For contacts, map the email, the name, and any custom properties from your columns. For reporting, map the event type, the timestamp, and the campaign ID into your sheet columns.
- 5
Add a test row or trigger a test event, confirm it appears on the other side with the right values, then switch the scenario on.
Skip the build, get the ready-made template
An import-ready file with a setup guide, live in about fifteen minutes.
What can you do with the two flows?
A spreadsheet as your list source
Sign-ups from a form or another workflow drop into a sheet, and each one is added to the right Mailjet list automatically with its custom properties intact.
Campaign stats you can chart
Opens, clicks, and bounces stream into a reporting tab, ready for a pivot table or a dashboard, with no export step in between.
A suppression list you edit in Sheets
Keep a do-not-contact sheet and let the workflow update the matching Mailjet contacts, so your sends stay compliant without manual list edits.
The result you get
Your contacts and your campaign data stay aligned on their own. New rows become Mailjet contacts, and every event lands in a sheet for reporting, so the spreadsheet and the sending tool finally agree.
Related integrations
Questions about the Google Sheets Mailjet integration
Which way does the data flow?
Either way, and you can run both. One flow pushes new Google Sheets rows into a Mailjet contact list. The other pulls Mailjet events and campaign stats back into a sheet for reporting.
What credentials does it need?
Your Mailjet API Key and Secret Key from API Key Management. The workflow calls Mailjet's v3 REST API directly, so there is no separate app to authorise.
Can I sync custom contact properties?
Yes. The contact flow maps any spreadsheet column to a Mailjet contact property, including the custom properties you have defined, not just email and name.
Does it work on n8n as well as Make.com and Zapier?
Yes. The same two flows build on all three, since they rely on the Mailjet API and the Google Sheets connector rather than a platform-specific feature.