[FIXED] Is there a way to connect Google sheets to MySQL(phpmyadmin )

Issue

So I have a Google sheet (is not mine) https://docs.google.com/spreadsheets/d/1bJWIwNPGa1nz5pO8TZMir4eh6p32YwFG6IgHPFt3PDI/pubhtml?gid=4&single=true&widget=false&headers=false&chrome=false and I want to insert in new database and to get update each day. Is this possible?

Solution

Sure you can. You can use Google Apps Script for this.

I recommend you go through the documentation about the JDBC service on how to connect to external DB from Apps Script.

Also, you want to fetch data from that sheet, but it appears the owner does not permit copying it or downloading it, so you should get authorization to at least download, that way you could open it with Apps Script and use the SpreadsheetApp to get the data from the sheet and pass it using JDBC to your MySQL instance.

Further reading: - Google Apps Script

Answered By - Aerials