Workflow Templates

Process multiple invoices automatically using Mistral's dedicated OCR model—at approximately $0.002 per page. Upload batches of PDF, PNG, or JPG invoices through a simple form, extract structured financial data with AI, validate results with confidence scoring, and save everything to Google Sheets. What this workflow does Accepts multiple invoice uploads via n8n Form Trigger Processes files in batch with rate limiting Converts each file to base64 and sends to Mistral OCR API Extracts 9 standard fields using GPT-4o-mini Information Extractor Validates data and assigns confidence scores (high/medium/low) Saves all results to Google Sheets with status tracking Fields extracted Invoice Number, Date, Vendor Name, Tax ID, Subtotal, Tax Rate, Tax Amount, Total Amount, Currency Use cases Accountants processing client invoices in bulk Small businesses digitizing paper receipts Bookkeepers automating repetitive data entry Finance teams building searchable invoice databases Setup requirements Mistral API Key (console.mistral.ai) — HTTP Header Auth credential OpenAI API Key (platform.openai.com) Google Sheets OAuth connection Google Sheet with 15 columns (template in workflow notes)

📰 What This Workflow Does This intelligent news monitoring system automatically: • RSS Feed Aggregation: Pulls the latest headlines from Google News RSS feeds and Hacker News • AI Content Filtering: Identifies and prioritizes AI-related news from the past 24 hours • Smart Summarization: Uses OpenAI to create concise, informative summaries of top stories • Telegram Delivery: Sends formatted news digests directly to your Telegram channel • Scheduled Execution: Runs automatically every morning at 8:00 AM (configurable) 🎯 Key Features ✅ Multi-Source News: Combines Google News and Hacker News for comprehensive coverage ✅ AI-Powered Filtering: Automatically identifies relevant AI and technology news ✅ Intelligent Summarization: OpenAI generates clear, concise summaries with key insights ✅ Telegram Integration: Instant delivery to your preferred chat or channel ✅ Daily Automation: Scheduled to run every morning for fresh news updates ✅ Customizable Timing: Easy to adjust schedule for different time zones 🔧 How It Works Scheduled Trigger: Workflow activates daily at 8:00 AM (or your preferred time) RSS Feed Reading: Fetches latest articles from Google News and Hacker News feeds Content Filtering: Identifies AI-related stories from the past 24 hours AI Summarization: OpenAI processes and summarizes the most important stories Telegram Delivery: Sends formatted news digest to your Telegram channel 📋 Setup Requirements • OpenAI API Key: For AI-powered news summarization • Telegram Bot: Create via @BotFather and get bot token + chat ID • RSS Feed Access: Google News and Hacker News RSS feeds (public) ⚙️ Configuration Steps Set Up Telegram Bot: Message @BotFather on Telegram Create new bot with /newbot command Save bot token and chat ID Configure OpenAI: Add OpenAI API credentials in n8n Ensure access to GPT models for summarization Update RSS Feeds: Verify Google News RSS feed URLs Confirm Hacker News feed accessibility Schedule Timing: Adjust Schedule Trigger for your time zone Default: 8:00 AM daily (modify as needed) Test & Deploy: Run test execution to verify all connections Activate workflow for daily automation 🎨 Customization Options Time Zone Adjustment: Modify Schedule Trigger for different regions News Sources: Add additional RSS feeds for broader coverage Filtering Criteria: Adjust AI prompts to focus on specific topics Summary Length: Customize OpenAI prompts for different detail levels Delivery Format: Modify Telegram message formatting and structure 💡 Use Cases • AI Professionals: Stay updated on latest AI developments and industry news • Tech Teams: Monitor technology trends and competitor announcements • Researchers: Track academic and industry research developments • Content Creators: Source material for AI-focused content and newsletters • Business Leaders: Stay informed about AI market trends and opportunities

