One shared reference
Application drafts pull from the same Source of Truth, helping keep recurring information consistent.
Case study
From Scattered Opportunity Searches to One Shared Workflow
How I helped BC Chinese Chamber Ensemble bring opportunity research and application preparation into one shared workflow, while keeping final decisions with people.
The challenge
Every opportunity worked differently, and nothing was tracked in one place
BCCCE members run the ensemble alongside their regular jobs, but opportunity research and application preparation took 6+ hours each week. Finding an opportunity was only the start: members still had to check fit, understand requirements, gather information, prepare answers and follow up.
Applications came through website forms, Google Forms and direct outreach, with no shared place to see what had been found, drafted, submitted or followed up.
What I built
A recurring workflow built around BCCCE’s existing tools
Every two weeks, the workflow searches for relevant performance opportunities across Metro Vancouver and Vancouver Island, checks them against BCCCE’s criteria, adds qualified opportunities to a shared Tracker, and prepares application or outreach drafts for member review.
The goal was not to automate the final decision or submission. It was to reduce the repetitive searching, checking and drafting around them, while keeping fit, missing information and final approval with the ensemble.
Key design decisions
One review format
Website forms, Google Forms and outreach requests are converted into the same format for review.
Confirmed answers get reused
Approved answers are saved back to the shared reference, reducing repeated input over time.
People make the final call
Members review every draft, fill in missing information and decide what is ultimately submitted.
What changed
- Estimated weekly hands-on time dropped from 6+ hours to about 30 minutes for the same volume of opportunity research and application preparation.
- BCCCE gained one shared place to track what had been found, drafted, submitted and followed up.
Where this pattern shows up elsewhere
The same approach can apply anywhere a team repeatedly finds opportunities, checks fit and prepares materials, while people keep the final decision.
Tenders & RFPs
Monitor opportunities, check requirements and prepare response materials.
Grants & funding applications
Find relevant programs, check eligibility and prepare application drafts.
Markets, festivals & vendor applications
Compare requirements and prepare submissions for review.
What this project showed
Automate the repetitive work Keep the decisions with people
The recurring search, screening and draft preparation were structured enough to automate, while fit, missing information and final approval stayed with the ensemble. This reduced admin work without removing the judgment that still needed people.