Google Docs and Google Gemini Chat Model integration

🎥 YouTube Video Summarizer for Social Media Turn any YouTube video into a short, structured summary using AI — perfect for content creators, marketers, or social media managers. 🔧 What We Built We created a no-code automation in n8n that: Accepts a YouTube Video ID via a form Fetches the video transcript using an external API Summarizes the transcript using AI (Google Gemini) Automatically saves the summary to Google Docs for team use 🧩 Flow Overview | Step | Description | |------|-------------| | ✅ Form Trigger | User submits a YouTube video ID using an n8n form | | 🔁 Set Node | Maps the YouTube video ID for use in the API request | | 🌐 HTTP Request (External API) | Calls the YouTube Transcriptor AI API via RapidAPI to fetch transcript | | 🧹 Formatter (Code Node) | Joins transcript lines into a readable text block | | 🧠 AI Agent + Google Gemini (via Langchain) | Summarizes the full transcript into bullet points and tone | | 🧽 Optimizer (Code Node) | Extracts just the summary from the AI response | | 📝 Google Docs Node | Appends the clean summary to a shared Google Doc | 🌍 Real-World Problem Solved ❌ The Challenge Creators and marketers waste hours watching full videos just to extract the key points. Manual summarization is inconsistent, repetitive, and delays content planning. ✅ Our Solution ⏱️ Reduces time spent watching videos 🧠 AI-powered summaries keep tone consistent and structured 📄 Auto-sync with Google Docs makes summaries instantly available for teams 🔥 Bonus: This uses the YouTube Transcriptor AI API, so no need to manually scrape captions or use browser extensions. 🚀 Ideal Use Cases Repurpose YouTube content into Instagram Reels, LinkedIn posts, or blog content Build a video summary library for your editorial team Quickly extract talking points from podcast episodes 🛠️ Tech Stack n8n** – workflow automation engine YouTube Transcriptor AI API** – via RapidAPI Google Gemini (via Langchain)** – AI summarization Google Docs** – stores the final summary JavaScript nodes** – custom text parsing & formatting 💡 Want to customize it? Add Slack, Airtable, Notion, or Tweet auto-posting to expand the flow. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!

WATCH THE n8n STARTER GUIDE 👇 This template is featured in the n8n Starter Guide series. The template is free, but comes with two additional PDFs and a Quick Start video if you grab the full download pack on gumroad. How it works This template is a visual map of many useful n8n nodes. It groups nodes like Triggers, AI tools, and App connectors onto the canvas. Explore the sections to learn about different nodes and easily copy them for your own workflows. It acts as a handy visual reference guide. Set up steps • Setup takes about 5 minutes. • Import the template into your n8n instance. • Explore the node categories visually on the canvas. • A Quick Start video is included in the download pack, along with a prompts PDF and PDF with links to other awesome n8n templates here on the n8n template gallery.

AI-Powered Tech Radar Advisor This project is built on top of the famous open source ThoughtWorks Tech Radar. You can use this template to build your own AI-Powered Tech Radar Advisor for your company or group of companies. Target Audience This template is perfect for: Tech Audit & Governance Leaders:** Those seeking to build a tech landscape AI platform portal. Tech Leaders & Architects:** Those aiming to provide modern AI platforms that help others understand the rationale behind strategic technology adoption. Product Managers:** Professionals looking to align product innovation with the company's current tech trends. IT & Engineering Teams:** Teams that need to aggregate, analyze, and visualize technology data from multiple sources efficiently. Digital Transformation Experts:** Innovators aiming to leverage AI for actionable insights and strategic recommendations. Data Analysts & Scientists:** Individuals who want to combine structured SQL analysis with advanced semantic search using vector databases. Developers:** Those interested in integrating RAG chatbot functionality with conversation storage. Description Tech Constellation is an AI-powered Tech Radar solution designed to help organizations visualize and steer their technology adoption strategy. It seamlessly ingests data from a Tech Radar Google Sheet—converting it into both a MySQL database and a vector index—to consolidate your tech landscape in one place. The platform integrates an interactive AI chat interface powered by four specialized agents: AI Agent Router:** Analyzes and routes user queries to the most suitable processing agent. SQL Agent:** Executes precise SQL queries on structured data. RAG Agent:** Leverages semantic, vector-based search for in-depth insights. Output Guardrail Agent:** Validates responses to ensure they remain on-topic and accurate. This powerful template is perfect for technology leaders, product managers, engineering teams, and digital transformation experts looking to make data-driven decisions aligned with strategic initiatives across groups of parent-child companies. Features Data Ingestion A Google Sheet containing tech radar data is used as the primary source. The data is ingested and converted into a MySQL database. Simultaneously, the data is indexed into a vector database for semantic (vector-based) search. Interactive AI Chat Chat Integration:** An AI-powered chat interface allows users to ask questions about the tech radar. Customizable AI Agents:** AI Agent Router: Determines the query type and routes it to the appropriate agent. SQL Agent: Processes queries using SQL on structured data. RAG Agent: Performs vector-based searches on document-like data. Output Guardrail Agent: Validates queries and ensures that the responses remain on-topic and accurate. Usage Examples Tell me, is TechnologyABC adopted or on hold, and why? List all the tools that are considered part of the strategic direction for company3 but are not adopted. Project Links & Additional Details GitHub Repository (Frontend Interface Source Code):** github.com/dragonjump/techconstellation Try It:** https://scaler.my

