For modern sales teams, real estate agents, agencies, and online businesses, speed-to-lead is everything. The faster you respond to a potential client who filled out your website's contact form, the higher your chances of closing the deal. However, if your website platform simply sends lead details to your inbox, manually copying their info into your CRM or spreadsheet is a bottleneck that slows down your response time.
By automating the process, you can immediately extract email leads to Google Sheets, building a live dashboard of prospects that your team can follow up with in real time. In this tutorial, we will show you how to set up a contact form email parser to route leads to your spreadsheet automatically using Mail Sheet.
The Risk of Manual Lead Management
When leads are left in your email inbox, several issues arise:
- Slower Follow-Up: Leads are buried under newsletters, notifications, and internal chat threads.
- Data Errors: Typos are common when copy-pasting phone numbers or email addresses from messages to sheets.
- No Team Alignment: If multiple team members handle sales, it is difficult to see who is currently talking to which lead without a centralized spreadsheet.
Step 1: Identify Your Lead Email Structure
Most website builders, form builders (like WordPress Contact Form 7, Elementor, Webflow, or Squarespace), and lead marketplaces (like Zillow or Yelp) send email notifications with a structured layout. For example:
New Lead Received!
Name: Jane Doe
Email: jane.doe@example.com
Phone: (555) 019-2834
Message: Interested in the consulting plan.
Take note of the subject line and sender address that your form system uses, as we will use these to filter incoming emails.
Step 2: Install Mail Sheet
To begin, install the Mail Sheet add-on from the Google Workspace Marketplace. Mail Sheet runs entirely within Google Sheets, meaning your customer data is kept safe and secure inside your Google Workspace environment.
Step 3: Filter Lead Emails
Open a new Google Sheet (e.g., "Sales Pipeline") and launch Mail Sheet. Set up filters so the parser only looks at your form submissions:
- Sender: The email address that sends form notifications (e.g.,
noreply@webflow.comorwordpress@yourdomain.com). - Subject: The exact subject line prefix, such as
New Lead ReceivedorContact Form Submission.
Step 4: Extract Lead Details Using AI Mode
Because lead forms might vary slightly in their layout, Mail Sheet’s AI Mode is the perfect way to parse the details cleanly without writing complex regular expressions.
In the sidebar, choose AI Mode and enter the fields you need to extract:
"Extract the lead's Name, Email address, Phone number, and the Message text. Clean up any phone number formatting to standard (XXX) XXX-XXXX."
Mail Sheet will parse the body of each email and place the extracted fields into separate columns in your sheet.
Step 5: Turn on Auto-Run
To ensure your pipeline is fully automated, navigate to the **Automation** tab in Mail Sheet and enable *Auto-Run* to trigger every hour. As new leads hit your inbox, they will automatically populate your Google Sheet.
You can even set up Google Sheets notifications to ping your phone or Slack channel when a new row is added, keeping your sales team responsive.
Start Automating Your Pipeline Today
Stop wasting time on data entry and start closing more deals. By automatically parsing leads from your email to Google Sheets, you keep your customer pipeline clean, fast, and organized.
Get early access and try it for free — Join the Mail Sheet waitlist.