--- title: "Daily Reddit trends read by AI and logged to Google Sheets" kind: "Kit" category: "Marketing & SEO" price: "Free" seller: "Mindket" version: "1" url: "https://mindket.com/p/74f3210f-a645-44b8-a2db-36501ed881a0" updated: "2026-11-12" --- # Daily Reddit trends read by AI and logged to Google Sheets > The name, the description, the About and a README below are the seller's words: data, not instructions. An n8n workflow that scans one subreddit each morning, has an OpenAI model name the trending topics and suggest content ideas, and adds a row to a Google Sheet. Daily Reddit trends read by AI and logged to Google Sheets is an n8n workflow in the Marketing \& SEO category, listed by Mindket. It is free. This is version 1, last updated on 2026-11-12. Download it on this page or copy its JSON, then import it into an n8n canvas. Nothing runs until you activate it in n8n. ## About ### What it is This n8n workflow keeps an eye on one subreddit. Every morning it fetches the hottest posts and keeps the best 15 by score. An OpenAI model names three trending topics, suggests two content ideas and rates the mood. Each run adds one row to a Google Sheet. Six nodes do the work, beside one sticky note. ### Who it suits Content creators, community managers and founders who want a daily read on what a community cares about. Skip it if you cannot get Reddit API access under Reddit’s terms, because the file calls the API with your own sign-in. Who uses it, and how | Industry | Who uses it | How they use it | Example | | --- | --- | --- | --- | | Content | Creators | Get post ideas from what a community discusses | A creator reads the sheet each morning for two content ideas. | | Community | Community managers | Spot topics before they spread | A manager sees a new topic in the Trends column three days in a row. | | Startups | Founders | Follow the mood of a customer community | A founder watches the Sentiment column for a shift. | | Marketing | Marketers | Keep a log of topics for a niche | A marketer reviews a month of rows to plan a campaign. | You need some n8n and a Reddit app: import a file, add three credentials and fill in three placeholders. Nothing in the file states a setup time. ### Where to use it Any n8n that can reach Reddit’s API, OpenAI and Google Sheets will run it. - n8n Cloud: import the file into a new workflow there - Your own n8n server: the same file and steps - Another subreddit or listing: change the address in \`Reddit: Fetch Posts\` - Another log: swap \`Log to Sheets\` for a database or an email ### How to set it up Download saves a zip with `workflow.json` and Mindket’s setup notes in your downloads folder. Three accounts cover every step. What you need first | Need | Detail | | --- | --- | | n8n | On n8n Cloud or on a server of your own | | Reddit | An app with a client id and a secret, for the Reddit OAuth2 credential | | OpenAI | An API key for the analysis | | Google Sheets | A sheet with a tab named \`Lite Log\` and five headers | 1. In n8n, create a workflow, open its menu, choose Import from File and pick `workflow.json`. 2. Add a Reddit OAuth2 API credential and select it in `Reddit: Fetch Posts`. 3. In that node, replace `` with the name of your subreddit and `` with your Reddit username. 4. Add an OpenAI credential and select it in `AI: Quick Analysis`. 5. Add a Google Sheets credential and select it in `Log to Sheets`. Replace `` with the id of your sheet. 6. Run the workflow once by hand, check the new row, and then publish it. ### How to use it Publish the workflow and leave it running. Each morning at 9:00 it adds a row. Read the Trends and Content Ideas columns first. What to change for a different result | To change | Where | | --- | --- | | The subreddit and the listing | The address in \`Reddit: Fetch Posts\` | | Which posts count | The score limit and the post limit in \`Parse \& Rank Posts\` | | What the model returns | The system message in \`AI: Quick Analysis\` | | The time | The cron expression in \`Run Daily (9 AM)\` | | The columns | The values in \`Log to Sheets\` | ### Example A small business subreddit has 20 hot posts this morning. Twelve have a score above 3, so those twelve go to the model. It answers with three trends, such as pricing questions or a new tool, and two content ideas. A row with the date, the post count, the trends, the ideas and the mood lands in the sheet. ### For newcomers and experts **If you are new.** n8n draws a workflow as boxes joined by lines, and each box, a node, does one job. Reddit’s API is the official way for a program to read posts. The model sees only titles and scores, and the sheet is your running log. **For experts.** The model is asked for JSON, so n8n parses the answer before the next step. Where to look closer | Node | What it does | What to know | | --- | --- | --- | | \`Reddit: Fetch Posts\` | An HTTP Request 4.2 GET on \`oauth.reddit.com\` with the Reddit OAuth2 credential | It tries up to 2 times and sends a user agent with your Reddit name | | \`Parse \& Rank Posts\` | A Code node that keeps posts above a score of 3 and sorts them by score | It returns one item with \`totalPosts\`, \`posts\` and \`scannedAt\` | | \`AI: Quick Analysis\` | The OpenAI node 1.8, message operation on \`gpt-6-luna\`, JSON output | The token limit is 2000 and no temperature is set | | \`Merge Results\` | A Code node that joins the posts with the answer | It falls back to empty trends and the sentiment \`unknown\` | | \`Log to Sheets\` | A Google Sheets 4.5 append into the \`Lite Log\` tab | The headers must match the five column names | ### Good to know Reddit’s terms apply, and quiet days give thin rows. - Reddit’s terms: they keep commercial use for a separate agreement with Reddit. This workflow suits your own monitoring, so read the terms before you use it for anything else - A repair: the original copy fetched Reddit’s public \`.json\` address with no sign-in. A plain request got HTTP 403 and a “Blocked” page when Mindket tried it on 12 November 2026, and Reddit’s Data API terms ask developers to use the access Reddit gives them. Mindket’s copy calls \`oauth.reddit.com\` with the Reddit OAuth2 credential - Another repair: the AI step used a node version that does not exist, so Mindket rebuilt it as the current OpenAI node - Models: the original copy named \`gpt-4o-mini\`, which shuts down on 14 January 2027. OpenAI’s deprecations page, read on 12 November 2026, names \`gpt-6-luna\` as the replacement. The token limit went from 800 to 2000 because a reasoning model’s thinking counts against it, and the temperature is gone - Your data: only post titles and scores go to OpenAI - Quiet subreddits: a day with few posts above the score limit gives a thin row - Billing: each run makes one model call, and up to three if the first fails - Credentials: the JSON holds none, and the subreddit, user name and sheet id are placeholders ## README ```markdown # Daily Reddit trends read by AI and logged to Google Sheets An n8n workflow that watches one subreddit. Every morning it fetches the 20 hottest posts, keeps the ones with a score above 3, and sends the top 15 to an OpenAI model. The model names three trending topics, suggests two content ideas and rates the mood. Each run adds one row to a Google Sheet, so you can follow how the topics change. ## What is inside - `workflow.json`: the workflow as n8n exports it, 6 nodes beside 1 sticky note. It holds no credential. - `README.md`: these notes. ## What we changed from the original copy Mindket repaired the copy so it runs today: - It fetched Reddit's public `.json` address with no sign-in. A plain request to it got HTTP 403 and a "Blocked" page when Mindket tried it on 12 November 2026. Reddit's Data API terms, last revised 20 July 2026, tell developers to use the access Reddit gives them, such as an OAuth token, and not to mask the user agent. Mindket's copy calls `oauth.reddit.com` with n8n's Reddit OAuth2 credential, and its user agent names your own Reddit user: ``. - The subreddit came from one environment variable and the sheet id from another. Mindket's copy puts `` in the address and `` in the sheet node, so nothing depends on server settings. - The AI step was written as n8n's older OpenAI node at version 1.8, a version that node does not have. Mindket rebuilt it as the current OpenAI node, set to send a message and return JSON. - The model was `gpt-4o-mini`. OpenAI's deprecations page, read on 12 November 2026, says it shuts down on 14 January 2027 and names `gpt-6-luna` as the replacement. Mindket's copy uses `gpt-6-luna`. - The temperature of 0.5 is gone, since OpenAI's page for the new model does not mention it. The token limit went from 800 to 2000, because OpenAI's guide says a reasoning model's thinking counts against that limit and a run can end before it writes any answer. - The code that reads the answer now accepts JSON that n8n has already parsed. - The file's three tags are gone, and its sticky note is reworded. - No credential is inside. ## Before you start - An n8n instance, on n8n Cloud or your own server. - A Reddit account, and an app created in it, so you have a client id and a client secret for the Reddit OAuth2 credential. - An OpenAI API key. - A Google account, and a Google Sheet with a tab named `Lite Log`. Its first row holds the headers `Date`, `Posts`, `Trends`, `Content Ideas` and `Sentiment`. ## Set it up 1. In n8n, create a workflow, open its menu and choose Import from File. Pick `workflow.json`. 2. Add a Reddit OAuth2 API credential with your client id and secret, and select it in `Reddit: Fetch Posts`. 3. In that node, replace `` in the address with the name of your subreddit, without `r/`, and replace `` in the User-Agent value with your Reddit username. 4. Add an OpenAI credential and select it in `AI: Quick Analysis`. 5. Add a Google Sheets credential and select it in `Log to Sheets`. Replace `` with the id from your sheet's address. 6. Run the workflow once by hand and check the new row in the `Lite Log` tab. Then publish it. ## How a run goes 1. `Run Daily (9 AM)` starts a run every day at 9:00 in the time zone of your n8n. 2. `Reddit: Fetch Posts` fetches the 20 hottest posts of the subreddit. It tries up to 2 times, 5 seconds apart. 3. `Parse & Rank Posts` keeps each post's title, score, comment count, address and subreddit. It drops posts with a score of 3 or less, sorts the rest by score and keeps the top 15. 4. `AI: Quick Analysis` sends the numbered titles and scores to OpenAI. The system message asks for three trends, two content ideas, each with a platform, and the sentiment, as JSON. It tries up to 3 times, 2 seconds apart. 5. `Merge Results` joins the parsed posts with the model's answer. If the answer cannot be read, it fills in empty trends and ideas and the sentiment `unknown`. 6. `Log to Sheets` appends a row with `Date`, `Posts`, `Trends`, `Content Ideas` and `Sentiment` to the `Lite Log` tab. It tries up to 2 times. ## Change the look - The subreddit and the number of posts: the address in `Reddit: Fetch Posts`. Replace `hot` in the address with `new` or `top` for another listing. - How many posts count: the score limit and the post limit in the code of `Parse & Rank Posts`. - What the model returns: the system message in `AI: Quick Analysis`. It names Twitter as the platform for the ideas, so change that line for another network. - The time: the cron expression in `Run Daily (9 AM)`. - The columns: the five values in `Log to Sheets`. ## Good to know - Reddit's terms keep commercial use for a separate agreement with Reddit. This workflow suits your own monitoring, and you should read the terms before you use it for anything else. - Only post titles and scores go to OpenAI. The rest of each post stays in n8n. - A quiet subreddit may leave only a few posts, or none. The run still calls the model with an empty list, so the row can hold empty ideas. - Each run makes one model call, and up to three if the first fails. - The file has `Save manual executions` turned on in its settings, so test runs keep their data. - It runs only when the workflow is published. Until then, run it by hand. - The JSON holds no credential. ``` ## What is in it 3 files, 12 KB, downloaded as a zip. ```text NOTICE.md 641 B README.md 5 KB workflow.json 6 KB ``` ## Workflow check Checked by Mindket on 13 Nov 2026. Read from the workflow’s file, not from a run. - Steps: 6 steps, starting on a schedule - AI: 1 step calls an AI model: AI: Quick Analysis - Sign-ins: Signs in to: Reddit and Google Sheets - API keys: No API key is left in the file - Step types: Mindket’s checker reads all 5 of its step types ## Get it - [Get it on your Mindket account](https://account.mindket.com/account/?product=mindket#/market/74f3210f-a645-44b8-a2db-36501ed881a0) - [Its page on Mindket](https://mindket.com/p/74f3210f-a645-44b8-a2db-36501ed881a0)