Who’s it for This template is perfect for TikTok creators, content marketers, and social media teams who want to turn viral comments into engaging short-form videos without manually scripting, recording, or editing. If you want to keep up with trends and consistently publish high-quality avatar videos, this workflow automates the entire process from comment selection to enhanced final video. What it does The workflow takes TikTok video URLs and their top comments from a Data Table, extracts the transcript using Dumpling AI, and uses GPT-4 to write a natural and engaging TikTok script inspired by the comment. It then generates a full AI avatar video through Captions.ai, enhances it with subtitles and B-roll using Submagic, and finally saves all video details into Airtable for tracking. Here’s what happens step by step: Pulls TikTok videos and their top comments from a Data Table Sends video URLs to Dumpling AI to retrieve transcripts Feeds both transcript and comment into GPT-4 to generate a conversational TikTok script Cleans and formats the script using JavaScript Sends the script to Captions.ai to produce an AI avatar video Checks video status and retries if needed Enhances the final video with Submagic for captions and effects Receives the enhanced video via webhook and logs details into Airtable How it works Schedule Trigger: Runs automatically at set intervals to start the workflow Data Table: Retrieves TikTok video URLs and associated comments Dumpling AI: Extracts transcripts from the video URLs GPT-4: Generates a compelling TikTok script based on the comment JavaScript Node: Cleans up script formatting for a smooth avatar generation Captions.ai: Creates an AI avatar video from the cleaned script Wait & Check: Monitors video creation status and retries if necessary Submagic: Enhances the video with captions, zooms, and B-roll effects Webhook & Airtable: Receives final video data and saves URL and ID for future use Requirements ✅ Dumpling AI API key stored as HTTP header credentials ✅ OpenAI GPT-4 credentials ✅ Captions.ai API credentials ✅ Submagic API credentials ✅ Airtable base with fields for Video URL and Caption Video ID ✅ A properly structured Data Table containing TikTok Keywords or video URLs How to customize Adjust the GPT-4 system prompt to shape the tone, style, or format of the TikTok script Change the avatar or creator settings in Captions.ai to match your brand personality Modify Submagic settings to control subtitle styling or B-roll effects Integrate approval steps before final video generation if needed Extend the workflow to auto-publish videos to TikTok or store them in cloud drives > This workflow lets you transform TikTok comments into engaging AI avatar videos with captions and edits, completely on autopilot. It’s a powerful way to scale content output and stay ahead of trends without manual scripting or filming.

Stop manually searching for songs and let an AI DJ do the work for you. This template provides a complete, end-to-end system that transforms any text prompt into a ready-to-play Spotify playlist. It combines the creative understanding of a powerful AI Agent with the real-time web knowledge of Linkup to curate perfect, up-to-the-minute playlists for any occasion. The experience is seamless: simply describe the vibe you're looking for in a web form, and the workflow will automatically create the playlist in your Spotify account and redirect you straight to it. Whether you need "upbeat funk for a sunny afternoon" or "moody electronic tracks for late-night coding," your personal AI DJ is ready to deliver. Who is this for? Music lovers:** Create hyper-specific playlists for any mood, activity, or niche genre without the hassle of manual searching. DJs & event planners:** Quickly generate themed playlists for parties, weddings, or corporate events based on a simple brief. Content creators:** Easily create companion playlists for your podcasts, videos, or articles to share with your audience. n8n developers:** A powerful example of how to build an AI agent that uses an external web-search tool to accomplish a creative task. What problem does this solve? Creates up-to-date playlists:** A standard AI doesn't know about music released yesterday. By using Linkup's live web search, this workflow can find and include the very latest tracks. Automates the entire creation process:** It handles everything from understanding a vague prompt (like "songs that feel like a summer road trip") to creating a fully populated Spotify playlist. Saves time and effort:** It completely eliminates the tedious task of searching for individual tracks, checking for relevance, and manually adding them to a playlist one by one. Provides a seamless user experience:** The workflow begins with a simple form and ends by automatically opening the finished playlist in your browser. There are no intermediate steps for you to manage. How it works Submit your playlist idea: You describe the playlist you want and the desired number of tracks in a simple, Spotify-themed web form. The AI DJ plans the search: An AI Agent (acting as your personal DJ) analyzes your request. It then intelligently formulates a specific query to find the best music. Web research with Linkup: The agent uses its Linkup web-search tool to find artists and tracks from across the web that perfectly match your request, returning a list of high-quality suggestions. The AI DJ curates the list: The agent reviews the search results and finalizes the tracklist and a creative name for your playlist. Build the playlist in Spotify: The workflow takes the agent's final list, creates a new public playlist in your Spotify account, then searches for each individual track to get its ID and adds them all. Instant redirection: As soon as the last track is added, the workflow automatically redirects your browser to the newly created playlist on Spotify, ready to be played. Setup Connect your accounts: You will need to add your credentials for: Spotify: In the Spotify nodes. Linkup: In the Web query to find tracks (HTTP Request Tool) node. Linkup's free plan is very generous! Your AI provider (e.g., OpenAI): In the OpenAI Chat Model node. Activate the workflow: Toggle the workflow to "Active." Use the form: Open the URL from the On form submission trigger and start creating playlists! Taking it further Change the trigger:* Instead of a form, trigger the playlist creation from a *Telegram* message, a *Discord** bot command, or even a webhook from another application. Create collaborative playlists:** Set up a workflow where multiple people can submit song ideas. You could then have a final AI step consolidate all the requests into a single, cohesive prompt to generate the ultimate group playlist. Optimize for speed:* The *Web query to find tracks** node is set to deep search mode for the highest quality results. You can change this to standard mode for faster and cheaper (but potentially less thorough) playlist creation.

