Understanding Your Sheet Layout
Learn how your Google Sheet is organized with tabs, columns, and lead scoring.
Tab structure
Your Google Sheet has one tab (worksheet) per form. If your website has a contact form and a newsletter signup form, you’ll see two tabs at the bottom of your spreadsheet — one for each.
Tab names are generated automatically based on the page and form type. For example, you might see tabs like "Homepage - Contact Form" or "Pricing - Quote Request".
Tip
You can rename tabs directly in Google Sheets if you prefer different names. Lead to Sheet will continue to sync to the correct tab regardless.
Column layout
Each tab in your spreadsheet has a consistent column layout. From left to right:
- 1
Lead Quality
A dropdown column for you to score and categorize each lead (see below).
- 2
Submitted At
The date and time the form was submitted, shown in the submitter’s local timezone when available.
- 3
Form fields
All the fields from the form (name, email, phone, message, etc.) in the order they were first seen.
- 4
Page URL
The full URL of the page where the form was submitted.
- 5
Referrer
The page the visitor was on before arriving at your form.
- 6
UTM parameters
Source, medium, campaign, term, and content — if present in the URL.
- 7
Ad click IDs
Google, Facebook, Microsoft, TikTok, and LinkedIn click IDs — if present.
- 8
Browser & device data
Browser, Browser Version, OS, OS Version, Device, Device Type, Device Vendor, Language, Platform, Screen Size, Viewport Size, and Timezone.
Note
The header row is bold and frozen so it stays visible as you scroll down through your submissions.
Lead quality scoring
The first column in each tab is a Lead Quality dropdown. This is for you and your team to score leads as you review them. It’s not filled in automatically — it’s a manual tool to help you prioritize follow-ups.
The available scores are:
- No Score Yet (default)
- Unqualified Lead
- Cold Lead
- Warm Lead (Low Fit)
- Warm Lead (Good Fit)
- Hot Lead
- Sales-Ready Lead
Each score is color-coded in the spreadsheet so you can scan your leads visually. Just click the cell and select a score from the dropdown.