All workflows
Reddit logoOpenAI logoGoogle Sheets logoGmail logo

Find the problems your market keeps raising

Product ManagementMarketing & Growth

Reads the subreddits your customers use, groups the complaints that keep coming back, and emails the ones with real evidence.

Add to WorkspaceBrowse all workflows
Every Monday at 08:004 apps4 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

RedditOpenAIGoogle SheetsGmail

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. For each subredditEntry

    1. If subredditName is not empty

      1. 1RedditGet subreddit postsReads the newest posts in each subreddit you listed, keeping each post's title and link to the thread.
  2. 2OpenAIQuery modelAsks the AI to group the complaints and unmet needs into themes, citing only the labelled posts it was given.

  3. For each rawThemeLine

    1. If themeLine contains “THEME:”, themeLine contains “REFS:”, themeLine contains “NEED:” and the number of items in themeParts is at least 3

      1. If evidenceCount is at least themeMinimum and themeName is not empty

        1. 3Google SheetsAppend rowAppends one row per reported theme with the date, its name, post count, the need, subreddits read and example links.
  4. 4GmailSendEmails you the themes that stood up, each with its post count, what people want and links to the threads.

How it works

What happens on each run, in plain English.

Every Monday at 08:00, the newest posts in the subreddits you name are read, the AI groups the frustrations and unmet needs that keep coming back into themes, and the ones with real evidence behind them are emailed to you. It looks for problems nobody has solved yet, not for mentions of you, so themes are reported whether or not your product is named.

Each theme comes with how many posts sit behind it, what those people want, and the title and link of every post behind it. Every post the AI cites is checked against the posts actually read, and any it did not get from that list is discarded, so nothing is invented. A theme with too few posts is left out rather than padded, and a week where nothing recurs is reported as exactly that. Each reported theme is also appended to your Google Sheet as a history that is never overwritten.

Before the first run you need a sheet with a tab headed 'Date', 'Theme', 'Posts behind it', 'What they want', 'Subreddits read' and 'Example links'.

redditcustomer researchvoice of customerthemesweeklygmailgoogle sheetsopenaiai

You May Also Be Interested In

Weekly Reddit mentions digestFinds posts about your product in the subreddits you watch, filters out the coincidences and emails a weekly digest.Drip helpful articles to your leadsEvery day, emails the next few leads in your sheet a random article with a short AI note, and comes back to each after a set gap.Turn a ChatGPT answer into spreadsheet rowsEvery hour, asks ChatGPT for a list as JSON, splits it into items and adds one row per item to your Google Sheet.Personalised marketing emails from customer dataReads each customer's purchases and feedback, lets AI decide who earns a coupon, and sends a tailored email from Gmail.

Start from a workflow that already works.

Add "Find the problems your market keeps raising" to your workspace, connect its apps, and make it yours. No credit card required.

Get StartedSee Pricing

Free plan available · No credit card required