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 by combining the page name and form name. 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. LeadToSheet 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
AI lead intelligence
Lead Score (Hot/Warm/Cold), Lead Score Reason, and Lead Summary — filled in automatically by the AI scorer when it runs on the submission (separate from the manual Lead Quality column in column A).
- 7
Company & person enrichment
Match Confidence, Company, Job Title, LinkedIn, Industry, Company Size, and Country — filled in by our AI when it can recognise the person or company. Company, Industry, Company Size, and Country need a business email address; Job Title and LinkedIn can sometimes be found even from a personal email.
- 8
UTM parameters
Source, medium, campaign, term, and content — if present in the URL.
- 9
Paid ad attribution
Two columns — Paid Source and Click ID — that consolidate paid-ad attribution across Google, Meta, Microsoft, TikTok, and LinkedIn (the platform that produced the click, plus its click ID). Present when the visitor arrived from a paid ad.
- 10
Browser & device data
Browser, Browser Version, OS, OS Version, Device, Device Type, Device Vendor, Language, Platform, Screen Size, Viewport Size, and Timezone.
- 11
Submission ID
A unique identifier for the submission, written as the final column. LeadToSheet uses this to find and update the row if the submission changes - leave it untouched.
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.