🧠 AI Brainstorm Generator - Break Through Creative Blocks Instantly Transform any problem into innovative solutions using AI-powered brainstorming that combines mathematical randomness with intelligent synthesis. What This Workflow Does This workflow generates creative, actionable solutions to any problem by combining: Mersenne Twister algorithm** for high-entropy random seed generation AI-driven random word generation** to create unexpected semantic triggers Dual AI agents** that brainstorm and refine ideas into polished solutions Simply input your challenge via the chat interface, and within 2 minutes receive a professionally refined solution that combines the best elements from 5+ innovative ideas. Key Features ✨ Consistent Creativity - Works regardless of your mental state or time of day 🎲 True Randomness - MT19937 algorithm ensures no pattern repetition 🤖 Multi-Model Support - Works with OpenAI GPT-4 or Google Gemini ⚡ Fast Results - Complete solutions in under 2 minutes 🔄 Self-Cleaning - Redis data expires automatically after use Use Cases Product ideation and feature development Marketing campaign concepts Problem-solving for technical challenges Business strategy innovation Creative writing prompts Workshop facilitation Requirements Redis database (local or cloud) OpenAI API key (GPT-4) OR Google Gemini API key n8n instance (self-hosted or cloud) How It Works User inputs problem via chat trigger Mersenne Twister generates high-entropy random numbers AI generates 36+ random words as creative triggers Brainstorming Agent creates 5 innovative solutions Critic Agent synthesizes the best elements into one refined solution Perfect for teams facing innovation challenges, solo entrepreneurs seeking fresh perspectives, or anyone who needs to break through creative blocks reliably. Setup Time: ~10 minutes Difficulty: Intermediate Support: Full documentation included via sticky notes

🧾 What this workflow does This automation transforms a short text idea into a cinematic video by chaining together three powerful AI services: GPT-4.1 for scene creation, Dumpling AI’s FLUX.1 Pro model for visual generation, and KIE API (Veo 3) for cinematic video creation. The system fully automates the journey from raw concept to video output, returning the final video URL. 👤 Who is this for Content creators who want to test visual ideas quickly Agencies creating moodboards, ad scenes, or pitch visuals Solo marketers or founders without video editing skills AI automation builders creating content tools ⚙️ How to set up ✅ Requirements OpenAI GPT-4.1 API key** Dumpling AI (FLUX.1 Pro model)** API token KIE API* account with access to the *Veo 3 endpoint** Optional: Tool to store or share the final video link (e.g., Google Sheets, Slack) 🔧 Setup steps Start with a text idea Example: “A lion running through misty mountains at sunrise.” GPT-4.1 Node: Expands the idea into two parts: Cinematic Prompt: Describes the atmosphere, emotion, and camera movement. Image Prompt: A vivid single-frame visual to generate the base image. Dumpling AI Node (FLUX.1 Pro): Takes the image prompt and returns a cinematic-style image. You can customize dimensions, steps, seed, and guidance level. KIE API Node (Veo 3): Sends both the cinematic prompt and image to the Veo 3 model. The model returns a video URL (e.g., 3–6 seconds cinematic footage). Final Output: The video URL is returned by the HTTP node. You can connect this to Airtable, Slack, Telegram, or Google Sheets to log the result or share with your team. 🧠 How it works You input a text idea GPT-4.1 turns it into both a detailed cinematic prompt and a base image prompt Dumpling AI generates the image KIE API’s Veo 3 turns it into a cinematic video The final video URL is returned for download or embedding 💡 Customization Ideas Add a Telegram bot to trigger this workflow with an idea via message Route video links to a Notion database or content calendar Add a loop with rating logic to regenerate low-rated videos Use Google Drive to auto-save videos in brand folders Automate weekly video ideation for social media using a prompt list This workflow helps you turn raw imagination into cinematic motion using AI. From social content to storyboarding, you can generate compelling visuals in minutes — no design or video background needed.

