Daily Product Hunt launches to Airtable, with a Slack recap

PromptCreate

Build a deterministic code workflow that logs yesterday's Product Hunt launches into Airtable and posts a recap in Slack.

Trigger: cron, every day at 8:00am in my local timezone.

Step 1. Use Product Hunt's List Posts operation to fetch every post from yesterday, ordered by vote count descending. Use a date range that begins at the start of yesterday and ends at the start of today in my timezone so we capture exactly one day's launches.

Step 2. For each post returned, build an Airtable record for my "PH Launches" table with these fields: Name, Tagline, Description, Post URL (the Product Hunt page), Website URL (the maker's link), Votes, Comments, Topics (the post's topic names joined as a comma-separated string), and Posted Date. Then call Airtable's Create Records operation. Airtable accepts up to 10 records per call, so batch the inserts in chunks of 10 if there are more than 10 launches.

Step 3. After all records are inserted, send one Slack message via Send a Message to my product-discovery channel. The message should include: the total count of launches logged, the top 3 launches by vote count formatted as a quick preview (name, tagline, vote count, link to the Product Hunt page), and a link to my Airtable view so I can browse the full list. Use Slack's mrkdwn formatting.

Every step is fixed, no judgment required, no model calls. This is a pure pipeline: list, map fields, batch create, format message, post.

What does this prompt do?

Pulls yesterday's Product Hunt launches once a day, ordered by votes.
Creates one Airtable record per launch with name, tagline, description, links, votes, comments, topics, and posted date.
Posts a single Slack message in your product channel with the total count, top three launches, and a link back to the Airtable view.
Runs on a fixed schedule with no manual review, so your launch log builds itself.

What do I need to use this?

A Product Hunt account you can sign in with.
An Airtable workspace with a base and a table ready to receive launch records.
A Slack workspace and the channel where you want the daily recap posted.

How can I customize it?

Change the time of day or the timezone the workflow runs in.
Swap the Slack channel, or send the recap as a direct message instead.
Adjust which fields land in Airtable, or change the number of launches included in the Slack preview.

FAQs

Which launches does this capture?

It pulls every Product Hunt launch from the previous day, sorted by vote count, so you get a complete daily snapshot rather than just the front page.

Do I need to prepare the Airtable table first?

Yes. Create a base and table in Airtable with columns for name, tagline, description, post URL, website URL, votes, comments, topics, and posted date before turning the workflow on.

Can I post the recap somewhere other than a channel?

Yes. You can point the Slack step at any channel you belong to, or send it to yourself as a direct message.

What happens if Product Hunt has a slow day with very few launches?

The workflow still runs and posts the recap. The Slack message will simply show a smaller count and fewer launches in the top three preview.

Will the same launch get logged twice?

No. The workflow only looks at launches from the previous day, so each daily run captures a distinct set of records.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.

+2

Agentic Task

Win back LiveChat visitors whose chats went unanswered

Every couple of hours we find the chats your team never answered, email those visitors a real reply, and hand the sensitive ones to a support lead.

Agentic Task

Chat quality review board for LiveChat support leads

Score last week's finished live chats against one rubric, let an AI grader draft the notes with quotes, and send coaching straight to the agent.

App

Win back no-show and cancelled appointments every morning

Every weekday morning, every appointment that fell through yesterday gets a personal text or email inviting them to rebook, plus a task for the right rep.

Agentic Task

Live Loop returns analytics with product-level drill-down

Pick any date range up to 120 days and see return volume, refund versus exchange mix, and the products behind every number, recalculated each time you open it.