Skip to content

Connect your MySql database with Google Sheets

License

Notifications You must be signed in to change notification settings

ashrafali46/MySql-gs

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

MySql-gs

Connect your MySql database with Google Sheets.

Create a copy of this sample file:

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.

About

Connect your MySql database with Google Sheets

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 69.9%
  • HTML 30.1%