How to Connect Google Sheets to a SQL Database

Google Sheets is an incredibly versatile tool for viewing, formatting, and analyzing data. However, when it comes to storing massive amounts of raw, transactional data (like millions of customer orders or website logs), a proper SQL database (such as MySQL, PostgreSQL, or SQL Server) is significantly more powerful, secure, and robust. Fortunately, you do not have to choose between the two. You can connect Google Sheets directly to your external SQL database, allowing you to use Sheets as a lightweight, real-time dashboard or front-end reporting tool while keeping the heavy data safely stored on your server.

Method 1: Using Google Apps Script (Free and Native)

The most direct, cost-free method to connect the two systems is by utilizing Google Apps Script, the javascript-based automation platform built directly into Google Workspace. Google provides a built-in service called Jdbc (Java Database Connectivity) specifically for this purpose.

1. Open a blank Google Sheet.
2. Click on Extensions in the top menu bar, then select Apps Script.
3. In the code editor, you will write a function using the Jdbc.getConnection() method.

You will need your database connection details ready: the IP address (or host URL), the port number, the database name, a username, and a password.

A basic connection script looks like this:

function readFromDatabase() {
  var address = 'YOUR_DB_IP_ADDRESS';
  var user = 'YOUR_USERNAME';
  var userPwd = 'YOUR_PASSWORD';
  var db = 'YOUR_DB_NAME';
  
  var dbUrl = 'jdbc:mysql://' + address + ':3306/' + db;
  
  var conn = Jdbc.getConnection(dbUrl, user, userPwd);
  var stmt = conn.createStatement();
  var results = stmt.executeQuery('SELECT * FROM customers LIMIT 100');
  
  // Code to loop through 'results' and write them to the Google Sheet goes here.
  
  results.close();
  stmt.close();
  conn.close();
}

Important Security Note: For Google’s servers to reach your database, you must configure your database firewall to “whitelist” (allow inbound connections from) Google’s specific block of IP addresses.

Method 2: Using Third-Party Add-ons (No-Code Approach)

If you are not comfortable writing JavaScript, or if your database is behind strict corporate firewalls that cannot be opened to Google’s IP ranges, you should use a third-party connector tool.

Tools like Zapier, Make (formerly Integromat), or specialized Google Workspace Add-ons like Coefficient or SyncWith are designed to bridge this exact gap.

1. In Google Sheets, click Extensions > Add-ons > Get add-ons.
2. Search the Google Workspace Marketplace for “SQL Connector” or “Coefficient”.
3. Install the Add-on.
4. Open the Add-on from a sidebar within your spreadsheet.

These tools provide a simple graphical interface. You just paste your database credentials into text boxes, type your SQL query visually, and the tool handles the complex background code, automatically pulling the requested rows into your spreadsheet cells on a daily or hourly schedule.