You have chosen to sponsor your bid up to a maximum amount of .
We have a google spreadsheet with 4 columns that needs to be exported and inserted into a mysql table with same 4 columns as well. Need to be able to run from ssh command-line of our Ubuntu Linux server, and have it insert the data on-demand. Sheet URL & authentication details can be saved in a config file.
The script must work both ways, so that a mysql table can be transferred to a google sheet, within a spreadsheet.
sample usage: GS2MySQL <sheetURL> <table_name> [url removed, login to view]
or MySQL2GS <table_name> <sheetURL> [url removed, login to view]
whereas config would contain the mysql login credentials and google login as well.