Integrating Google Sheets with Mail Modo Using Pabbly Connect

Learn how to automate the creation of Mail Modo contacts from Google Sheets rows using Pabbly Connect. Follow this 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 Integration

To start automating the creation of Mail Modo contacts from Google Sheets, you first need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect website.

Once there, sign in with your existing account or create a new one. New users can sign up for free, receiving 100 tasks monthly. After signing in, you will land on the dashboard, where you can create new workflows.

2. Creating a New Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to name your workflow, such as ‘Create Mail Modo Contact from Google Sheets Row.’ Select the appropriate folder to save this workflow.

• Name your workflow appropriately.
• Select the folder for organization.

Once you’ve named your workflow and chosen the folder, click on ‘Create’. You will now see two sections: Trigger and Action. The Trigger is the event that starts the workflow, while the Action is what happens as a result.

3. Setting Up Google Sheets as the Trigger

In this step, we will set Google Sheets as the trigger application in Pabbly Connect. Choose Google Sheets and select the trigger event as ‘New or Updated Spreadsheet Row.’ This setup ensures that whenever a new row is added, the workflow will be activated.

Next, you will receive a webhook URL from Pabbly Connect. This URL acts as a bridge to connect Google Sheets with Pabbly Connect. Copy this URL and proceed to your Google Sheets.

4. Configuring Google Sheets to Send Data

In your Google Sheets, navigate to ‘Extensions’ and select ‘Add-ons,’ then click on ‘Get Add-ons.’ Search for ‘Pabbly Connect Webhooks’ and install it. After installation, refresh your Google Sheets. using Pabbly Connect

Go back to ‘Extensions’ > ‘Pabbly Connect Webhooks’ > ‘Initial Setup’. Here, paste the webhook URL you copied earlier and specify the trigger column, which should be the last column that will hold the final data. Once configured, click on ‘Submit’ to finalize the setup.

• Open Pabbly Connect Webhooks in Google Sheets.
• Paste the webhook URL and define the trigger column.

Now, whenever data is added to the specified column, it will be sent to Pabbly Connect, allowing the workflow to trigger.

5. Adding Mail Modo as the Action Application

With Google Sheets set up, it’s time to add Mail Modo as the action application in Pabbly Connect. Choose Mail Modo and select the action event as ‘Add Contact to a List.’ To connect, you will need your Mail Modo API key, which can be found in your Mail Modo account settings under API Keys.

Once you have the API key, return to Pabbly Connect, enter the key, and click on ‘Save’. Now, map the fields from your Google Sheets data to the Mail Modo fields. This ensures that the correct information is sent to Mail Modo whenever a new row is added in Google Sheets.

After mapping all required fields, click on ‘Save and Send Test Request’. If the setup is correct, you will receive a confirmation that the contact was successfully created in Mail Modo.

Conclusion

In this tutorial, we successfully demonstrated how to automate the creation of Mail Modo contacts from Google Sheets rows using Pabbly Connect. By following the steps outlined, you can streamline your email marketing efforts and ensure your contact list is always up to date.