Using Google API for Sheets, collecting recurring data sets and inserting into database (PHP MYSQL)
1. Using supplied API key and Credentials, read the list of sheets from shared google workbook.
2. Using the sheet names as a reference allow the collection and update from any given sheet and store it in a mysql database for that sheet name (month-year) (1 of the cols in the database).
3. Write a simple web application to show a drop down list of sheet names and a submit button that we can then update the data from the sheet into the database. We will then display in html certain information from the database after the data has been updated.
An example of the Spreadsheet is attached, you will see the sheet names are the Month – Year and the sheets can contain different employee names and can have more or less employees on any given sheet, the format always stays the same however including the empty rows.
- Date August 22, 2017
- Tags Google API, MySQL, PHP