Every Monday, emails you the Reddit posts that mention your product, checked by AI so namesakes are filtered out, with links.
Uses
Gmail
Google Sheets
OpenAI
Reddit
Get a weekly email of Reddit posts about your product
Run every day at 08:00.Run every day at 08:00.
Set productName to blank.Set productName to blank.Set productDescription to blank.Set productDescription to blank.Set subreddits to blank.Set subreddits to blank.Set digestRecipient to blank.Set digestRecipient to blank.Set mentionLogUrl to blank.Set mentionLogUrl to blank.Set mentionLogTab to Reddit mentions.Set mentionLogTab to Reddit mentions.Set postsPerSubreddit to 100.Set postsPerSubreddit to 100.
Get today's date and save it as runDate.Get today's date and save it as runDate.Set logRows to an empty list.Set logRows to an empty list.
If a step below fails, save the error as logErrorIf a step below fails, save the error as logErrorTry
Google SheetsRead the rows of mentionLogUrl. Save it as mentionLog.Read the rows of mentionLogUrl. Save it as mentionLog.
Compare [Date reported, Post ID, Subreddit, Title, Link, Why it matters] with mentionLog.headers and save it as logColumns.Compare [Date reported, Post ID, Subreddit, Title, Link, Why it matters] with mentionLog.headers and save it as logColumns.
If logColumns.only_in_first isn't emptyIf logColumns.only_in_first isn't emptyYes
Stop and report a problem: The first row of the '@mentionLogTab' tab in your mention log must read: Date reported, Post ID, Subreddit, Title, Link, Why it matters (one heading per column, in that order, spelled exactly like that). Fix the headings, then run it again. Nothing was checked, so no mention has been missed.Stop and report a problem: The first row of the '@mentionLogTab' tab in your mention log must read: Date reported, Post ID, Subreddit, Title, Link, Why it matters (one heading per column, in that order, spelled exactly like that). Fix the headings, then run it again. Nothing was checked, so no mention has been missed.No
No steps
Change logRows to mentionLog.rows.Change logRows to mentionLog.rows.On error
Stop and report a problem: Could not read the '@mentionLogTab' tab of your mention log, so nothing was checked: the log is what stops a post being reported twice. Check the sheet link in 'mentionLogUrl', the tab name in 'mentionLogTab', and that the connected Google account can open the sheet. Reason: logError.message.Stop and report a problem: Could not read the '@mentionLogTab' tab of your mention log, so nothing was checked: the log is what stops a post being reported twice. Check the sheet link in 'mentionLogUrl', the tab name in 'mentionLogTab', and that the connected Google account can open the sheet. Reason: logError.message.Get Post ID from every item in logRows and save it as reportedIds.Get Post ID from every item in logRows and save it as reportedIds.Set productBrief to The product: productNameSet productBrief to The product: productName
What it is: productDescription.Set mentions to an empty list.Set mentions to an empty list.Set problems to an empty list.Set problems to an empty list.Set unreadSubreddits to an empty list.Set unreadSubreddits to an empty list.Set readCount to 0.Set readCount to 0.
Split subreddits by , and save it as subredditList.Split subreddits by , and save it as subredditList.
For each subredditEntry in subredditList:For each subredditEntry in subredditList:Trim subredditEntry and save it as subreddit.Trim subredditEntry and save it as subreddit.If subreddit isn't emptyIf subreddit isn't emptyYes
If a step below fails, save the error as subredditErrorIf a step below fails, save the error as subredditErrorTry
RedditList posts in r/subreddit. Save it as listing.List posts in r/subreddit. Save it as listing.Add 1 to readCount.Add 1 to readCount.For each post in listing.posts:For each post in listing.posts: If a step below fails, save the error as postError If a step below fails, save the error as postErrorTry
Trim post.title and save it as title.Trim post.title and save it as title.Trim post.id and save it as postId.Trim post.id and save it as postId.Trim post.permalink and save it as permalink.Trim post.permalink and save it as permalink.If title contains productName (ignoring case) and reportedIds doesn't contain…If title contains productName (ignoring case) and reportedIds doesn't contain…Yes
If permalink contains /comments/If permalink contains /comments/Yes
Set link to https://www.reddit.com@permalink.Set link to https://www.reddit.com@permalink.Set postBrief to Post title: titleSet postBrief to Post title: title
Posted in: r/subreddit.
Run an AI agent: Is this Reddit post about the product below, or does its title only share the name? prod… and save it as relevance.Run an AI agent: Is this Reddit post about the product below, or does its title only share the name? prod… and save it as relevance.Trim relevance.output.reason and save it as reason.Trim relevance.output.reason and save it as reason.If reason is emptyIf reason is emptyYes
Change reason to The AI gave no reason..Change reason to The AI gave no reason..No
No steps
If relevance.output.verdict in lowercase is yesIf relevance.output.verdict in lowercase is yesYes
Set mentionLine to r/subreddit - titleSet mentionLine to r/subreddit - title
link
Why it matters: reason.Google SheetsAdd a row to mentionLogTab in mentionLogUrl.Add a row to mentionLogTab in mentionLogUrl.Add postId to the end of reportedIds and save it as reportedIds.Add postId to the end of reportedIds and save it as reportedIds.Add mentionLine to the end of mentions and save it as mentions.Add mentionLine to the end of mentions and save it as mentions.No
Show in the output: Not a real mention, skipped: title (reason).Show in the output: Not a real mention, skipped: title (reason).No
Show in the output: Skipped a matching post with no usable link: title.Show in the output: Skipped a matching post with no usable link: title.No
No steps
On error
Add Could not check or log @post.title in r/subreddit: postError.message to the end of problems and save it as problems.Add Could not check or log @post.title in r/subreddit: postError.message to the end of problems and save it as problems.On error
Add r/subreddit to the end of unreadSubreddits and save it as unreadSubreddits.Add r/subreddit to the end of unreadSubreddits and save it as unreadSubreddits.Add Could not read r/subreddit: subredditError.message to the end of problems and save it as problems.Add Could not read r/subreddit: subredditError.message to the end of problems and save it as problems.No
No steps
Count the items in mentions and save it as mentionCount.Count the items in mentions and save it as mentionCount.Join problems with a new line and save it as problemList.Join problems with a new line and save it as problemList.Set problemNote to blank.Set problemNote to blank.If problems isn't emptyIf problems isn't emptyYes
Build the text Not everything could be checked on this run: @problemList The next daily check tries again, but posts that have dropped out of a subreddit's newest @postsPerSu... and save it as problemNote.Build the text Not everything could be checked on this run: @problemList The next daily check tries again, but posts that have dropped out of a subreddit's newest @postsPerSu... and save it as problemNote.No
No steps
Set emailNote to They will be in Monday's email..Set emailNote to They will be in Monday's email..If the weekday name of runDate is MondayIf the weekday name of runDate is MondayYes
Get the date 6 days before runDate and save it as weekStart.Get the date 6 days before runDate and save it as weekStart.Keep each item in logRows where item["Date reported"] is greater than or equal to weekStart and item["Date… and save it as earlierThisWeek.Keep each item in logRows where item["Date reported"] is greater than or equal to weekStart and item["Date… and save it as earlierThisWeek.Set weekLines to an empty list.Set weekLines to an empty list.For each loggedMention in earlierThisWeek:For each loggedMention in earlierThisWeek: Add r/loggedMention.Subreddit - loggedMention.Title Add r/loggedMention.Subreddit - loggedMention.Title
loggedMention.Link
Why it matters: loggedMention["Why it matters"] to the end of weekLines and save it as weekLines.Combine weekLines and mentions into one list and save it as weekLines.Combine weekLines and mentions into one list and save it as weekLines.Count the items in weekLines and save it as weekCount.Count the items in weekLines and save it as weekCount.Set digestSummary to No new mentions were found this week..Set digestSummary to No new mentions were found this week..If weekCount is greater than 0If weekCount is greater than 0Yes
Join weekLines with a blank line and save it as digestSummary.Join weekLines with a blank line and save it as digestSummary.No
No steps
Set subjectNote to blank.Set subjectNote to blank.If unreadSubreddits isn't emptyIf unreadSubreddits isn't emptyYes
Join unreadSubreddits with , and save it as unreadNames.Join unreadSubreddits with , and save it as unreadNames.Build the text - could not read @unreadNames and save it as subjectNote.Build the text - could not read @unreadNames and save it as subjectNote.No
No steps
Make runDate readable as “Monday, November 2” and save it as weekLabel.Make runDate readable as “Monday, November 2” and save it as weekLabel.GmailSend an email to digestRecipient.Send an email to digestRecipient.
Subject: productName on Reddit - weekCount new mention(s), week to weekLabel@subjectNoteReddit posts about productName found in the week to weekLabel.
digestSummary@problemNote
Subreddits watched: subreddits
Every mention above is also in your mention log, which keeps it out of later emails.Build the text This week's email went to @digestRecipient. and save it as emailNote.Build the text This week's email went to @digestRecipient. and save it as emailNote.No
No steps
If readCount is 0If readCount is 0Yes
Stop and report a problem: None of the subreddits you watch could be read, so no posts were checked. Check the names in 'subreddits' (without r/), and that each one is public.Stop and report a problem: None of the subreddits you watch could be read, so no posts were checked. Check the names in 'subreddits' (without r/), and that each one is public.
problemList.No
No steps
If problems isn't emptyIf problems isn't emptyYes
Stop and report a problem: Logged mentionCount new mention(s), but not everything could be checked:Stop and report a problem: Logged mentionCount new mention(s), but not everything could be checked:
problemList
emailNote.No
No steps
Finish the run: Checked readCount subreddit(s) and logged mentionCount new mention(s). emailNote.Finish the run: Checked readCount subreddit(s) and logged mentionCount new mention(s). emailNote.