You can pull data from MySQL database to Google doc spreadsheet auto with just click of a button or scheduled time. This is great use for retrieving data in spreadsheet format. Buy me a coffee Step 1: Create a spreadsheet within your Google Drive. Step 2: Insert script in newly created spreadsheet. How to insert script Step 2.1: To insert the script in Google spreadsheet go to Tools > Script Editor. Step 2.2: On opening script editor you will find a Google Apps Script pop-up Close it. Step 2.3: On closing pop-up you will also find some pre-written function tags. Remove them completely. Step 2.4: Paste the script code provided below in script Editor. Step 3: Adding your MySQL database credentials and correct table names Jdbc.getConnection('jdbc:mysql:// 127.0.0.1:3306 / employee_db ', ' username ', ' pass ') Step 3.1: Replace the place holder credentials ( host , database , user , pass ) for MySQL, Als...
Tech Enthusiast, Blogger, Developer