App Icon
Import reports or custom data queries from Salesforce into Sheets, or make changes to Salesforce directly from Sheets.
Listing updated:May 11, 2023
Works with:
1M+
Overview
Import reports or custom data queries from Salesforce into Google Sheetsᵀᴹ, or make changes to Salesforce directly from Google Sheetsᵀᴹ.

This Google 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 Google Sheetsᵀᴹ manually, or on a regularly scheduled interval
    * Delete data from Salesforce

Learn more about the add-on on support.google.com/docs/answer/9073952.
Additional information
PricingFree of charge
Developer
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Todd Sheets
February 6, 2023
It's good for small sets of data. If you need to use multiple reports in one sheet, it begins to become a bit cumbersome. To fix this, I would love to see a "Refresh All" button so that you can easily refresh all tabs, rather than doing each one-by-one.
Is this review helpful?
Yes
No
Profile Picture
Melissa Roy
May 8, 2023
This extension was great for automating Salesforce report imports into Google Sheets for several of my clients. Sometimes there were import row limits and bugs but I always found workarounds with Apps Script. Now I'm stuck with a new error. One of my clients is a large company and we're getting error message "You can't run more than 1,200 reports asynchronously every 60 minutes. Try again later." - I've reached out to Google and no one will reply to offer any support. We've switched to coefficient.io and are much happier but I'd still appreciate a reply from Google Support. Thank you
Is this review helpful?
Yes
No
Profile Picture
Luca De Angelis
May 1, 2023
Used to be great, now it limits me to 2000 rows per report.
Is this review helpful?
Yes
No
Profile Picture
Iggy Mach
April 7, 2023
I am connecting to a mid-size report (Columns A:AB, Rows 1:2500). This connector loads two sets of headers on row 1 and 2. The second is displaced since it is missing columns from the original report. Now I have to connect google sheets to my copy in MS Excel and refresh data manually and frequently (not ideal). I imported a smaller report and that one is not messed up, but the auto refresh (every 8 hours) does not refresh anything although the log says it did. This add-on seems to be limited to small reports that don't update frequently. A pity but I will have to keep working with my Ms Excel 365
Is this review helpful?
Yes
No
Profile Picture
Austin Reece
April 4, 2023
This tool used to work well, then the auto refresh stopped working. I can no longer rely on this tool to run our reporting.
Is this review helpful?
Yes
No
Profile Picture
Kate Osowiec
March 23, 2023
This tool could be perfect, we just keep running into the Run Report Permissions error that we can't seem to find the fix. With no support Its deeming it impossible to keep using the add-on
Is this review helpful?
Yes
No
Profile Picture
Trever Johnson
October 24, 2022
Is there a way to keep data highlighted in the report after it is refreshed? Context. I work out of a live report and will highlight an entire row after an action is taken however when the report updates if there is a new entry in a row above the rows do not shift down and rather they take the previous entry's place. The result: The wrong row is now highlighted.
Is this review helpful?
Yes
No
Profile Picture
Matt Gross
October 27, 2022
cool tool, and nice that it keeps your queries right in sheets. However- seems like a huge missed opportunity that you can't reference a cell or column in an import and you have to write the full query using their actual values (in the case of adding a column of data from salesforce to your sheet). THAT would be super helpful
Is this review helpful?
Yes
No
Profile Picture
Pedro Atienza Gomendio
May 24, 2022
I run into a limit of 2000 rows per report, Does anyone know how to avoid that? I know it's possible but not working for me
Is this review helpful?
Yes
No
Profile Picture
Frank James
May 5, 2022
I used this extension heavily in my roles (Sales Analyst) to automate some work, but overall quite frustrating. It seems to crash spontaneously and often it will not even be flagged as a "failed run" in the auto-refresh execution log, causing my team to believe everything worked, when in reality, half the data didn't update and all the final numbers on our dashboard are inaccurate. Sometimes it will fail halfway through the job, so columns A-C will refresh but D-M won't refresh, so there will be mismatched data (ie column A will say it's Opportunity XXX, but column D will be showing the Close Date for Opportunity YYY). Dangerous. And no support from the Google team.
Is this review helpful?
Yes
No
1-10 of 93
Search
Clear search
Close search
Google apps
Main menu