The Data Connector for Salesforce is a Google Sheets add-on, built by Google, that pulls reports from your Salesforce account into a Google Sheet. From there, you can use the Perdoo Google Sheets integration to easily update your goals with your Salesforce data.
ℹ️ This is a Premium feature.
In this article:
💡 Pro tip: Why use a spreadsheet integration? It gives you complete flexibility to edit your Salesforce data before sending it to Perdoo!
Install our Google Sheets integration
If you haven't already, install our Google Sheets integration.
Make sure to import the goals that you wish to integrate with Salesforce.
Pull Salesforce data into your Google Sheet
Open the Data Connector for Salesforce in Google's Marketplace.
You may be prompted to choose a Google account that you’d like to use the Salesforce connector with. Pick one.
You’ll then be asked to confirm that you’re happy to give the Salesforce Data Connector access to certain aspects of your Google account. Scroll down, and click “Allow”.
Open the Google Sheet that you wish to integrate with Perdoo and Salesforce (or create a new one).
Now we need to authorize your Salesforce account. Go to Extensions > Salesforce Connector > Open. This will open a panel on the right. Follow the steps to authorize your Salesforce account.
You can easily import data from Salesforce. Most likely, you want to use a Salesforce report to automatically update a KPI or Key Result in Perdoo. Click Reports in the Add-on's menu.
Search for the report that you wish to import and select Import to new sheet.
A new sheet will be generated in your GSheet with the data from this Salesforce report.
Set up auto-sync so that your GSheet is automatically updated from Salesforce.
Click Refresh in the Add-on's main menu.
Create an Auto Refresh.
Select all the Salesforce reports that you imported.
Choose Every 4 hours.
Link the Salesforce data and reports with the Goal Progress cells for the goals that you imported in the previous step.
You can use simple GSheets formulas to modify the data according to your needs.
Contact our friendly Support team via the live chat at the bottom-right of your screen, or email email@example.com.