Salesforce logo Google Sheets logo

How to Integrate Salesforce with Google Sheets

Native vs Make vs n8n vs Relay — setup time, cost & field mapping

Integration Status

Not every Salesforce stakeholder is a Salesforce user — but finance leads, operations managers, and executives still need access to pipeline data, account lists, and activity metrics. Google Sheets fills that gap, giving teams a familiar, flexible workspace to analyze CRM data without navigating Salesforce's report builder or waiting on an admin. Syncing Salesforce to Sheets enables live pipeline exports for forecasting models, contact lists for territory planning, and custom dashboards that blend CRM data with inputs from other sources. For RevOps teams, it's often the fastest way to build the report that Salesforce can't quite produce natively.

Note: We've identified 2 known limitations with this integration. See known limitations below for details.

Data Flow Architecture

Salesforce Salesforce
→ One-Way
Standard API Latency
Google Sheets Google Sheets
API Tier
REST API v3
Auth Method
OAuth 2.0
Rate Limits
Standard SaaS Limits

Integration Overview

Connect Salesforce to Google Sheets and automate customer data sync, eliminating manual entry and ensuring compliance with data residency requirements.

Primary Use Case

Sync customer data from Salesforce to Google Sheets for unified customer view and automated reporting.

Setup Complexity

medium

Typical Setup Time

20 minutes

💰 Cost Estimator

Calculate your monthly automation cost based on data volume

Records per month
10,000
0 10,000 15,000+

💡 Tip: Make is best for complex logic and data transformations. n8n is great if you need privacy and self-hosted control. Relay adds manager approval gates—perfect for sensitive financial or legal data transfers. Pabbly Connect offers unlimited tasks at a flat rate—ideal for high-volume workflows on a budget.

Known Limitations & Errors

criticalHigh
Salesforce opportunity forecast data isn't exporting to Google Sheets
View Fix →
highModerate
Currency and date fields are displaying incorrectly in Google Sheets
View Fix →

Recommended Integration Path

Salesforce to Google Sheets is a technical workflow.

This pair usually requires custom mapping (Forecast Modeling Export), so an automation layer is needed between Salesforce and Google Sheets.

Primary Recommendation: Make for Fast Automation

Make is the fastest way to map fields and automate Salesforce -> Google Sheets without custom code.

  • Visual scenarios with branch logic and filters
  • Strong data mapping and transformation controls
  • Reliable fallback path when native sync is limited
Start with Make

Budget Alternative: Pabbly Connect

Pabbly Connect is a one-time payment automation tool — ideal for Salesforce → Google Sheets workflows without monthly fees.

  • One-time pricing with unlimited tasks
  • 1,000+ app integrations including most SaaS tools
  • Good fit for teams on tight automation budgets
Try Pabbly Connect

Integration Solutions

Choose the right tool for your requirements:

Platform Cost
🔗
Native
Free
Free
Included
Make
$9–99/mo
Budget-Friendly
Start Free
✨ Fastest to Deploy

Use Make to get running in 15–45 minutes. Map fields, transform data, and connect dozens of apps without touching code. Best for startups and fast iterations.

👤 Require Human Sign-Off

Add Relay on top of any solution to require approval before syncing. Perfect for finance, legal, or compliance—let humans make the final call before data moves.

🔐 Maximum Control

Deploy n8n on your own servers for zero cloud dependencies. Full data residency, unlimited customization, and complete audit trails—essential for healthcare, finance, and GDPR compliance.

Ready to automate? We have a template for you.

Copy this Salesforce → Google Sheets blueprint, open n8n, paste it into the canvas, and your workflow is ready to configure.

n8n
salesforce-google-sheets-blueprint.json
{
  "name": "Salesforce → Google Sheets Sync",
  "nodes": [
    {
      "id": "node-1",
      "name": "Salesforce Trigger",
      "type": "n8n-nodes-base.salesforceTrigger",
      "typeVersion": 1,
      "position": [
        240,
        300
      ],
      "parameters": {},
      "credentials": {
        "salesforceOAuth2Api": {
          "id": "1",
          "name": "Salesforce account"
        }
      }
    },
    {
      "id": "node-2",
      "name": "Google Sheets Action",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 1,
      "position": [
        460,
        300
      ],
      "parameters": {},
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "2",
          "name": "Google Sheets account"
        }
      }
    }
  ],
  "connections": {
    "Salesforce Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets Action",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "tags": [
    "integratestack",
    "blueprint",
    "salesforce",
    "google-sheets"
  ]
}

Frequently Asked Questions

How do I connect Salesforce to Google Sheets?

There's no native integration. To connect them, you will need a middleware tool like Make or n8n.

Is the connection between Salesforce and Google Sheets secure?

Yes. This integration typically uses OAuth 2.0, meaning you grant permission via a secure login window. You do not need to share your raw password, and you can revoke access at any time from your Salesforce security settings.

Is the sync one-way or two-way?

This is typically a one-way sync: Salesforce → Google Sheets. Changes in Google Sheets do not sync back to Salesforce.

Will existing data in Salesforce sync to Google Sheets?

Usually, no. Most native integrations are "forward-looking," meaning they only sync data created or updated *after* you activate the connection. To move historical data, you will likely need to perform a one-time CSV export/import manually.

Why does Salesforce opportunity forecast data isn't exporting to Google Sheets?

This is a known issue (~50% of users). Common cause: Report Filter Configuration. Typical fix time: 10 minutes. Many teams solve this with Make's visual mapping tools or n8n for self-hosted control.

Can I sync custom fields?

Native integration is limited to standard fields. For custom field mapping, use an automation tool.

Automating Salesforce → Google Sheets (incl. Unbounce)

Automation & webhook questions

How do I set up a webhook from Salesforce to Google Sheets?

Salesforce doesn't write directly to Google Sheets, but a Make scenario bridges them cleanly: trigger on a Salesforce record change (contact updated, opportunity closed, etc.), then use the Google Sheets "Add Row" or "Update Row" action. The whole setup takes under an hour and runs in real time.

Can I connect Unbounce form submissions to Salesforce and Google Sheets simultaneously?

Yes — this is a classic demand-gen reporting stack. In Make, set the Unbounce webhook as the trigger, then run two parallel actions: create or update a Salesforce lead, and append a row to Google Sheets. Both happen in the same scenario with a single trigger — no duplicate work.

Does Salesforce have a native Google Sheets sync?

No native sync exists. Salesforce can export data to CSV manually, and some AppExchange tools offer scheduled exports, but there is no real-time native Sheets connector. For live sync — especially for reporting dashboards or multi-tool workflows like Unbounce → Salesforce → Sheets — Make is the standard solution.

Using Salesforce and Google Sheets with other tools?

Build your full stack map — see all connections and gaps at once.

See your full stack →