🧾 What this workflow does This automation turns a Telegram voice or text message into a high-quality LinkedIn post using OpenAI’s Whisper, Dumpling AI and GPT-4, and then repurposes that same message into a content idea with visual inspiration using Dumpling AI. All outputs are saved to Airtable for review, approval, and scheduling. 👤 Who is this for Founders or creators sharing ideas while walking or multitasking Content teams turning voice memos into carousel content Personal brands posting on LinkedIn with minimal manual work Virtual assistants or SMMs handling voice-driven content tasks ⚙️ How to set up ✅ Requirements You’ll need active accounts for: Telegram Bot (via n8n’s Telegram Trigger node) OpenAI (for Whisper and GPT-4) Dumpling AI (to search Google and create Image) Airtable (to log your posts) In Airtable, create a table with the following fields: Ideas (Single line text) Context (Long text) Image URL (URL) 🔧 Setup steps Set up your Telegram bot Use BotFather to create a bot and get your token Add the bot to a private group or channel Connect all credentials in n8n Telegram Trigger (Bot Token) OpenAI (for Whisper + GPT-4) Dumpling AI (HTTP Auth) Airtable (OAuth or Personal Token) Update node parameters In the Telegram Trigger node, specify your bot and listening chat In the HTTP node for Dumpling AI, add your API key via header In Airtable nodes, map to your base and table correctly Optional prompt customization In the GPT-4 node, you can update the prompt for tone, formatting, or CTA style Optional: Adjust the Dumpling AI prompt to suit your niche (e.g., health, tech, finance). 🧠 How it works The Telegram bot receives a voice message. Whisper transcribes the voice into clean text. GPT-4 formats the text into a polished LinkedIn post. Dumpling AI: Generates a short-form content idea from the transcript. Creates a branded image prompt and renders a matching image. The full set of outputs (text, idea, image) is saved to Airtable. You can now review and schedule the post manually or via another automation. 🛠️ Customization ideas Swap Telegram for WhatsApp or voice memos via Google Drive Add moderation or approval steps before saving to Airtable Send the LinkedIn post directly to Buffer or Hootsuite for auto-posting Generate post captions or hashtags using GPT-4 before publishing Extend the workflow to auto-create carousel slides from the content idea This workflow makes it easy to share your voice with your audience — literally. Whether you're walking, thinking out loud, or sending team updates, this automation turns your spoken ideas into professional content, ready to post or polish.