The Ultimate Beginner's Guide to an AI-Powered Telegram Assistant (PDF, Brave search & Google Suite) This comprehensive workflow bundle is designed as a powerful starter kit, enabling you to build a multi-functional AI assistant on Telegram. It seamlessly integrates AI-powered voice interactions, an intelligent PDF document search using a Retrieval-Augmented Generation (RAG) system, and automates various Google Suite tasks like calendar management and document generation. Perfect for beginners looking to explore advanced AI and automation capabilities. Disclaimer This template is designed for self-hosted n8n instances. 🚀 Key Features Telegram Bot Interface:** Interact with your AI assistant using both text and voice commands through Telegram. AI Voice Bot:** Transcribes user voice messages using OpenAI Whisper. Processes requests with an AI agent powered by Google Gemini. Responds with AI-synthesized voice using Replicate API. PDF RAG System:** Index PDF documents from Google Drive via Telegram commands. Utilizes Mistral AI for Optical Character Recognition (OCR) on PDFs. Stores document content and embeddings in a Qdrant vector database. Answers questions about your documents using Google Gemini, based on retrieved context. Google Suite Automation:** Manage Google Calendar: Create events, find upcoming holidays, and list birthdays. Google Drive: Search for PDF files and manage document templates. Google Docs: Automatically generate invoices from templates. Intelligent Web Search:** Employs Brave Search for fetching real-time information from the web. Versatile AI Agent:** Leverages Google Gemini with a suite of tools including a calculator, date & time utilities, and custom integrations (e.g., example Airbnb tools). Command-Driven Functionality:** Easily trigger specific actions using Telegram commands like /help, /pdf, /rag, /invoice, /chat, /brave, and /birthday. ⚙️ How It Works The workflow is initiated by messages or commands sent to your Telegram bot. A central Switch node directs the flow based on the input received. Telegram Interaction & Command Routing A Telegram Trigger node listens for new messages (text or voice). A "typing..." indicator is sent to Telegram for better user experience. The Switch node parses the message content and routes it to the appropriate sub-workflow based on predefined commands (e.g., /pdf, /rag, /voice) or general chat. AI Voice Bot Functionality For voice messages (or if the voice path is triggered): The voice file is downloaded from Telegram. OpenAI Whisper transcribes the audio into text. The transcribed text is fed to an AI Agent (powered by Google Gemini and equipped with various tools and memory). The AI Agent's text response is then sent to the Replicate API to generate a natural-sounding voice. The generated audio response is sent back to the user on Telegram. PDF RAG System with Mistral OCR & Qdrant Indexing PDFs (via /qdrant <Google_Drive_File_ID> command):** The specified PDF is downloaded from Google Drive. The PDF is uploaded to Mistral AI for OCR processing. The extracted text (in markdown format) is retrieved. The text is split into manageable chunks. OpenAI Embeddings are generated for each chunk. These chunks and their embeddings are stored in a Qdrant vector collection. A confirmation message is sent to Telegram. Querying PDFs (via /rag <your_question> command):** The user's question is processed by a RetrievalQA Chain. This chain uses Google Gemini as the Language Model and retrieves relevant document chunks from Qdrant based on semantic similarity (embeddings). Google Gemini then generates a concise answer based on the user's question and the retrieved contextual information from the documents. The answer is sent back to the user on Telegram. Searching PDFs in Drive (via /pdf <search_term> command):** Searches your Google Drive for PDF files matching the provided search term. Sends a list of found PDF files (name and ID) to the user on Telegram, allowing them to easily identify files for indexing with /qdrant. AI Chat & Task Automation (General Chat & /chat command) Handles general text messages or transcribed voice inputs that are not specific commands. An AI Agent (Google Gemini) processes these inputs. The agent is equipped with tools such as: Google Calendar Tools: To create events, find the next public holiday, or list upcoming birthdays. Brave Search Tool: To search the internet for information. Calculator Tool: For mathematical computations. Date & Time Utility: For handling and formatting dates. Example Airbnb Tools: Demonstrates extensibility for custom tool integrations. The agent utilizes a "Think Node" process for reasoning and Window Buffer Memory to maintain conversational context. Responses are formulated and sent back to the user on Telegram. Google Automations Invoice Generation (via /invoice command):** Copies a predefined Google Docs invoice template from your Google Drive. Populates the new document with details (client name, items, etc. – currently uses placeholder data from an 'Edit Fields' node, which can be customized to parse input from the command). Converts the populated Google Doc into a PDF file. Sends the generated PDF invoice to the user via Telegram. Calendar Management (via AI Agent or specific commands like /birthday):** The /birthday command fetches upcoming birthdays from a specified Google Calendar. The AI Agent can also interact with Google Calendar to create events or retrieve information based on natural language requests. Web Search (via /brave <query> command or AI Agent) Performs a web search using the Brave Search API. Returns a list of search results, including titles and URLs, to the user on Telegram. Help Command (/help) Provides the user with a formatted list of all available Telegram commands and their basic usage instructions. 🛠️ Setup Steps & Credentials To get this workflow bundle up and running, you'll need to configure several credentials: Telegram: Create a new bot via @BotFather on Telegram to obtain a Bot Token. Add this token to the Telegram Trigger node and all Telegram (sender) nodes in the workflow. OpenAI: Obtain an API Key from platform.openai.com. Create an OpenAI credential. Use this credential in the Convert audio to text (OpenAI node for Whisper transcription) and all Embeddings OpenAI nodes (for RAG system). Replicate API (Text-to-Speech): Sign up at replicate.com and get your API token. Create an HTTP Bearer Auth credential using this token. Assign this credential to the Call Replicate API (HTTP Request) node. Google Gemini (PaLM API): Get an API key from Google AI Studio or Google Cloud Console. Create a Google Gemini(PaLM) Api credential. Assign it to all Google Gemini Chat Model nodes. Qdrant (Vector Database): Set up a Qdrant instance (either cloud-hosted or self-managed). Note your Qdrant instance URL and API Key (if security is enabled). Create a QdrantApi credential with these details. Assign it to the Qdrant Vector Store nodes. For the Refresh collection node (an HTTP Request node used to clear the collection for /pdf command demo), create an HTTP Header Auth credential with your Qdrant API key if required by your instance. Mistral AI (PDF OCR): Obtain an API key from console.mistral.ai. Create a Mistral Cloud API credential. Assign this to the Mistral Upload, Mistral Signed URL, and Mistral DOC OCR (HTTP Request) nodes. Google Drive & Google Docs: Ensure the Google Drive API and Google Docs API are enabled in your Google Cloud Console project. Set up OAuth 2.0 credentials (Client ID and Client Secret). Create Google Drive OAuth2 Api and Google Docs OAuth2 Api credentials. Assign these to the respective Google Drive and Google Docs nodes throughout the workflow. Important: Configure relevant Folder IDs (for PDF search, invoice template source, invoice output) and the invoice template Document ID in the Google Drive and Google Docs nodes. Google Calendar: Enable the Google Calendar API in your Google Cloud Console project. Set up OAuth 2.0 credentials. Create a Google Calendar OAuth2 Api credential. Assign it to the Google CalendarTool and Google Calendar nodes. Specify the correct calendar names or IDs in the nodes (e.g., for birthdays, holidays, new event creation). Brave Search: Get a Brave Search API key from their developer portal. Create a Brave Search API credential. Assign it to the Brave Search nodes and tools. (Optional) Airbnb MCP Client: The workflow includes example nodes for Airbnb MCP tools. If you intend to use or expand these, set up the corresponding MCP Client API credentials. 💡 Customization & Learning This "Beginner Bundle" is not just a ready-to-use solution but also a fantastic learning resource: Explore AI Agent Prompts:** Dive into the AI Agent nodes to see how prompts are structured to guide the LLM's behavior, including the "Think Node" process and character guidance for robust messaging. Modify Toolsets:** Easily add or remove tools for the AI agent to expand its capabilities. Invoice Customization:** Adapt the Edit Fields node and the Google Docs template to match your invoicing needs. You can extend it to parse invoice details directly from the Telegram command. RAG Parameters:** Experiment with chunk sizes, overlap, and different embedding models in the RAG pipeline. Extend Commands:** Add new commands and corresponding functionalities by expanding the main Switch node and building out new automation paths. By setting up and dissecting this workflow, beginners can gain a practical understanding of building complex, AI-driven applications, integrating various services, and managing different data flows.

This n8n workflow creates a financial analysis tool that generates reports on a company's quarterly earnings using the capabilities of OpenAI GPT-4o-mini, Google's Gemini AI and Pinecone's vector search. By analyzing PDFs of any company's earnings reports from their Investor Relations page, this workflow can answer complex financial questions and automatically compile findings into a structured Google Doc. How it works: Data loading and indexing Fetches links to PDF earnings document from a Google Sheet containing a list of file links. Downloads the PDFs from Google Drive. Parses the PDFs, splits the text into chunks, and generates embeddings using the Embeddings Google AI node (text-embedding-004 model). Stores the embeddings and corresponding text chunks in a Pinecone vector database for semantic search. Report generation with AI agent Utilizes an AI Agent node with a specifically crafted system prompt. The agent orchestrates the entire process. The agent uses a Vector Store Tool to access and retrieve information from the Pinecone database. Report delivery Saves the generated report as a Google Doc in a specified Google Drive location. Set up steps Google Cloud Project & Vertex AI API: Create a Google Cloud project. Enable the Vertex AI API for your project. Google AI API key: Obtain a Google AI API key from Google AI Studio. Pinecone account and API key: Create a free account on the Pinecone website. Obtain your API key from your Pinecone dashboard. Create an index named company-earnings in your Pinecone project. Google Drive - download and save financial documents: Go to a company you want to analize and download their quarterly earnings PDFs Save the PDFs in Google Drive Create a Google Sheet that stores a list of file URLs pointing to the PDFs you downloaded and saved to Google Drive Configure credentials in your n8n environment for: Google Sheets OAuth2 Google Drive OAuth2 Google Docs OAuth2 Google Gemini(PaLM) Api (using your Google AI API key) Pinecone API (using your Pinecone API key) Import and configure the workflow: Import this workflow into your n8n instance. Update the List Of Files To Load (Google Sheets) node to point to your Google Sheet. Update the Download File From Google Drive to point to the column where the file URLs are Update the Save Report to Google Docs node to point to your Google Doc where you want the report saved.

