Google Sheets + Mailjet

Update Mailjet contact properties from a Google Sheet

Bulk updating contacts can involve endless copy/paste effort. This integration can help speed things up. After you set it up, whenever additional or updated information about your contacts is added to a Google Sheet, Zapier will update the corresponding Mailjet contact with the new information. Your copy/paste muscles will thank you.

When this happens...
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Update Contact Properties
Update in real time the Contact Properties of a Contact in your Mailjet account. Useful with Mailjet Email Automation.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write
New Parse API Inbound Email
Triggers when a new email is sent to your
Trigger
Instant
Try It
- Contacts List
Trigger
Instant
Try It
- From AddressRequired
- From Name
- Reply To
- To:Required
- Cc:
- Bcc:
- SubjectRequired
- Email TEXT Body
Action
Write
- From AddressRequired
- From Name
- Reply To
- ToRequired
- Cc
- Bcc
- Subject
- TemplateRequired
- Templating Language
- Template Variables
- Error Reporting Email
- Campaign
Action
Write
- Contact ListRequired
- EmailRequired
Action
Write
- Email AddressRequired
Action
Write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
- Contacts List
Trigger
Instant
Try It
- Contacts ListRequired
Trigger
Scheduled
Try It
- From AddressRequired
- From Name
- Reply To
- To:Required
- Cc:
- Bcc:
- SubjectRequired
- Email HTML Body
Action
Write
- From AddressRequired
- From NameRequired
- Reply To
- Contact ListRequired
- Campaign TitleRequired
- SubjectRequired
- Email BodyRequired
Action
Write
- FromRequired
- ToRequired
- TextRequired
Action
Write
- Contact ListRequired
- EmailRequired
Action
Write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Mailjet

Mailjet is an all-in-one solution to send, track and deliver transactional, notification and marketing emails. Engage, analyze and react with your client base through email. Get started by using the Mailjet zap to synchronise contacts from your favorite eCommerce, CRM or other SaaS tools to your Mailjet contact lists. For users on API version 3 or higher.

Learn more Help

Related categories

Email Newsletters

Similar apps

SendGrid

Transactional Email

Mailchimp Transactional

Transactional Email

Mailgun

Transactional Email

PRODUCTS

CAPABILITIES

By team

Google Sheets + Mailjet

Update Mailjet contact properties from a Google Sheet

New Spreadsheet Row (Team Drive)

Drive

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired

WorksheetRequired

Column NameRequired

Index

Create Multiple Spreadsheet Rows

Drive

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

TitleRequired

Spreadsheet to Copy

Headers

Delete Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Update Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

SpreadsheetRequired

TitleRequired

Lookup Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Find or Create Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

New Parse API Inbound Email

New Unsubscribe

Contacts List

Send Plain Text Email

From AddressRequired

From Name

Reply To

To:Required

Cc:

Bcc:

SubjectRequired