How to send contact form leads from Gmail to Google Sheets

By Jake Marsh · Updated

To get contact form leads from Gmail into Google Sheets, open Rowcatch, click New and choose Leads and contact forms. It finds emails with subjects like "contact form", "new lead", "new submission" or "inquiry", and writes the date, name, email, phone, company, message, form and a Gmail link for each one. Click Preview on 20 emails, adjust the labels to match your form, create the spreadsheet, export, then set it to run every hour.

Why this works on almost any form

Website forms built with WordPress plugins, Webflow, Squarespace, Wix and most other site builders email each submission as a list of "Label: answer" lines:

Name: Dana Ruiz
Email: dana@example.com
Phone: (469) 555-0142
Company: Ruiz Landscaping
Message: Do you service Plano?

Rowcatch's Text after a label rule reads exactly that shape, so it doesn't matter which form builder sent the email.

Steps

  1. Click New, then Leads and contact forms.
  2. Set the search in step 1. Keep the suggested one or point it at your form's sender, for example from:wordpress@yoursite.com newer_than:1y. Click Find emails to make sure only lead emails match.
  3. Click Preview on 20 emails and check each column.
  4. Match the labels to your form. Each column already tries several spellings:
ColumnLabels it looks forFormat
NameFull name, Name, Your name, First nameTrim spaces
EmailEmail, E-mail, Your email, Email addressFirst email address
PhonePhone, Phone number, Mobile, TelFirst phone number
CompanyCompany, Organization, BusinessTrim spaces
MessageMessage, Comments, How can we help, DetailsTrim spaces
FormThe email's subjectAs found

If your form says "Business name", add it: Business name|Company|Organization. For an extra question, click Add column, set From to Body text, Take to Text after a label and type the question's label.

  1. Create the spreadsheet in step 4, then Check what will be exported and Export N emails now.
  2. Set step 5, Keep it up to date, to Every hour so new leads land in the sheet while Chrome is open.

Keep one row per lead

The template uses "One row per email; skip emails already in the sheet", which is right for most forms. If the same person fills in your form twice and you want only their first inquiry, switch Duplicates to "Skip rows whose value in a column is already there" and pick the Email column.

Leads from more than one form

Make one export per form or per site, each with its own search, and pick the same spreadsheet in step 4 with Or use one Rowcatch created earlier.... Each export writes its own tab. The Form column, which holds the subject line, tells leads apart when several forms share one export.

Moving leads into a CRM

Most CRMs import a CSV file. Download the sheet from Google Sheets with File > Download > Comma separated values, or use Download this preview as CSV for a quick test. Rowcatch puts the email address and phone number in clean columns of their own, which is what an import screen asks you to map.

Mixed form notification emails

Notifications from form tools that list every question, such as quizzes or applications, suit the Form notifications template better. It gives one column per question; rename its "Question 1" and "Question 2" labels to the exact question text in your form.

What it costs

The trial covers your first 100 exported emails or 7 days, whichever comes first, with every feature. Then Starter is $39 a month (1 saved export, 1,000 emails a month), Pro $70 (10 exports, 2,000 emails) and Business $99 (unlimited exports, 4,000 emails), per Google account. Every plan and the install link are on the Rowcatch page.

Rowcatch: Email Parser to Google Sheets for Gmail

Export Gmail emails to Google Sheets with parsing rules, duplicate checks and scheduled sync 3 plans from $39 a month per Google account.


Questions

Will the sheet update when a new lead comes in?

Yes, with step 5 set to Every hour, Every 6 hours or Every day. Scheduled runs happen while Chrome is open on that computer; if Chrome was closed, the next run catches up.

Can I add my own columns, like Status or Follow up?

Yes. Add them in the sheet next to Rowcatch's columns. Rowcatch keeps them and lines new rows up by column name.

What if the phone number is written in different ways?

First phone number finds the number in formats such as (469) 555-0142, 469.555.0142 and +1 469 555 0142, and writes it as it appears in the email.

Does Rowcatch send anything to the lead?

No. Gmail access is read-only, so Rowcatch can't send, reply to or change any email.


More Rowcatch guides


More Chrome guides