Who this is for This workflow is designed for researchers, marketing teams, customer success managers, and survey analysts who want to automatically generate AI-powered summaries of form responses collected via Jotform — turning raw feedback into actionable insights. It is ideal for: Teams conducting market research or post-event surveys. Customer experience teams that collect feedback via forms and need instant, digestible summaries. Product managers seeking concise overviews of user comments and suggestions. Analysts who want to compare comprehensive vs. abstract summaries for richer intelligence. What problem this workflow solves Analyzing open-ended Jotform responses manually can be slow, repetitive, and error-prone. This workflow automates the process by generating two AI summaries for every response: Comprehensive Summary — captures all factual details from the response. Abstract Summary — rephrases and synthesizes insights at a higher, conceptual level. With this workflow: Each response is summarized instantly using Google Gemini AI. Both comprehensive and abstract summaries are automatically generated and stored. Data is persisted in Google Sheets, DataTable, and Google Docs for further use. What this workflow does This n8n workflow transforms Jotform submissions into structured summaries using Google Gemini. Step-by-Step Breakdown Webhook Trigger (Jotform Integration) Listens for new Jotform submissions using the Webhook node. Receives full form data via the Webhook response. Set the Input Fields Extracts and assigns key fields like: FormTitle SubmissionID Body (the formatted form data) Prepares structured JSON to feed into the AI summarization stage. Comprehensive & Abstract Summarizer Powered by Google Gemini Chat Model (models/gemini-2.0-flash-exp). Custom prompt: You are an expert comprehensive summarizer. Build a detailed and abstract summary of the following {{ $json.body.pretty }}. Produces two distinct summaries: comprehensive_summary abstract_summary Structured Output Parser Ensures Gemini output matches a defined JSON schema: { "comprehensive_summary": "", "abstract_summary": "" } Guarantees reliable downstream integration with Sheets and Docs. Persist on DataTable Saves both summaries into an n8n DataTable for historical tracking or visualization. Useful for teams running internal analytics within n8n Cloud or self-hosted environments. Append or Update Row in Google Sheets Writes both summaries into a connected Google Sheet. Columns: comprehensive_summary abstract_summary Create Google Document Automatically generates a Google Docs file titled: {FormTitle}-{SubmissionID} Acts as a per-submission record with a placeholder ready for AI summary insertion. Update Google Document Inserts both summaries directly into the newly created Google Doc: Comprehensive Summary: [Full detailed summary] Abstract Summary: [Conceptual summary] Each doc becomes a polished, shareable insight artifact. Concepts Used in the Workflow Comprehensive Summarization Comprehensive summarization captures every important detail in a factual, exhaustive way — ideal when accuracy and completeness matter. Goal: Provide a detailed understanding of user responses without losing nuance. Best For: Research surveys Customer service logs Support ticket summaries Feedback traceability Abstract Summarization Abstract summarization rephrases and synthesizes ideas, offering high-level insights rather than copying text. Goal: Capture the essence and implications of feedback — ideal for storytelling and executive reviews. Best For: Executive summaries Marketing insights Customer trend analysis Blog-style recaps Setup Instructions Pre-requisite If you are new to Jotform, Please do signup using Jotform Signup For the purpose of demonstation, we are considering the Jotforms Prebuilt Form as a example. Follow these steps to deploy and customize the workflow: Step 0: Local n8n This step is required for the locally hosted n8n only. Please make sure to setup and install ngrok and follow the steps to configure and run ngrok on your local with the n8n port. This is how you can run. ngrok http 5678 Copy the base URL ex: https://2c6ab9f2c746.ngrok-free.app/ as it will be utilized as part of the webhook configuration for the Jotform. Step 1: Configure Jotform Webhook Copy the webhook URL generated by n8n’s Jotform Trigger node. In your Jotform dashboard, go to: Settings → Integrations → Webhooks → Add Webhook If you are executing this workflow on a self hosted n8n instance, please follow the steps for setting up ngrok and format the Webhook URL so that the Jotform can make a Webhook POST over the public URL. Copy the Webhook URL generated by n8n. You can copy the URL by double clicking on the Jotform Trigger node. Make sure to replace the base url with the above Step 0, if you are running the workflow from your local machine. Step 2: Connect Google Gemini Navigate to n8n → Credentials → Google Gemini (PaLM API). Add API credentials and select the model: models/gemini-2.0-flash-exp Test the connection before proceeding. Step 3: Configure the Structured Output Parser Open the Structured Output Parser node. Ensure the schema includes: { "comprehensive_summary": "", "abstract_summary": "" } Modify or expand schema fields if additional summaries (e.g., “sentiment_summary”) are needed. Step 4: Connect Google Sheets Link your Google Sheets OAuth2 credentials. Specify: Document ID (Google Sheet URL) Sheet Name (e.g., “Sheet1”) Map columns to: comprehensive_summary abstract_summary Step 5: Enable DataTable Storage (Optional) Use the DataTable node to maintain a permanent database within n8n Cloud. Configure the schema fields for: comprehensive_summary abstract_summary Step 6: Generate and Update Google Docs Link your Google Docs account under n8n credentials. The workflow auto-creates and updates a doc per submission, embedding both summaries for easy sharing. How to Customize Add Sentiment Analysis** After generating the summary, insert another Google Gemini node to classify the tone of each response — for example, Positive, Neutral, or Negative. This helps you track user sentiment trends over time. Send Alerts for Urgent Feedback** Use an IF node to check if the abstract summary contains words such as “urgent,” “issue,” or “negative.” If triggered, automatically send an alert through Slack, Gmail, or Discord, so the team can respond immediately. Enable Multi-Language Support** Insert a Language Detection node before the Gemini summarizer. Once the language is detected, modify the summarizer prompt dynamically to summarize in that same language — ensuring localized insights. Add Topic Extraction** Include an additional Gemini text extraction node that identifies major topics or recurring themes from each response before summarization. This creates structured insights ready for analytics or tagging. Integrate with CRM or Ticketing Systems** Connect your workflow to HubSpot, Salesforce, or Zendesk to automatically create new records or tickets based on the feedback type or sentiment. This closes the loop between survey collection and actionable response. Summary This workflow automates survey intelligence generation from Jotform submissions — powered by Google Gemini AI — delivering dual-layer summarization outputs directly into Google Sheets, DataTables, and Google Docs. Benefits: Instant comprehensive and abstract summaries per submission. Ready-to-use outputs for reports, dashboards, and client deliverables.

