Salesforce to Google Sheets
Send Salesforce data to Google Sheets automatically
Salesforce
- Mammoth
Google Sheets
Opportunity Stage Amount Close date Northwind renewal Closed Won $48,000 Nov 14 Harbor Foods expansion Negotiation $32,500 Nov 28 Lumen Labs pilot Proposal $12,000 Dec 05 Atlas Freight new Closed Won $27,800 Nov 11
Shown on sample data.
Set up Salesforce to Google Sheets in three steps
- Step 1
Connect Salesforce
Sign in to Salesforce from Mammoth. Production orgs, sandboxes and custom domains all work.
- OpportunitiesAccountsContactsLeadsStep 2
Pick your fields
Tick the objects and fields you want. Preview 100 rows before you save.
Updated
Step 3Send it to Google Sheets
Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.
Choose how Google Sheets updates
Your Salesforce data refreshes every day, or only when you ask. You can set a different schedule.
| Opportunity | Stage | Amount | Close date |
|---|---|---|---|
| Northwind renewal | Closed Won | $48,000 | Nov 14 |
| Harbor Foods expansion | Negotiation | $32,500 | Nov 28 |
| Lumen Labs pilot | Proposal | $12,000 | Dec 05 |
Clears the tab, then writes every row again.
Best for a current view, like open pipeline.
| Opportunity | Stage | Amount | Close date |
|---|---|---|---|
| Northwind renewal | Closed Won | $48,000 | Nov 14 |
| Harbor Foods expansion | Negotiation | $32,500 | Nov 28 |
| Atlas Freight new | Closed Won | $27,800 | Nov 11 |
Adds new rows under the ones already there.
Best for a running log, like deals closed each week.
A spreadsheet holds up to 10 million cells. For bigger data, use a Live link or a CSV file.
Clean and combine your Salesforce data first
Mammoth gets the data ready before it goes to Google Sheets.
Add your other data
Join Salesforce with HubSpot, Google Ads, Xero or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Win rate = Won ÷ (Won + Lost)Add the columns you need
Work out win rate, deal age or quarter so they arrive ready to use.
What teams use Salesforce in Google Sheets for
Weekly pipeline review
Open deals by stage and owner, current every Monday.
Commission tracking
Closed won deals by rep, added to the sheet as they close.
Finance forecasts
Expected revenue by close month, ready for the forecast model.
Ways to get Salesforce data into Google Sheets
Mammoth
For clean Salesforce data in a sheet, joined with your other sources.
- ✓Updates on a schedule
- ✓Clean the data before it reaches the sheet
- ✓Join HubSpot, ads or finance data
- ✓Send the same data to Excel, Power BI or a warehouse
- ✕Edit Salesforce records from the sheet
Data connector for Salesforce
Free, made by Google. For pulling a Salesforce report into a sheet.
- ✓Updates on a schedule
- ~Clean the data before it reaches the sheetWith a SOQL query
- ~Join HubSpot, ads or finance dataSalesforce only
- ✕Send the same data to Excel, Power BI or a warehouse
- ✓Edit Salesforce records from the sheet
Export a report by hand
For a one-off copy of the numbers.
- ✕Updates on a schedule
- ~Clean the data before it reaches the sheetBy hand
- ~Join HubSpot, ads or finance dataPasted in by hand
- ✕Send the same data to Excel, Power BI or a warehouse
- ✕Edit Salesforce records from the sheet
Or turn the same data into a Salesforce dashboard
Describe the dashboard in one sentence and Mammoth builds it from your data.
The template: paste this into Mammoth
Salesforce opportunity dashboard: closed won amount, open pipeline, win rate (won opportunities over closed opportunities), average deal size, opportunities won and opportunities created as KPIs, closed won amount by month, open pipeline by stage, and closed won amount by lead source

Common questions about Salesforce to Google Sheets
How do I connect Salesforce to Google Sheets?
Does Google Sheets update automatically?
Can I add new rows instead of overwriting the sheet?
Is there a size limit?
Does it work with a Salesforce sandbox?
What do I need in Salesforce?
Step-by-step setup is in our docs for Salesforce and Google Sheets.
Keep Google Sheets up to date with Salesforce data.
Start free, connect Salesforce, and send it to Google Sheets.
- ✓ 14-day Pro trial
- ✓ No credit card
- ✓ Viewers always free