Google Sheets

Google Sheets and Salesforce Integration

Sync contact data, manage deal flow and automate your sales pipeline in Salesforce. Create new rows, search and update them in Google Sheets. Do much more by connecting Google Sheets and Salesforce.

Get Started

Popular Integrations

  • Google Sheets - New Row
    Salesforce - Add or Update a Lead

    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?

    • 1

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

    • 2

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

    Show More
  • Google Sheets - New Row
    Salesforce - Add or Update a Custom Object

    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?

    • 1

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

    • 2

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

    Show More
  • Salesforce - New Custom Object
    Google Sheets - Add Row

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

  • Google Sheets - New Row
    Salesforce - Add or Update a Contact

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

  • Salesforce - New Contact
    Google Sheets - Add Row

    Add Row in Google Sheets on a New Contact in Salesforce

  • Salesforce - New Lead
    Google Sheets - Add Row

    Add Row in Google Sheets on a New Lead in Salesforce

  • Salesforce - New Opportunity
    Google Sheets - Add Row

    Add Row in Google Sheets on a New Opportunity in Salesforce

  • Salesforce - Updated Opportunity
    Google Sheets - Add Row

    Add Row in Google Sheets on a Updated Opportunity in Salesforce

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

    New Row

    Triggers when a new row is added in a worksheet.

  • Google Sheets - New or Updated Row

    New or Updated Row

    Triggers when a new row is added or existing row is updated in a worksheet

  • Google Sheets - New Spreadsheet

    New Spreadsheet

    Triggers when a new spreadsheet is created.

  • Google Sheets - New Worksheet

    New Worksheet

    Triggers when a new worksheet is created.

  • Salesforce - New Contact

    New Contact

    Triggers when there is a new Contact

  • Salesforce - New Custom Object

    New Custom Object

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

  • Salesforce - New Lead

    New Lead

    Triggers when there is a new Lead

  • Salesforce - Updated Opportunity

    Updated Opportunity

    Triggers when an existing Opportunity is updated

  • Salesforce - New Opportunity

    New Opportunity

    Triggers when there is a new Opportunity

  • Salesforce - New Task

    New Task

    Triggers when there is a new Task

  • Salesforce - New Account

    New Account

    Triggers when there is a new Account

  • Salesforce - Updated Opportunity Property

    Updated Opportunity Property

    Triggers when an existing Opportunity's property is updated

  • Salesforce - New Event

    New Event

    Triggers when there is a new Event

  • Salesforce - Updated Lead

    Updated Lead

    Triggers when an existing Lead is updated

  • Salesforce - Updated Account

    Updated Account

    Triggers when an existing Account is updated

  • Salesforce - Updated Custom Object

    Updated Custom Object

    Triggers when an existing Custom Object is updated

  • Salesforce - Updated Contact

    Updated Contact

    Triggers when an existing Contact is updated

  • Salesforce - Updated Contact Property

    Updated Contact Property

    Triggers when an existing Contact's property is updated

  • Salesforce - Updated Account Property

    Updated Account Property

    Triggers when an existing Account's property is updated

  • Salesforce - New Case

    New Case

    Triggers when there is a new Case

  • Salesforce - New Note

    New Note

    Triggers when there is a new Note

  • Salesforce - Updated Opportunity Stage

    Updated Opportunity Stage

    Triggers when an existing Opportunity's Stage is changed

  • Salesforce - New Case Comment

    New Case Comment

    Triggers when there is a new Comment on a Case

Do this

