Workflow Templates

The Content Calendar Manager > n8n + Google Sheets + Groq AI + Slack Automation This workflow automates your entire content planning process—from idea backlog to AI-generated drafts and team-ready summaries. It runs weekly, fetches pending content ideas from Google Sheets, generates platform-specific content using AI (blogs, videos, social posts) and delivers a clean summary to Slack while updating statuses in your sheet. Quick Implementation Steps Connect credentials for Google Sheets, Slack and Groq API in your n8n account. Update the Google Sheet ID and Sheet Name in the "Fetch Content Backlog" node. Ensure your sheet has columns: Sr No, Topic, Type, Status, Deadline. Set your Slack Channel ID in the "Post Summary to Slack" node. Test with sample rows (Status = idea or writing). Activate the workflow. What It Does This workflow acts as a smart content operations assistant. Every week, it scans your content backlog stored in Google Sheets and identifies items that are either in the "idea" or "writing" stage. It then prioritizes them by deadline and processes them accordingly. Based on the content type (Blog, Video or Social), the workflow routes each idea into specialized AI agents powered by Groq. These agents generate structured outputs such as blog outlines, video scripts or social media briefs—each tailored to its format and purpose. Finally, all generated outputs are compiled into a single, clean Slack report for your team. At the same time, the workflow updates the original sheet to mark processed items as "writing", ensuring no duplication of effort and maintaining workflow consistency. Who It's For Content marketing teams Social media managers Digital agencies Startup founders managing content pipelines SEO and content strategists Anyone using Google Sheets to manage content ideas Requirements To use this workflow, you need: An active n8n account Google Sheets account** with API access Slack workspace** with OAuth2 setup Groq API credentials** A Google Sheet structured with: Sr No Topic Type (video, blog, social) Status (idea, writing, etc.) Deadline How It Works & Setup Guide Workflow Breakdown 1. Trigger Node:** Check for New Ideas (Weekly) Runs every week on Monday at 9 AM 2. Fetch Data Node:** Fetch Content Backlog Pulls rows where: Status = idea OR writing 3. Sort Content Node:** Order by Deadline Ensures urgent items are processed first 4. Route by Content Type Node:** Route by Format (Video/Blog/Social) Sends items to: Blog AI branch Video AI branch Social AI branch 5. AI Content Generation Blog Branch** Node: Generate Blog Outline Uses: SEO Strategist LLM Video Branch** Node: Generate Video Script Uses: Video Producer LLM Social Branch** Node: Generate Social Post Uses: Growth Expert LLM 6. Data Mapping Nodes: Map Blog Data Map Video Data Map Social Data Captures: Row ID AI Output 7. Merge Results Node: Sync Parallel Branches Combines outputs from all branches 8. Aggregate Data Node: Bundle Results into List Creates a unified dataset 9. Format Slack Report Node: Format Slack Report Layout Cleans and formats text for Slack readability 10. Send to Slack Node: Post Summary to Slack Posts a structured weekly report 11. Update Google Sheet Nodes: Unbundle Individual Rows Mark Status as Writing Updates each processed row to: Status = writing How To Customize Nodes AI Prompts** Modify prompts in: Generate Blog Outline Generate Video Script Generate Social Post Adjust tone, structure or output format Schedule** Change timing in Check for New Ideas (Weekly) Sheet Filters** Update status filters in Fetch Content Backlog Slack Message Format** Edit JavaScript in Format Slack Report Layout Content Types** Add new conditions in Route by Format for more formats Add-ons (Extend This Workflow) Auto-publish content to CMS (e.g., WordPress) Send email summaries instead of/in addition to Slack Add approval workflow before marking as "writing" Integrate with Notion or Airtable instead of Google Sheets Store generated content in a database or cloud storage Add AI rewriting or optimization steps Use Case Examples Weekly Content Planning Automation Automatically generate drafts for upcoming content ideas Agency Content Pipeline Manage multiple client content queues efficiently YouTube + Blog Strategy Generate scripts and blog outlines simultaneously Social Media Campaign Prep Create ready-to-post social content ideas weekly SEO Content Scaling Quickly generate structured blog outlines at scale There can be many more use cases depending on how you customize and extend this workflow. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No data fetched | Incorrect sheet ID or filters | Verify Google Sheet ID and filter values | | Workflow runs but no output | No rows match "idea" or "writing" | Check Status column values | | AI output is empty | Groq API issue | Validate API credentials and model | | Slack message not sent | Incorrect channel ID or auth issue | Recheck Slack OAuth2 and channel ID | | Sheet not updating | Mapping mismatch | Ensure Sr No matches correctly | | Duplicate processing | Status not updated | Confirm "Mark Status as Writing" node | Need Help? If you need assistance setting up this workflow, customizing prompts or extending it with advanced features, our n8n workflow development team at WeblineIndia is here to help. We can help you: Customize this workflow for your business Integrate with your existing tools Build advanced AI-powered automations Scale your content operations efficiently Reach out to WeblineIndia for expert support and tailored automation solutions.

