Build a CRM in Google Sheets with Email Integration

Google Sheets makes a surprisingly good CRM for small teams. It's flexible, shareable, and everyone already knows how to use it. The missing piece? Getting client emails into your pipeline without copy-pasting.

Here's how to build a Google Sheets CRM with email integration 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

1. Save selectively -- Don't save every email. Focus on important communications that you'll need to reference later.
2. 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.
3. 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.
4. Use the Next Follow-Up column -- A CRM without follow-up tracking is just an email log. Set a follow-up date for every active deal and check it daily.
5. Share with your team -- Give team members access to the spreadsheet. Each person can create their own filter views without affecting others.

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.