How to Create Mail Modo Contacts from Google Sheets Using Pabbly Connect

Learn how to automate creating Mail Modo contacts from Google Sheets using Pabbly Connect. Step-by-step tutorial for seamless integration! Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating the creation of Mail Modo contacts from Google Sheets, you need to access Pabbly Connect. Begin by visiting the Pabbly website and signing in to your account. If you are a new user, sign up for free to get started with 100 tasks monthly.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you will see the option to create a new workflow. This will allow you to set up the integration between Google Sheets and Mail Modo. Click on ‘Create Workflow’ to proceed with setting up your automation.

2. Setting Up Google Sheets as the Trigger Application

In this step, you will configure Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets and choose the event as ‘New or Updated Spreadsheet Row’. This means that every time a new row is added to your Google Sheets, it will trigger the workflow.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, go to your Google Sheets document where you have your customer details. Click on ‘Extensions’, then ‘Add-ons’, and finally ‘Get Add-ons’. Search for Pabbly Connect Webhooks and install it. After installation, refresh your Google Sheets to ensure the add-on is active.

3. Configuring the Webhook URL in Google Sheets

To connect Google Sheets with Pabbly Connect, you need to configure the webhook URL. Click on ‘Extensions’, navigate to ‘Pabbly Connect Webhooks’, and select ‘Initial Setup’. Here, paste the webhook URL you copied earlier.

Additionally, specify the trigger column in your Google Sheets. This column will be the final data column that triggers the webhook when a new entry is added. For example, if your last column is ‘D’, enter ‘D’ in the trigger column field and submit the setup.

• Paste the webhook URL in the setup.
• Specify the trigger column (e.g., ‘D’).
• Click ‘Submit’ to save the configuration.

Finally, go back to ‘Extensions’ and select ‘Send on Event’ to ensure that future data entries are sent to Pabbly Connect. This completes the Google Sheets setup for triggering the automation.

4. Adding Mail Modo as the Action Application

After configuring Google Sheets, it’s time to set up Mail Modo as the action application in Pabbly Connect. Select Mail Modo and choose the action event as ‘Add Contact to a List’. This action will create a new contact in Mail Modo whenever a new row is added in Google Sheets.

If you do not have an existing connection, click on ‘Add New Connection’. You will be prompted to enter your Mail Modo API key. To find this, log in to your Mail Modo account, navigate to ‘Settings’, and then ‘API Keys’. Here, create a new API key and copy it.

Select Mail Modo as the action application. Choose ‘Add Contact to a List’ as the action event. Enter your Mail Modo API key to establish the connection.

Once the connection is established, you will map the fields from Google Sheets to Mail Modo. This includes mapping the email address and other personalization fields to ensure the contact is created correctly in Mail Modo.

5. Testing the Integration Between Google Sheets and Mail Modo

To verify that the integration between Google Sheets and Mail Modo is working correctly, you will need to enter some dummy data into your Google Sheets. For instance, input a first name, last name, phone number, and email address into the respective columns.

Once the data is entered, return to Pabbly Connect and check for the webhook response. If the setup is correct, you should see the captured data reflected in the response. This confirms that Google Sheets is successfully sending data to Pabbly Connect.

Enter dummy data in Google Sheets to test the integration. Check the webhook response in Pabbly Connect for confirmation. Verify that the contact is created in Mail Modo.

After testing, you should see the new contact in your Mail Modo list, confirming that the automation is working perfectly. This process effectively automates the creation of contacts from Google Sheets to Mail Modo using Pabbly Connect.

Conclusion

This tutorial detailed how to automate the creation of Mail Modo contacts from Google Sheets using Pabbly Connect. By following these steps, you can streamline your email marketing processes efficiently and effectively.