sql server to google sheets SQL Server + Google Sheets Google Spreadsheets

 =

KPIBees Google Add-on.

SQL Server to Google Sheets

re you looking for a simple method to pull data from your Microsoft SQL Server to Google Sheets? 

Then you’ve arrived at the right place, as you can quickly achieve this with the Google Sheet Add-on KPIBees. Exporting SQL Server data with KPIBees requires no coding or Google Apps Script, you just need to add your connection credentials and to make sure that your database server accepts connections from our IP. 

With the KPIBees Add-on, you can integrate SQL Server with Google Sheets and write SQL queries directly within your spreadsheets! And that’s not all, you can import data from every corner of your business ranging from APIs to marketing data! You’ll be able to create beautiful business dashboard within minutes!

Export Microsoft SQL Server query to Google Sheets

To connect your SQL Server database and export your data to Google Sheets, follow these quick steps:

STEP 1

STEP 2

Accept the authorization of the KPIBees Add-on. This is a standard procedure for installing Google Sheet Add-ons.

STEP 3

Open any spreadsheet and go to the Add-ons toolbar.

Google Sheet Add-on location toolbar.

STEP 4

Click on the SQL Server integration.

SQL Server to Google Sheets integration

STEP 5

Add your database connection credentials. It’s best to use a read-only user for safety precautions. When you are done, check whether the connection is successful with the “Test connection” button. Also, your database server needs to accept connections from our server IP (94.130.18.249).

A localhost database won’t work – as you need to expose your database on the internet. Even though this might be possible, it’s a lot easier to move your a database copy with a hosting provider.

Microsoft SQL Server Database Credentials for Spreadsheet

STEP 6

After you’ve added the database connection, name your query and write the SQL query that you want brought to the sheet, then click create query. The data will be pulled in your selected spreadsheet cell.

Microsoft SQL Server query in Google Sheet

STEP 7

You can add as many mysql queries as you want from multiple databases and even other data sources! These queries can be edited or refreshed from the Manage Queries menu.

Combine SQL Server Queries with other Google Sheet integrations

STEP 8

When you’re done with adding your mysql queries to the spreadsheet make sure you set automated refresh triggers with email or Slack notifications!

Schedule automatic refresh of SQL Server queries in Google Sheets
Furthermore, KPIBees supports integrations that enable you to create incredible marketing reports that include your MySQL database:

Here are all the Google Sheets integrations that KPIBees supports: