Daily Reddit trend digest to Slack and Google Sheets

Build a code workflow that delivers a daily Reddit trend digest to Slack and archives every post in Google Sheets. Trigger: cron, every weekday (Monday through Friday) at 9:00am America/New_York.

Configuration: a list of subreddit names (for example r/marketing, r/SaaS, r/ProductManagement) and the destination Slack channel (default #reddit-pulse) plus a Google Sheets spreadsheet ID and tab name. Keep the configured subreddit count under 50 to stay inside Reddit rate limits.

Step 1 (per subreddit, run in parallel): call Reddit's Retrieve Posts from Subreddit with sort = top, time = day, limit = 10. Collect title, author, upvotes (score), comment count (num_comments), permalink, and the post fullname (name) for each result.

Step 2: format a single Slack message that lists, per subreddit, the top 5 posts as bullet lines in this shape: "title (upvotes upvotes / comments comments) https://reddit.com<permalink>". Group by subreddit with a bold header per group. Send it via Slack's Send a Message operation to the configured channel.

Step 3 (in parallel with step 2): for every post returned across all subreddits (not just the top 5 displayed in Slack), call Google Sheets Append Values once with all rows batched. Columns in order: date (YYYY-MM-DD in America/New_York), subreddit, title, author, upvotes, comments, permalink, post fullname.

The pipeline is fully deterministic. No LLM steps, no summarization, no judgment. If a Reddit call fails for one subreddit, log the error and continue with the rest so a single bad subreddit cannot break the digest.

Additional information

What does this prompt do?

Pulls the top 10 posts of the day from each subreddit in your configured list using Reddit's Retrieve Posts from Subreddit operation.
Posts a single Slack message to #reddit-pulse listing the top 5 posts per subreddit with title, upvotes, comments, and permalink.
Appends one row per post to a Google Sheet so you can sort, filter, and review what trended over time.
Runs as a cron on weekdays at 9am ET, fully deterministic, no LLM judgment in the loop.

What do I need to use this?

A Reddit account connected via OAuth so the workflow can read public subreddit listings.
A Slack workspace where you can post to a channel like #reddit-pulse.
A Google account with edit access to the destination Google Sheet.
A configured list of subreddits to track (keep it under ~50 to stay well within Reddit rate limits).

How can I customize it?

Change the schedule (for example weekdays at 8am PT, or 7 days a week).
Swap the Slack channel, change the message format, or send to a DM instead.
Edit the subreddit list, the sort (top vs hot vs rising), or the time window (day vs week).
Add or remove columns in the Google Sheet, or split the archive into one tab per subreddit.

Frequently asked questions

How many subreddits can I track without hitting Reddit rate limits?

One Reddit call per subreddit per run. Keeping the list under about 50 subreddits leaves plenty of headroom on Reddit's standard OAuth rate limits.

Will this post duplicate posts day over day?

The Slack message is a snapshot of today's top, so popular posts will reappear while they're hot. The Google Sheet appends a new row per post per run, with the date column, so you can dedupe or trend over time in your own analysis.

Can I use a private subreddit?

Yes, as long as the connected Reddit account is a member. The workflow uses your OAuth credential to read posts.

Does this need any AI model?

No. The workflow is pure plumbing. It calls Reddit, formats a message, posts to Slack, and appends to Sheets. No LLM judgment, no surprises.

Why both Slack and Google Sheets?

Slack is the daily nudge so the team sees what is hot without doom-scrolling. The Sheet is the long-term archive you actually search during retros and editorial planning.