Microsft SQL Server

Google Sheets + Microsft SQL Server

Query, Post and Sync Data from Microsft SQL Server

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc. 

It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Microsft SQL Server?

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving .

Setting up Microsft SQL Server with Sheet Director

Choose the Microsft SQL Server(Premium app) from the list and choose the service which you want to perform

If you're opening it for the first time on the sheet, then you won't be having any connections.

Don't worry Sheet director provides a way to create a connection easily

To create the connection you have to provide the following details.

Test Connection

Once you have provided the credentials you can easily check the connectivity by clicking on the test connection button

Based on the credentials authenticity, you will be having the feedbacks from the test

Once after connecting successfully, you can save the conection and continue.

These connections can be reused anytime and from any services used on the same Google Sheets

Querying on Microsft SQL Server

Once after saving the connection successfully, you can select the table and fields which you want to present on the Google Sheets

You also have a refresh button to get the updated tables list from the database


Filters can be used to query only the matching data from the tables 

You can have multiple filters filters to a query


Sort can be used to sort the query results based on your interest.

You can have multiple sorts to a query

Max Result

You can limit how much no of records you want to fetch using a query

Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output

Let's try to query the Data from JIVRUS_People table

Without Filters and Sort

Posting on Microsft SQL Server

Select the service to Post

Source Sheet


You  can manually map the sheet data with the Microsoft SQLfields

After clicking on Execute you will be shown with the confirmation dialog of how many records will be posted, check that and click on "Post Now" to continue the posting

After successfully completeng the previous step you will be shown with the no successfully posted and failure records

You will also see that under the Result and the status column in the Google Sheet

Output in Microsft SQL Server

Syncing on Microsft SQL Server

Select Sync as a service

Synchronize settings

Synchronization Key

The keys will be used for matching rows in Google Sheets with data in Microsoft SQL Server, these keys will be your primary key. (this is identified automatically)

Conflict Resolution:

Microsft SQL Server Wins: Latest data from Microsoft SQL Server will be updated into Google Sheets.

Google Sheet Wins: Latest data from Google Sheets will be updated in Microsoft SQL Server.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it in the Microsoft SQL Server

Microsft SQL Server Wins

Updating a record, "Department" field with the value "Growth Engineering" in Microsoft SQL Server, where the role was not updated in the Google Sheets

Let's execute this to get the updated record from the Microsoft SQL Server

Before Synchronizing 

After Synchronizing

The value from Microsoft SQl Server is now updated on Google Sheets

Google Sheet Wins

Let's execute this to Sync the updated record from Google Sheets


In this sample, we will update the values in all the "Department" and add a new record to Microsoft SQL Server from Google Sheets

Before Synchronizing

The Department Fields are getting updated and the new row is going to be added in Microsoft SQL Server

After Synchonizing

Update Records in Microsft SQL Server