Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Google Sheets with Salesforce - no code necessary. See how you can get setup in minutes.
100%
Help
Google Sheets
Google Sheets
1. Choose trigger event
Salesforce
Salesforce
2. Choose action
1. Select the event
Setup
Test
Google Sheets
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New Spreadsheet Row (Team Drive)" from Google Sheets.
Add your action
An action happens after the trigger—such as "Add Contact to Campaign" in Salesforce.
You’re connected!
Zapier seamlessly connects Google Sheets and Salesforce, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Create a new record or update an existing record in your app.
Path after /services/apexrest/
Required
HTTP method
Required
Query parameters
Extra headers
Request body
Timeout
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
File
Required
Salesforce Object
Required
Description
Attachment visibility
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Contact
Creates a new contact.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
File
Required
Title
Description
Salesforce Object
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note Title
Required
Note
Salesforce Object
Required
Note Visibility
Use Assignment Rules
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Salesforce Object
Required
Use Assignment Rules
Allow Duplicates
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Flow
Required
Manual flow input parameters
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
To
Required
CC
BCC
Subject
Required
Email Format
Required
Sender Type
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Lead to Update
Required
Use Assignment Rules
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Salesforce Object
Required
Record to Update
Required
Use Assignment Rules
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Query Type
Required
Include Deleted Records
Action
This is an event a Zap performs.
Search
Find existing data in your app
Parent Object
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
SOQL WHERE clause
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
SOQL WHERE Clause
Required
Sort by
Sort Order
Maximum Number of Records
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
Search Value
Required
Second Field to Search By
Second Search Value
Search Operator
Use Assignment Rules
Allow Duplicates
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
For AI agents & developers
Use Google Sheets and Salesforce with AI agents and code
Beyond Zap workflows. Call Google Sheets and Salesforce actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Google Sheets and Salesforce actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Create Spreadsheet Column
Add Contact to Campaign
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Practical ways you can use Google Sheets and Salesforce
Monitor opportunities in Google Sheets.
Keep an eye on sales opportunities without logging into Salesforce frequently. When a new Salesforce opportunity is created, Zapier records it in Google Sheets. This simplifies sales tracking and allows business owners to manage leads at a glance.
Track Salesforce updates in real-time for better oversight. When any Salesforce record is updated, Zapier logs the changes into Google Sheets. This workflow ensures IT administrators have a clear, consistent record for audit purposes or system monitoring.
Ensure every Salesforce lead is documented for analysis. When a new lead is created in Salesforce, Zapier automatically adds its details to a Google Sheets spreadsheet. This automation increases visibility for the marketing team, improves trend tracking, and keeps data organized for campaign planning.
Learn how to automate Google Sheets on the Zapier blog
Learn how to automate Salesforce on the Zapier blog
Make work flow with AI
Level up your Google Sheets to Salesforce integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Google Sheets + Salesforce integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google Sheets and Salesforce
How do I start the integration between Google Sheets and Salesforce using Zapier?
To start integrating Google Sheets and Salesforce, you need to set up a Zap in our platform. This involves choosing a trigger event from Google Sheets (such as a new or updated row) and an action in Salesforce (like creating a record). Both accounts should be connected to Zapier during the setup.
What are common trigger events when integrating Google Sheets with Salesforce?
Common trigger events include a new row added, updated rows in Google Sheets, or specific column changes. These triggers prompt actions in Salesforce, like updating existing records or creating new leads.
What actions can be performed in Salesforce through the integration?
Within Salesforce, actions can include creating or updating records, finding records that match particular criteria, or even attaching files to specific records from the data captured in Google Sheets.
Can I synchronize data bi-directionally between Google Sheets and Salesforce?
Currently, our integration focuses on automating tasks based on events within one platform triggering actions in another. While real-time bi-directional synchronization isn't typically part of these setups directly through Zapier alone, setting up reciprocal Zaps for certain updates is possible.
How secure is my data during the integration process?
We prioritize security in all our integrations. Data transferred between Google Sheets and Salesforce via our platform is subject to strict security protocols including encryption at rest and secure HTTPS connections.
Are there any limitations on using custom fields from either platform during the integration?
You can use custom fields from both platforms while setting up your Zap. However, ensure that these fields are accessible via your respective accounts' APIs as inaccessible fields might cause issues during setup.
Do I need specific permissions set within Salesforce or Google Sheets for Zapier integration?
Yes, necessary permissions are needed for both platforms. In Salesforce, ensure API access permissions are enabled; for Google Sheets, sharing settings must allow Zapier access to view and edit spreadsheets involved in Zaps.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.