This workflow automates the creation of exam questions (both open-ended and multiple-choice) from educational content stored in Google Docs, using AI-powered analysis and vector database retrieval This workflow saves educators hours of manual work while ensuring high-quality, curriculum-aligned assessments. Let me know if you'd like help adapting it for specific subjects! Use Cases Educators**: Rapidly generate quizzes, midterms, or flashcards. E-learning platforms**: Automate question banks for courses. Corporate training**: Create assessments for employee onboarding. Technical Requirements: APIs**: Google Gemini, OpenAI, Qdrant, Google Workspace. n8n Nodes**: LangChain, Google Sheets/Docs, HTTP requests, code blocks. This workflow combines AI efficiency with human-curated quality, making it a powerful tool for modern education and training. Advantages of This Workflow ✅ Fully Automated Exam Generation: From document to fully formatted quiz content with no manual intervention. ✅ Supports Comprehension and Critical Thinking: Questions are designed to go beyond factual recall, including inference and application. ✅ Uses AI and RAG for Accuracy: Ensures that answers are grounded in the document content, reducing hallucination. ✅ Seamless Google Integration: Pulls content from Google Docs and writes outputs to Google Sheets. ✅ Scalable for Any Subject: Works with any article or content domain as input. ✅ Modular and Customizable: Can be easily adapted to generate different question types or to use other LLMs or storage systems. How It Works Document Ingestion: The workflow starts by fetching an educational document (e.g., textbook chapter, lecture notes) from Google Docs. Converts the document to Markdown for structured processing. AI Processing: Splits text into chunks and generates vector embeddings (via OpenAI) for semantic analysis. Stores embeddings in Qdrant (vector database) for retrieval. Question Generation: Open-ended questions: Google Gemini AI creates 10 critical-thinking questions. Multiple-choice questions: Generates 10 MCQs (1 correct + 3 plausible distractors) using RAG to validate answers against the vector DB. Answer Validation: For open questions: Retrieves context-aware answers from the vector store. For MCQs: Ensures distractors are incorrect but believable via AI cross-checking. Output: Saves questions/answers to Google Sheets in two tabs: Open questions: Question + AI-generated answer. Closed questions: MCQ + options + correct answer. Set Up Steps Prerequisites: APIs/Accounts: Google Workspace (Docs + Sheets). OpenAI (for embeddings). Google Gemini (for question generation). Qdrant (vector DB – self-hosted or cloud). n8n Nodes: Ensure LangChain, Google Sheets/Docs, and HTTP request nodes are installed. Configure Connections: Link credentials for: Google Docs/Sheets (OAuth2). OpenAI (API key). Google Gemini (API key). Qdrant (URL + API key). Customize Input: Replace the default Google Doc ID in the "Get Doc" node with your source document. Adjust chunk size/overlap (Token Splitter node) for optimal text processing. Tweak Question Generation: Modify prompts in: "Open questions" node: Adjust criteria (e.g., difficulty, question types). "Closed questions" node: Edit MCQ formatting rules. Output Settings: Update the Google Sheet ID in "Write open" and "Write closed" nodes. Map columns in Google Sheets to match question/answer formats. Run & Automate: Trigger manually ("Test workflow") or schedule periodic runs (e.g., for updated content). Need help customizing? Contact me for consulting and support or add me on Linkedin.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ❓ What Problem Does It Solve? Manual transcription and action planning from meeting notes is often error-prone, time-consuming, and inconsistent. Important tasks, decisions, or deadlines can be overlooked or delayed. This workflow solves these pain points by automatically analyzing notes using AI and turning them into actionable, structured data. It drastically reduces follow-up delays, miscommunications, and administrative effort, letting teams focus on execution instead. 💡 Why Use Google Meet Automation? Save Hours of Manual Work:** Automatically transform raw meeting notes into structured tasks and emails without lifting a finger. Ensure Accurate Follow-up:** Never miss important action items or decisions buried in text; everything is extracted and assigned clearly. Improve Team Collaboration:** Instantly distribute meeting summaries and next steps to attendees, keeping everyone aligned. Leverage Advanced AI:** Utilize Google Gemini’s powerful natural language processing tailored specifically for meetings. Fully End-to-End Automated:** From receiving notes to task creation and email dispatch — your post-meeting workflow is completely hands-free. ⚡ Who Is This For? Project Managers:** Streamline task delegation and keep project timelines on track. Team Leads:** Quickly communicate key takeaways and follow-ups to team members. Sales and Account Teams:** Document client meetings efficiently and automate follow-up outreach. Remote Teams:** Ensure clarity and continuity after virtual meetings. Executives:** Get concise summaries and important decision logs automatically. 🔧 What This Workflow Does ⏱ Trigger: Activated via a POST webhook receiving meeting notes, title, attendees, date, and duration. 📎 Step 2: Validates inputs; if missing required fields, sends an error response. 🔍 Step 3: Extracts and formats meeting data into structured variables for processing. 🤖 Step 4: Sends meeting notes to Google Gemini AI for advanced analysis to identify action items, decisions, summaries, follow-ups, and dates. 💌 Step 5: Splits AI responses to create Google Tasks from action items and send personalized follow-up emails via Gmail. 🗂 Step 6: Generates a Google Docs meeting summary document and finally returns a success response with all processed results. 🔐 Setup Instructions Import the provided Google Meet Automation.json file into your n8n instance. use Payload example Set up credentials for: Google OAuth2 API (Google Tasks, Google Docs) Gmail OAuth2 API for sending emails Google Palm API (for Google Gemini AI access) Customize workflow parameters: Webhook URL and access permissions Google Tasks project or folders if applicable Email templates if desired (subject line, branding) Update any API endpoints or credential references to match your account setup. Thoroughly test with sample meeting note payloads to ensure smooth execution. 🧩 Pre-Requirements Active n8n instance (Cloud or Self-hosted) Google Cloud Platform project with: Google Tasks API enabled Google Docs API enabled Gmail API enabled Google Palm API access (Google Gemini AI) Valid OAuth2 credentials configured in n8n for above services API quota and permissions for sending emails, creating docs, and tasks 🛠️ Customize It Further Integrate with calendar apps (Google Calendar, Outlook) to auto-schedule next meetings. Add Slack or Microsoft Teams notifications for real-time alerts. Extend AI prompt for deeper insights like sentiment analysis or risk flags. Customize email templates with branding, signatures, or attachments. Connect task outputs with project management tools like Asana, Trello, or Jira. 📞 Support Made by: khaisa Studio Tag: automation, google meet, meeting notes, AI, google tasks, gmail, google docs Category: Productivity Need a custom? Contact Us

AI Documentation Crawler & Knowledge Base Builder This n8n template automatically crawls technical documentation websites, scrapes their content, and converts it into clean, structured, developer-friendly documentation. Each page is organized into folders and saved as Google Docs, making it easy to build or maintain an internal knowledge base. Who’s it for Developer teams maintaining internal or external documentation SaaS companies onboarding users or support teams AI builders creating documentation-based knowledge bases Anyone who wants to turn raw docs into structured, readable references How it works / What it does Manual Trigger The workflow starts manually whenever you want to crawl or refresh documentation. Documentation Discovery (Crawler) The workflow crawls a root documentation URL and generates a sitemap of all discoverable documentation pages. URL Processing The sitemap is split into individual URLs. The workflow dynamically analyzes URL depth to recreate the documentation hierarchy. Folder Structure Creation A parent folder is created in Google Drive for the service. Subfolders are automatically generated to mirror the documentation structure (based on URL paths). Content Scraping Each documentation page is scraped using the Olostep API. Clean markdown content is extracted from the page. Information Extraction AI extracts structured technical details such as: API summaries cURL examples Authentication methods Key notes and pitfalls AI Documentation Generation An AI agent transforms the scraped content into a polished, human-readable API reference or guide. Document Creation A Google Doc is created for each documentation page. The generated content is inserted into the document and saved in the correct folder. Rate Control A wait step prevents API throttling during large documentation crawls. The result is a fully structured documentation library generated automatically from live documentation websites. How to set up Import the template into your n8n workspace. Set the root documentation URL you want to crawl. Connect your Google Drive and Google Docs accounts. Add your Olostep API key and AI model credentials. Execute the workflow to generate your documentation library. Requirements n8n account (cloud or self-hosted) Olostep API key Google Drive & Google Docs access AI model provider (OpenAI or Gemini) How to customize the workflow Limit the number of pages crawled per run. Adjust AI prompts to match your documentation style. Store results in Notion, Confluence, or Markdown files instead of Google Docs. Add vector storage (Pinecone, Supabase) to turn docs into an AI knowledge base. Schedule automatic re-crawls to keep documentation up to date. 👉 This template turns complex technical documentation into an organized, searchable knowledge base — automatically.

AI Complaint Mining & Insight Extraction This n8n template automates complaint mining from unstructured text sources and turns raw user feedback into clear, actionable insights. It uses AI to identify recurring complaints, pain points, and themes, helping teams understand what users are unhappy about and why. Who’s it for Product managers identifying recurring user pain points Customer support and success teams Founders validating product-market fit issues UX researchers analyzing qualitative feedback Anyone dealing with large volumes of complaints or negative feedback How it works / What it does Trigger The workflow starts with a manual trigger, form submission, or imported text source containing user complaints. Data Preparation Raw complaint text is cleaned, normalized, and split into individual complaint entries. Ensures consistent input for AI processing. AI Complaint Analysis An AI model analyzes each complaint to identify: Core issue Complaint category Emotional tone Severity or urgency Pattern Detection Complaints are grouped by similarity to uncover recurring issues and themes. Highlights the most frequent and impactful problems. Insight Extraction AI summarizes key insights such as: Top recurring complaints Root causes Suggested improvement areas Structured Output Results are converted into structured data fields. Ready to be stored, visualized, or shared with stakeholders. Storage & Reporting Extracted complaints and insights are saved to a table or sheet for easy review and analysis. This workflow transforms unstructured complaint data into a clear feedback loop you can act on. How to set up Import the template into your n8n workspace. Connect your AI model credentials (OpenAI or Gemini). Define your input source (text, form, or file). Connect your storage destination (Google Sheets, Data Table, or database). Run the workflow to start mining complaints automatically. Requirements n8n account (cloud or self-hosted) AI model provider (OpenAI or Gemini) Storage destination (Google Sheets, Data Table, or database) How to customize the workflow Adjust complaint categories and severity scoring. Add sentiment analysis or emotion classification. Connect a vector database to track complaints over time. Trigger alerts when critical issues are detected. Generate dashboards or weekly complaint summaries automatically. 👉 This template helps you turn complaints into insights — and insights into product improvements.

