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.
583,678 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
February 23, 2020
Too many limits and too few settings to customize. The worst: automatically truncating cell values longer than 254 characters off and replaces chopped off part with "..." If anyone comes across a workaround, I'd appreciate it!
Submit reply
Cancel
Mike Lewis
February 21, 2020
It is changing the dates upon upload. Seems to only happen on Dec 30 & 31 dates. I try to import 12/31/2019 but it changes to 12/31/2020, or 12/30/12018 uploads to 12/30/2019. I can't seem to be able to get any support to help with this issue. This is ruining my accounting data in salesforce - changing transactions from one accounting period to another. Would be great otherwise. Help!?!
Submit reply
Cancel
Mariusz Kusak
February 17, 2020
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
February 5, 2020
Not able to schedule an import into Salesforce, you are only able to schedule a refresh of a query. For long term use, it's really only a one way connector.
Submit reply
Cancel
A User of Data connector for Salesforce
February 3, 2020
thanks
Submit reply
Cancel
A User of Data connector for Salesforce
February 3, 2020
I don't know what and when happened but it seems like there is no 2000 rows limit anymore. For now, this covers all our needs.
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 Akbar Sayed
November 15, 2019
Does not work with Salesforce Lite
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
1-10 of 34
Additional information
Search
Clear search
Close search
Google apps
Main menu