The Spreadsheet That Wasn't Working Anymore
Green Futures CIC is a three-person community interest company that helps schools in the North West install rooftop gardens. Until last Tuesday, their funding process lived in a single Google Sheet.
It started simple enough. One tab for opportunities, one for deadlines, one for notes. Then came the colour codes. Red meant 'apply soon', but only Sarah knew that. Amber meant 'waiting for documents' or sometimes 'maybe interested'-nobody could remember. Duplicates crept in: the same trust was listed twice, once under a misspelled name. A deadline for the National School Garden Fund came and went because someone entered the closing date in the wrong month.
The real gut punch arrived in February. A PDF of their supporting financial statement had been linked from a cloud folder that expired. By the time the assessor clicked it, the file was gone. The application failed validation. Three weeks of work, gone.
Mike, their project lead, spent an hour each Monday untangling the sheet before he could even start writing bids. Jenna, the part-time fundraiser, kept her own paper list because the shared version felt like a trap. 'We're not a spreadsheet team,' Sarah finally said. 'We're a gardening team pretending to be a spreadsheet team.'
That afternoon, they printed everything out, laid the mess across the office table, and admitted it: they needed a real pipeline. Not more tabs. Not another colour code. Something that showed them, at a glance, what was live, what was next, and who needed to do what.
Setting Up the GrantGunner Pipeline in One Afternoon
Lydia logs in to GrantGunner and starts with her profile. Social enterprise. Environment sector. UK, North West. Done in under two minutes. The platform already knows what to look for.
Next: the spreadsheet. She opens the Opportunities catalogue and searches for the funders her team had tracked manually - the National Lottery Community Fund, the Landfill Communities Fund, a few local trust foundations. GrantGunner has them all with current deadlines and direct links. Lydia clicks Add to Pipeline on each one. No cutting, pasting, or formatting.
Stages she sets up
The default pipeline stages already match her workflow: Processing, In Review, Submitting, Submitted, Awarded, Rejected. She drags her imported opportunities into the right columns. The one she was panic-finishing last week sits in Submitting. The one with no decision yet stays in Review. Now her team can see, at a glance, what is stuck and what is moving.
Calendar sync
She clicks the Calendar tab and sees every deadline already populated - opens, closes, notified-by dates. She sets a reminder two weeks before the next deadline. No more checking the old "Dates" column with its mismatched formats.
Turning on the AI Scout
Finally, Lydia enables the automated search. She sets it to scan weekly for new environment-related opportunities for social enterprises in the UK. The agent starts its first run immediately. By tomorrow morning, it will surface matches she would never have found digging through Google results.
Total time: roughly 45 minutes of active work. The spreadsheet is already closed.
The Mistakes They Made and How They Fixed Them
Green Futures made three classic mistakes in their first hour. Here's what went wrong-and how they fixed each one before the afternoon was out.
Mistake 1: Dumping Every Spreadsheet Row Into the Pipeline
Lydia imported 47 rows from the old sheet. Trouble was, 23 of those deadlines had already passed. The pipeline looked like a busy team was chasing ghosts-past applications, closed rounds, and opportunities that expired months ago. Clutter kills clarity in a shared view.
The fix: She toggled the pipeline view and bulk-archived every entry older than 90 days. Gone. The remaining 24 live opportunities gave the team a clean, honest snapshot of what was actually winnable right now. Archiving isn't deleting; those records stayed available in her account history if needed later.
Mistake 2: Letting the AI Scout Run Wild
The team forgot to set their agent preferences after profile setup. The AI Scout started surfacing matches for "environment" broadly-including a marine conservation fellowship in Cornwall and a hydrogen fuel grant for factories. Interesting, but useless for rooftop gardens in Manchester schools.
The fix: Lydia opened the scout settings and narrowed the filter to grant size under £50,000, geography: North West only, and keywords: school estates, outdoor learning. Next run returned eight relevant opportunities. That's the difference between a firehose and a drinking fountain.
Mistake 3: Forgetting to Share the Workspace
Dave and Priya couldn't see the pipeline. Lydia had set up the account but hadn't adjusted user permissions under workspace sharing. They were locked out-staring at an empty dashboard while Lydia alone could see the new setup.
The fix: She sent both colleagues a workspace invitation via the Team section. Priya got Editor access (she drafts application answers). Dave got Viewer access (he tracks deadlines). Five clicks, thirty seconds. Now everyone sees the same stage without asking Lydia for status updates.
Three mistakes. Three corrections. Total time lost: about 20 minutes.
What the Pipeline Looks Like Three Months Later
Fast forward three months. Green Futures’ GrantGunner pipeline no longer resembles a frantic bucket list. It’s a clean, colour-coded Kanban that tells Lydia and her team exactly where every application stands.
Five live applications sit in their lane. Two are in Review-one for a £12,000 National Lottery Awards for All grant, another for a £25,000 Esmée Fairbairn Communities strand. Two more are being drafted in the workspace, with Zoe’s budget attachments already uploaded. One was submitted on time last Thursday, with every supporting file checked and attached the day before the deadline. No panicked 11:59 pm email submissions.
What the calendar now shows
The calendar aggregates every deadline and submission window. Key dates are colour-coded: orange for “opens soon,” red for “due this week,” green for “submitted.” The team has stopped double-booking bid-writing days against delivery projects. They see the whole quarter at a glance.
And the AI Scout? It flagged two new trust grants from the Cloudesley and the Tudor Trust last week, matching Green Futures’ profile exactly. Lydia scrolled through the summaries in under three minutes. One was a strong fit; she clicked Add to Pipeline and it appeared in the right lane instantly.
Their next move: Bespoke for the big one
A £75,000 capital grant is opening next quarter. The team knows their in-house capacity for a bid of that size is thin. They’re considering GrantGunner Bespoke-agency-quality bid writing and account management at roughly half the traditional cost, with no lock-in. The discovery call takes about an hour. If they go ahead, the Bespoke team handles research, drafting, and submission while Lydia focuses on installing gardens.
Check it out at bespoke.grantgunner.org or learn more at grantgunner.org/bespoke.