How it works Runs on schedule (Monday-Friday at 9 AM) to automate lead generation Searches for companies on Google Maps by location and category Extracts owner information from company websites and impressum pages Enriches leads with email addresses and LinkedIn profiles using Lemlist Generates personalized compliment messages using Claude AI Creates custom video messages with Pitchlane Uploads qualified leads to your CRM for follow-up Set up steps Configure Google Maps search parameters (location, category, search terms) Add Serper API credentials for Google Maps search Connect Lemlist for lead enrichment and upload Configure Pitchlane API credentials for video creation Set up Google Docs for documentation and notes Connect Claude AI for personalized message generation Adjust the schedule trigger time if you want a different time than 9 AM Keep detailed workflow notes in the sticky notes inside your workflow

Who’s it for This workflow is ideal for: Content creators producing daily historical or educational videos YouTube automation enthusiasts building AI-driven channels Educators sharing engaging historical facts in short-form video format Anyone creating an automated AI video pipeline with human approval How it works This workflow automates the full pipeline of generating and publishing historical videos: Triggers daily at 1 AM and initializes retry tracking (maximum 3 attempts) Fetches historical events for the current date and selects one randomly Uses Google Gemini to generate a cinematic text-to-video script Sends the prompt to fal.ai (Hunyuan LoRA) to generate a short video Polls the generation status every 30 seconds until the video is ready Downloads the generated video and sends it to Telegram with context Waits for manual approval via Telegram If approved → uploads the video to YouTube and sends a confirmation message If declined → retries with a new event (up to 3 attempts total) How to set up Import the workflow into n8n Configure your Telegram credentials Set your Telegram Chat ID using a variable or Set node (avoid hardcoding) Configure HTTP Header Auth credentials for fal.ai (API key required) Set up Google Gemini API credentials Connect your YouTube account using OAuth2 (Optional) Adjust the schedule time in the trigger node Activate the workflow Requirements n8n (cloud or self-hosted) fal.ai account and API key (for video generation) Google Gemini API access YouTube account with upload permissions Telegram account for approval notifications How to customize the workflow Adjust retry limits in the retry logic node Modify video parameters (resolution, frames, aspect ratio) in the fal.ai request Change the script style by editing the Gemini prompt Replace the historical events API with another content source Customize Telegram messages or approval flow

What this workflow does This workflow automatically generates and publishes Instagram content using AI. It: Generates content ideas using AI Creates images automatically Edits images (resize/format) Publishes directly to Instagram How it works Trigger starts the workflow (manual or scheduled) AI generates a content idea and prompt Image is generated via API Image is processed and formatted Post is published automatically Setup Connect your OpenAI (or AI provider) credentials Add your image generation API key Connect your Instagram account (Optional) Connect Google Drive for storage Setup time: 15–20 minutes

