Log every GitHub release to Supabase and announce it in Slack

By General Input

When you publish a new GitHub release, save it as a row in your Supabase changelog table and post a clean announcement to your Slack release channel.

Integrations

  • GitHub
  • Supabase
  • Slack Bot

Type

Deterministic Code

Categories

  • Engineering
  • Product

When a new release is published in my GitHub repository, I want to capture it as a row in my Supabase changelog table and announce it in my team's Slack channel. Pure deterministic pipeline, no reasoning or judgement involved.

Trigger: a GitHub webhook on the release.published event from my product repository. Only fire on full published releases. Skip drafts and pre-releases.

Step 1. In GitHub, call Get a Release using the release ID from the webhook payload so I have the full release metadata: tag name, release name, body, author login, published_at timestamp, and the HTML URL back to the release page.

Step 2. In Supabase, call Create Row to insert into my `releases` table. Map these columns from the GitHub release object: tag (text, from tag_name), name (text, from name), body (text, from body), author (text, from author.login), published_at (timestamp, from published_at), and html_url (text, from html_url). Assume the table already exists with those columns.

Step 3. In Slack, call Send a Message as the bot to channel #releases. Format the message in Slack mrkdwn with the tag as a bold heading, the release name on the next line, the release body underneath, and a link back to the GitHub release page at the bottom. Keep the formatting clean so it reads well in the channel.

Make the Slack channel name, the Supabase table name, and the watched GitHub repository configurable inputs so I can reuse the same workflow for other repos or other channels later.

Related prompts

Explore more prompts
A brand asset library your marketing team actually searchesTurn Mailjet email clicks into ranked HubSpot follow-upsClean out the Looker dashboards and Looks nobody opensLiveKit live operations console for room moderationWake up dormant Keap leads with a researched reasonLiveChat coverage board for planning next week's shiftsPhone routing control panel for LiveKit voice agentsLinkedIn Ads budget pacing dashboard for every client accountGive your team Looker numbers without buying more seatsPause marketing emails to escalated customers, then restore them