Roll every branch workbook up into one summary sheet
Every Monday, WebRun opens each branch workbook in Microsoft Excel Online, reads the named ranges or tables you nominate, writes every location's figures into one roll-up sheet with totals, mirrors the summary into Airtable for reporting, and raises a Trello card for any workbook that is missing, empty or has not been updated.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I combine multiple branch spreadsheets into one summary?
WebRun opens each branch workbook in Microsoft Excel Online every Monday and reads the nominated table or named range. It writes every location's figures into one roll-up sheet with totals, mirrors the summary into Airtable, and raises a Trello card for any workbook missing or not updated.
- One sheet holds every location's figures without hand-stitching files
- Missing workbooks show as gaps, never as a silent zero
- Each week is stored in Airtable so branch trends are visible
Built for operations managers · multi-site businesses · franchise groups · finance teams · retail chains
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.office.com/launch/excelin a real browser with your saved login - no setup, no API keys. -
1
Microsoft Excel Online - combine the branch workbooks
office.com
WebRun opens Microsoft Excel Online to combine the branch workbooks. - Open each branch workbook from the OneDrive folder you nominate in Microsoft Excel Online
- Read the named range or table on the agreed worksheet in every workbook
- Write each location's figures as a row in the roll-up workbook, with the location and the date read
- Total the columns and note which workbooks were last modified before this week
Done when The roll-up sheet holds one row per branch with totals and a last modified date each.
-
2
Airtable - mirror the summary for reporting
airtable.com How to Automate Airtable
WebRun opens Airtable to mirror the summary for reporting. - Mirror the roll-up into Airtable, one record per branch per week
- Keep the totals and the week ending date so the table builds a history
- Compare each branch against its own previous week and store the change
- Leave the source workbooks untouched. WebRun writes only to the roll-up and to Airtable
Done when Airtable holds this week's branch figures with the change on last week.
-
3
Trello - flag missing or stale workbooks
trello.com How to Automate Trello
WebRun opens Trello to flag missing or stale workbooks. - Create a Trello card for every branch workbook that is missing, empty or not updated this week
- Put the branch, the file, the last modified date and the person responsible on the card
- Move a card to Done automatically once the next run finds the workbook updated
- Leave chasing the branch to a person. WebRun never emails or messages the branch manager
Done when Every missing or stale workbook has a card naming the branch and who owns it.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change the branch workbooks?
No. WebRun reads the nominated range in each source workbook and writes only to the roll-up workbook and to Airtable, so branch files come back exactly as they were.
What happens when a branch has not filed its numbers?
The roll-up marks that row as missing and a Trello card is raised naming the branch, the file and who owns it, so the gap is visible rather than silently zero.
Will it chase the branch managers?
No. It raises internal Trello cards only. It never emails or messages a branch manager, so chasing stays with a person who knows the context.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.