Generate professional sales proposals from a simple form—AI writes the content, you deliver the document. Fill out client details, pain points, and pricing, and this workflow creates a polished proposal with calculated ROI metrics, executive summary, solution strategy, and team bios. How It Works Sales rep submits a form with client name, industry, pain points, and pricing Code node calculates ROI, net savings, and break-even period Gemini AI generates proposal content: executive summary, key challenges, solution strategy, team bios, and call to action Copies your Google Doc template and replaces all placeholders with generated content Final proposal is ready in Google Drive Setup Import the workflow JSON Create a Google Doc template with placeholders: {{client_name}}, {{executive_summary}}, {{key_challenges}} {{solution_strategy}}, {{team_bios}}, {{next_steps}} {{formatted_roi}}, {{formatted_net_savings}}, {{formatted_break_even}} {{formatted_solution_cost}}, {{date}} Add credentials: Google Drive → OAuth2 Google Docs → OAuth2 Google Gemini → API key from aistudio.google.com Configure "Copy proposal template" node → Point to your template document Customize the AI → Edit system message in "Generate proposal content" to match your tone Test → Submit the form and check the generated proposal Activate

This workflow automates the entire UX research planning process — from gathering context to delivering a ready-to-share Google Doc report. Built for UX researchers and designers, it combines AI-powered generation with human feedback loops to make research planning faster, smarter, and more collaborative. 🧠 What it does Collects context** through an online form (organization, product, and research goals) Generates research questions** automatically using an AI Agent Sends approval emails** to the researcher or designer for review and feedback Refines and rewrites** questions based on user input Recommends suitable research methods** for each question, with clear rationales Formats the content** into a structured, professional HTML report Creates and updates a Google Doc** with the final approved research plan 🎯 Who it’s for Perfect for UX teams, design researchers, and product designers who want to streamline their workflow without losing human oversight. Whether you’re preparing a usability study or strategic research plan, this automation helps you focus on insight — not administration. Result: a fully-approved, polished UX Research Plan — ready for collaboration and presentation.

Transform meeting transcripts into fully customized, AI-powered presentations automatically. This comprehensive 5-workflow automation system analyzes client conversations and generates professional slide decks complete with personalized content and AI-generated illustrations. 🎯 What This Automation Does This end-to-end solution takes a meeting transcript (Google Docs) and client information as input, then automatically: Creates a presentation from your custom template Generates a strategic presentation plan tailored to the client's needs Creates custom illustrations using AI image generation Populates slides with personalized text content Inserts generated images into the appropriate slides Delivers a client-ready presentation Perfect for sales teams, consultants, agencies, and anyone who needs to create customized presentations at scale. 🔧 How It Works The automation is split into 5 interconnected workflows: Workflow 1: Clone Presentation & Database Setup Form trigger captures client name, transcript URL, and submission time Clones your presentation template via Google Slides API Saves presentation details to Google Sheets for tracking Workflow 2: AI Presentation Plan Generation Analyzes meeting transcript to understand client pain points Generates comprehensive presentation structure and content strategy Saves plan to Google Docs for review and tracking Uses company profile (customizable) to match solutions to client needs Workflow 3: AI Illustration Generation AI agent creates image prompts based on presentation plan Generates illustrations using Flux model via OpenRouter (nanobanana) Uploads images to Google Drive for slide insertion Tracks all generated assets in database Workflow 4: Text Content Population AI agent generates final presentation text from the plan Replaces template placeholders with personalized content Uses Object IDs to target specific text elements in slides Updates slides using native n8n Google Slides node Workflow 5: Image Insertion Retrieves image Object IDs from presentation structure Downloads illustrations from Google Drive Converts images for ImgBB hosting (resolves Google Drive URL limitations) Updates slide images via Google Slides API 📋 Prerequisites Required Accounts & API Keys: Google Workspace (Drive, Slides, Docs) OpenAI API (for AI agents) OpenRouter API (for Flux image generation) ImgBB API (free tier available) Gemini API (optional, for additional AI tasks) Setup Requirements: Google Sheets database (template provided in article and inside the workflow) Google Slides presentation template with standard Object IDs Meeting transcript in Google Docs format 🎨 Customization Options This automation is designed to be flexible: Template Flexibility**: Use any slide template structure Company Profile**: Customize the business context for your use case AI Models**: Swap OpenAI/Gemini agents for your preferred LLM Image Generation**: Replace Flux with DALL-E, Midjourney API, or other models Slide Logic**: Extend to dynamically select slides based on content needs 💡 Key Technical Insights Structured Output Handling**: Uses JavaScript for reliable JSON parsing when AI output structure is complex Object ID System**: Template placeholders use unique IDs for precise element targeting Image Hosting Workaround**: ImgBB resolves Google Drive direct URL limitations in API calls HTTP Request Nodes**: Used for API operations not covered by native n8n nodes (copying presentations, image updates) 🔗 Full Documentation For a detailed breakdown of each workflow, configuration steps, and best practices, read the complete guide on this Medium article 🚀 Use Cases Sales Teams**: Auto-generate pitch decks from discovery calls Consulting Firms**: Create client proposals from needs assessments Marketing Agencies**: Build campaign presentations from strategy sessions Product Teams**: Transform user research into stakeholder presentations Training & Education**: Convert session notes into learning materials ⚠️ Important Notes Template must use consistent Object IDs for automation to work Google Drive images require ImgBB hosting for reliable URL access AI agent output structure is complex; JavaScript parsing recommended Rate limits apply for API services (especially image generation) 📦 Resources & Templates API Services (Get Your Keys Here) OpenRouter** - For Flux (nanobanana) AI image generation ImgBB API** - Free image hosting service OpenAI API** - For AI agents and text generation Google Cloud Console** - Enable Google Slides, Drive, and Docs APIs Google AI Studio** - For Gemini API key Templates & Examples Meeting Transcript Sample** - Example transcript structure Google Sheets Database Template** - Copy this to track your presentations Presentation Template** - Base slide deck with Object IDs 💡 Tip: Make copies of all templates before using them in your workflows! Have questions or improvements? Connect with me: X (Twitter): @juppfy Email: [email protected] P.S: I'd love to hear how you adapt this for your workflow!

🤖 Automated YouTube Script Generator (Shorts & Long-Form) This workflow is a content multiplier. Provide a single video topic via a form, and it automatically researches, outlines, and writes two separate scripts: one for a YouTube Shorts and another for a Long-form video, saving both directly to Google Docs. ✨ Key Features Dual-Format Output:** Creates tailored scripts for both Shorts and long-form videos from one idea. AI-Powered Writing:* Uses Google Gemini* for all creative steps, from building a structured outline to writing the final scripts. Up-to-Date Research:* Integrates Tavily AI* to pull fresh, relevant information from the web. Fully Automated:** An end-to-end process that takes a form submission and delivers final documents to your Google Drive with no manual steps. ⚙️ How It Works After a topic is submitted, the workflow splits into two parallel branches: The Shorts Branch: This path is built for speed. It performs a quick web search and immediately uses an AI agent to write a short, punchy script. The Long-Form Branch: This path focuses on structure. It conducts a web search, uses an AI agent to first create a detailed outline, and then uses another AI agent to write a comprehensive script based on that outline. 🔑 Prerequisites An active n8n instance. A form to submit your video topic. API keys for Tavily AI and Google Gemini. Google Account credentials (OAuth2) configured in n8n for Google Docs. 🛠️ Setup Guide On form submission Trigger: Configure your form to accept a field for your video topic (e.g., a field named topic). Tavily Nodes: In both Tavily nodes, select or create your Tavily API credential and paste in your API key. Google Gemini Chat Model: In the nodes labeled AI Agent and Create Outline, select your Google AI credential linked to your Gemini API key. Google Docs Nodes: For all four Google Docs nodes (Create Doc, Update Doc, etc.), select your Google OAuth2 credential. Activate the Workflow: Once all credentials are in place, save and activate the workflow. 🚀 How to Use Activate the workflow. Submit your topic via the connected form. Check your Google Drive a few moments later for your the new script!

