Skip to main content

Search Slack for n8n templates with OpenAI tips, Google Sheets cache and weekly analytics

Workflow preview

Workflow preview
100%
Search Slack for n8n templates with OpenAI tips, Google Sheets cache and weekly analytics preview
Open on n8n.io

1. Workflow Overview

Slack Bot for n8n Template Search with AI Tips, Cache and Analytics Search n8n workflow templates directly from Slack with AI powered suggestions. Mention the bot with what you need in English, Spa...

Best for

  • Internal Wiki automation workflows
  • AI Chatbot automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.slacktrigger, n8n-nodes-base.code, n8n-nodes-base.switch, n8n-nodes-base.googlesheets, n8n-nodes-base.if, n8n-nodes-base.httprequest, n8n-nodes-base.slack

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Masaki Go.

Original n8n.io source

1.1 Workflow description

Title
Search Slack for n8n templates with OpenAI tips, Google Sheets cache and weekly analytics
Workflow name
Search Slack for n8n templates with OpenAI tips, Google Sheets cache and weekly analytics

Slack Bot for n8n Template Search with AI Tips, Cache and Analytics

Search n8n workflow templates directly from Slack with AI-powered suggestions. Mention the bot with what you need in English, Spanish or Japanese and get matching templates plus actionable tips to improve your automation.

Who is this for

Teams using n8n who want to find workflow templates without leaving Slack. Great for multilingual teams and onboarding new members.

What this workflow does

  • Detects user intent (search, help, or browse categories) and routes accordingly
  • Extracts keywords from 200+ known services and translates 150+ Japanese business terms to English
  • Checks a Google Sheets cache before calling the n8n Templates API
  • Uses OpenAI (gpt-4o-mini) to generate contextual tips based on the search results and use case
  • When no templates are found, the AI suggests alternative keywords and how to build the workflow from scratch
  • Logs every search to Google Sheets and posts a weekly usage report to Slack

Setup

  1. Create a Slack App with app_mentions:read and chat:write scopes
  2. Set Slack credentials in n8n
  3. Create an HTTP Header Auth credential for OpenAI (name: Authorization, value: Bearer sk-your-key)
  4. Create a Google Sheet with two tabs: Cache (SearchQuery, CachedResponse, ResultCount, Timestamp) and Analytics (Timestamp, User, Query, Keywords, ResultCount, Intent, FromCache)
  5. Connect the Google Sheet in all four Sheets nodes
  6. Select your Slack channel in the Trigger, Error Reply and Weekly Summary nodes
  7. Activate and test with a mention

How to customize

  • Add services to knownServices or extend jaToEn for more languages
  • Edit the AI system prompts to change tone or tip style
  • Adjust the weekly report schedule in the Schedule Trigger node
  • Replace Google Sheets cache with Redis for better performance at scale

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Sticky Note - Overview

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 2 - Sticky Note - Trigger

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Sticky Note - Normalize

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 4 - Sticky Note - Intent Router

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 5 - Sticky Note - Cache

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Sticky Note - Search & AI

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - Sticky Note - Reply & Log

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Sticky Note - Error Handling

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Slack Trigger - Bot Mention

Type / Role
n8n-nodes-base.slackTrigger - slackTrigger
Config choices
Version 1

Block 10 - Extract Keywords & Detect Intent

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 11 - Route by Intent

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3

Block 12 - Generate Help Response

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 13 - Generate Categories Response

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 14 - Check Cache - Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 15 - Cache Hit?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2

Block 16 - Use Cached Result

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 17 - Search n8n Templates API

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 18 - Has Results?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2

Block 19 - AI Generate Tips & Suggestions

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 20 - AI Suggest Alternatives

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 21 - Format Results + Tips

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 22 - Format No Results + Suggestions

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 23 - Reply in Slack Thread

Type / Role
n8n-nodes-base.slack - slack
Config choices
Version 2.2

Block 24 - Log to Analytics Sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Showing the first 24 of 31 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Search Slack for n8n templates with OpenAI tips, Google Sheets cache and weekly analytics
Complexity advanced
Nodes 31
Categories Internal Wiki, AI Chatbot
Author Masaki Go
Published 03 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13195/13195.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Search Slack for n8n templates with OpenAI tips, Google Sheets cache and weekly analytics do?

Slack Bot for n8n Template Search with AI Tips, Cache and Analytics Search n8n workflow templates directly from Slack with AI powered suggestions. Mention the bot with what you need in English, Spa...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Internal Wiki, AI Chatbot use case.