Overview
Mailchimp's landing page builder creates simple email signup and product showcase pages that feed directly into Mailchimp audiences. While this is convenient for email marketing, the landing page tool offers limited customization and no per-subscriber UTM attribution. LeadToSheet captures every signup alongside its traffic source data in Google Sheets, providing a backup of your audience that includes campaign-level attribution and is accessible to team members who do not have Mailchimp access.
Implementation checklist
- 1
Add the LeadToSheet SDK via Mailchimp's custom code block
In the Mailchimp landing page editor, add a Code content block to your page. Paste the SDK snippet inside it. Position the code block at the bottom of the page so the script loads after the form elements.
Tip: Mailchimp's Code block may strip script tags on some plans. If the script does not load, try adding it via Mailchimp's Website Builder settings under Custom Code > Footer if available on your plan.
Mailchimp code block
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Review audience fields mapped to the landing page form
Mailchimp landing page forms pull fields from your audience settings. Go to Audience > Settings > Audience fields and merge tags to see which fields are available. LeadToSheet captures the field names as they render on the page, which correspond to your merge tag labels.
- 3
Submit a test signup and verify both Mailchimp and Sheets
Enter a test email address on your landing page. Confirm it appears in both your Mailchimp audience list and your Google Sheet. Check that the Sheet row includes the page URL and any UTM parameters from the landing page link you used.
Customization ideas
Create a Sheets-based audience backup
Mailchimp audiences can lose subscribers through unsubscribe actions, list cleaning, or accidental deletion. Your Google Sheet serves as an immutable log of every original signup with timestamp and source, giving you a recovery reference that Mailchimp's activity log may not fully cover.
Add per-subscriber UTM attribution
Mailchimp tracks landing page traffic sources in aggregate but does not attach UTM parameters to individual subscriber records. LeadToSheet fills this gap by capturing the full UTM string with each signup, enabling per-subscriber campaign attribution in Sheets.
Share lead data without sharing Mailchimp access
Grant Google Sheets access to sales, support, or partner teams who need to see landing page signups without giving them Mailchimp logins. This avoids additional Mailchimp seat costs and keeps your email marketing configuration secure.
Troubleshooting
Code content block not executing JavaScript
Some Mailchimp plans restrict JavaScript execution in Code blocks for security reasons. If the LeadToSheet script does not run, check whether your plan supports custom JavaScript on landing pages. As an alternative, use Mailchimp's landing page webhook or Zapier integration to forward submissions to LeadToSheet's server-side endpoint.
Double opt-in delays Sheets entry
Mailchimp may require double opt-in for new subscribers, meaning the contact is not confirmed until they click an email link. LeadToSheet captures the form submission at the browser level regardless of opt-in status, so the Sheet row appears immediately. Add a column note that the contact may not be confirmed in Mailchimp yet.
Product showcase page forms behaving differently
Mailchimp product showcase landing pages may use a different form structure than email signup pages, especially for 'Buy Now' buttons connected to Mailchimp Stores. These commerce buttons may not render as standard forms. If product page submissions are not captured, they may be processing through Stripe or Square rather than a form element.
Resources
Frequently asked questions
- Why do I need Sheets when Mailchimp already stores my subscribers?
- Sheets gives you a backup independent of Mailchimp, adds per-subscriber UTM attribution that Mailchimp does not offer, and lets non-Mailchimp users access signup data without additional seats. It also preserves a complete history even if subscribers are later removed from your audience.
- Does LeadToSheet add subscribers to my Mailchimp audience?
- No. LeadToSheet captures the form submission and writes to Google Sheets only. It does not interact with Mailchimp's audience, email automation, or subscriber management. Mailchimp handles audience addition independently.
- Can I use LeadToSheet on Mailchimp's free plan?
- It depends on whether the free plan supports custom JavaScript in Code blocks. If JavaScript is restricted, use Mailchimp's integration options to forward submissions to LeadToSheet's webhook endpoint as an alternative capture method.