Workflow Execution Link: Watch Execution Video Workflow Pre-requisites Step 1: Supabase Setup First, replace the keys in the "Save the embedding in DB" & "Search Embeddings" nodes with your new Supabase keys. After that, run the following code snippets in your Supabase SQL editor: Create the table to store chunks and embeddings: CREATE TABLE public."RAG" ( id bigserial PRIMARY KEY, chunk text NULL, embeddings vector(1024) NULL ) TABLESPACE pg_default; Create a function to match embeddings: DROP FUNCTION IF EXISTS public.matchembeddings1(integer, vector); CREATE OR REPLACE FUNCTION public.matchembeddings1( match_count integer, query_embedding vector ) RETURNS TABLE ( chunk text, similarity float ) LANGUAGE plpgsql AS $$ BEGIN RETURN QUERY SELECT R.chunk, 1 - (R.embeddings <=> query_embedding) AS similarity FROM public."RAG" AS R ORDER BY R.embeddings <=> query_embedding LIMIT match_count; END; $$; Step 2: Create Knowledge Base Create a new Google Doc with the complete knowledge base about your business and replace the document ID in the "Content for the Training" node. Step 3: Get Together AI API Key Get a Together AI API key and paste it into the "Embedding Uploaded document" node and the "Embed User Message" node. Step 4: Setup Meta App for WhatsApp Business Cloud Go to https://business.facebook.com/latest/settings/apps, create an app, and select the use case "Connect with customer through WhatsApp". Copy the Client ID and Client Secret and add them to the first node. Go to that newly created META app in the app dashboard, click on the use case, and then click on "customise...". Go to the API setup, add your number, and also generate an access token on that page. Now paste the access token and the WhatsApp Business Account ID into the send message node. Part A: Document Preparation (One-Time Setup) When clicking ‘Execute workflow’ Type:** manualTrigger Purpose:** Manually starts the workflow for preparing training content. Content for the Training Type:** googleDocs Purpose:** Fetches the document content that will be used for training. Splitting into Chunks Type:** code Purpose:** Breaks the document text into smaller pieces for processing. Embedding Uploaded document Type:** httpRequest Purpose:** Converts each chunk into embeddings via an external API. Save the embedding in DB Type:** supabase Purpose:** Stores both the chunks and embeddings in the database for future use. Part B: Chat Interaction (Realtime Flow) WhatsApp Trigger Type:** whatsAppTrigger Purpose:** Starts the workflow whenever a user sends a WhatsApp message. If Type:** if Purpose:** Checks whether the incoming WhatsApp message contains text. Embend User Message Type:** httpRequest Purpose:** Converts the user’s message into an embedding. Search Embeddings Type:** httpRequest Purpose:** Finds the top matching document chunks from the database using embeddings. Aggregate Type:** aggregate Purpose:** Merges retrieved chunks into one context block. AI Agent Type:** langchain agent Purpose:** Builds the prompt combining user’s message and context. Google Gemini Chat Model Type:** lmChatGoogleGemini Purpose:** Generates the AI response based on the prepared prompt. Send message Type:** whatsApp Purpose:** Sends the AI’s reply back to the user on WhatsApp.

📄 What this workflow does This workflow turns a spreadsheet row into a fully formatted, media-rich WordPress article. It pulls the outline and brand context from Google Sheets/Docs, drafts the article with Anthropic or Gemini, enriches it with internal links, converts it to WordPress-ready HTML, uploads images to the WordPress Media Library, and updates your Google Sheet with links and statuses. Optionally, it can create WooCommerce products (kept disabled by default). 👤 Who is this for Content & SEO teams who publish long-form articles at scale. E-commerce teams creating product blogs/landing pages with galleries. Agencies and freelancers who want a repeatable, trackable content pipeline. Founders/marketers who want “brief → draft → images → publish” in one click. ✅ Requirements Google Sheets (content tracker with columns like Title, Query, Outline Link, Image Links, Status). Google Docs (for outline sources and saving final content). Anthropic &/or Gemini API access (drafting + transformations). WordPress site with REST API enabled (Basic/App Password auth) to upload media (and optionally create posts/products). SerpAPI key (for Google Images cover search) — optional; can be removed. (Optional) Perplexity API if you want the “read official docs once” tool for specs. ⚙️ How to set up Connect Google Sheets and select your tracking sheet/tab. Connect Google Docs (for reading the outline and saving the final article). Add Anthropic and/or Gemini credentials in n8n. Add WordPress credentials (REST API) in the HTTP Request nodes used for media upload (and product/post creation if enabled). (Optional) Add SerpAPI key for the image-cover search node. (Optional) Add Perplexity key in the Sonar node if you’ll parse official docs/specs. Publish/enable the Webhook (or your trigger), then test with a sample row (Status Writing = “Run”). 🔁 How it works Trigger → Get Info (Sheets): Picks the next row marked to run and sets “Processing.” Fetch Outline (Docs): Opens the outline link from the sheet. Content Outline Generator & On-page (Anthropic/Gemini): Writes the article using brand context, E-E-A-T rules, and (optionally) reads official docs once via Perplexity Sonar. Previous Posts → Aggregate → Add Internal Links (Gemini): Loads summaries/keywords of prior posts and injects at least 5 high-relevance internal links into the draft. HTML Version: Converts the draft to strict WordPress-ready HTML (H1–H4, justified paragraphs, links, lists, blockquotes). Post image to WordPress (sub-flow) Image Covers (SerpAPI): Finds a cover image by query. Google Sheets + Code: Parses Image Links and Product Image columns; converts Google Drive shares into direct downloads. Split & HTTP Requests: Downloads each image and uploads to WordPress Media Library. Aggregate + Code: Builds an HTML gallery snippet from uploaded URLs. Update Google Doc: Inserts the final article content into a Google Doc and stores the link. Merge → Update Status to Sheet: Writes back Content Final, Outline Link, statuses (Draft/Complete), and any media links. (Optional) Create WooCommerce Product: Disabled by default—enable if you want automatic product creation using the article HTML and gallery. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development.