Pull a Dun & Bradstreet Business Information Report (PDF) by DUNS, convert the response into a binary PDF file, extract readable text, and use OpenAI to return a clean, flat JSON with only the key fields you care about (e.g., report date, Paydex, viability score, credit limit). Includes Sticky Notes for quick setup help and guidance. ✅ What this template does Requests a D&B report* (PDF) for a specific *DUNS** via HTTP Converts* the API response into a *binary PDF file** Extracts** the text from the PDF for analysis Uses OpenAI with a Structured Output Parser to return a flat JSON Designed to be extended to Sheets, databases, or CRMs 🧩 How it works (node-by-node) Manual Trigger — Runs the workflow on demand ("When clicking 'Execute workflow'"). D&B Report (HTTP Request) — Calls the D&B Reports API for a Business Information Report (PDF). Convert to PDF File (Convert to File) — Turns the D&B response payload into a binary PDF. Extract Binary (Extract from File) — Extracts text content from the PDF. OpenAI Chat Model — Provides the language model context for the analyzer. Analyze PDF (AI Agent) — Reads the extracted text and applies strict rules for a flat JSON output. Structured Output (AI Structured Output Parser) — Enforces a schema and validates/auto-fixes the JSON shape. (Optional) Get Bearer Token (HTTP Request) — Template guidance for OAuth token retrieval (shown as disabled; included for reference if you prefer Bearer flows). 🛠️ Setup instructions (from the JSON) 1) D&B Report (HTTP Request) Auth:* Header Auth (use an n8n *HTTP Header Auth** credential) URL:** https://plus.dnb.com/v1/reports/duns/804735132?productId=birstd&inLanguage=en-US&reportFormat=PDF&orderReason=6332&tradeUp=hq&customerReference=customer%20reference%20text Headers:** Accept: application/json Credential Example:** D&B (HTTP Header Auth) > Put your Authorization: Bearer <token> header inside this credential, not directly in the node. 2) Convert to PDF File (Convert to File) Operation:** toBinary Source Property:** contents[0].contentObject > This takes the PDF content from the D&B API response and converts it to a binary file for downstream nodes. 3) Extract Binary (Extract from File) Operation:** pdf > Produces a text field with the extracted PDF content, ready for AI analysis. 4) OpenAI Model(s) OpenAI Chat Model** Model:** gpt-4o (as configured in the JSON) Credential:* Your stored *OpenAI API* credential (do *not** hardcode keys) Wiring:** Connect OpenAI Chat Model as ai_languageModel to Analyze PDF Connect another OpenAI Chat Model (also gpt-4o) as ai_languageModel to Structured Output 5) Analyze PDF (AI Agent) Prompt Type:** define Text:** ={{ $json.text }} System Message (rules):** You are a precision extractor. Read the provided business report PDF and return only a single flat JSON object with the fields below. No arrays/lists. No prose. If a value is missing, output null. Dates: YYYY-MM-DD. Numbers: plain numerics (no commas or $). Prefer most recent or highest-level overall values if multiple are shown. Never include arrays, nested structures, or text outside of the JSON object. 6) Structured Output (AI Structured Output Parser) JSON Schema Example:** { "report_date": "", "company_name": "", "duns": "", "dnb_rating_overall": "", "composite_credit_appraisal": "", "viability_score": "", "portfolio_comparison_score": "", "paydex_3mo": "", "paydex_24mo": "", "credit_limit_conservative": "" } Auto Fix:** enabled Wiring:* Connect as ai_outputParser to *Analyze PDF** 7) (Optional) Get Bearer Token (HTTP Request) — Disabled example If you prefer fetching tokens dynamically: Auth:** Basic Auth (D&B username/password) Method:** POST URL:** https://plus.dnb.com/v3/token Body Parameters:** grant_type = client_credentials Headers:** Accept: application/json Downstream usage:** Set header Authorization: Bearer {{$json["access_token"]}} in subsequent calls. > In this template, the D&B Report node uses Header Auth credential instead. Use one strategy consistently (credentials are recommended for security). 🧠 Output schema (flat JSON) The analyzer + parser return a single flat object like: { "report_date": "2024-12-31", "company_name": "Example Corp", "duns": "123456789", "dnb_rating_overall": "5A2", "composite_credit_appraisal": "Fair", "viability_score": "3", "portfolio_comparison_score": "2", "paydex_3mo": "80", "paydex_24mo": "78", "credit_limit_conservative": "25000" } 🧪 Test flow Click Execute workflow (Manual Trigger). Confirm D&B Report returns the PDF response. Check Convert to PDF File for a binary file. Verify Extract from File produces a text field. Inspect Analyze PDF → Structured Output for valid JSON. 🔐 Security notes Do not hardcode tokens in nodes; use Credentials (HTTP Header Auth or Basic Auth). Restrict who can execute the workflow if it's accessible from outside your network. Avoid storing sensitive payloads in logs; mask tokens/headers. 🧩 Customize Map the structured JSON to Google Sheets, Postgres/BigQuery, or a CRM. Extend the schema with additional fields (e.g., number of employees, HQ address) — keep it flat. Add validation (Set/IF nodes) to ensure required fields exist before writing downstream. 🩹 Troubleshooting Missing PDF text?* Ensure *Convert to File** source property is contents[0].contentObject. Unauthorized from D&B?** Refresh/verify token; confirm Header Auth credential contains Authorization: Bearer <token>. Parser errors?** Keep the agent output short and flat; the Structured Output node will auto-fix minor issues. Different DUNS/product?** Update the D&B Report URL query params (duns, productId, etc.). 🗒️ Sticky Notes (included) Overview:** "Fetch D&B Company Report (PDF) → Convert → Extract → Summarize to Structured JSON (n8n)" Setup snippets for Data Blocks (optional) and Auth flow 📬 Contact Need help customizing this (e.g., routing the PDF to Drive, mapping JSON to your CRM, or expanding the schema)? 📧 robert@ynteractive.com 🔗 https://www.linkedin.com/in/robert-breen-29429625/ 🌐 https://ynteractive.com

