Daily Product Hunt launch log to Airtable with Slack heads-up

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.