Back to Templates

Send weekly Reddit sentiment digests to Notion with ScraperAPI and OpenAI

Created by

Created by: ScraperAPI || scraperapi
ScraperAPI

Last update

Last update 2 days ago

Categories

Share

Quick Overview

This workflow runs every Monday, scrapes weekly top posts from selected Reddit pages via ScraperAPI, analyzes sentiment and themes with OpenAI GPT-5 Mini, compiles a single weekly digest, and creates a formatted page in a Notion database.

How it works

  1. Runs every Monday at 9:00 AM on a schedule.
  2. Defines a list of Reddit source URLs to analyze and the target Notion database ID.
  3. Scrapes each Reddit page via ScraperAPI and converts the returned HTML into plain text for analysis.
  4. Sends the cleaned text to OpenAI GPT-5 Mini to extract per-source sentiment counts, top themes, representative quotes, and a short tone note in JSON.
  5. Normalizes and aggregates all source results into a single weekly digest with totals, theme rollups, per-source breakdown, and selected quotes.
  6. Creates a new Notion database page containing the digest sections (overview, counts, themes, per-source breakdown, and quotes).

Setup

  1. Add a ScraperAPI credential and ensure it can access the Reddit URLs you want to scrape.
  2. Add an OpenAI API key credential for the OpenAI Chat Model configured as GPT-5 Mini.
  3. Add a Notion credential (API token), share your target Notion database with the integration, and replace the placeholder Notion database ID in the configuration step.
  4. Update the Reddit source URLs/labels (and optional country code) to match the subreddits and views you want to track.
  5. Adjust the schedule cron expression if you want the digest to run at a different time.