Work directly with Salesforce from Google Sheets. Pull reports data without 2000 rows limitation from any edition of Salesforce. Load data to Salesforce. Any Salesforce Edition is supported.
Works with:
3K+
Overview
Update your data in Salesforce from Google Sheets directly using our connector.
You can pull the report's and object's data to Google Sheets without any 2000 rows limitation from any Edition of Salesforce (Professional, Enterprise or Unlimited). Clear the duplicates using the Duplicates tool.
Use "Scheduler" to automate tasks. Email results when the data is changed.
Edit the Salesforce object's data simultaneously from different accounts and resolve conflicts automatically using Team Editor. See the Salesforce object details and description from Google Sheets.
Fully functional SOQL query builder and Data Loader allows populating any object in Salesforce from Google Sheets. You can execute any supported by Salesforce SOQL query using the "Custom Query" tool.
If you new to Salesforce Best Connector for Salesforce will help you to tune in to Salesforce as fast as possible.
Best Connector helps decreasing mistakes, gaining productivity, and speed up your work with Salesforce data and tables.
See any table's data, report's data, the description of Salesforce object in Google Sheets. Merge allows you to update existing data and insert new data to Salesforce object at the same time.
Product Features:
 - Log in using your account to Salesforce Production or Sandbox from Google Sheets (completely safely using the modern OAuth 2.0 connection protocol);
 - REST API Support;
 - SOAP API Support ( for Professional Edition);
 - Pull data from existing reports no rows limitation;
 - Pull data from Salesforce using SOQL query builder;
 - Support of templates that store SOQL text for future usage;
 - the scheduler to pull /load data from/to Salesforce when you are offline;
 - fully functional Data Loader that allows you to insert, update and merge data from Google Sheets to Salesforce;
 - Get information about the fields of the object that you are currently working with;
 - Merge local changes with information that is now stored on the server
 - Mass delete rows in objects using the backlight for cells that stores the id or manually providing rows Id.

Product Requirements:

You must have the active Production or Sandbox Salesforce account and active personal or corporate Gmail account.
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
MySalesData G-Sheets Connector for Salesforce will ask for the permissions shown below. Learn more
MySalesData G-Sheets Connector for Salesforce will need access to your Google account
This will allow MySalesData G-Sheets Connector for Salesforce to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all your Google Sheets spreadsheets
Connect to an external service
Allow this application to run when you are not present
Send email as you
View and manage data associated with the application
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu