Live · since Aug 2026 · Power Automate, Excel Office Scripts, TypeScript
Sponsorship tracker sync
A daily automation that moves new sponsorship bookings from the sales system into the inventory spreadsheet the team already uses, then sends one email listing only the bookings that need a person.
Try the demoRead the case study
- What it replaced
- Copying each morning's new bookings into the tracker by hand
- Role
- Mapped the workflow, built and tested the automation, and supported the rollout
- Period
- Jul–Sep 2026
Before and after
Manual entry per team member each workday
Estimated· 3-person team, 260 workdays a yearAbout 3,744 hours a year of manual entry across the team, down to about 10% of their time
Steps done by a person
BeforeEvery booking copied by hand
After1 of 8
Sponsorship tracker sync
Demo of a live enterprise workflow, built with synthetic data · Aug 2026
Step 1 of 64:00 AM
The report arrives
Every morning the sales system emails a spreadsheet of new bookings. Before this, someone copied it into the tracker by hand.
- From
- Sales system
- To
- Tracker inbox
- Subject
- New sponsorships · daily export
| Booking | Sponsorship | Value |
|---|---|---|
| B24110 | 1042-Bayside-WEATHER | $2,875 |
| B24111 | 1187 - Northgate - - WEATHER | $1,750 |
| B24112 | 1315-Cedar Hills-TRAFFIC | $3,125 |
| B24100 | 1042-Bayside-WEATHER | $2,300 |
| B24104 | 1230-Lakeview-WEATHER | $2,025 |
| B24113 | 1230-Lakevew-WEATHER | $750 |
| B24114 | 1042-Bayside-SPORTS | $2,575 |
| B24115 | 1187-Northgate-TRAFFIC | $3,050 |
| Total | Total | $18,450 |
| Count | Count | 8 |