Open Ticket Search Bot

Support and dev kept losing time bouncing between Slack and Jira to answer the same ticket questions. Open Ticket Search Bot answers those questions inline: it watches messages, searches Jira across multiple projects for open tickets that match, and posts the results right back into the channel.

It started life as a paid Zapier workflow. To cut the recurring per-task fees, I rebuilt it as a free, standalone Google Apps Script web app — same behavior, no subscription, fully under my control.

A Slack Events API listener verifies every request with signing-secret HMAC and dedupes Slack's automatic retries via a cache, so a single message never triggers duplicate searches. When a message comes in, the bot searches Jira across multiple projects and returns batched results to respect Slack's rate limits.

Client-ID lookups resolve against a custom Jira field, backed by a 24-hour cache to keep things fast — plus a workaround for an app-provided field that the Jira fields API doesn't expose. The whole thing runs as a standalone Apps Script web app, so there's no server to maintain and no per-task billing.