Connect your MySql database with Google Sheets.
Create a copy of this sample file:
Usage:
-
Connect. Menu:
🛢️ MySql > ➕ Connect... -
Create new sheet
-
Write your SQL select-statemant in cell [A1]
-
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.
Google Sheets Magic: https://sheetswithmaxmakhrov.wordpress.com