What does this Google Sheets automation do?
Each week the sheet is read, totals calculated, and a report project created.
What can you do with it?
- Produce the weekly number without rebuilding the pivot
- Keep the report next to the follow-up actions
- Give the team a report they can comment on
The Steps
This automation runs in 4 steps:
- When Schedule — Every Week
- Then Google Sheets — Find Row(s)
- Then Utilities — Sum
- Then Taskade — Create Project
Who is this automation for?
Built for ops and finance leads. Each week the sheet is read, totals calculated, and a report project created.
How do you set it up?
- Open the "Automations" tab in your workspace.
- Click ➕ Add automation, then start from scratch.
- Add the trigger "Every Week" from Schedule.
- Add the action "Find Row(s)" from Google Sheets.
- Add the action "Sum" from Utilities.
- Add the action "Create Project" from Taskade.
- Connect your Google Sheets account when prompted, then enable the toggle in the top-right corner.
Prefer to describe it instead? Click Build this flow with AI above and Taskade wires the trigger, the steps for you.