I have been wondering about this for a while. We are using Google Spreadsheets a lot with my colleagues and the thing is that we always have to write down data that we already have in our MySQL database.
I wonder if there is a possibility to connect your spreadsheet with MySQL server and fetch the data to specific rows via executable script or something.
Best Answer
You can use the JDBC services of Google Apps Scripts.
You will have to write a script that populates your spreadsheet with data from the JDBC service.
Not sure exactly what you want to do, but you could start with the example from the documentation: