The world's leading cloud-based CRM platform powering sales, service, and marketing for businesses of all sizes.
Full ReviewCloud-based spreadsheet application for data management and collaboration.
All Google Sheets ToolsThe Google Sheets and Salesforce integration enables you to export Salesforce reports and record data to Google Sheets for custom analysis, import lead and contact data from spreadsheets into Salesforce, and create automated bidirectional sync workflows. Salesforce offers native report export capabilities, and tools like Zapier, Salesforce Data Loader, and dedicated connectors like Coefficient and Salesforce Connector for Google Sheets provide more advanced sync options.
This integration is valuable for teams that need to share CRM data with stakeholders who do not have Salesforce licenses, create custom reports and visualizations that go beyond Salesforce's built-in report builder, or bulk-import records from spreadsheets into Salesforce. Sales ops teams frequently use this connection to build territory planning models, commission calculators, and pipeline analysis in Google Sheets using live Salesforce data.
The end result is a flexible data pipeline between your CRM and spreadsheets. Salesforce remains the system of record for customer data, while Google Sheets provides the analytical flexibility to slice, chart, and share that data in any format your team needs.
For one-time or periodic exports, go to a Salesforce report, click Export, and choose Formatted Report (.xlsx) or Details Only (.csv). Open the downloaded file in Google Sheets by uploading it to Google Drive. This is the simplest approach but requires manual repetition for updated data.
For live, automated sync, install a connector. In Google Sheets, go to Extensions > Add-ons > Get add-ons. Search for "Salesforce" and install Coefficient or a similar connector. These add-ons let you query Salesforce data directly from Google Sheets using SOQL or a visual query builder, and refresh the data on a schedule.
After installing the add-on, open it from the Extensions menu. Click Connect to Salesforce and enter your Salesforce credentials. Authorize the add-on to access your Salesforce data. If your org uses SSO, you may need to use a security token or connected app credentials. The add-on stores the connection for future use.
Use the add-on's interface to select which Salesforce data to pull into Google Sheets. Choose the Salesforce object (e.g., Opportunity, Contact, Account), select the fields you want (Name, Stage, Amount, Close Date, Owner), and optionally add filter conditions (e.g., Close Date is this quarter, Stage is not "Closed Lost"). The add-on translates your selections into a SOQL query and pulls the results into your sheet.
Configure the add-on to refresh data automatically. Most connectors support scheduled refresh at intervals like hourly, daily, or weekly. In the add-on settings, set the refresh schedule and choose whether to append new rows or replace all data on each refresh. For dashboards, replacing all data is recommended to keep the sheet in sync with current Salesforce data.
To push data from Google Sheets into Salesforce, use Zapier or the Salesforce Data Loader. With Zapier: create a Zap with Google Sheets as the trigger ("New Spreadsheet Row") and Salesforce as the action ("Create Record" — choose the object type like Lead or Contact). Map spreadsheet columns to Salesforce fields. With Data Loader: export your Google Sheet as CSV and use Salesforce Data Loader to insert or upsert the records.
With Salesforce data in Google Sheets, use built-in tools to create custom reports. Use pivot tables to summarize deal pipeline by stage and owner. Use VLOOKUP or INDEX/MATCH to join data across sheets. Create charts and graphs for visual pipeline reporting. Share the Google Sheet with stakeholders who need CRM visibility without Salesforce licenses.
Connector add-ons offer configuration for: SOQL query customization (for users comfortable with Salesforce's query language), relationship queries (pulling data from related objects in a single query), auto-refresh intervals, and write-back support (pushing updated data from Sheets back to Salesforce). Zapier-based connections support filters, field formatting, and multi-step data transformation.
| Data | Direction | Frequency |
|---|---|---|
| Reports and object data | Salesforce to Google Sheets | On-demand or scheduled (hourly/daily) |
| New spreadsheet rows (leads/contacts) | Google Sheets to Salesforce | Near real-time (via Zapier) |
| Record updates | Salesforce to Google Sheets | On scheduled refresh |
| Bulk data imports | Google Sheets to Salesforce | On-demand (via Data Loader) |
If authentication fails, check whether your Salesforce org requires a security token for API access. Append your security token to your password when logging in. If your org uses SSO, you may need to create a connected app in Salesforce and use OAuth credentials instead.
Salesforce limits the number of API calls per 24-hour period based on your edition and number of licenses. If you hit the limit, reduce the refresh frequency or optimize your queries to pull less data per call. Check your API usage in Salesforce under Setup > Company Information > API Usage.
Google Sheets add-ons require the sheet to be open (or on a Google Workspace Business plan with Apps Script triggers) for scheduled refreshes to run. If the sheet is closed, the refresh will not execute. Consider using Google Apps Script with time-driven triggers for reliable background refresh.
For full programmatic control, use Google Apps Script to call the Salesforce REST API directly. Write scripts that authenticate via OAuth, execute SOQL queries, and write results to specific sheet ranges on a time-driven trigger. This approach bypasses third-party add-on limitations and supports complex multi-object queries, data transformation logic, and write-back workflows. Combine this with Salesforce's Bulk API for large data volumes (over 10,000 records) that would be too slow for standard API calls.
