Skip to content

Latest commit

 

History

History
15 lines (12 loc) · 980 Bytes

README.md

File metadata and controls

15 lines (12 loc) · 980 Bytes

Google-Spreadsheet-JDBC

This is a JDBC to connect your Google Spreadsheets to Mysql or Microsoft SQL servers. I am also working on setting this up as a free Google Spreadsheet Add-on. I will be publishing new commits soon. If you would like to assist in this project please fork this project so we can communicate changes. You may contact me @ [email protected]

Please make sure you follow the ip whitelist rules explained the the Google Guide. https://developers.google.com/apps-script/guides/jdbc#setup_for_other_databases

Parameters to fill will be enclosed with percentage signs with all cap lettering. For example: '%CAP LETTERS%'

To install,

  1. Create new spreadsheet Or open the spreadsheet where you want your connection.
  2. In the overhead menu go to Tools -> Script Editor
  3. Copy and paste Project Script file into the editor.
  4. Fill in the parameters
  5. Run script to get authorization.
  6. Add your first query using the new menu on the spreadsheet itself.