Better Sheets

JDBC

What it does

Connect to external JDBC-compliant SQL databases from Apps Script.

Official Google docs

Explore

Related methods

.getConnection()
Opens a connection to an external SQL database.
.executeQuery()
Runs a SELECT query and returns the result set.
.createStatement()
Creates a SQL statement to run against the database.
.executeUpdate()
Runs an INSERT, UPDATE, or DELETE statement.

More Apps Script

Better Sheets tutorials

No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.

Related blog posts

Written guides about JDBC in Google Apps Script.

Browse the blog

How to Use Google Sheets as a Website Database

Did you know you can use Google Apps Script to turn a Google Sheet into a free, auto-syncing database for your website? This guide shows you exactly how to set it up. You’ll prepare your spreadsheet, write a few lines of code and publish your site. Don’t worry if you’re not a developer, we’ll walk you through it. Why Use Google Sheets as a Database? For small projects, Google Sheets offers many advantages over traditional databases: * Free hosting and storage * Easy to edit data without...

Read post →