Automate website tool analysis with Telegram, Apify, AI & Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 15 nodes and runs on Telegram events (message). Along the way it connects Telegram, OpenRouter Chat Model and Google Sheets. It also calls api.apify.com over HTTP.
How it runs
Trigger: On Telegram events (message).
- Extract URL from Message (Code): runs custom JavaScript code
- URL Present? (If): checks a condition and branches into true / false
- Set Input URL Field (Edit Fields (Set)): sets 1 field: URL
- Notify User: No Link Found (Telegram): uses Telegram
- Launch Web Content Extraction (HTTP Request): calls api.apify.com (POST)
- Set Raw Web Content (Edit Fields (Set)): sets 1 field: Website_content
- Clean Website Content (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Chat Model
- Set Clean Detailed Context (Edit Fields (Set)): sets 1 field: cleaned_detailed_context
- Contextual Website Analyzer AI (AI Agent): runs an AI agent, with model: OpenRouter Chat Model; 1 tool (Fetch Profile from Google Sheets); output parser: Structure AI Analysis Output
- Record Website Analysis Results (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Telegram
n8n-nodes-base.telegram - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets
From the author
Description This powerful workflow automates the evaluation of new digital tools, websites, or platforms with the goal of assessing their potential impact on your business. By leveraging Telegram for user input, Apify for deep content extraction, advanced AI…