Who's it for Marketing teams, content creators, and agencies managing Webflow CMS sites who need to optimize SEO metadata at scale. How it works The workflow fetches CMS items from Webflow, then uses AI to rewrite titles and descriptions to meet SEO best practices (50-60 character titles, 120-155 character meta descriptions). It automatically publishes changes back to Webflow and logs all updates to Google Sheets for audit purposes. Requirements Webflow site with CMS collections MCP Webflow OAuth2 credentials Any LLM api Google Sheets for logging (optional) How to set up Get your collection ID: In Webflow, go to your CMS collection → copy the collection ID Update Set Fields node: Replace collectionId with yours Update Format for Update node: Replace collectionId Match field names: If your collection uses different fields than "name" and "project-summary", update the agent prompt and Format for Update code Test first: Set batch size to 1 and run on a single item Scale up: Increase batch size gradually How to customize Change character limits: Adjust minTitleLength, maxTitleLength, minSummaryLength, maxSummaryLength in Set Fields node. Add more fields like alt-text, post body, slug, etc. Different field names: Update agent system prompt, Structured Output Parser schema, and Format for Update code

Who this is for Anybody using Firefly III, especially home/self-hosted users, who want to add some level of automation to their transaction tracking, either in addition to or because they can't or don't want to use the dataimporter How it works - posting transactions User sends a transaction screenshot/image or statement to a Telegram bot Gemini analyzes it based on the user's requirements (asset account IDs & categories) The transaction information is parsed to create a suitable POST to a Firefly instance The transaction(s) are posted to Firefly via its API, using an OAuth2 credential How it works - requesting budget reports User sends the word 'Report' via telegram A 'GET' API request is sent to Firefly for all budgets between the beginning of the month and the request date, including remaining amounts for each This is converted to a CSV file The CSV is sent to the user via Telegram Prerequisites Telegram, and knowledge of how to set up a bot (search for BotFather in Telegram) An existing instance of Firefly III with admin access for creating OAuth2 credentials How to set it up - Credentials Open Telegram, and search for BotFather Create a new bot by following the instructions Save the API key provided In n8n, create a new Telegram credential using the info for the new bot Create an OAuth client in Firefly, using the redirect URL found in n8n's OAuth2 API credential creator Fill the n8n OAuth2 API credential form as Authorization Code, filling in the remaining parameters from the info created in Firefly Create a Gemini credential following the instructions in n8n How to set it up - the workflow Set the credential in each Telegram node Set the Firefly credential in each http node Set the correct base URL for the Firefly instance in each http node Set the desired Gemini credential and model in each AI node Set the correct Bank IDs (as per Firefly) and preferred categories in the AI node system message Customization options The user can specify all types of asset and expense accounts, as well as a specific list of categories and descriptions for Gemini to use. Gemini can also be swapped out for any other AI/LLM. Additionally, anyone can build on this by reviewing the Firefly API documents to automate almost any other part of the Firefly software.

Automate Water Bill Calculations with Telegram, Gemini AI, and Google Sheets This workflow automates the calculation of monthly water bills. Residents can send a photo of their water meter along with their name via Telegram. The workflow uses Gemini AI to extract the meter reading, calculates the usage difference compared to the previous month, and updates a Google Sheet with the billing details. Finally, the workflow sends a summary back via Telegram. Don’t hesitate to reach out if you have any questions or run into issues! 🙌 Requirements A Telegram bot token (created via BotFather). A Google account with access to Google Sheets. A Gemini API key (). A pre-created Google Sheet with the required columns. Google Sheet Setup Create a new Google Sheet with the following columns: Nama, Volume Sebelumnya, Volume Saat Ini, Harga/m³, Jumlah Bayar, Beban, Total Bayar, Tanggal Input Workflow Setup Instructions Connect Google Sheets Add your Google Sheets credentials in n8n. Link the workflow to your sheet with the structure above. Set Up Telegram Bot Create a Telegram bot via BotFather. Copy your bot token into the Telegram Trigger node. Configure Gemini AI Obtain a Gemini API key from Google AI Studio. Add it to your n8n credentials. The workflow will parse the meter reading from the uploaded image. Example Calculation Previous Volume: 535 m³ Current Volume: 545 m³ Usage: 10 m³ Price per m³: Rp3.000 Fixed cost: Rp3.000 Total Bill: Rp33.000 How It Works User sends a photo of the water meter with caption (name). Telegram Trigger receives the message. Gemini AI reads the meter number from the photo. Workflow fetches previous volume from Google Sheets. Usage and total bill are calculated. Data is stored back into Google Sheets. Bot replies in Telegram with detailed bill info. Customization Change Harga/m³ in the sheet to match your community’s water price. Update Beban if your community uses a different fixed fee. Edit the Telegram reply message node to adjust wording. With this workflow, you can streamline water billing for residents, ensure accuracy, and save time on manual calculations.

