Work scheduler using google sheets

I would like to develop a work scheduler that does the following:

- base data in google sheets
- date/time appointments integrated with google calendar with colour of appointment based on a status entry
- locations integrated with google maps using address field

The data in google sheets includes the following fields

- unique site number (six digit number)
- client name
- site name
- site address
- date required
- status (drop down)
- date of visit
- time of visit
- visit duration (default 1 hour)
- comments (free text)
- Category (drop down)
- Region (drop down)

I want to be able to sort and filter data by all fields and search on google maps with an accompanying summary table. So for example if I want to see all sites visited in a region and on a specific date.

Thanks

I want to be able to add new sites and archive sites