What This Workflow Does
This automation solves a common challenge for WordPress site owners who use MailPoet for email marketing. When visitors submit forms on your website, this workflow automatically adds them as subscribers to your MailPoet lists while simultaneously logging all submission data to Google Sheets for record-keeping.
The workflow bridges WordPress forms from WordPress (via the TWZ plugin) to MailPoet's subscriber management system through n8n's powerful automation platform. It eliminates manual data entry, reduces subscription errors, and creates a complete audit trail of all form submissions.
How It Works
1. WordPress Form Submission Trigger
The workflow starts when a visitor submits any form on your WordPress that's connected through the TWZ plugin. This plugin forwards the submission data to n8n via a webhook.
2. Data Processing in n8n
n8n receives the form data and prepares it for MailPoet's API requirements. This includes:
- Validates email addresses
- Formats names correctly
- Maps custom fields
- Handles any special formatting requirements
3. Adding to MailPoet
The processed data gets added to your specified MailPoet subscriber list. The workflow handles:
- List selection
- Subscription status
- Custom field mapping
- Double opt-in settings
4. Google Sheets Logging
Simultaneously, every submission gets logged to your Google Sheet with:
- Timestamp of submission
- All form field data
- Subscription status
- Any error messages
Pro tip: Use the Google Sheets log to create dashboards showing your form conversion rates and subscriber growth trends.
Who This Is For
This workflow is ideal for:
- WordPress site owners using MailPoet
- Businesses with lead capture forms
- Marketers who want subscriber analytics
- Teams needing reliable form-to-email automation
- Teams wanting backup records of all submissions
What You'll Need
- WordPress site with TWZ plugin installed
- MailPoet account with API access
- Google Sheets with write permissions
- n8n instance (cloud or self-hosted)
- Basic understanding of webhook URLs
Quick Setup Guide
- Download and import this template into your n8n
- Connect your MailPoet account in n8n
- Set up the Google Sheets connection
- Configure your TWZ plugin webhook URL
- Test with a form submission
- Deploy when working correctly
Key Benefits
Save 5-10 hours monthly by eliminating manual list management and data entry between systems.
Reduce subscription errors by 90% through automated validation and proper formatting before adding to MailPoet.
Gain valuable insights from your Google Sheets submission logs to optimize forms and campaigns.
Improve compliance with a complete record of when and how each subscriber joined your list.
Scale effortlessly as your subscriber base grows without additional administrative work.