Export Data from Salesforce Reports into Google Sheets

Any report that you’ve created in your Salesforce environment can be instantly available in any of your Google Spreadsheets with the help of G-Connector. With G-Connector you can easily export a Salesforce report and automatically refresh it at your desired cadence.

To pull a Salesforce report into the spreadsheet you’ll need to install G-Connector add-on to your Google Drive, log in, and then click the Get Reports item on the add-on menu or Launch and click Import Data ->Report from the side panel:

The most recently run reports will appear first. If you haven’t run a report yet, enter a part of its name and click the Search button to find the report you need.

• Salesforce Filters
  If this tab is enabled – it means that it is possible to customize filters for the selected report. The customized filters will be saved along with the report and applied on each refresh.
  Not all reports allow filters customization. If this tab is greyed out – the report filters are not customizable from the G-Connector end. Please edit them directly at Salesforce.

• Client-Side Filter

Apply additional custom filters to your Salesforce reports when pulling data into Google Sheets. This feature allows you to narrow down  large datasets, making your analysis more focused and manageable.

• Put to: New sheet(s) or Active Sheet
  This option indicates whether the report data will be placed into the currently active sheet or a new sheet will be created for it. By default this option is New sheet(s) when running a report for the first time, and Active sheet if running a report from a sheet where it has been previously downloaded.
• Toolbar in first row (this option is selected by default. Unselect it and change start cell to disable it.)

Having this checkbox selected will create a toolbar in the first row with buttons to open sidebar menu, refresh sheets and run push

templates in the sheet. The start cell of your data will be defined as A2 for this to work.

• Start cell
  This option will let you determine the starting point for the report data. It indicates the top leftmost corner of the data when exported to a Google sheet. There can be only one report exported into one given tab.
• Auto-fill formulas
  Set this option if you have additional formula columns to the right of your data and would like them to expand/contract as the number of rows in the exported data changes on each refresh.
• Freeze header row
  If on, the header row will be frozen after the pull to allow for data scrolling while keeping the headers visible.
• Printable report view
  If checked, the report will be exported in Formatted view. By default all reports are exported in Detail view, similar to the how you choose the export view in Salesforce:
  
• Create drop-downs in picklist columns
  If checked, we’ll add a drop-down into each cell of a column coming from a ‘picklist’ field in Salesforce as follows:
  

How to refresh the data on your Salesforce report in Google Sheets

• On refresh: Overwrite, Append, Create new sheet
  This drop-down determines the behavior of the exported report when it is refreshed using the Refresh current sheet (all sheets) G-Connector command or the refresh performed by the automatic scheduler. The following options are available:
  – Overwrite: the default mode. Will overwrite the data in the sheet with newly exported data. This operation will clean up any remaining data (if the exported data is smaller than the one already in the sheet).
  – Append: in this mode, each refresh will append all export data at the end of the previously exported data. Having duplicates after the repeated refreshes is highly likely in this mode. Therefore, it’s up to you to make sure the report returns new data or has a DateTime column that is different in all rows to be able to analyze the data by.
  – Create new sheet: in this mode, a new timestamped tab will be created for each report refresh. This mode is good if you want to keep snapshots of your data in the same Google sheet. Keeping snapshots of your data in different Google Sheets is achieved using G-Connector’s snapshotting functionality.

• Smart refresh: when this box is checked, the report refresh will update existing sheet rows at their positions using record ID. New rows will be added at the end, and missing sheet rows will be removed. Salesforce record ID must be present in the data source to identify the rows and use this feature. This will let you have custom data columns that are not present in Salesforce next to your Salesforce data rows and they will always remain aligned! Also any sorting applied to the data in the spreadsheet will remain unaffected on refresh, even if the source data is sorted differently.

You can select more than one report and click Get report(s). All of them will be pulled from Salesforce and put each into a separate sheet in your workbook.

Learn more about managing your Salesforce reports in Google Sheets.