This program was built to help limo business log their rides in a more efficient manner. This is effectively a business automation tool that logs information into a Google sheet that can later be used to calculate things like driver pay. I also charged a fee for building this tool to a limo company. This program is to be used as a template or a model to learn from because not every employer page will have the same format however the basic logic of the project will mostly remain the same.
This project utilizes the Google sheets API in order to log each ride info. The most useful function for this project is update_sheet, a function that will allow us to write to a Google sheet.
The software logs into the website and navigates to the appropriate page. It then scrapes and looks for the needed rides by month. It then only clicks on the rides month it needs and takes the data from the page, the data is then parsed into its sub details for the ride such as the driver's name, the customer's name and price for the ride. This information is then posted onto the Google sheet. Once the information is posted, it updates the value of a current txt file row_count that holds the value of the next row we will write to. Once the program detects it has navigated to the month after the month the user wanted (EX: the user wanted the record for April and now the software is looking May), the program stops and reports the scraping done.
You will need to generate a credentials file from Google in order to use the google_sheets api. The process is a little complicated so I reccomend following a tutorial. When you have the credential file simply place it in the same directory as the rest of the files.