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?
2 Answers
0
votes
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
0
votes
For daily refreshes, you might want to look into simple triggers. Google places some hard limits however, like 20 Triggers / user / script. You can learn more about that here.
If you don't want to build your own solution, you can use database connector addons, like Castodia, Seekwell, Kpibees, and so on. You can find them here. Most of them support auto refreshes, but I can only speak of Castodia since I was involved in building that addon. Its backend does not use simple triggers, so there are no limits on number of triggers or sheets.