What this workflow does This workflow builds a Retrieval-Augmented Generation (RAG) document chat assistant inside n8n using Supabase Vector Store and AI models. The workflow allows users to upload documents, convert them into embeddings, store them inside Supabase pgvector, and query them through an AI chat interface using semantic search. When a user sends a question through the webhook endpoint, the workflow retrieves the most relevant document chunks from Supabase and uses an AI model to generate a grounded response based on the uploaded documents. This template includes: Document ingestion pipeline Recursive text chunking AI embeddings generation Supabase vector storage Semantic retrieval AI-powered document question answering Webhook API integration for frontend apps How it works The workflow is split into two main parts: Document ingestion pipeline Downloads documents from Google Drive Extracts text from PDFs Splits text into smaller chunks Generates embeddings using AI models Stores embeddings inside Supabase pgvector RAG chat pipeline Receives user questions through a webhook Searches Supabase vector database for relevant content Retrieves matching document chunks Sends retrieved context to the AI model Returns grounded responses back to the frontend Requirements n8n instance Supabase account with pgvector enabled Google Drive account AI provider credentials (OpenRouter, Gemini, or OpenAI) Setup Create a Supabase project and enable pgvector Create the required documents table and match_documents function Connect your Supabase credentials in n8n Connect your AI model credentials Add your Google Drive credentials Upload your documents and run the ingestion workflow Use the webhook endpoint to connect your frontend application Setup typically takes around 15–30 minutes. How to customize You can customize this workflow by: Switching AI providers (Gemini, OpenRouter, OpenAI) Adjusting chunk size and retrieval count Connecting your own frontend UI Adding support for multiple document sources Expanding the workflow into a multi-user knowledge assistant This workflow is designed as a practical starting point for building AI-powered document assistants and RAG applications inside n8n.

