Route X mentions to Notion, Slack and Google Sheets with Apify and OpenAI

Quick overview

This workflow runs every four hours to search public X mentions via Apify, uses an OpenAI chat model to classify each mention as a question, complaint, or noise, then routes questions to Notion, complaints to Slack, and everything else to a Google Sheets log.

How it works

1. Runs every four hours on a schedule.
2. Searches X for your configured search terms using the Apify Twitter Search Scraper actor and collects up to the defined number of results.
3. Filters out very short mentions and skips posts already seen in previous workflow runs.
4. Sends each remaining mention to an OpenAI chat model to return JSON with a route (question/complaint/noise), a one-sentence summary, and an urgency score.
5. Creates a new page in a Notion database for routed questions, including the mention link.
6. Posts routed complaints to a Slack channel with the urgency score, summary, and link.
7. Appends all routed noise items to a Google Sheets sheet for simple logging.

Setup

1. Add an Apify credential and ensure you have access to the dami_studio~twitter-search-scraper actor.
2. Add an OpenAI credential for the chat model used to classify mentions.
3. Update the configuration values (searchTerms, product description, maxItems, and Slack channel) in the “What to watch for” step.
4. Add Notion credentials, select the target database ID, and ensure it has a URL property for saving the mention link.
5. Add Slack credentials and confirm the target channel exists and matches the configured channel value.
6. Add Google Sheets credentials and select the spreadsheet and sheet to append logged items.