Telegram GPT Website Audit to Google Sheets (n8n Workflow)

Turn Telegram messages into website audits—automatically logged to Google Sheets

This n8n workflow powers a Telegram GPT Website Audit assistant: send a URL to your Telegram bot, and it scrapes the page, uses OpenAI (gpt-4o-mini) to generate a structured audit, saves the results to Google Sheets, and replies back in the same chat.

What this workflow does

• Triggers on new Telegram messages sent to your bot.
• Extracts the first URL from the message text. If no URL is found, it sends a help reply back to the same Telegram chat.
• Fetches the website HTML using an HTTP Request and converts it into cleaned, readable text for analysis.
• Generates a structured audit with OpenAI (gpt-4o-mini), including business type, score, issues, quick wins, recommendation, opportunity, and talking points.
• Replies with a plain-text audit in Telegram.
• Appends the audit to Google Sheets by adding a new row in the tab named “Website Audits”.

Use cases

• Run a fast website quality review for clients by sending their URL in Telegram.
• Operationalize SEO/UX checks by automatically storing each audit in Google Sheets for reporting.
• Reduce manual audit work for SaaS teams: gather issues and talking points directly from the page content.
• Support sales/partnership outreach by providing immediate, structured website feedback in the same chat.

Technical details

• Telegram Trigger for incoming bot messages, plus Telegram send-message replies.
• if and set logic to handle missing URLs and message formatting.
• http request to download page HTML.
• code to clean and prepare readable text for the audit.
• OpenAI chat model using gpt-4o-mini for the structured website audit.
• Google Sheets (OAuth2) append step writing results to the Website Audits tab.