App Holder
Google Sheets

Google Sheets and Salesforce Integration

Sync contact data and automate sales activity in Salesforce. Create new rows in Google Sheets. Do much more by connecting Google Sheets and Salesforce.

Get Started

Popular Integrations

google-sheets salesforce

Create leads on Salesforce from new Google Sheets rows

So you have a Google spreadsheet for all your incoming leads before you move them to your Salesforce account. But if you have leads flowing in, you can't afford to spend time pushing them to Salesforce manually. Let this Google Sheets to Salesforce integration template sync those leads automatically for you, while you use that time to chase down your leads. So, for every new row in your Google spreadsheet, a new lead will be created in your Salesforce. You can also map data fields like Name, Email ID, Source, etc. from your Google spreadsheet to your Salesforce account. No more manual periodic imports. Just set up this integration, and you’re good to go.

How it works

  • Step 1:

    This Bot runs whenever a new row is added in specified Google Sheet.

  • Step 2:

    It creates a new lead in Salesforce with all the details from the added rows.

Read More
google-sheets salesforce

Create custom objects in Salesforce from new Google spreadsheet rows

Google Sheets is a handy tool to quickly store any important information. But sometimes, we need something more reliable to get our job done. For example, Salesforce’s custom objects let you store information specific to businesses. In such cases, you can copy that information from your Google spreadsheet to Salesforce. But, instead of any manual import/export work that can slow down your sales process, just use this readymade Google Sheets to Salesforce integration template. With this integration activated, a new Salesforce custom object will be created for every new row in your Google spreadsheet. You can also map the data fields from the spreadsheet to the custom object. Just connect your Salesforce and Google Sheets accounts in Automate.io, activate this integration, and you are done. Automate.io will save you from doing all the grunt work.

How it works

  • Step 1:

    This Bot runs whenever a new row is added in specified Google Sheet.

  • Step 2:

    It creates a new Salesforce custom object with the data coming from the added row.

Read More
Salesforce Google Sheets

Add a Row in Google Sheets on a New Custom Object in Salesforce

Google Sheets Salesforce

Add or Update a Contact in Salesforce on a New Row in Google Sheets

Salesforce Google Sheets

Add a Row in Google Sheets on a New Contact in Salesforce

Salesforce Google Sheets

Add a Row in Google Sheets on a New Lead in Salesforce

Google Sheets Salesforce

Add or Update a Contact in Salesforce on a New Row (old) in Google Sheets

Google Sheets Salesforce

Add or Update a Lead in Salesforce on a New Row (old) in Google Sheets

Looking for something else?


Create your own Integration

Connect Google Sheets and Salesforce the way you want. Start by selecting the trigger and action events listed here.

When This Happens

TRIGGERS
  • Google Sheets

    New Row

    Triggers when a new row is added in a worksheet (recommended)
  • Google Sheets

    New or Updated Row

    Triggers when a new Row is added or an existing Row is updated
  • Google Sheets

    New Spreadsheet

    Triggers when a Spreadsheet is created
  • Google Sheets

    New Worksheet

    Triggers when a Worksheet is created
  • Google Sheets

    New Row (old version)

    Triggers when a new row is added in a worksheet
  • Salesforce

    New Contact

    Triggers when there is a new Contact
  • Salesforce

    New Custom Object

    Triggers when there is a new Custom Object (of the type selected) is created
  • Salesforce

    New Lead

    Triggers when there is a new Lead
  • Salesforce

    Updated Opportunity

    Triggers when an existing Opportunity is updated
  • Salesforce

    New Opportunity

    Triggers when there is a new Opportunity
  • Salesforce

    New Task

    Triggers when there is a new Task
  • Salesforce

    New Account

    Triggers when there is a new Account
  • Salesforce

    Updated Opportunity Property

    Triggers when an existing Opportunity's property is updated
  • Salesforce

    New Event

    Triggers when there is a new Event
  • Salesforce

    Updated Lead

    Triggers when an existing Lead is updated
  • Salesforce

    Updated Account

    Triggers when an existing Account is updated
  • Salesforce

    Updated Custom Object

    Triggers when an existing Custom Object is updated
  • Salesforce

    Updated Contact

    Triggers when an existing Contact is updated
  • Salesforce

    Updated Contact Property

    Triggers when an existing Contact's property is updated
  • Salesforce

    Updated Account Property

    Triggers when an existing Account's property is updated
  • Salesforce

    New Case

    Triggers when there is a new Case
  • Salesforce

    New Note

    Triggers when there is a new Note
  • Salesforce

    Updated Opportunity Stage

    Triggers when an existing Opportunity's Stage is changed
  • Salesforce

    New Case Comment

    Triggers when there is a new Comment on a Case

