Google Sheets SalesForce Integration

How to integrate Salesforce with Google Sheets

It is very simple to connect SalesForce to Google Sheets, it can be done in a fast and easy manner with Windsor.ai.

First step:

You need to select SalesForce as Data Source and Grant Access to Windsor.ai.

Second step:

Select Google sheets as a data destination.

Third Step:

You can choose between two options:

Option 1: Advanced and for large data volumes

1. Click this link to install the Google Sheets add-on
2. Enter your API key: defab2f1e4d0b69f2aa9fcca30c8abe0f996
3. Start using the add-on in Google Sheets from the Add-ons menu in a Google Sheets document and select your fields

Option 2: Quickstart

• Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.

=IMPORTDATA(“https://connectors.windsor.ai/pinterest?api_key=defab2f1e4d0b69f2aa9fcca30c8abe0f996&date_preset=last_7d&fields=date,campaign,clicks,spend&_renderer=googlesheets”)

Instruction: The list of selected fields must contain a date field.

• The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.
• You can add any field that is available in the data sources you have added.

Benefits of the SalesForce Integration  with Google Sheets

Analyze Data in Google Sheets

Google Sheets is powerful data analysis and visualization tools that can help you gain insights from your Salesforce data. By connecting Salesforce to Google Sheets using a data connector, you can import data from Salesforce and use the tools in Google Sheets to create reports and dashboards that can help you better understand your business.

Save time and money

By using the Google Sheets Salesforce connector, you won’t have to upload data manually or copy it, all you need to do is schedule an automatic refresh with Windsor.ai’s add on as we learned before.

Make better data-driven decisions

By connecting Salesforce to Google Sheets, and using Windsor.ai’s Data connector you can use the data in Salesforce to inform your decision-making process. For example, you can import data from Salesforce into Google Sheets and use the analysis tools in Google Sheets to create reports and insights that can help you better understand your business.

Share data with teammates and outside your organization

Google Sheets is a powerful tool for collaboration, so you can work with your team to analyze data and make better decisions. By sharing data and insights in a single shared spreadsheet, you can get input from a wider range of perspectives and make more informed decisions.

Try Windsor.ai today

Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.

Start Free Trial