We can integrate Integromat with Mailmodo for the following use cases-

  • Export Submissions to other apps (Refer guide)

  • Trigger transactional campaign Refer guide

  • Add contacts to a list (in Mailmodo) 

In this article we will see how to upload contact IDs in Mailmodo via Integromat.

This article will cover-

1. Prerequisites

2. Mailmodo API key

3. Integromat setup

For the purpose of this tutorial, we will use Google Sheets as the trigger app. Whenever a row(contact) is added to a Google sheet, the contact will be added to a list in Mailmodo.

Prerequisites

  • Your Integromat Account

  • Your Mailmodo account

  • Google Sheet containing contact email ids

  • Get the Mailmodo invite by clicking on this link.

Mailmodo API key

We would need Mailmodo API key while setting up our Integromat scenario. 

Step 1- To access it, go to Integrations from the vertical menu on the left. 

Locate Integromat under Available for Connection. Click on Click to authenticate. A dialogue box with an API key will open. Copy the API key.

To access this key in the future, go to Integrations from the vertical menu on the left. Locate Integromat from the list of Connected Platforms. Click on See Details. The same dialogue box will open, copy the API key. 

Integromat Setup

Step 1- Visit Integromat dashboard, click on Create New Scenario.


Step 2- New scenario screen will open.  Click on the plus icon. Search for Google Sheets. Add Watch Rows as trigger.

Step 3 - Click on the app to configure it. Connect your Google account. Select the spreadsheet from which you would want to push data. If there are headers, click on Next. Select the row range you have the headers on. Enter the maximum number of rows that would be worked on in one execution cycle.

In ‘Choose where to start’, you can select the options based on your data set in the google sheet. 

If you want to start the cycle from a particular data element, you can select it by using its ID or choosing manually from the list.

Click on the clock icon to configure the frequency of scenario.


Step 4 - Now, you need to add a module by clicking on the ‘semi-circle’ on the right side of Google sheets.

 Search for ‘Mailmodo’ to add it as a module. 

Select action as Add to Contact List

The module would be added. Click on the Mailmodo module to configure it.

Step 5- Click on Add under Connection. Paste the API key copied from Mailmodo. 

Step 6- Map the "Email" (mandatory) to the respective columns in the Google Sheet. 

Select the list in Mailmodo (mandatory) to which you wish to add contacts

You can optionally map other user properties in your Mailmodo account to the respective column in the Google Sheet. Please find below the default properties provided for mapping in Mailmodo.

Property Name 

Data type (Preassigned)

Definition

first_name

String

First name of the user

last_name

String

Last name of the user

name

String

Full name of the user

gender

String

Gender of the user

age

Number

Age of the user

birthday

ISO  

Birthdate of the user in ISO format (Can also sent as UNIX timestamp)

phone

String

Primary phone number of the user

address1

String 

Line 1 of the address of the user

address2

String

Line 2 of the address of the user

city

String

Name of the city (or district, village or town) of the user

state

String

State, region or province of the user

country

String

Country of the user

postal_code

String

PIN/ZIP Code of the user

designation

String

Designation of the user, usually related to their position at a specific company. Example: “VP of Engineering”

company

String

Company of the user

industry

String

Industry of the user

description

String

Description of the user

anniversary_date

ISO

Anniversary date of the user in ISO format (Can also sent as UNIX timestamp)

Once done, click on OK.

Step 7- Lastly, Click on RUN ONCE to do the test run of the integration.

Turn the scenario ON. Your integration is now ready. If any new entry is made in the google sheet, the corresponding contact will be added to the selected list in Mailmodo.