Mailmodo 0ff833fbTry Mailmodo for Free↗️Login Mailmodo↗️

No results

Help CenterIntegrationsPabblyImporting Contacts in Mailmodo via Pabbly

Importing Contacts in Mailmodo via Pabbly

Last updated December 24, 2023

We can integrate Pabbly with Mailmodo to implement the following use cases-

  • Add contacts to a list (in Mailmodo)
  • Trigger a transactional campaign (  guide  )

In this article, we will cover-

1. Integrating Pabbly with Mailmodo

1.1 Mailmodo API Key

2. Pabbly setup

2.1 Configuring the Trigger app

2.2 Configuring the Action app (Mailmodo) 

2.2.1 Add Contacts to a List

Mailmodo API key

Step 1Go to Settings from the vertical menu on the left. Navigate to API keys. Click on Show API Key. Select and copy the API key.

Importing Contacts in Mailmodo via Pabbly

Pabbly Setup

Step 1Go to Pabbly homepage, click on Pabbly Connect (Access Now)

Importing Contacts in Mailmodo via Pabbly

Step 2You will be redirected to Pabbly Connect. Click on Create Workflow.

Importing Contacts in Mailmodo via Pabbly

Step 3Give your workflow a suitable name. Click on Create.

Importing Contacts in Mailmodo via Pabbly

Step 4Choose the first application. Events recorded in this application will trigger your workflow.

Importing Contacts in Mailmodo via Pabbly

Step 5Select a trigger event for the chosen app.

Importing Contacts in Mailmodo via Pabbly

Step 6You might need to follow some on screen instructions for the chosen app. The instructions will vary depending on the app you choose.

Configuring the Trigger App

For the purpose of this tutorial, we will select Google Sheets as the trigger app.

Step 1Copy the Webhook URL from Pabbly.

Importing Contacts in Mailmodo via Pabbly

Step 2: Create a new spreadsheet->Navigate to Extensions->Add-ons->Get Add-ons

Importing Contacts in Mailmodo via Pabbly

Step 3A dialogue box will open, search for Pabbly Connect Webhooks.

Importing Contacts in Mailmodo via Pabbly

Install the extension.

Importing Contacts in Mailmodo via Pabbly

Step 4Choose the account for which you want to download the extension, give necessary permissions. Upon successful installation, you will see the following screen. Click on Done. Refresh the page.

Importing Contacts in Mailmodo via Pabbly

Step 5: Again navigate to Extensions->Pabbly Connect Webhooks->Initial Setup

Importing Contacts in Mailmodo via Pabbly

Step 6A dialogue box will open, paste the webhook URL copied from Pabbly.

Importing Contacts in Mailmodo via Pabbly

Enter Trigger column. Trigger column will be your final data column on which if the data is added, the whole of that row data will be sent to the webhook URL.

For the spreadsheet above (see image), the last data column in B. So, trigger column for this spreadsheet is B.

Note- Be careful while entering the trigger column. Wrong value will not trigger the webhook or incomplete data will be sent.

Step 7Click on Send Test. Your screen should look like this.

Importing Contacts in Mailmodo via Pabbly

Go back to Pabbly, you should be able to see the Webhook response.

Importing Contacts in Mailmodo via Pabbly

Step 8Click Submit on the Initial Setup dialogue box (in google sheets). Your initial setup is now saved.

Importing Contacts in Mailmodo via Pabbly

Step 9: Navigate to Extensions->Pabbly Connect Webhooks->Enable Send on Event

Importing Contacts in Mailmodo via Pabbly

If you are manually making the change in the Spreadsheet, the updated data will be sent immediately to Pabbly Connect. Ensure enabling the Send on Event option in the add-on.

If the change is made through an external platform besides Google Forms in the Spreadsheet, the trigger will be sent once every hour. Ensure you enable the Send on Schedule option in the add-on.

Importing Contacts in Mailmodo via Pabbly

You have successfully set up the webhook in your Google Sheets as a trigger!

Configuring the Action App (Mailmodo)

Step 1Search and select Mailmodo as the Action app.

Importing Contacts in Mailmodo via Pabbly

Step 2Select the Action Event

Importing Contacts in Mailmodo via Pabbly

Step 3Click on Connect. A dialogue box will open. Select Add New Connection, paste the API key copied from Mailmodo.

Importing Contacts in Mailmodo via Pabbly

Click on Save. Your Mailmodo account is now connected.

Importing Contacts in Mailmodo via Pabbly

Add Contacts to List

After connecting your account and selecting the Action event as Add Contacts to List, you need to map the following parameters-

Email: Map it to the column in your spreadsheet containing Email ID's

List Name: Name the list in which you want to add your contacts. If the list does not exist, it will be created.

Personalization Fields: Map the personalisation parameters to the respective columns in your spreadsheet eg. First Name, Customer ID etc.

Personalization should be done as shown below.

Importing Contacts in Mailmodo via Pabbly

Personalization format:-

"parameter_name":"Selected_parameter_from_google_sheet"

Type the name of the personalisation key used in Mailmodo (eg. first_name) inside double quotes. Insert a colon (:). Select the parameter from Google sheet, insert it between the double quotes.

Save and Test Send request. Upon successful testing, save your workflow. Make sure your workflow is ON.

Every time a row is added or updated, the contact will be added to a list in Mailmodo.

Was this article helpful?