Help & Support
Send Feedback
Data connector for Salesforce
Import reports or custom data queries from Salesforce into Sheets, or make changes to Salesforce directly from Sheets.
567,628 users
Works with
Install
Overview
Import reports or custom data queries from Salesforce into Sheets, or make changes to Salesforce directly from Sheets.
This Sheets add-on allows four different operations with your Salesforce data:
    * Pull in a Salesforce report
    * Import Salesforce data based on a custom query or SOQL
    * Insert / Update changes made in the Sheet to Salesforce
    * Refresh data in sheets manually, or on a regularly scheduled interval
    * Delete data from Salesforce

** This add-on is made by Google Cloud.  Add-ons are covered by the Google Terms of Service (https://policies.google.com/terms) and Privacy Policy (https://policies.google.com/privacy),  as well as the End Users Using Scripts or Add-ons. (https://developers.google.com/apps-script/terms#end_users_using_scripts_or_add-ons)

To report issues with this add-on, please submit feedback within the add-on or visit the help forum (https://productforums.google.com/forum/#!forum/docs)
Reviews
A User of Data connector for Salesforce
January 17, 2020
Very good tool, help us to track in-office data
Submit reply
Cancel
A User of Data connector for Salesforce
December 16, 2019
Really liking this addon, use it alot for pulling in reports generated from within Salesforce. can't give it a 4 or 5 star just yet because there is 1 piece that isn't really working up to expectations. The SOQL function is using an older version of the API then what is currently on our servers. I'm assuming it's pulling from the data service to determine the version and versions we have are from 20 up to 47 (being the newest). However, the SOQL function is using what i'm assuming it the first one being 20, so multiple cols are missing from the SOQL results and we can't use that function, so roughly 25-30% of the functions are none-usable to us. Please add a dropdown for the version for API for SOQL and whatever other methods that might use it. Will be willing to provide a 4 or 5 star after that.
Submit reply
Cancel
A User of Data connector for Salesforce
December 12, 2019
Am liking the tool but would like to know what times the data refreshes when selecting 4/8/24 hours or whether this is relevant to time. Does anyone know? It would be nice if we could select the time which we wish this to happen.
Submit reply
Cancel
Zeeshan Sayed
November 15, 2019
Does not work with Salesforce Lite
Submit reply
Cancel
Mariusz Kusak
November 5, 2019
Very good tool, user friendly, help us a lot to automatize the in-office trackers
Submit reply
Cancel
A User of Data connector for Salesforce
October 23, 2019
Good so far except URL fields in the report integration have a bunch of javascript injected into them rather than just the simple URL. No bueno.
Submit reply
Cancel
A User of Data connector for Salesforce
October 3, 2019
This seems great so far! Our org wants to use this, but we're concerned about employees creating/updating/deleting Salesforce records. We want Sheets to show read-only data from our SFDC reports to facilitate reporting needs. Are we able to set this limit, or is this functionality coming soon? Thanks!
Submit reply
Cancel
Mattias Nordin
September 13, 2019
When a record in salesforce is deleted or added, please insert a new line (insert null values into any local columns). If a salesforce record is deleted, please remove the whole line from the sheet, including local columns. This would allow us to add custom fields in sheets and to keep them mapped to the row they belong to. Currently this gets messed up as soon as the number of rows is updated.
Submit reply
Cancel
Mei Ling Kuan
September 12, 2019
I love it. it is simple but i wish when it insert records it will also populate a column with the ID of the new record instead of just the success text.
Submit reply
Cancel
A User of Data connector for Salesforce
August 26, 2019
Results are listed on the wrong rows, making it impossible to know which records failed to insert or update.
Submit reply
Cancel
MySalesData SupportTeam
November 4, 2019
Try to use Best Connector for Salesforce, nice and free
1-10 of 30
Additional information
Search
Clear search
Close search
Google apps
Main menu