Skip to content

Latest commit

 

History

History
27 lines (13 loc) · 957 Bytes

README.md

File metadata and controls

27 lines (13 loc) · 957 Bytes
Raw

MySql-gs

Connect your MySql database with Google Sheets.

Create a copy of this sample file:

Source code is here:

Usage:

  1. Connect. Menu: 🛢️ MySql > ➕ Connect...

  2. Create new sheet

  3. Write your SQL select-statemant in cell [A1]

  4. Get the data from MySql base: 🛢️ MySql > ✔️ Update active sheet

Security note: your password and connection string are safe. The script uses PropertiesService.getUserProperties() to store your secret information. Your Google Account is the only place from where this information available.

image