MySql-gs

Connect your MySql database with Google Sheets.

Create a copy of this sample file:

• MySql to Google Sheets

Source code is here:

• 118KocmYPQgb_4oFjUk4Be1Is9Yr2aqHfi74VZw_KZO5zXzETOOoPhtQk

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.