Introduction Automates AI-driven assignment grading with HTML and CSV output. Designed for educators evaluating submissions with consistent criteria and exportable results. How It Works Webhook receives papers, extracts text, prepares data, loads answers, AI grades submissions, generates results table, converts to HTML/CSV, returns response. Workflow Template Webhook → Extract Text → Prepare Data → Load Answer Script → AI Grade (OpenAI + Output Parser) → Generate Results Table → Convert to HTML + CSV → Format Response → Respond to Webhook Workflow Steps Input & Preparation: Webhook receives paper, extracts text, prepares data, loads answer script. AI Grading: OpenAI evaluates against answer key, Output Parser formats scores and feedback. Output & Response: Generates results table, converts to HTML/CSV, returns multi-format response. Setup Instructions Trigger & Processing: Configure webhook URL, set text extraction parameters. AI Configuration: Add OpenAI API key, customize grading prompts, define Output Parser JSON schema. Prerequisites OpenAI API key Webhook platform n8n instance Use Cases University exam grading Corporate training assessments Customization Modify rubrics and criteria Add PDF output Integrate LMS (Canvas, Blackboard) Benefits Consistent AI grading Multi-format exports Reduces grading time by 90%

Odoo CRM MCP Server Workflow 📖 Overview This workflow connects an AI Agent with Odoo CRM using the Model Context Protocol (MCP). It allows users to manage CRM data in Odoo through natural language chat commands. The assistant interprets the user’s request, selects the appropriate Odoo action, and executes it seamlessly. 🔹 Key Features Contacts Management**: Create, update, delete, and retrieve contacts. Opportunities Management**: Create, update, delete, and retrieve opportunities. Notes Management**: Create, update, delete, and retrieve notes. Conversational AI Agent**: Understands natural language and maps requests to Odoo actions. Model Used**: OpenAI Chat Model. This makes it easy for end-users to interact with Odoo CRM without needing technical commands—just plain language instructions. ▶️ Demo Video Watch the full demo here: 👉 YouTube Demo Video ⚙️ Setup Guide Follow these steps to set up and run the workflow: 1. Prerequisites An Odoo instance configured with CRM enabled. An n8n or automation platform account where MCP workflows are supported. An OpenAI API key with access to GPT models. MCP Server installed and running. 2. Import the Workflow Download the provided workflow JSON file. In your automation platform (n8n, Langflow, or other MCP-enabled tool), choose Import Workflow. Select the JSON file and confirm. 3. Configure MCP Server Go to your MCP Server Trigger node in the workflow. Configure it to connect with your Odoo instance. Set API endpoint. Provide authentication credentials (API key). Test the connection to ensure the MCP server can reach Odoo. 4. Configure the OpenAI Model Select the OpenAI Chat Model node in the workflow. Enter your OpenAI API Key. Choose the model (e.g., gpt-5 or gpt-5-mini). 5. AI Agent Setup The AI Agent node links the Chat Model, Memory, and MCP Client. Ensure the MCP Client is mapped to the correct Odoo tools (Contacts, Opportunities, Notes). The System Prompt defines assistant behavior—use the tailored system prompt provided earlier. 6. Activate and Test Turn the workflow ON (toggle Active). Open chat and type: "Create a contact named John Doe with email john@example.com." "Show me all opportunities." "Add a note to John Doe saying 'Follow-up scheduled for Friday'." Verify the results in your Odoo CRM. ✅ Next Steps Extend functionality with Tasks, Stages, Companies, and Communication Logs for a complete CRM experience. Add confirmation prompts for destructive actions (delete contact/opportunity/note). Customize the AI Agent’s system prompt for your organization’s workflows.

