How to integrate data into Google Sheets with Windsor.ai

Google Sheets is an excellent tool for managing and analyzing data at scale.

This cloud-based spreadsheet application has a user-friendly interface that makes organizing large datasets and performing advanced calculations effortless, all while enabling real-time collaboration.

Integrating Google Sheets with Windsor.ai data connectors lets you generate comprehensive reports on your business performance across multiple channels in just a few minutes.

Explore our video tutorial and a step-by-step guide to seamlessly integrate your data from any source into Google Sheets with the Windsor.ai ELT connector.

1. Log in to your Google Sheets account and open a new spreadsheet document.

2. Go to the “Extensions” tab, select the “Add-ons” option, and click the “Get Add-ons“ tab towards the right.

3. On the search tab, type “Windsor.ai“ and install the extension.

4. You’ll be prompted to choose the Google account associated with your Windsor.ai account. Sign in and allow Windsor.ai to access your Google account. Complete additional setup.

1. Go to your Windsor.ai dashboard:

• Log in if you already have a Windsor.ai account.
• Create a new account if you don’t have one.

2. Select the data source you’d like to connect to Google Sheets, e.g., “Google Analytics 4,“ select the necessary account(s), and click “Next.“

3. Scroll down and choose the data destination you’re working with; in our case, it’s Google Sheets.

1. After selecting the Google Sheets destination, copy your API key provided in the instructions below.

2. Now, go back to your Google Sheets tab. Click on the “Extensions“ tab again, find “Windsor.ai,“ and click “Login.“

3. Enter your API key in the pop-up. 

Congratulations, you’ve now connected Google Sheets with Windsor.ai!

Now, we can easily sync previously integrated Windsor.ai data into Google Sheets.

1. Open your Google Sheets file, go to “Extensions,“ and click on “Get Data into Sheet“ under the Windsor.ai extension.

2. In Windsor’s panel on the right, click on “Add New Query.“

3. Name your Google Sheet, click on “Data Source,“ and select “Google Analytics.“

4. Once you have selected the accounts, set the parameters using “Select date range“-> “Fields” -> “Filters.“

5. Click “Load Data“ to import the data to Google Sheets. The process will take a few minutes.

1. Navigate to the Windsor.ai Google Sheet templates page.

2. Select the template that suits your data needs.

3. Click on the template link provided.

4. Copy the spreadsheet template by clicking on “File” and then “Make a copy.”

5. On the new copy of the template, go to the Windsor.ai extension and select “Get Data into Sheet.”

6. Click on the Edit icon under the template query.

7. Choose the accounts you want to include and your date range, then click on “Load Data.“