Sync new subscribers from Google Sheets to MailerLite without duplicates

This n8n template from Intuz provides a complete solution to automate the syncing of new subscribers from Google Sheets to MailerLite. It intelligently identifies and adds only new contacts, preventing duplicates and ensuring your email lists are clean and accurate.

Who's this workflow for?

• Marketing Teams
• Email Marketers
• Small Business Owners
• Community Managers

How it works

1. Read from Google Sheets: The workflow begins by reading all contact rows from your designated Google Sheet.

2. Check for Existing Subscribers: For each contact, it performs a search in MailerLite to check if a subscriber with that email address already exists.

3. Handle Duplicates: If the subscriber is found in MailerLite, the workflow stops processing that specific contact, preventing any duplicates from being created.

4. Create New Subscribers: If the contact is not found, the workflow proceeds to create a new subscriber in MailerLite, using all the details from the Google Sheet (like name, company, and country) and assigns them to the specified group.

Setup Instructions

1. Google Sheets Setup:

• Connect your Google Sheets account to n8n.
• Create a sheet with the required columns: Email, first_name, last_name, Company, Country, and group_id.
• In the Get row(s) in sheet node, select your credentials and specify the Document ID and Sheet Name.

2. MailerLite Setup:

• Connect your MailerLite account to n8n using your API key.
• In both the Get a subscriber and Create subscriber... nodes, select your MailerLite credentials.
• Make sure the group_id values in your Google Sheet correspond to valid Group IDs in your MailerLite account.

3. Activate Workflow:

• Save the workflow and click "Execute workflow" to run the sync whenever you need to update your subscriber list.

Connect with us

• Website: https://www.intuz.com/services
• Email: [email protected]
• LinkedIn: https://www.linkedin.com/company/intuz
• Get Started: https://n8n.partnerlinks.io/intuz

For Custom Worflow Automation

Click here- Get Started