All templates

Marketing

Reddit Trending Stories to Mattermost

Analyze trending Reddit-linked news and share a ZIP of story reports.

Reddit Trending Stories to Mattermost workflow in Open FlowReddit Trending Stories to Mattermost workflow in Open Flow

Analyze trending Reddit-linked news and share a ZIP of story reports.

Setup

Connect Reddit, Gemini, Google Drive and Mattermost. In Open Flow set the newline-separated topics, Drive folder ID and Mattermost channel ID in Configure topics and destinations, bind JINA_API_KEY, and enable persistent State. The schedule runs Monday at 06:00 UTC in Open Flow.

Use

The workflow searches each topic, selects link posts with more than 100 upvotes, retains the most-upvoted post per URL, and reads comments and the linked news article. Three analyses use the discussion, article and engagement metrics to create one report per post. Reports are combined into a ZIP, uploaded to Drive, shared with anyone holding the link and announced in Mattermost. No notification is sent when no posts qualify. Reddit comments and article text are sent to Gemini. Check the resulting reports and share only material suitable for a public link.

A delivery of unknown outcome stays pending. Inspect Drive permissions and Mattermost before retrying. For Open Flow enter the pending key in ack; choose confirmed only after all effects are complete, or absent only after verifying no prior effects remain. Clear the recovery fields afterwards. Avoid overlapping runs. Each date is delivered once; use a different date for another run.

In n8n

In n8n set topics, Drive folder, Data Table with item_key and status text columns, the Mattermost webhook URL and Header Auth credentials for Jina and Gemini. Configure the n8n instance timezone to UTC for the same schedule. For n8n reconcile the Data Table row before removing a pending checkpoint.

Inspiration & credits

Search the configured topics, use Jina JSON responses and Gemini, retain per-post association, and add a delivery checkpoint.

Adapted from Automatic Weekly Digital PR Stories Suggestions in Zie619/n8n-workflows. Attribution: Zie619 / n8n-workflows.

The collection’s MIT notice is pinned at a later revision. This is the collection notice at that revision; it does not establish a separate original template author’s license. Our changes are listed above; see repository licensing.

MIT License

Copyright (c) 2025 Zie619

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

fflate 0.7.4 license: MIT License

Copyright (c) 2020 Arjun Barrett

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.