ACTIONS
  • Salesforce - Add or Update a Contact

    Add or Update a Contact

    Creates a new Contact or updates an existing Contact

  • Salesforce - Add or Update a Lead

    Add or Update a Lead

    Creates a new Lead or updates an existing Lead

  • Salesforce - Add or Update an Account

    Add or Update an Account

    Creates a new Account or updates an existing Account

  • Salesforce - Add or Update a Custom Object

    Add or Update a Custom Object

    Creates a new Custom Object or updates an existing Custom Object

  • Salesforce - Add or Update an Event

    Add or Update an Event

    Creates a new Event or updates an existing Event

  • Salesforce - Add a Note

    Add a Note

    Creates a new Note

  • Salesforce - Add or Update an Opportunity

    Add or Update an Opportunity

    Creates a new Opportunity or updates an existing Opportunity

  • Salesforce - Add or Update a Task

    Add or Update a Task

    Creates a new Task or updates an existing Task

  • Salesforce - Add a Campaign Member

    Add a Campaign Member

    Creates a new Campaign Member (Existing Lead or Contact)

  • Salesforce - Add or Update a Case

    Add or Update a Case

    Creates a new Case or updates an existing Case

  • Salesforce - Search a User

    Search a User

    Search Users

  • Salesforce - Get Account of a Contact

    Get Account of a Contact

    Get Accountof a Contact

  • Salesforce - Add a Call Log

    Add a Call Log

    Creates a new Call log

  • Salesforce - Get Contacts for a Opportunity

    Get Contacts for a Opportunity

    Get Contacts for Opportunity

  • Salesforce - Search an Account

    Search an Account

    Search Accounts

  • Salesforce - Search a Task

    Search a Task

    Search Tasks

  • Salesforce - Search an Opportunity

    Search an Opportunity

    Search Opportunities

  • Salesforce - Search a Contact

    Search a Contact

    Search Contacts

  • Salesforce - Search a Custom object

    Search a Custom object

    Search Custom Objects

  • Salesforce - Search an Event

    Search an Event

    Search Events

  • Salesforce - Search a Lead

    Search a Lead

    Search Leads

  • Salesforce - Get Opportunities of a Contact

    Get Opportunities of a Contact

    Get Opportunity for Contact

  • Salesforce - Search a Folder

    Search a Folder

    Search Folders

  • Salesforce - Search a Case

    Search a Case

    Search Cases

  • Salesforce - Search a Campaign

    Search a Campaign

    Search Campaigns

  • Google Sheets - Add Row

    Add Row

    Adds a new row to a given Worksheet

  • Google Sheets - Search Row

    Search Row

    Searches a row based on column value

  • Google Sheets - Update Row

    Update Row

    Updates a row in a given worksheet based on row number

  • Google Sheets - Add Column

    Add Column

    Adds a new column into a specific worksheet.

  • Google Sheets - Add a Worksheet

    Add a Worksheet

    Adds a new worksheet to a given spreadsheet

  • Google Sheets - Delete Row

    Delete Row

    Deletes a row from the specified worksheet based on the row number

Let's Integrate

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

Run Workflows

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.

Typeform
Google Forms
Zoho Forms

Forms

Google Sheets Workflow

Google Sheets

Salesforce Workflow

Salesforce

Mailchimp
AWeber
GetResponse

Marketing

Try Now

Frequently Asked Questions

How long does it take to connect Google Sheets and Salesforce?

Less than 3 minutes. That’s right, you can create automation between Google Sheets and Salesforce without writing a single line of code and using our drag and drop interface in under 3 minutes.

What technical know-how or skills do I need to create automations (bots)?

You don’t need any technical skills to use automate.io. Our product is designed keeping non-technical and business users in mind. You just need to know what information or data you want to transfer from one app to the other.

How much does it cost?

You can start with a Free Plan which allows you to create up to 5 bots (automations). As your requirements grow, you can easily upgrade to a premium plan which starts at $19/month. Check all pricing plans here..

What apps can I connect using Automate.io?

We have 200+ apps to choose from ranging across Marketing, CRM, Sales, Email, Project Management and many other categories. Explore all the apps here..

What about the safety and security of my data?

We use the most up to date and powerful encryption protocols to secure your data at rest and in transit. We also undergo regular security audits to ensure the integrity of our security systems.

Who uses Automate.io?

Over 30,000 organizations from 93 countries use our product which includes small businesses, startups, nonprofits and even Fortune 500.

Why Automate.io?

iPaaS products that connect multiple apps have been costly and complicated to use. Automate.io brings the same power to small businesses at economical price so you can automate away your tedious & repetitive tasks once and for all.

Rated 4.8 out of 5 on

Easy

No coding. Easy to use drag and drop interface designed keeping non-technical users in mind.

Trusted Worldwide

Used by 30,000+ organizations from 93 countries, from small businesses to Fortune 500.

Secure & Reliable

Runs on secure HTTPS and all sensitive data is stored using powerful encryption format.

Automate Work. Have Fun!

Say goodbye to those busy days.

Get Started for FREE

No credit card required.