HumationHuman + Automation
Back to Catalog

Automate website tool analysis with Telegram, Apify, AI & Google Sheets

Mirza AjmalMirza Ajmal
335 views
2/3/2026
Query ParametersData TransformationCleanupURL ManipulationUtility
Official Page

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 for contextual analysis, and Google Sheets for personalized data integration and record-keeping, this tool delivers clear, actionable verdicts that help you determine whether a tool is worth adopting or exploring further.

Key Features and Workflow

User-Friendly Input: Submit URLs of tools or websites directly through Telegram for quick and easy evaluation requests.

  • Dynamic Content Extraction: The workflow retrieves detailed content from the submitted URLs using the Apify web crawler, capturing rich data for analysis.

  • AI-Powered Cleaning & Analysis: Sophisticated AI models filter out noise, distill meaningful insights, and contextualize findings based on your business profile and goals stored in Google Sheets.

  • Personalized Business Context: Integration with Google Sheets brings in your company’s specialization, current focus, and strategic objectives to tailor the analysis specifically to your needs.

  • Structured Analysis Output: Receive a thorough, structured report including concise summaries, key considerations, business impact, benefits, risks, actionable insights, and an easy-to-understand final verdict on the tool’s relevance.

  • Decision Support: The tool estimates effort, time to value, urgency, and confidence levels, enabling informed prioritization and strategic decision-making.

  • Seamless Communication: Results are sent back via Telegram, ensuring you get timely and direct feedback without needing to leave your messaging app.

  • Record Keeping & Tracking: All analyses and decisions are logged automatically into Google Sheets, creating a searchable knowledge base for ongoing reference and reporting.

Setup Instructions for Key Nodes

Telegram Trigger Node:

  1. Configure your Telegram bot API credentials here.
  2. Link the bot to your Telegram account to receive messages for URL submissions.

URL Extraction Node: No credentials needed. This node extracts URLs from incoming messages for processing.

Apify Web Crawler Node Setup Guide: Go to Apify's website, sign up for an account if you don’t have one, and get your API token from your profile’s API tokens section. Then, paste this token into the Apify Node’s API Key field in n8n.

AI Cleaning and Analysis Nodes:

  1. Configure OpenRouter or compatible AI service API keys for content processing.
  2. Customize prompts or models if desired to align analysis style.

Google Sheets Nodes:

  1. Connect using your Google account and provide access to the specified Google Sheet.
  2. Ensure sheets for Company Details and Analysis Results exist with proper columns as per this workflow.

Telegram Reply Node: Use the Telegram bot API credentials to send analysis summaries and verdicts back to users.

Access and Edit the Google Sheet

You can access the Google Sheet used by this workflow here: Access the google sheet here Please make a copy of the sheet to your own Google Drive before connecting it with this workflow. This allows you to customize the sheets, update company information, and manage analysis results securely without affecting the original template.

Extendibility

Beyond manual URL submissions, you can enhance this workflow by scheduling automated daily checks of new product launches from platforms like Product Hunt. The system can proactively analyze emerging tools and deliver timely updates via Telegram, email, or other channels, helping you stay ahead of innovation effortlessly.

Automate Website Tool Analysis with Telegram, Apify AI, and Google Sheets

This n8n workflow automates the process of analyzing website tools, generating insights using AI, and storing the results in a Google Sheet, all triggered and controlled via Telegram. It's designed for users who want to quickly get an overview of the technologies used on a website and receive a summarized report.

What it does

