In this project, I will be using Google Spreadsheet and MYSQL.
I manage a Petrol Station in Mexico where all my credit clients are registered in a database. Every time a credit client fills up with gas, their fill-up gets registered in the database.
What i am trying to do with this project is:
1. Query from a table in our database to a Google Spreadsheet.
2. The query will consist of the clients account number, name and the amount of gasoline filled up during that day for that specific client.
3. The output to the Google Spreadsheet must have columns displaying the queried information. They consist of client account, name of the client and the total amount of gasoline purchased during that day.
I currently use MYSQL with HTML/PHP using a PHP framework that already does this, however i want it to work with Google Spreadsheets and the google App Script services.
I am attaching pictures of how my work is being done currently.
The PDF showing the information is what i want to do. Display all the data exactly how its pictured in the PDF picture on the google spreadsheets.
I can allow access to my database, website and google spreadsheet docs once a freelance is hired. Thanks