YouTube Transcription, Summarization & Translation to Google Docs This workflow automates the end-to-end process of converting YouTube videos into structured, multilingual written content. It transcribes the video's speech, optionally summarizes it, translates it into the chosen language and stores the result in a well-formatted Google Doc—ready for review, sharing or publication. Who’s It For Content creators and bloggers repurposing video content. Educators and researchers converting lectures into readable notes. Marketing teams localizing video material for international audiences. Students summarizing and translating study material. YouTube viewers who want written notes or blog-ready formats. How It Works A Webhook triggers the flow with inputs: youtube_url, language and enable_summary. A Code node formats these inputs into videoId, originalUrl, language and enable_summary. An HTTP Request node sends the video to Supadata API for full transcription. Another Code node combines all transcript segments into one body of text. The Basic LLM Chain node uses the Google Gemini Chat Model to summarize and translate the transcript if requested. A Google Docs node creates a new document with a title based on videoId and language. A final Google Docs node appends the processed summary and translation into the created document. How to Set Up Webhook Input: Send a POST request with three fields: youtube_url, language, enable_summary. Configure Supadata API: Add the HTTP URL and Authorization Header for transcription. Set up Gemini Chat Model: Use Google Vertex AI/Gemini integration in the Basic LLM Chain node. Create Google Docs Credentials: Connect your Google account using OAuth2. Document Naming Logic: You may adjust document titles using expressions (e.g., {{ videoId }} - {{ language }}). Requirements Supadata API key (or any video-to-text API). Google account with Google Docs access. Google Gemini access via n8n’s LLM integration. n8n Cloud or self-hosted instance. Basic understanding of webhook setup (or a form frontend). How to Customize Change LLM model:** Swap Gemini with GPT-4 or Claude in the LLM Chain node. Summarization toggle:** Use the enable_summary flag to control verbosity. Document layout:** Customize headings, font styles and content sections in Google Docs. Multiple languages:** Extend the workflow to translate into multiple languages and generate one document per language. Sharing options:** Add Gmail or Slack nodes to notify users once the document is generated. Add‑ons Notion Export:** Send the document summary directly into Notion using the Notion node. Slack Notification:** Notify your team with a link to the Google Doc using the Slack node. Google Sheets Logging:** Log video URLs, timestamps, and language used for auditing. n8n Forms Integration:** Allow users to submit video URLs and language via a hosted n8n form. Use Case Examples Repurposing Videos into Blogs:** Automatically convert YouTube podcasts into multilingual blog posts. Educational Notes:** Extract and translate lecture content into shareable study documents. International Marketing Teams:** Summarize and localize product explainer videos for different countries. Transcription Library:** Create a searchable database of translated transcripts from niche educational YouTube channels. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------------- | ------------------------------------------ | ---------------------------------------------------------- | | Webhook not triggering | Incorrect webhook URL or POST format | Double-check payload and content-type (application/json) | | Transcription API fails | Invalid video ID or API key | Validate YouTube URL and Supadata API access | | Empty translation/summarization | Transcript was empty or prompt was weak | Ensure the video contains spoken content and refine prompt | | Google Doc not created | OAuth2 credentials not authorized properly | Reconnect Google Docs credentials in n8n | | Gemini LLM Chain fails | Model misconfigured or request malformed | Verify your model selection and payload structure | Need Help? Need help getting this set up or customizing it for your workflow? ✅ We can help you: Set up transcription and translation APIs Modify the summarization prompt Customize document layouts or automate sharing 👉 Contact WeblineIndia's automation experts !

This n8n template demonstrates how to build a complete AI-powered content pipeline that pulls fresh news from RSS feeds, transforms it into engaging Medium articles. Categories Content Creation AI Automation Publishing Social Media Share Yes, this n8n workflow is straight FIRE for content creators who want to automate their entire publishing game! 🔥 This template creates a complete content pipeline that pulls fresh tech news from RSS feeds, transforms it into engaging Medium articles using AI, generates matching cover images, and handles the entire approval-to-publishing process through Slack integration. Good to know Uses multiple AI models (Groq, Google Gemini) for content generation Integrates with Medium publishing API for automated posting Includes smart duplicate checking via Google Sheets Generates professional cover images using Pollinations AI Full Slack approval workflow with human oversight Automatic storage and organization in Google Drive How it works RSS Content Fetching Pulls fresh content from The Verge, TechCrunch, and Ars Technica RSS feeds on a 6-hour schedule Smart filtering ensures only new, unposted articles are processed AI Content Generation Groq and Google Gemini models transform RSS content into engaging Medium-style articles Automatic image prompt generation creates relevant cover visuals Pollinations AI generates professional marketing-style images Smart Review & Approval Creates Google Doc with formatted article for easy review Sends preview to Slack channel/DM for human approval Waits for explicit approval before publishing Multi-Platform Publishing Auto-publishes to Medium upon approval Sends formatted content via Gmail Stores everything in Google Drive for archiving Updates Google Sheets to prevent duplicates Rejection Handling Clean rejection notifications via Slack No publishing if content doesn't meet standards Key Features That'll Blow Your Mind Zero-Duplicate Publishing**: Smart Google Sheets integration tracks all published content Human-in-the-Loop**: Slack approval system keeps quality control tight Full AI Pipeline**: From RSS parsing to image generation, everything's automated Multi-Source Content**: Aggregates from top tech news sources Professional Formatting**: Articles come out Medium-ready with proper structure Cloud Storage**: Everything gets archived in Google Drive automatically Email Distribution**: Auto-sends content to your mailing list How to use Clone this workflow and connect your credentials Set up your Google Sheets tracking document Configure Slack notifications for your approval channel Add your Medium API credentials for publishing The schedule trigger runs every 6 hours, but you can adjust timing Manual trigger available for testing and one-off runs Requirements Google Workspace**: Sheets, Docs, Drive, Gmail access Slack Workspace**: For approval notifications and review Groq API**: For AI content generation Google Gemini API**: For image prompt creation Medium API**: For automated publishing Pollinations**: Free AI image generation (no API key needed) Customizing this workflow This isn't just another automation—it's your new content creation superpower. Here's how to make it yours: Switch RSS Sources**: Replace tech feeds with your niche (finance, health, etc.) Modify AI Prompts**: Adjust the content generation style to match your brand voice Change Publishing Destinations**: Swap Medium for WordPress, Ghost, or other platforms Add More Approval Steps**: Include multiple reviewers or different approval criteria Customize Image Generation**: Modify prompts for different visual styles Schedule Flexibility**: Adjust timing from 6 hours to daily, weekly, whatever fits Pro Tips: The workflow includes comprehensive error handling and logging Sticky notes provide detailed documentation for each section Modular design makes it easy to swap components Built-in duplicate prevention saves you from embarrassing reposts This template is perfect for content creators, digital marketers, tech bloggers, and anyone who wants to scale their content game without losing quality control. It's like having a full content team working 24/7, but smarter and way more consistent. Use cases that work incredibly well: Tech blog automation for agencies News aggregation and commentary sites Personal brand content scaling Client content creation workflows Multi-platform publishing systems

📝 Description: This template is designed for healthcare providers, sales reps, and medical tourism companies who need to process diagnosis emails efficiently. It automates the full flow from email to report delivery. When a new diagnosis email arrives: The email content is captured and parsed by an AI agent (Gemini or any customizable LLM). Patient and medical data is extracted into structured fields (e.g., name, phone, diagnosis). Data is logged into a Google Sheet for records. A Google Docs medical report is generated using a predefined template. The report is exported as PDF and emailed to stakeholders (e.g., managers or sales team). This template supports custom AI models, customizable Google Docs templates, and flexible filtering based on sender email. 🛠️ Features Gmail email trigger (customizable sender filter) AI-powered diagnosis parsing using Gemini (easily switchable to OpenAI or others) Google Sheets log Google Docs templated report (auto-filled) PDF export and email sending Full flexibility & customization 🔧 Requirements Before using this template, you'll need: A connected Gmail account (to receive diagnosis emails) A valid Google Sheets integration (create your own sheet with the desired columns) A Google Docs template document that includes placeholder tags like {{patient_name}}, {{date}}, etc. A Gemini or OpenAI API connection for the AI agent (fully customizable) Note: You must replace all Google Drive, Docs, and Sheets references with your own documents. This template does not grant access to the original creator's files. ⚙️ Customization Tips In the Gmail Trigger node, change the sender filter to match the doctor’s email you want to process. Modify the AI prompt if your use case needs different extracted fields. Replace the Google Docs template link with your own file and customize its structure and variables. Change recipient email addresses in the final Gmail node to notify the correct team members. Optional: Add fallback flows or error branches for when AI fails or input is malformed. 🧠 Use Case Examples Medical tourism agencies auto-generating patient reports for incoming diagnosis summaries Clinics storing structured data from messy email inputs Sales teams instantly notified of new leads with completed medical summaries

