Skip to content

Salesforce to Google Sheets

Send Salesforce data to Google Sheets automatically

Connect Salesforce to Mammoth, pick the fields you want and send them to Google Sheets. Mammoth keeps Google Sheets up to date on a schedule, so nobody exports a report by hand.
  1. Salesforce
  2. Mammoth
  3. Google Sheets
    OpportunityStageAmountClose date
    Northwind renewalClosed Won$48,000Nov 14
    Harbor Foods expansionNegotiation$32,500Nov 28
    Lumen Labs pilotProposal$12,000Dec 05
    Atlas Freight newClosed Won$27,800Nov 11

Shown on sample data.

Set up Salesforce to Google Sheets in three steps

  1. Step 1

    Connect Salesforce

    Sign in to Salesforce from Mammoth. Production orgs, sandboxes and custom domains all work.

  2. OpportunitiesAccountsContactsLeads
    Step 2

    Pick your fields

    Tick the objects and fields you want. Preview 100 rows before you save.

  3. Updated
    Step 3

    Send it to Google Sheets

    Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.

Start free and connect Salesforce14-day Pro trial · No credit card

Choose how Google Sheets updates

Your Salesforce data refreshes every day, or only when you ask. You can set a different schedule.

Google Sheets
OpportunityStageAmountClose date
Northwind renewalClosed Won$48,000Nov 14
Harbor Foods expansionNegotiation$32,500Nov 28
Lumen Labs pilotProposal$12,000Dec 05
Replace

Clears the tab, then writes every row again.

Best for a current view, like open pipeline.

Google Sheets
OpportunityStageAmountClose date
Northwind renewalClosed Won$48,000Nov 14
Harbor Foods expansionNegotiation$32,500Nov 28
Atlas Freight newClosed Won$27,800Nov 11
Append

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.

Join

Add your other data

Join Salesforce with HubSpot, Google Ads, Xero or 100+ other sources.

12 duplicate deals removedClose dates set to one format
Clean

Fix the data first

Remove duplicates, fill blanks and fix formats. The same fixes run every time.

Win rate = Won ÷ (Won + Lost)
Calculate

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

Salesforce dashboard built in Mammoth, showing Closed won amount, Open pipeline, Win rate, Average deal size, Opportunities won, Opportunities created
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free Salesforce dashboard template

Common questions about Salesforce to Google Sheets

How do I connect Salesforce to Google Sheets?
Connect Salesforce to Mammoth and pick the fields you want. Then export them to Google Sheets, and Mammoth keeps it up to date.
Does Google Sheets update automatically?
Yes. Your Salesforce data refreshes every day, or only when you ask. You can set a different schedule. After each refresh, Mammoth sends the new data to Google Sheets.
Can I add new rows instead of overwriting the sheet?
Yes. Choose Append and Mammoth adds rows under the data already in the tab. Replace clears the tab first.
Is there a size limit?
Google Sheets holds up to 10 million cells in a spreadsheet. For more than that, use a Live link or a CSV file.
Does it work with a Salesforce sandbox?
Yes. Enter your sandbox login address, such as https://test.salesforce.com, when you connect.
What do I need in Salesforce?
A Salesforce user with API access turned on. Mammoth sees the objects and fields that user can see.

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