Job description
I will order a PHP script that will retrieve data from a Google spreadsheet and send it to Mysql (the column structure is the same as in the spreadsheet).
Here is some sample data:
https://docs.google.com/spreadsheets/d/1JCAFN6vruo0YGm4O6USuGm16QL6msxyuifldB_TFuEc/edit?usp=sharing
I would like the script to work as follows:
0) The script will be run in cron every 1 min
1) Checks whether there is data in the sheet (in all plants)
2) If they are, it downloads and puts it into the database
3) Deletes them after adding them to the database