This could be a good one for a newbie to cut their teeth. I'm looking for someone who wants to build their portfolio and will be able to work through this process with me. We'll discuss the algorithm, you'll clone my repository, you'll write the code, and you and I will talk about it. I would write this myself but I have to focus on other projects at the moment.
Here's the parameters of the project. I've got a google a couple of google sheets. I want my nodejs server go through the following steps:
1. Download required google sheets, and extract cell information for a given day
2. download transaction data from Square (the merchant service cc processing company) and filter by the devices specified in the google sheet.
3. compile daily and or weekly payroll models for each employee that worked on the given days.
4. save those payroll models as new spreadsheets to google docs
5. email the employe their earnings report
6. email me the employee earnings reports
There may be some steps beyond this but this is the first set of priorities.
Please respond with a proposal about how you would work through these problems.