---
title: "Import data from MS SQL Server to Google Sheets using Google Apps Script"
author: "Martin Hawksey"
date: 2021-07-28T19:01:15+00:00
modified: 2021-07-28T19:01:19+00:00
canonical_url: https://pulse.appsscript.info/p/2021/07/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2021/07/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script.md
categories:
  - "Intermediate"
  - "Sheets"
  - "Solutions"
tags:
  - "Medium"
  - "trang-nguyen-ngoc"
featured_image: https://pulse.appsscript.info/files/2021/07/1yaJ_J9jMjU3Z3yfPJPzUBQ.png
description: "Continuing the SQL theme this post from Trang Nguyen Ngoc provides a useful overview and introduction for connecting to a MS SQL databases using JDBC service. The post is particularly useful as it contains some tips if you encounter issues with connection."
---

# Import data from MS SQL Server to Google Sheets using Google Apps Script

![Import data from MS SQL Server to Google Sheets using Google Apps Script](https://pulse.appsscript.info/files/2021/07/1yaJ_J9jMjU3Z3yfPJPzUBQ.png)

> [https://trang-nguyen-ngoc.medium.com/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script-d92098ea16ee](https://trang-nguyen-ngoc.medium.com/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script-d92098ea16ee)Image created by Trang Nguyen Ngoc with the icons by [Freepik](http://freepik.com/), [Pixel perfect](https://icon54.com/) and [phatplus](https://www.flaticon.com/authors/phatplus) on [Flaticon](https://www.flaticon.com/)
> There are many ways to push data from SQL Server to Google Sheets, including using Python or Google Apps Script. While Python is great for a heavy SQL query, I find it a bit of a hassle when it comes to scheduling. Meanwhile, Google Apps Script works perfectly well for middle-size SQL queries and the triggers make it very simple to schedule, there is also no need to use any API.
> In this article, I will share with you how to push data from MS SQL Server to Google Sheets using Google Apps Script and the tips I learned when implementing the solution.

Continuing the SQL theme this post from Trang Nguyen Ngoc provides a useful overview and introduction for connecting to a MS SQL databases using [JDBC service**](https://developers.google.com/apps-script/reference/jdbc). The post is particularly useful as it contains some tips if you encounter issues with connection.

[Note: there have been some issues recently with the JDBC service and if you encounter problems we recommend [checking the issuetracker**](https://issuetracker.google.com/issues?q=componentid:191640%2B%20sql)]

Source: *[Import data from MS SQL Server to Google Sheets using Google Apps Script*](https://trang-nguyen-ngoc.medium.com/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script-d92098ea16ee)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/07/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script/](https://pulse.appsscript.info/p/2021/07/import-data-from-ms-sql-server-to-google-sheets-using-google-apps-script/)*