This workflow simplifies the process of website tool analysis by:

  1. Listening for Telegram messages: It acts as a Telegram bot, waiting for incoming messages.
  2. Extracting the website URL: When a message is received, it extracts the URL from the user's input.
  3. Analyzing website tools via Apify: It makes an HTTP request to an external service (likely Apify or a similar tool detection API) to identify the technologies used on the provided website.
  4. Generating AI insights: It then uses an AI agent (likely powered by a large language model like OpenAI via OpenRouter) to analyze the detected tools and generate a comprehensive summary or report.
  5. Structuring AI output: The AI's output is parsed into a structured format (e.g., JSON) for consistency.
  6. Filtering irrelevant data: It checks if the AI successfully generated a summary. If not, it skips the next steps.
  7. Saving results to Google Sheets: The website URL, detected tools, and the AI-generated summary are appended as a new row to a specified Google Sheet.
  8. Sending a Telegram confirmation: Finally, it sends a message back to the user on Telegram, confirming the analysis is complete and providing a link to the Google Sheet or a snippet of the summary.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Telegram Bot Token: A Telegram bot token to set up the Telegram Trigger and Telegram nodes.
  • Apify Account/API Key: Access to an API that can analyze website tools (e.g., Apify's Website Checker, or a custom API endpoint). You'll need the API endpoint and any necessary authentication.
  • OpenRouter API Key: An API key for OpenRouter to access various AI models.
  • Google Account: A Google account with access to Google Sheets. You'll need to specify the Spreadsheet ID and Sheet Name.
  • Google Sheets Credential: An n8n credential configured for Google Sheets.

Setup/Usage

  1. Import the workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Telegram Trigger:
    • Set up a Telegram credential with your bot token.
    • Activate the Telegram Trigger node.
  3. Configure HTTP Request (Apify):
    • Update the "HTTP Request" node with the correct URL for your website tool analysis API (e.g., Apify endpoint).
    • Add any necessary API keys or authentication headers.
  4. Configure AI Agent and Chat Model:
    • Set up an OpenRouter credential with your API key.
    • Ensure the "OpenRouter Chat Model" node is configured with your desired model.
    • Review the prompt in the "AI Agent" node to tailor the analysis to your needs.
  5. Configure Google Sheets:
    • Set up a Google Sheets credential.
    • In the "Google Sheets" node, specify your Spreadsheet ID and Sheet Name where the data will be stored.
  6. Activate the workflow: Once all credentials and configurations are set, activate the workflow.
  7. Start analyzing: Send a message containing a website URL to your Telegram bot, and the workflow will process it.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Generate Weather-Based Date Itineraries with Google Places, OpenRouter AI, and Slack

🧩 What this template does This workflow builds a 120-minute local date course around your starting point by querying Google Places for nearby spots, selecting the top candidates, fetching real-time weather data, letting an AI generate a matching emoji, and drafting a friendly itinerary summary with an LLM in both English and Japanese. It then posts the full bilingual plan with a walking route link and weather emoji to Slack. 👥 Who it’s for Makers and teams who want a plug-and-play bilingual local itinerary generator with weather awareness — no custom code required. ⚙️ How it works Trigger – Manual (or schedule/webhook). Discovery – Google Places nearby search within a configurable radius. Selection – Rank by rating and pick the top 3. Weather – Fetch current weather (via OpenWeatherMap). Emoji – Use an AI model to match the weather with an emoji 🌤️. Planning – An LLM writes the itinerary in Markdown (JP + EN). Route – Compose a Google Maps walking route URL. Share – Post the bilingual itinerary, route link, and weather emoji to Slack. 🧰 Requirements n8n (Cloud or self-hosted) Google Maps Platform (Places API) OpenWeatherMap API key Slack Bot (chat:write) LLM provider (e.g., OpenRouter or DeepL for translation) 🚀 Setup (quick) Open Set → Fields: Config and fill in coords/radius/time limit. Connect Credentials for Google, OpenWeatherMap, Slack, and your LLM. Test the workflow and confirm the bilingual plan + weather emoji appear in Slack. 🛠 Customize Adjust ranking filters (type, min rating). Modify translation settings (target language or tone). Change output layout (side-by-side vs separated). Tune emoji logic or travel mode. Add error handling, retries, or logging for production use.

nodaBy noda
52

AI-powered document search with Oracle and ONNX embeddings for recruiting

How it works Create a user for doing Hybrid Search. Clear Existing Data, if present. Add Documents into the table. Create a hybrid index. Run Semantic search on the Documents table for "prioritize teamwork and leadership experience". Run Hybrid search for the text input in the Chat interface on the Documents table. Setup Steps Download the ONNX model allMiniLML12v2augmented.zip Extract the ZIP file on the database server into a directory, for example /opt/oracle/onnx. After extraction, the folder contents should look like: bash bash-4.4$ pwd /opt/oracle/onnx bash-4.4$ ls allMiniLML12_v2.onnx Connect as SYSDBA and create the DBA user sql -- Create DBA user CREATE USER app_admin IDENTIFIED BY "StrongPassword123" DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users; -- Grant privileges GRANT DBA TO app_admin; GRANT CREATE TABLESPACE, ALTER TABLESPACE, DROP TABLESPACE TO app_admin; Create n8n Oracle DB credentials hybridsearchuser → for hybrid search operations dbadocuser → for DBA setup (user and tablespace creation) Run the workflow Click the manual Trigger It displays Pure semantic search results. Enter search text in Chat interface It displays results for vector and keyword search. Note The workflow currently creates the hybrid search user, docuser with the password visible in plain text inside the n8n Execute SQL node. For better security, consider performing the user creation manually outside n8n. Oracle 23ai or 26ai Database has to be used. Reference Hybrid Search End-End Example

sudarshanBy sudarshan
211