Case File · 020 Shipped

Text Analysis Tools

Two Google Workspace plugins turning open-ended survey answers into something a human can actually work with — sentiment + categorisation, in-app.

Role
Solo prototype
Period
2024
  • google-workspace
  • apps-script
  • ai
  • sentiment
  • categorisation
★ Exhibit · Reel 01Motion · YouTube
Footage — Sentiment tagging and content categorisation on open-ended survey data.

Two small Google Workspace plugins that collapse the “we ran a survey and nobody has time to read the comments” failure mode.

What they do

  1. Sentiment analysis — tags free-text responses as positive, negative, or neutral so a reviewer can sort before they read.
  2. Content categorisation — groups responses into emergent themes, surfacing patterns that would otherwise require a manual coding pass.

Both run inside Google Sheets / Docs — no export, no separate tool, no “send this CSV to the data team and wait a week.”

Why it’s here

The bottleneck on qualitative feedback is almost never the data — it’s the review labour. L&D teams collect thoughtful open-ended responses and then read maybe 10% of them because there’s nothing between raw text and a written summary. These tools sit in that gap: not a replacement for a human reading the quotes, but a way to get to the quotes that matter.

Why in Workspace

Because the people doing the analysis are already in Sheets. A tool that makes them leave the document they’re working in is a tool that doesn’t get used.