If you build or run websites on Wix, Squarespace, or WordPress, you already know the drill: a visitor fills out your contact form, and a "New Submission" notification lands in your inbox. One or two of these a day is manageable. Dozens across multiple client sites is not, especially when the only record of that lead is buried in an email you'll eventually lose track of.
In this guide, we'll walk through how to automatically turn every contact form notification email into a clean, organized row in Google Sheets, so you always have a searchable list of leads without copying a single field by hand.
Why Contact Form Notifications Are Hard to Track
Most website builders and form plugins were not designed with reporting in mind. Wix and Squarespace send you a formatted email each time someone submits a form, WordPress plugins like Contact Form 7 or WPForms do the same, but none of them give you a shared, filterable spreadsheet out of the box. If you manage more than one site, or if a client asks "how many people have contacted us this month," the honest answer usually involves scrolling through your inbox and counting.
Some platforms offer paid CRM integrations or third-party plugins to solve this, but they typically require extra setup on the website itself, and they rarely work the same way across Wix, Squarespace, and WordPress at once. Since every one of these platforms already emails you a notification, the simplest fix is to read that email and extract what matters, no matter which builder sent it.
Step-by-Step: Turning Form Emails into a Lead Sheet
1. Create a Gmail Filter and Label for Form Notifications
In Gmail, set up a filter that matches the sender addresses or subject lines your form notifications use, for example subjects containing "New Submission", "New Form Entry", "You've got a new message", or the notification address used by your Wix or Squarespace site (such as no-reply@wixsite.com). Apply a label like "Website Leads" to anything that matches, so every submission, from any of your sites or platforms, collects in one place.
2. Set Up Your Website Leads Sheet
Create a new Google Sheet named "Website Leads" and add column headers in Row 1: Date Received, Name, Email, Phone, Message, and Source Site (useful if you manage more than one website).
3. Connect Mail Sheet to the Label
Open the sheet, go to Extensions > Mail Sheet > Open, and choose the "Website Leads" label as your source. Mail Sheet is a Google Sheets add-on that scans matching emails and writes the extracted fields straight into new rows, so nothing needs to be forwarded or pasted manually.
4. Use AI Mode to Handle Different Form Platforms
A Wix notification, a Squarespace form email, and a WPForms alert all lay out their fields differently. Instead of building a separate parsing rule for each platform, switch Mail Sheet to AI Mode and use a prompt like:
"Extract the submitter's Name, Email Address, Phone Number if present, and their Message from this contact form notification email. Also note which website or form this came from based on the sender or subject line."
Because AI Mode reads the meaning of the email rather than a fixed layout, it correctly pulls the same fields whether the notification came from Wix, Squarespace, Contact Form 7, WPForms, or any other platform that emails you a submission.
5. Schedule Automatic Runs
Set Mail Sheet to check the "Website Leads" label on a recurring schedule, for example every 30 minutes or hourly. New submissions get appended to your sheet as soon as they arrive, so you or your sales team can respond quickly instead of discovering a lead a day later while cleaning out your inbox.
Use Cases Beyond a Simple Leads List
Once form submissions flow into Sheets automatically, the data becomes useful for more than just contacting leads. Agencies use it to show clients exactly how many inquiries their website generated in a given month. Small business owners pair the Source Site column with a pivot table to see which of their landing pages converts best. Web designers use the sheet as a lightweight CRM, adding a Status column to track which leads were followed up, without paying for a dedicated CRM tool.
Frequently Asked Questions
Does this work with Wix, Squarespace, and WordPress form plugins at the same time?
Yes. Wix, Squarespace, Contact Form 7, and WPForms all send a notification email whenever a visitor submits a form, and those emails land in the same Gmail inbox. Mail Sheet's AI Mode reads the content of each notification rather than matching one fixed template, so it can extract the same fields, name, email, and message, from every platform's notification format and write them into the same sheet.
What if different forms on my site collect different fields?
If you run multiple forms, for example a general contact form and a quote request form with extra fields, create a separate Gmail label and sheet tab for each one, or add the extra columns to a single sheet and instruct the AI Mode prompt to leave a field blank when a submission does not include it. Mail Sheet only fills in the columns it finds data for, so mismatched fields across forms won't break the rest of the row.
Can I get notified immediately when a new lead comes in, not just see it in the sheet?
Mail Sheet focuses on reliably logging every submission to Google Sheets on a schedule you set, including runs as frequent as every few minutes. For instant alerts on top of that, use Google Sheets' own notification rules (Tools > Notification settings) to email or notify you whenever a new row is added, giving you both a structured log and a real-time heads-up without building a separate integration.