Supercharged Lead Scraper | AI Chatbot Subflow

AI-Powered Content Summarization and Archiving This workflow automates the process of summarizing web content and archiving it for future reference. It's triggered by an external signal containing a URL, uses AI to create a concise summary of the content at that URL, and then logs the original link along with its new summary into a Google Sheet. This is ideal for creating an automated knowledge base, compiling research, or tracking media mentions without manual intervention. Technologies Used - n8n - Webhooks - OpenAI - Google Sheets AI Integration The core intelligence of this workflow is supplied by the OpenAI node. It receives a URL and is prompted to act as a content summarizer. The AI model accesses the content of the linked webpage, comprehends its main points, and generates a new, concise summary. This completely replaces the human task of reading an article and manually writing a summary, transforming raw URLs into structured, digestible information automatically. Node-by-Node Breakdown 1. Webhook (Webhook): This node serves as the workflow's entry point. It listens for HTTP POST requests from any service capable of sending one. It's configured to expect a JSON body containing a title and a url, which it then passes on to start the automation. 1. OpenAI (Summarize with AI): This is the AI-powered brain of the operation. It takes the url received by the webhook and uses the OpenAI Chat Completions API. A carefully crafted prompt instructs the AI to visit the URL, read the content, and produce a brief summary. The output is a structured JSON object containing the AI-generated text. 1. Set (Prepare Data): This utility node acts as a data organizer. It gathers the original title and url from the initial Webhook trigger and combines them with the summary generated by the OpenAI node. It also appends the current timestamp ($now) to record when the summary was created. This ensures a clean, single object is ready for the final step. 1. Google Sheets (Append to Sheet): This node serves as the final storage destination. It connects to a specified Google Sheet and uses the "Append" operation to add a new row.