App Icon
Import reports or custom data queries from Salesforce into Sheets, or make changes to Salesforce directly from Sheets.
Listing updated:October 12, 2021
Works with:
1,142,053
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)
Additional information
PricingFree
Privacy policy
Terms of service
Salesforce Connector will ask for the permissions shown below. Learn more
Salesforce Connector will need access to your Google account
This will allow Salesforce Connector to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Megan Himan
February 11, 2019
Love the simplicity and configuration of pulling Salesforce reports into a google sheet. However, we are running into issues in that the connector based on Salesforce reports is pulling the "printable view" (ie cuts off long text fields at 254 characters). If we configure it via Query, it pulls in all data = but the fields are not as readable (ie the Date field shows detail to the minute/second). Would love a response from the developers of this app to see if the connector can be adjusted to read the full field values, instead of the printable view values. Thank you!
Is this review helpful?
Yes
No
Profile Picture
Scott Hemmeter
August 3, 2018
I've been using it for simple, 1 to 2 column updates of our data. It works nicely. One request would be to control the batch size for updates. It appears to have a batch size of 500 (at least that's how often it reports back to the Sheet with status) and this has caused challenges.
Is this review helpful?
Yes
No
Profile Picture
A User of Salesforce Connector
May 10, 2019
Great add-on, works perfectly! However, I'd love to be able to schedule recurring data insert/update jobs from Google Sheet to Salesforce, but it's not possible in the current release... Maybe in future?
Is this review helpful?
Yes
No
Profile Picture
A User of Salesforce Connector
March 14, 2019
It was great! It worked really smoothly and was much quicker than using the salesforce data loader. The UI was lovely too. Then it stopped working and with this error message "Sign in with Google temporarily disabled for this app This app has not yet been verified by Google in order to use Google Sign in." This is a google product that has failed to be verified by google. V annoying.
Is this review helpful?
Yes
No
Profile Picture
A User of Salesforce Connector
December 5, 2018
Simple and easy to use, however until Google removes the row limitation and adds the ability to schedule data pulls it is of limited use for me. Others may find value in it for 1 off tasks, but I personally cannot use it or recommend it to to those who would be using it for regular day-to-day tasks.
Is this review helpful?
Yes
No
Profile Picture
A User of Salesforce Connector
May 23, 2019
I'm loving it, but I'm having an issue with updating Account Team Members. It says the Salesforce UserID is not valid for the Account Team Member.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
Yosapol Singhavorakul
July 24, 2018
Overall is very good. We know well about limitation of Google Sheets but it helps to save time a lot when you want to edit data in bulk. Nice for the first sight.
Is this review helpful?
Yes
No
Profile Picture
A User of Salesforce Connector
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.
Is this review helpful?
Yes
No
Profile Picture
A User of Salesforce Connector
April 17, 2019
Pulling data works fine but importing data just timesout
Is this review helpful?
Yes
No
1-10 of 92
Search
Clear search
Close search
Google apps
Main menu