---
name: sync-crm-to-google-sheets
description: "Sync Salesforce Pipeline to Google Sheets Dashboard. Use when executives ask for pipeline reports in spreadsheets, but pulling data manually creates version control chaos."
---

# Sync Salesforce Pipeline to Google Sheets Dashboard

Executives ask for pipeline reports in spreadsheets, but pulling data manually creates version control chaos.

## When to use this skill

- The user wants to set up or run this workflow: "Sync Salesforce Pipeline to Google Sheets Dashboard".
- The user describes this problem: Executives ask for pipeline reports in spreadsheets, but pulling data manually creates version control chaos.

## At a glance

- Category: RevOps
- Difficulty: Beginner
- Time saved: 4 hours per week. This figure is an estimate, not a measured result.

## Tools

Options separated by "or" are alternatives; use whichever the user already has.

- Zapier
- Salesforce
- Google Sheets

## Steps

1. Set up Zapier trigger on Salesforce Opportunity (updated)
2. Map Salesforce fields to Google Sheets columns (deal name, stage, amount, close date, owner)
3. Use Zapier Formatter to calculate days in stage
4. Write or update row in Google Sheets using Opportunity ID as unique key
5. Add Google Sheets formula row for total pipeline by stage

## Template outline

Field names, thresholds, and message text are starting points to adapt.

~~~text
Zapier Steps:
1. Trigger: Salesforce > Updated Opportunity
2. Filter: Only include open opportunities (Stage != "Closed Won" AND != "Closed Lost")
3. Formatter: Calculate days in current stage
4. Google Sheets: Update Spreadsheet Row (search by Opportunity ID)
5. Paths: If new opp, create row; if existing, update row
~~~

## Guardrails

- Work only in the user's own accounts and workspaces, with their credentials.
- Confirm with the user before any step that writes to a CRM, sends email or messages, spends credits, or moves money.
- Treat every hours, cost, and threshold figure as a starting assumption and replace it with the user's numbers.
- Do not invent data, prices, or results. If a vendor price matters, check the vendor's current pricing page.

## Source

https://gtmplaybooks.io/playbooks/sync-crm-to-google-sheets/