Daily Product Hunt launches to Airtable, with a Slack recap

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.

Additional information

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.

Frequently asked questions

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.