Automation: Google Workspace

Overview: We set tasks and assign them on spaces and so they are filtered over to everyones own Google Tasks section on their google workspace.

From this google tasks list we need to use Google Task API to populate these onto a google sheets document, one for each user.

From this, they will populate onto a master tracker, there will be a tab for each user.

Furthermore, on the staff's own google sheets document, there is a tab for a timesheet requiring manual data input.

What we need regarding this is the google tasks populated onto the individual staffs google sheets.

We then need from this individual staffs google sheets, the timesheet to populate onto a master tracker on the staff members tab, along with all of the staffs tasks, labelled as completed and outstanding.

The other aspect of automation is regarding sending of stock and invoicing.

We have a request tracker that is manually filled out per requests from our various shops.

We also have an item log of all items/parcels that have been sent out from head office/warehouse.

We need automation to exist from the request tracker when the status of a request has been updated to "sent", for that particular requested item to be populated into the item log as this has now been sent out and is ready for invoicing.