👉 n8n No Limits Access :

https://www.hostg.xyz/SHHAd

Hébergement VPS n8n | Automatisation sécurisée et évolutive

coupon -15% : DRFIRAS15

👉 Formation n8n en Français

Formation n8n en Français : Automatisation & Agents IA

coupon -20% : LANCEMENT : HERE

Course support: rebuild this workflow live, node by node

This page is a step by step build guide. Everything you need to recreate the workflow manually is here, ready to copy and paste. Follow the sections in order, from the trigger to the last node.

What the workflow does: every day at 9 AM it checks the public n8n Templates API for the newest templates in a chosen category, remembers which template IDs it has already seen, asks an AI model for business improvement ideas on each new template, then logs everything to Google Sheets and posts a digest to Telegram.

Flow at a glance

Run daily at 9 AM
  -> Configuration
  -> Fetch template list from n8n
  -> Extract template metadata
  -> Detect new templates
  -> New templates found?
       TRUE  -> Split out new templates -> Analyze template with AI -> Build sheet row
                     Build sheet row -> Append row to Google Sheets
                     Build sheet row -> Build Telegram digest -> Send digest to Telegram
       FALSE -> Report all-clear? -> Send all-clear to Telegram

The AI node (Analyze template with AI) uses one sub node: the OpenAI chat model.

Prerequisites and credentials

Before building, prepare these three credentials inside n8n (Credentials > New).

1. Telegram API (Telegram bot)
   • Open Telegram and talk to @BotFather, send /newbot, follow the steps, copy the token it gives you.
   • In n8n: Credentials > New > Telegram API, paste the token, save.
   • Get your chat ID: talk to @get_id_bot on Telegram, it replies with your numeric chat ID. Keep it, you will paste it in the Configuration node.
2. OpenAI API
   • Go to https://platform.openai.com/api-keys, create a secret key, copy it.
   • In n8n: Credentials > New > OpenAI API, paste the key, save. This guide uses the credential named OpenAi account.
3. Google Sheets OAuth2 API
   • In n8n: Credentials > New > Google Sheets OAuth2 API, click Sign in with Google, allow access, save. This guide uses the credential named Google Sheets account.
   • Create a Google Sheet named workflow_n8n_update with a tab named my_list. Put these exact column headers on row 1 (order matters):