So I have a Google sheet that maintains a lot of data. I also have a MySQL DB with a huge junk of data. There is a vital piece of information in the Sheet that is also present in the DB. Both needs to be in sync. The information always enters the Sheet first. I had a python script with mysql queries to update my database separately. Now the work flow has changed. Data will enter the sheet and whenever that happens the database has to updated automatically. After some research, I found that using the onEdit function of Google AppScript (I learned from here.), I could pickup when the file has changed. The Next step is to fetch the data from relevant cell, which I can do using this. Now I need to connect to the DB and send some queries. This is where I am stuck. Approach 1: Have a python web-app running live. Send the data via UrlFetchApp.This I yet have to try. Approach 2: Connect to mySQL remotely through appscript. But I am not sure this is possible after 2-3 hours of reading the docs. So this is my scenario. Any viable solution you can think of or a better approach? Continue reading...