Transform your Telegram channel or group into a fully functional, automated e-commerce storefront. This n8n workflow template allows you to sell both physical and digital products directly within Telegram, utilizing Flutterwave for secure checkout and Google Sheets as a lightweight, free database for inventory and order management. Say goodbye to complex website builders and monthly subscription fees. With this serverless setup, you can launch a store in minutes and manage everything from a simple spreadsheet. ✨ Key Features 🛒 Interactive Shopping Cart: Users can browse products, select quantities, and manage their cart entirely through seamless Telegram inline buttons. 💳 Secure Payments: Direct integration with the Flutterwave API generates unique, secure checkout links for every order. 📦 Smart Fulfillment: Automatically detects if an order is digital or physical. Digital goods (e.g., PDFs, E-books via Google Drive) are delivered instantly upon payment confirmation. Physical orders are marked as “Paid” and queued for shipping. 📊 Free Database (Google Sheets): No SQL required! Manage your product catalog, track active user sessions, and view order history entirely within Google Sheets. 🔍 Order Tracking System: Customers can use the /orders command or search by their unique ORD- ID to view their purchase history, resume pending payments, or track shipped items. ⚙️ Built-in Validation: Includes robust data validation for email addresses (catching common typos like .con) and physical delivery addresses. 🛠 Prerequisites To run this template, you will need the following accounts: Telegram: A free Telegram Bot Token (obtained via BotFather). Flutterwave: A Flutterwave account to receive payments (you will need your Secret Key and hash/Encryption Key). Google Workspace: A Google account to host the Google Sheets database and Google Drive (if selling digital files). 📝 Setup Instructions Database Setup Create a new Google Sheet (Template; https://docs.google.com/spreadsheets/d/1x58FYmsdo2K2dKNm81LgCSrGvHwhenkJTtjDIxc8-2w/edit?gid=187299608#gid=187299608 with three tabs: Products, Orders, and Session. Products Tab Headers: id, name, price, type (physical/digital), stock, description, file_url (optional, for digital goods). Orders Tab Headers: order_id, reference, user_id, email, address, items_json, total, status, payment_link, tracking, created_at. Session Tab Headers: user_id, chat_id, state, cart_json, selected_product_id, selected_product_name, selected_product_price, selected_product_type, input_quantity, input_email, input_address. n8n Node Configuration Import this template into your n8n workspace. Update the Google Sheets credentials and replace the Document ID in all sheet nodes with your specific spreadsheet ID. Add your Telegram Bot Token via n8n’s credential manager to activate the Telegram Trigger and messaging nodes. Locate the nodes containing the YOUR_FLUTTERWAVE_SECRET_KEY placeholder (e.g., Flutterwave Init Transaction) and insert your actual Flutterwave Secret Key. Webhook Activation Double-click the Flutterwave Webhook node. Copy the “Production URL” provided by n8n. Log into your Flutterwave Dashboard, navigate to Settings > Webhooks, and paste the URL. This ensures your bot receives real-time payment confirmations. 💡 Use Cases Digital Creators: Sell e-books, courses, templates, or software directly to your Telegram audience with instant file delivery. Local Businesses: Automate orders for physical goods, food delivery, or merchandise without needing a dedicated website. Dropshipping: Seamlessly collect orders and addresses before forwarding them to suppliers. 🔗 Apps Integrated Telegram Flutterwave Google Sheets Google Drive (Optional) You can also test the workflow live on Telegram: @flutterwave_sell_bot or http://t.me/flutterwave_sell_bot) 👋 Need help or want to customize this workflow? 📺 Contact: Fiverr 📩 Consultation: Book Apoointment

This workflow is a complete AI-powered customer support automation for e-commerce businesses. The system allows customers to interact with an AI assistant directly through WhatsApp. This chatbot can: Answer customer questions in real time Retrieve order information from WooCommerce Search products and provide recommendations Access company policies and FAQs using RAG (Retrieval-Augmented Generation) Escalate conversations to human support when necessary Maintain conversation memory for contextual interactions Apply AI guardrails for safer conversations Key Advantages 1. ✅ Fully Automated Customer Support The workflow dramatically reduces manual customer support workload by automating: FAQs Order tracking Product inquiries Return policy questions Technical troubleshooting This enables 24/7 support availability without human intervention. 2. ✅ Native WhatsApp Integration Using Whapi, customers can communicate through WhatsApp — one of the most widely used messaging platforms globally. 3. ✅ AI-Powered Product Assistance The assistant can: Search products in WooCommerce Compare items Recommend products Check stock availability Provide real-time pricing This transforms the chatbot into an intelligent sales assistant, increasing conversion opportunities. 4. ✅ RAG Knowledge Base with Qdrant The workflow uses Retrieval-Augmented Generation (RAG) powered by Qdrant vector search. 5. ✅ Human Escalation System When the AI cannot solve an issue, the workflow automatically escalates the conversation to human support via Gmail. 6. ✅ Multi-Model AI Architecture The workflow combines: Google Gemini for conversational reasoning OpenAI embeddings for semantic retrieval 7. ✅ Persistent Conversation Memory The Window Buffer Memory node maintains contextual conversations. 8. ✅ Built-In Guardrails & Security The workflow includes AI Guardrails to: Filter inappropriate content Block unsafe requests Prevent policy violations Improve AI reliability This is essential for production-ready AI assistants. 9. ✅Real-Time WooCommerce Integration The chatbot interacts directly with WooCommerce APIs to: Retrieve customer profiles Access order history Check shipment status Query products This provides live data instead of static responses. 10. ✅ Modular & Scalable Architecture The workflow is highly modular: Easily customizable Extendable with new tools Compatible with additional APIs Scalable for large e-commerce operations New AI tools or integrations can be added without redesigning the entire system. Ideal Use Cases This workflow is ideal for: E-commerce stores Fashion brands Electronics retailers Customer support automation AI sales assistants WhatsApp commerce Technical support automation Multilingual support systems This workflow represents a production-ready AI customer support system capable of combining conversational AI, semantic search, real-time e-commerce operations, and human escalation into a single automated pipeline. How it works WhatsApp message reception The workflow starts when a WhatsApp message is received via the Get WhatsApp webhook (Whapi). It checks if the message is of type text — if not, it replies with a message saying only text is supported. Guardrails & policy check The message passes through a Guardrails node that filters inappropriate content or policy violations. If the message violates policies, a rejection reply is sent. Customer support AI Agent The message is passed to an AI Agent (powered by Google Gemini or OpenAI). The agent has access to: Memory (Window Buffer Memory) to keep conversation context. Tools for: Retrieving company knowledge via rag_search (from Qdrant). Fetching WooCommerce orders, products, and customers. Performing calculations. Escalating to human support via Gmail. The agent follows a detailed system prompt covering product info, order assistance, technical support, and escalation logic. Response normalization & sending The agent's raw output is cleaned (newlines/tabs escaped) via a Code node. The cleaned response is sent back to the customer via Whapi (Send WhatsApp). Knowledge base vectorization (separate flow) A separate part of the workflow (triggered manually) loads documents from Google Drive, splits them into chunks, generates embeddings via OpenAI, and stores them in Qdrant for semantic search. Set up steps Configure external services & credentials Whapi: Sign up (FREE TRIAL available), get API credentials, and set the webhook URL in Whapi settings to point to your n8n webhook. OpenAI: Create an API key for embeddings and chat model (or use Google Gemini). Qdrant: Set up a Qdrant instance (e.g., on Hetzner) and create API credentials. Google Drive: Authenticate to access document folders. WooCommerce: Generate API keys for order/product/customer retrieval. Gmail: Authenticate for human support escalation. Create Qdrant collection Run the Create collection HTTP request node (update QDRANTURL and COLLECTION name). Upload & vectorize documents Place your knowledge base files (PDFs, text, Google Docs) in a Google Drive folder. Set the folder ID in the Get folder node. Run the manual trigger to load, split, embed, and store documents into Qdrant. Configure the AI Agent Set the system prompt (already provided in the E-Commerce Customer Support AI Agent node). Choose the language model (Gemini or OpenAI) and connect credentials. Ensure all tools (rag_search, WooCommerce nodes, calculator, Gmail) are enabled and properly connected. Set webhook & activate workflow Copy the webhook URL from the Get WhatsApp node. Paste it into your Whapi dashboard as the incoming message webhook. Toggle the workflow to active. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

🚀 Overview Transform your Telegram channel or group into a fully functional, automated e-commerce storefront. This n8n workflow template allows you to sell both physical and digital products directly within Telegram, utilizing Paystack for secure checkout and Google Sheets as a lightweight, free database for inventory and order management. Say goodbye to complex website builders and monthly subscription fees. With this serverless setup, you can launch a store in minutes and manage everything from a simple spreadsheet. ✨ Key Features 🛒 Interactive Shopping Cart:** Users can browse products, select quantities, and manage their cart entirely through seamless Telegram inline buttons. 💳 Secure Payments:** Direct integration with the Paystack API generates unique, secure checkout links for every order. 📦 Smart Fulfillment:** Automatically detects if an order is digital or physical. Digital goods (e.g., PDFs, E-books via Google Drive) are delivered instantly upon payment confirmation. Physical orders are marked as "Paid" and queued for shipping. 📊 Free Database (Google Sheets):** No SQL required! Manage your product catalog, track active user sessions, and view order history entirely within Google Sheets. 🔍 Order Tracking System:** Customers can use the /orders command or search by their unique ORD- ID to view their purchase history, resume pending payments, or track shipped items. ⚙️ Built-in Validation:** Includes robust data validation for email addresses (catching common typos like .con) and physical delivery addresses. 🛠 Prerequisites To run this template, you will need the following accounts: Telegram: A free Telegram Bot Token (obtained via BotFather). Paystack: A Paystack account to receive payments (you will need your Secret Key). Google Workspace: A Google account to host the Google Sheets database and Google Drive (if selling digital files). 📝 Setup Instructions 1. Database Setup Create a new Google Sheet (Template; https://docs.google.com/spreadsheets/d/1x58FYmsdo2K2dKNm81LgCSrGvHwhenkJTtjDIxc8-2w/edit?gid=187299608#gid=187299608 with three tabs: Products, Orders, and Session. Products Tab Headers: id, name, price, type (physical/digital), stock, description, file_url (optional, for digital goods). Orders Tab Headers: order_id, reference, user_id, email, address, items_json, total, status, payment_link, tracking, created_at. Session Tab Headers: user_id, chat_id, state, cart_json, selected_product_id, selected_product_name, selected_product_price, selected_product_type, input_quantity, input_email, input_address. 2. n8n Node Configuration Import this template into your n8n workspace. Update the Google Sheets credentials and replace the Document ID in all sheet nodes with your specific spreadsheet ID. Add your Telegram Bot Token via n8n's credential manager to activate the Telegram Trigger and messaging nodes. Locate the nodes containing the YOUR_PAYSTACK_SECRET_KEY placeholder (e.g., Paystack Init Transaction) and insert your actual Paystack Secret Key. 3. Webhook Activation Double-click the Paystack Webhook node. Copy the "Production URL" provided by n8n. Log into your Paystack Dashboard, navigate to Settings > Webhooks, and paste the URL. This ensures your bot receives real-time payment confirmations. 💡 Use Cases Digital Creators:** Sell e-books, courses, templates, or software directly to your Telegram audience with instant file delivery. Local Businesses:** Automate orders for physical goods, food delivery, or merchandise without needing a dedicated website. Dropshipping:** Seamlessly collect orders and addresses before forwarding them to suppliers. 🔗 Apps Integrated Telegram Paystack Google Sheets Google Drive (Optional) You can also test the workflow live on Telegram: @sellvia_paystack_bot or https://t.me/sellvia_paystack_bot) 👋 Need help or want to customize this workflow? 📺 Contact: Fiverr 📩 Consultation: Book Appointment

Stop manually copy-pasting client data into Word templates. This workflow automates the entire invoicing process, handling complex line items, VAT calculations, PDF generation, and CRM syncing in under 20 seconds. It is designed to solve the "Admin Trap" by connecting your database (Airtable) to your document generator (Google Drive/Docs) via a Webhook trigger. ⚡ What this workflow does Receives Data: Listens for a Webhook (compatible with frontends like Lovable, Softr, or standard forms) containing the Client ID and a list of Services. Splits Line Items: Uses a "Split In Batches" logic to iterate through multiple services/products, ensuring every line item is recorded individually. Database Sync: Creates a parent "Invoice" record and links child "Service" records in Airtable. Generates PDF: Populates a Google Doc/Sheet template with dynamic client data and service rows, then exports it as a PDF. Files & Links: Uploads the PDF to a designated Google Drive folder and attaches the file URL back to the specific Invoice record in Airtable. 🛠 Setup Requirements 1. Airtable Base Structure You need three linked tables to make this work: Clients: Stores Address, VAT Number, and Email. Invoices: The master record containing Date, Total Amount, and the Invoice PDF attachment field. Services: Stores individual line items (Value, Units, VAT Amount) linked to the Invoices table. 2. Google Drive Template Create a Google Doc or Sheet. Use {{variable_name}} placeholders for Client Name, Address, and Invoice ID. Ensure you have a section for line items that matches the automation loop. 💡 Use Case Perfect for freelancers, agencies, and founders who want to trigger invoices from a dashboard or dropdown menu without manually calculating VAT or typing out addresses. 👋 Need help building this? Want to automate & scale your business? I help founders automate their "boring work" so they can focus on sales. https://www.linkedin.com/in/sergiomedinah/ https://sergio-medina.com/