Hi Make Community,
I’m new to Make and was wondering how to summarise a google sheet into a simple Google doc at the end of each week.
Here is the sheet:
You can see there are 3 contractors each with the own number (1-3) I want a report for each contractor at the end of each week.
The challenge I have is trying to get multiple rows of data in to one Google Doc for each contractor each week.
I made this Google Doc template:
I have just started mucking around in Make and thought that routing each contractor and filtering with their code would allow me to aggregate each row into one Google Doc.
Here is the Scenario:
I’m wondering if I’m making this too complicated? The reports are just our office staff to double check before requesting the invoice.
Best,
Addison Appliances Team.