Google Sheets to Salesforce Integration

Google Sheets

Google Sheets is a spreadsheet in Google Drive. Use this when the source data is a sheet a team already maintains, and those rows need to load into Salesforce without a CSV download.

Learn more about Google Sheets

View Documentation

Import from Google Sheets to Salesforce

‍

Load rows from a Google Sheet into Salesforce. Insert, update, upsert, or delete Accounts, Contacts, Leads, Opportunities, and custom objects.

‍

Connect Google Sheets

‍

Connect with Google sign-in. You may need to allow the Dataimporter IP addresses.

‍

Pick the sheet

‍

On the job, browse folders and spreadsheets, then choose the sheet tab to import from and the Salesforce object to load into. If the filename changes, use a wildcard so the job can find the latest match.

‍

Map, clean, and schedule

‍

Set the field mapping and cleaning rules once, then schedule the job.

‍

Export from Salesforce to Google Sheets

‍

Write a Salesforce object out to a path. Enter the export path and the object to export from.

Try it out now
View all Integrations