Build a CRM in Google Sheets with Email Integration

A Google Sheets CRM is the fastest one to set up. No onboarding, no per-seat pricing, no learning curve — just columns for contacts, a row per email, and filters that actually work. Add a VLOOKUP or two, throw in some conditional formatting, and you've got something genuinely functional in under an hour.

The missing piece is getting client emails in there without manually copying things over. Here's how to connect your Gmail inbox to a Sheets CRM using Quicktion.

Why a CRM in Google Sheets?

• Zero cost — Google Sheets is free, unlike CRM tools that charge per user per month
• No learning curve — your team already knows spreadsheets
• Full customization — add any column, formula, or filter you need
• Shared access — multiple team members can view and edit the pipeline in real time
• Formulas and analysis — use COUNTIF, DAYS, and conditional formatting to track your pipeline automatically

Setting Up Your CRM Spreadsheet

Create a single spreadsheet with these columns:

Use data validation to create dropdown menus for Stage, Priority, and Source. This keeps your pipeline data consistent and makes filtering reliable.

Connecting Your Email (via Quicktion)

Method 1: Email Forwarding

For high-volume client communication, set up forwarding rules:

1. Create a Quicktion destination pointing to your CRM spreadsheet
2. Create a Gmail filter for a specific client's email domain (e.g., from:*@clientcompany.com)
3. Forward to your Quicktion address
4. All emails from that domain automatically appear as new rows in your spreadsheet

This works well for clients who use a company domain. You can also forward emails from your contact form address or sales inbox to capture every inquiry automatically.

Method 2: Gmail Add-on

The Gmail add-on is ideal for CRM because you want to choose which emails to save:

1. Install the Quicktion Gmail add-on from the Google Workspace Marketplace
2. When an important client email arrives, click the Quicktion icon in Gmail's sidebar
3. Select your CRM destination and save

This gives you control over what enters your pipeline. Not every email deserves a CRM entry — the add-on lets you be selective.

CRM Workflows

New Lead Workflow

1. A new inquiry arrives (via forwarding or saved manually with the add-on)
2. Set Stage to "Lead" and assign a Priority
3. Add the contact name and any relevant notes
4. Set a Next Follow-Up date
5. Respond to the inquiry from your email client

Follow-Up Tracking

Use a formula to surface contacts who need attention. In a helper column, calculate days since last contact:

=DAYS(TODAY(), Date_cell)

Apply conditional formatting to highlight rows where this value exceeds 7 days and Stage is not "Won" or "Lost". You can also create a filter view showing only rows where Next Follow-Up is today or in the past.

Pipeline Visualization

Use conditional formatting to color-code your Stage column:

• Lead -- Yellow
• Contacted -- Blue
• Negotiation -- Orange
• Won -- Green
• Lost -- Gray

Create a summary section with formulas to see your pipeline at a glance:

• Total leads: =COUNTIF(Stage_range, "Lead")
• Active deals: =COUNTIFS(Stage_range, "<>Won", Stage_range, "<>Lost")
• Win rate: =COUNTIF(Stage_range, "Won") / COUNTA(Stage_range)

Tips for a Better Email CRM

Save selectively. Don't log every email — focus on communications you'll actually need to reference later.

Add context immediately. When saving via the add-on, fill in the Notes column with next steps or key points while the conversation is fresh.

Review weekly. Scan your pipeline using a filter view sorted by Stage. Update stages, follow up on stale leads, and archive deals that have gone cold.

Use the Next Follow-Up column. A CRM without follow-up tracking is just an email log. Set a date for every active deal and check it daily.

Share with your team. Each person can create their own filter views without affecting anyone else.

Get Started

Sign up for Quicktion and set up a destination for your CRM spreadsheet. Use the Gmail add-on for selective saving or email forwarding for automatic capture — or use both together.

For more on connecting Gmail to Google Sheets, see our integration guide or the email tracking spreadsheet walkthrough. You can also build a CRM in Notion or Airtable if you prefer those platforms.