**Get Started ** Creator: @obisdev This workflow powers a fully automated WhatsApp chatbot using a self-hosted Venom Bot instead of the official WhatsApp Business API. It integrates Google Gemini AI to generate intelligent, conversational responses and optionally pulls factual information from a Google Docs-based knowledge base. Designed for small businesses and creators, the bot can maintain contextual memory across messages and act as a smart virtual assistant for sales, support, and lead generation. Overview This n8n workflow connects with a custom-hosted Venom Bot that simulates WhatsApp Web to send and receive messages. It uses a Webhook trigger to receive incoming messages, processes them with an AI Agent powered by Gemini, optionally pulls extra data from a Google Doc or Google Sheet, and sends a smart reply back through the Venom Bot. The workflow also includes a memory system to retain user context, making it capable of handling follow-up questions and dynamic conversations. Who this workflow is for Small Business Owners: Offer 24/7 customer service on WhatsApp without paying for Meta’s Business API. Freelancers & Developers: Build, test, and monetize intelligent bots without the approval process of WhatsApp’s API. Online Sellers & Creators: Handle FAQs, orders, and customer inquiries via WhatsApp on autopilot. Marketers: Deploy campaign bots that respond to DMs with personalized product suggestions or lead captures. Hackers & Builders: Experiment with unofficial APIs to control WhatsApp reliably without breaking TOS for small-scale use. Tools Used n8n: The automation platform managing flow, context, and decision logic. Venom Bot: A Node.js-based, self-hosted WhatsApp Web bot used to send/receive messages. Google Gemini: AI engine for generating context-aware replies. Google Docs (Optional): Acts as a structured knowledge base for business info or FAQs. Google Sheets (Optional): Feeds real-time or structured data into your AI responses. How to Install Import the Workflow: Download the .json and import it into your n8n instance. Set Up Venom Bot: Deploy Venom Bot (on VPS or local) and set it to send messages to your Webhook URL. Webhook Configuration: Update the Webhook node in n8n and set 'Respond' to "Using Respond to Webhook Node". Connect Google Gemini: Add your Gemini API key in n8n credentials. Set Up Google Docs (Optional): Link the document containing your knowledge base. Enable Conversational Memory: Use ={{ $("Process Message").first().json.from }} as the session ID. Check API Key Matching: Ensure the API_SECRET_KEY in Venom .env matches the authorization header in n8n. Customize Persona & Prompts: Update the AI Agent system message to fit your brand tone. Use Cases Customer service without WhatsApp Business API Smart lead generation bots E-commerce order responders AI-powered chatbot for DMs FAQ responder with knowledge base support Connect with Me Email: [email protected] Twitter/X: @obisdev GitHub: github.com/obisdev Visit: obisdev.vercel.app #n8n #whatsappautomation #venombot #chatbots #noapi #geminiapi #googleworkspace #aiassistant #nocode #vpsautomation #chatbotwithoutapi #automationtools #customerbot #salesautomation #googleintegration

Automate Legal Document Generation with n8n, Apify, Google Drive, and AI This tutorial details an end-to-end automation solution for streamlining the lien filing process for Homeowners Associations (HOAs) using an n8n workflow. It significantly reduces manual effort and potential errors for legal professionals by automating document retrieval, information extraction, and document generation. Who's it for This template is ideal for legal professionals, law firms, and property management companies that frequently handle lien filings for Homeowners Associations. If you're looking to reduce manual document processing time, minimize errors, and improve efficiency in your legal operations, this workflow is for you. The Problem Legal professionals often allocate a significant portion of their time—up to 40%—to manual document processing tasks. The traditional process for filing a lien is particularly time-consuming (e.g., 15 minutes per case) and error-prone, involving steps like manual searching, downloading, extracting, and populating legal documents. The Automation Solution Overview This automation leverages an n8n workflow in conjunction with external services like Playwright (via Apify), Google Drive, Google Sheets, Gmail, and the Gemini API. The primary objective is to automate the legal document generation process—from initial data submission to final document generation and notification. Requirements Before importing and running the n8n workflow, you need the following: n8n Instance:** A running n8n instance (self-hosted or cloud). Google Account:** With access to Google Sheets, Google Drive, and Gmail. Google Sheets:** An Input Sheet to receive form responses (e.g., "Legal Automation Input Form (Responses)"). An Output/Review Sheet for extracted data and approval (e.g., "Automation Output data Sheet") with specific columns like "Timestamp", "Legal Description", "Association Name", "Debt", "Parcel", "Owner", "Doc link", "Approval", and "Created". Google Drive:** A main folder for n8n outputs (e.g., "N8N Folder"). A Google Docs Lien Template with placeholders (e.g., {{ASSOCIATION}}, {{DEBT}}, {{PROPERTY}}, {{MONTH}}, {{YEAR}}, {{DAY}}, {{PARCEL}}, {{OWNER}}). Google Gemini API Key:** For text and image processing. Apify Account & Playwright Actor:** An Apify account with access to a Playwright actor capable of scraping property information from your target county's website. Setup Steps n8n Credentials: Add Google Sheets, Google Drive, and Gmail credentials in your n8n instance. Add an HTTP Query Auth credential for your Gemini API key (named "Query Auth account" in the template). Ensure your Apify API token is configured within the Apify Playwright script to find property info node. Google Sheets Configuration: Link the Google Sheets Trigger node to your Input Sheet. Link the Google Sheets node (for appending data) and the Intermediate data received trigger to your Output/Review Sheet. Google Drive Configuration: Update the Create folder to output node with the ID of your "N8N Folder". Update the Make Copy of Template node with the ID of your Google Docs Lien Template. Email Addresses: Update the recipient email addresses in the Approve Through Email and Notify complete nodes to your desired notification email. Detailed Tutorial Steps and n8n Workflow Breakdown Summary This n8n workflow, "Legal Document Generator E2E", automates the process of generating legal lien documents, from initial data input to final document creation and notification. Initiate Workflow: The workflow starts with a Google Sheets Trigger node, which listens for new lien requests submitted via a form that populates a Google Sheet. Gather Property Data: An Apify Playwright script to find property info node fetches property details from county websites, and a Get file for property node downloads associated legal documents. Process and Store Document: The downloaded document is transformed to base64 using Transform to base64 and then uploaded to Google Drive via Upload legal doc for storage and further processing. Extract Information with AI: Call Gemini API for legal desc and Property metadata nodes leverage the Gemini API to extract the precise legal description, parcel number, and owner's name from the document. This extracted data is then structured by the Property Information Extractor. Review and Approve: The extracted information is appended to an intermediate Google Sheet by the first Google Sheets node, and an email is sent via Approve Through Email to the user for review and approval. Generate Documents on Approval: A second Intermediate data received Google Sheets Trigger node monitors the approval status in the sheet. Once "Approved", an If node allows the workflow to proceed. Create and Populate Documents: A new client-specific folder is created in Google Drive using Create folder to output. A blank lien template is copied (Make Copy of Template), and its custom variables are populated with the extracted data using Change Custom Variables. Finalize and Store Output: The populated document is converted to PDF (Generate PDF), and both the new PDF (Add PDF To Drive) and the original source document (Move file in Google Drive) are saved to the client's new folder. Update Records and Notify: The Update Creation Google Sheets node marks the document as "Created" in the tracking sheet and updates the document link. Finally, Notify complete sends a notification email about the completion. How to Customize the Workflow Adjust Input Form Fields:** Modify the column names in your initial Google Sheet and update the expressions in the Google Sheets Trigger and Apify Playwright script to find property info nodes to match your form. Change County Website/Scraper:** If you need to fetch data from a different county or property database, you will need to modify the Apify Playwright script to find property info node to call a different Apify actor or configure a new HTTP Request node to interact with your chosen data source. Customize Document Template:** Update the placeholders in your Google Docs Lien Template to match your specific document needs. Ensure corresponding replaceAll actions are updated in the Change Custom Variables node. Modify AI Prompts:** Refine the prompts within the Call Gemini API for legal desc and Property metadata nodes to improve the accuracy of information extraction based on your document types. Notification Preferences:** Adjust the sendTo email addresses and subject/message content in the Approve Through Email and Notify complete nodes. Benefits of this Automation This automation offers significant advantages for legal professionals: Streamlined Organization:** Ensures all relevant documents—original source files, editable templates, and final PDFs—are systematically organized, tracked, and easily accessible within Google Drive. Time-Saving and Efficiency:** Documents are quickly generated and ready for client sharing, leading to faster turnaround times and improved service delivery. Scalability:** Provides a scalable solution for handling a higher volume of document processing tasks without a proportional increase in manual effort. Learn more about Chill Labs and our services on our website: Chill Labs