🟢 Manual Trigger Workflow starts manually to initiate the reconciliation process on demand. 📄 Fetch Invoices & Bank Statements Retrieves invoice data and bank statement data from Google Sheets for comparison. 🔀 Merge Data Combines both datasets into a single structured dataset for processing. 🧩 Format Payload for AI Function node prepares and structures the merged data into a clean JSON payload for AI analysis. 🤖 AI Reconciliation AI Agent analyzes the invoice and bank statement data to identify matches, discrepancies, and reconciled entries. 🧮 Parse AI Output Parses the AI response into a structured format suitable for adding back to Google Sheets. 📊 Update Sheets Adds the reconciled data and reconciliation results into the target Google Sheet for recordkeeping. 🧾 Prerequisites ✅ OpenAI API Credentials Required for the AI Reconciliation node to process and match transactions. Add your OpenAI API key in n8n → Credentials → OpenAI. ✅ Google Sheets Credentials Needed to read invoice and bank statement data and to write reconciled results. Add credentials in n8n → Credentials → Google Sheets. ✅ Google Sheets Setup The connected spreadsheet must contain the following tabs: Invoices – for invoice data Bank_Statement – for bank transaction data Reconciled_Data – for storing the AI-processed reconciliation output ✅ Tab Structure & Required Headers Invoices Sheet Columns: Invoice_ID Invoice_Date Customer_Name Amount Status Bank_Statement Sheet Columns: Transaction_ID Transaction_Date Description Debit/Credit Amount Reconciled_Data Sheet Columns: Invoice_ID Transaction_ID Matched_Status Remarks Confidence_Score ⚙️ n8n Environment Setup Ensure all nodes are connected correctly and the workflow has permission to access the required sheets. Test each fetch and write operation before running the full workflow.

🎯 Description Automatically generates, designs, stores, and logs complete Instagram carousel posts. It transforms a simple text prompt into a full post with copy, visuals, rendered images, Google Drive storage, and a record in Google Sheets. ⚙️ Use case / What it does This workflow enables creators, educators, or community managers to instantly produce polished, on-brand carousel assets for social media. It integrates OpenAI GPT-4.1, Pixabay, Templated.io, Google Drive, and Google Sheets into one continuous content-production chain. 💡 How it works 1️⃣ Form Trigger – Collects the user prompt via a simple web form. 2️⃣ OpenAI GPT-4.1 – Generates structured carousel JSON: titles, subtitles, topic, description, and visual keywords. 3️⃣ Code (Format content) – Parses the JSON output for downstream use. 4️⃣ Google Drive (Create Folder) – Creates a subfolder for the new carousel inside “RRSS”. 5️⃣ HTTP Request (Pixabay) – Searches for a relevant image using GPT’s visual suggestion. 6️⃣ Code (Get first result) – Extracts the top Pixabay result and image URL. 7️⃣ Templated.io – Fills the design template layers (titles/subtitles/topic/image). 8️⃣ HTTP Request (Download renders) – Downloads the rendered PNGs from Templated.io. 9️⃣ Google Drive (Upload) – Uploads the rendered images into the created folder. 10️⃣ Google Sheets (Save in DB) – Logs metadata (title, topic, folder link, description, timestamp, status). 🔗 Connectors used OpenAI GPT-4.1 (via n8n LangChain node) Templated.io API (design rendering) Pixabay API (stock image search) Google Drive (storage + folder management) Google Sheets (database / logging) Form Trigger (input collection) 🧱 Input / Output Input: User-submitted “Prompt” (text) via form Output: Generated carousel images stored in Google Drive Spreadsheet row in Google Sheets containing title, topic, description, Drive URL, status ⚠️ Requirements / Setup Valid credentials for: OpenAI API (GPT-4.1 access) Templated.io API key Pixabay API key Google Drive + Google Sheets OAuth connections Existing Google Drive folder ID for RRSS storage Spreadsheet with matching column headers (Created At, Title, Topic, Folder URL, Description, Status) Published form URL for user prompts 🌍 Example applications / extensions Educational themes (mental health, fitness, sustainability). Extend to auto-publish to Instagram Business via Meta API. Add Notion logging or automated email notifications. Integrate scheduling (Cron node) to batch-generate weekly carousels.