Looking for an for a script that will read Google Calendar events, read ShiftPlanning shifts, do some comparisons and note missing staff, etc. The script will also access a database and pull data relevant to the Google Calendar events such as start times. (Optionally, script can pull data from Google Sheets instead of database). It will create a summary report of all staff/shifts and events/locations for the week by creating a Google Sheets spreadsheet (.CSV or .XLS "ok" but not preferred) and email a notification. There are roughly 3 data points per ShiftPlanning staff person (name, shift start, shift end), 2-3 data points for each Google Calendar event (location, event name, event date) and 6-8 data points per database entry (example: type of event, event name (same as google calendar), start time, end time, meeting time, contact info, etc).
Script can be Python, PHP or whatever will run on a linux web server via weekly cron job.
Note: ShiftPlanning and Google Calendar have API interfaces, please confirm compatibility with your chosen script language before bidding. Python language preferred; however language is developers choice.
Note: This is stage one of the script, stage two will incorporate web scraping to compare 3-4 websites to the Google Calendar events. Please code with that in mind, leaving the ability to add to the script later on. Upon successful completion, will likely hire same developer for stage two, if skilled in web scraping.