Do this

ACTIONS
  • Salesforce

    Add or Update a Contact

    Creates a new Contact or updates an existing Contact
  • Salesforce

    Add or Update a Lead

    Creates a new Lead or updates an existing Lead
  • Salesforce

    Add or Update an Account

    Creates a new Account or updates an existing Account
  • Salesforce

    Add or Update a Custom Object

    Creates a new Custom Object or updates an existing Custom Object
  • Salesforce

    Add or Update an Event

    Creates a new Event or updates an existing Event
  • Salesforce

    Add a Note

    Creates a new Note
  • Salesforce

    Add or Update an Opportunity

    Creates a new Opportunity or updates an existing Opportunity
  • Salesforce

    Add or Update a Task

    Creates a new Task or updates an existing Task
  • Salesforce

    Add a Campaign Member

    Creates a new Campaign Member (Existing Lead or Contact)
  • Salesforce

    Add or Update a Case

    Creates a new Case or updates an existing Case
  • Salesforce

    Search a User

    Search Users
  • Salesforce

    Get Account of a Contact

    Get Accountof a Contact
  • Salesforce

    Add a Call Log

    Creates a new Call log
  • Salesforce

    Get Contacts for a Opportunity

    Get Contacts for Opportunity
  • Salesforce

    Search an Account

    Search Accounts
  • Salesforce

    Search a Task

    Search Tasks
  • Salesforce

    Search an Opportunity

    Search Opportunities
  • Salesforce

    Search a Contact

    Search Contacts
  • Salesforce

    Search a Custom object

    Search Custom Objects
  • Salesforce

    Search an Event

    Search Events
  • Salesforce

    Search a Lead

    Search Leads
  • Salesforce

    Get Opportunities of a Contact

    Get Opportunity for Contact
  • Salesforce

    Search a Folder

    Search Folders
  • Salesforce

    Search a Case

    Search Cases
  • Salesforce

    Search a Campaign

    Search Campaigns
  • Google Sheets

    Add Row

    Adds a new Row. Use this only if you have an issue with the other ‘Add Row’ action.
  • Google Sheets

    Add a Worksheet

    Adds a new Worksheet to a given Spreadsheet
  • Google Sheets

    Search Rows

    Searches a row based on column value
  • Google Sheets

    Update a Row

    Update a row in a given Worksheet based on row id
  • Google Sheets

    Add Row (older version)

    Adds a new row to a given Worksheet
  • Google Sheets

    Delete a Row

    Delete a Row from the specified Worksheet based on the Row ID

Let's Integrate

Create your custom integration by selecting the Trigger event and Action to be performed.

Run Workflows

Typeform
Facebook Lead Ads
Wufoo

Forms

Google Sheets Workflow
Salesforce Workflow
Mailchimp
AWeber
HubSpot

Marketing

Connect Google Sheets and Salesforce with your other apps and run workflows across them. Trigger workflows automatically when things happen in any of the apps.

Try Now

Why Automate.io?

Easy

No coding. No change in your apps. Setup and get going in 2 minutes.

Secure

Runs on secure HTTPS channel & all sensitive data is stored in an encrypted format.

Reliable

Used by 1000+ organizations globally - big and small. Live chat support available.

Automate Work. Have Fun!

Say Goodbye to those busy days

Get Started for FREE

No credit card required.