How to Export your .csv File from Google Spreadsheet:
- Click File
- Click Web Publish
- Choose Sheet You want Publish
- Click Link
- Keep your link for Import Script
How to Import your .csv File from Google Spreadsheet:
- Put your database details on script
- Put your .csv url you generate from Google Spreadsheet
- Run your PHP File on server
Use Trigger on Google AppScript to Automaticly Export & Import your Google Spreadsheet to MySQL, much faster than using JDBC