n8n

How to Automate Reddit PR Reports to Google Drive?

Stay on top of news your audience cares about. The system scans Reddit for hot posts on your topics, reads top comments to understand mood, and pulls key points from the linked articles. It turns all of this into press ready story ideas and a clear report your team can use right away.

Each week a schedule kicks it off. Topics from one text field are split into items, then Reddit search checks hot posts and an upvote rule keeps only strong signals. The flow removes duplicates by URL so the best version remains, then pulls full comment threads and formats the top thirty with replies in a clean outline. AI reviews the comments for sentiment and talking points, Jina AI fetches clean article text, and both views are merged into one report, saved as text, zipped, uploaded to Google Drive, and shared to a Mattermost channel.

Connect Reddit OAuth, an Anthropic key, Google Drive OAuth, a Mattermost incoming webhook, and a Jina AI key, then enter your topics and choose your day and time. Teams cut manual research from hours to minutes and get consistent, data backed PR angles every week. It suits digital PR, content marketing, and brand communications that need steady story scouting and fast team sharing.

What are the key features?

  • Weekly schedule runs at your chosen time so trend scanning never gets missed.
  • Topic splitter turns one multiline list into items for targeted Reddit searches.
  • Reddit search checks hot posts and an upvote filter keeps high quality results.
  • Duplicate removal keeps only the most upvoted post for each unique link.
  • Comment fetcher pulls threads and top replies, then formats the best thirty in a clean outline.
  • AI analysis with Anthropic summarizes sentiment and talking points from real comments.
  • Article fetch with Jina AI extracts clean text from the linked news source.
  • Report builder merges metrics, comments insight, and article summary into a single text file.
  • Zip packaging groups all reports, uploads to Google Drive, and posts to Mattermost for team access.

What are the benefits?

  • Reduce manual trend research from 3 hours to 15 minutes
  • Automate 80 percent of story scouting work
  • Improve signal quality by filtering on upvotes and removing duplicates
  • Connect Reddit, Anthropic, Jina AI, Google Drive, and Mattermost in one flow
  • Handle up to 10 times more topics with batch processing
  • Share ready to use reports instantly in your team channel

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Anthropic, Reddit, Google Drive, Mattermost and Jina AI. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create a Reddit OAuth2 credential. Double click a Reddit node, choose Credential to connect with, click Create new credential, then follow the on screen steps to authorize your Reddit account.
  4. Create an Anthropic credential. In your Anthropic account, create an API key. In n8n, open any Anthropic Chat Model node, click Create new credential, paste the key, and save.
  5. Connect Google Drive. In n8n, open a Google Drive node, click Create new credential, choose OAuth2, sign in to your Google account, and allow access to My Drive.
  6. Set up Mattermost. In your Mattermost workspace, create an incoming webhook and copy its URL. Open the Send files to Mattermost node in n8n and paste the webhook URL and the channel name.
  7. Get your Jina AI API key from the Jina AI dashboard. Open the Set Data node and paste the key into the Jina API Key field. Confirm the Get News Content node Authorization header uses this key.
  8. Add your topics. In the Set Data node, enter one topic per line so the flow can split them correctly.
  9. Adjust Reddit search and quality filters. In the Search Posts node, set your keyword and sort. In the Upvotes Requirement Filtering node, choose the upvote threshold that fits your niche.
  10. Review file naming and packaging. In Convert to File, confirm the filename expression works for your language. Check Compress files for the zip name and output property.
  11. Set the run time. Open the Schedule Trigger node and set the day and time that fits your team schedule.
  12. Run a test with one topic. Execute the workflow, then check Google Drive for the zip and your Mattermost channel for the post. Review the report structure and make any small edits.
  13. Troubleshoot common issues. If Reddit returns no items, lower the upvote filter or widen the search. If Jina AI returns an error, verify the API key. If Google Drive upload fails, reauthorize the credential. If Mattermost does not post, confirm webhook permissions and channel name.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Anthropic

Sign up

Pay-as-you-go: Claude 3 Haiku at $0.25 per 1M input tokens and $1.25 per 1M output tokens

Google Drive

Sign up

Drive API: $0 (no additional cost; quota-limited)

Jina AI

Sign up

Free tier: $0, includes 10M tokens per new API key; Reader usable without a key at 20 RPM (500 RPM with key)

Mattermost

Sign up

Free (self-hosted): $0 / mo; incoming webhooks available on all plans

Reddit

Sign up

Commercial access: $0.24 per 1,000 API calls; non‑commercial free up to 100 QPM (OAuth).

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.