Airtable and Google Drive integration

Auto-Generate Long Videos with AI, ElevenLabs,PIAPI,Shotstack/Creatomate & Post to Youtube Overview This n8n automation workflow automates the creation, scripting, production, and posting of YouTube videos. It leverages AI (OpenAI), image generation (PIAPI), video rendering (Shotstack), and platform integrations (Airtable, Google Sheets, YouTube) to streamline the process. Target Audience Content creators, video producers, and YouTubers** seeking to automate video content creation. Digital marketing teams** managing video campaigns for travel or history niches. Users familiar with n8n, Airtable, Google Sheets, YouTube, and API integrations**. Problem Solved Manually managing YouTube video production, from ideation to posting, is time-consuming and prone to errors. This workflow addresses: Content Sourcing**: Generates video ideas using AI based on "domain of choice". Content Formatting**: Automatically creates detailed scripts and scene structures. Visual Production**: Produces high-quality images and renders videos with minimal manual input. Multi-Platform Integration**: Publishes to YouTube with status tracking in Airtable and Google Sheets. Status Tracking**: Monitors progress (Generated, Scripted, Produced, Published) across platforms. Prerequisites Before setting up, ensure you have: An n8n instance (self-hosted or cloud) API credentials for: OpenAI (for idea generation) PIAPI.ai (for image and video generation) ElevenLabs (for audio generation) Shotstack (for video rendering) Creatomate (for video rendering) Airtable & Google Sheets and Drive (for storage and tracking) Gmail (for notifications) YouTube API (for posting to YouTube) How the Automation Works (Step by Step) Trigger (Schedule Trigger) Initiates the workflow daily Connects to "Generate Idea" Generate Idea Uses OpenAI to create a unique 4-minute video idea with a title, description, keywords, scene structure, and intrigue note Checks Airtable "Ideas" table via searchAirtable to avoid duplicates Connects to "Parse Ideas" Parse Ideas Extracts title, description, and notes from the OpenAI output using JavaScript Connects to "Add Ideas" Add Ideas Stores the initial idea in Google Sheets "Ideas" sheet with fields like "Idea", "Description", and "Progress" (set to "Generated") Connects to "Store in Airtable" Store in Airtable Saves the idea to Airtable "Ideas" table with mapped fields and typecast enabled Connects to "Generate Script" Generate Script Creates a 500-600 word script with 8-10 scenes using OpenAI, based on the latest "Generated" idea Uses Structured Output Parser to format output Connects to "Parse Script Output" Parse Script Output Formats the script into readable text and JSON, extracting scenes and closing question Connects to "Store Script" Store Script Saves the script to Google Sheets "Production" sheet with "Script", "Scenes", and "Status" (set to "Scripted") Connects to "Store Script in Airtable" Store Script in Airtable Saves the script to Airtable "Production" table with mapped fields and typecast enabled Connects to "Updated Idea to Scripted" Updated Idea to Scripted Updates the idea status to "Scripted" in Google Sheets "Ideas" sheet Connects to "Update Status Ideas Table" Update Status Ideas Table Updates the idea status to "Scripted" in Airtable "Ideas" table, matching by "Idea ID" Connects to "Extract Scenes" Extract Scenes Parses scene data from Airtable "Production" table for image generation Connects to "Text-to-Image" Text-to-Image Generates images for each scene using PIAPI Connects to "Wait for 4 Min" Wait for 4 Min Waits 3 minutes to allow image generation to complete Connects to "Get Images" Trigger (Schedule Trigger1) Initiates the posting process daily Connects to "Search for Latest Ready Video" Search for Latest Ready Video Searches Airtable "Production" table for the latest video with "Status" = "Ready" Connects to "If Ready?" If Ready? Checks if a video is ready (condition: Status contains Ready) If true, connects to "Download Video" and "Update Production Table" Download Video Downloads the video file using the VideoURL from Airtable Connects to "Post YouTube" Post YouTube Uploads the video to YouTube with title and description, using YouTube OAuth2 Update Production Table Updates the "Production" sheet in Google Sheets, setting "Status" to "Published" and matching by "Production ID" Additional Nodes and Processes OpenAI Chat Model**: Powers "Generate Idea" and "Generate Script" with GPT Structured Output Parser**: Ensures proper JSON output for scripts Get Images**: Retrieves generated images Extract Narration**: Prepares narration for voice generation Voice Generation**: Generates voiceovers Generate Music Prompt**: Creates music prompts using OpenAI Text-to-Music**: Generates music Build Shotstack Timeline**: Constructs video timeline ShotStack Render Video**: Renders the final video Poll Rendered Videos**: Checks video rendering status Final Video**: Updates Airtable "Production" with final video details Final Video Update**: Updates Google Sheets "Production" with video URL Music Urls**: Adds music URLs to the process Setup Requirements Before starting, ensure you have the following 1 n8n Instance A self-hosted or cloud-based n8n instance to run the workflow 2 API Credentials OpenAI: API key Airtable: Personal Access Token (e.g, "Airtable Personal Access Token Google Sheets: OAuth2 credentials PIAPI: HTTP Header Auth key YouTube: OAuth2 credentials 3 Airtable Configuration Base: "Youtube Videos" Tables: "Ideas" "Production" Share with the Airtable token 4 Google Sheets Configuration Document: "Youtube Videos" Sheets: "Ideas" "Production" Share with the Google Sheets credential email Shotstack Configuration (Assumed) API key and endpoint for video rendering (not specified in JSON) Setup Instructions Import the Workflow Import the provided JSON file into your n8n instance Configure Credentials Add OpenAI, Airtable, Google Sheets, PIAPI, and YouTube credentials in n8n’s credential manager Set Up Airtable Create or update the "Ideas" and "Production" tables with the specified fields Ensure proper permissions with the Airtable token Configure Google Sheets Create or update the "Ideas" and "Production" sheets with the specified columns Share the document with the Google Sheets credential email Schedule Triggers Set "Schedule Trigger" to trigger Test the Workflow Run manually to verify each node’s functionality Check Airtable, Google Sheets, and YouTube for updates Ensure PIAPI image generation completes (wait 4 minutes) Monitor and Adjust Monitor API rate limits (e.g, PIAPI, YouTube) Adjust wait times if image or video generation delays occur Verify connections for unlinked nodes Benefits Efficiency**: Automates the entire process from idea to posting Scalability**: Handles daily video production Quality**: Ensures cinematic scripts and visuals Tracking**: Provides detailed progress monitoring Notes Rate Limits**: Be aware of PIAPI (150,000 units per task) and YouTube API limits Timing**: Adjust wait nodes (e.g, "Wait for 4 Min") based on API response times Conclusion and Suggestions to Improve the Automation Conclusion This workflow streamlines YouTube video production, making it ideal for busy content creators, video producers, and marketing teams. Customize it by adding more platforms, adjusting wait delays for image/video generation, or enhancing notifications for status updates. Share your feedback in the n8n community to help others benefit from this automation. Suggestions to Improve Customization**: Adjust prompts, timings, and API parameters based on your needs Expand "Text-to-Music**" with multiple music styles or integrate a royalty-free music API for variety. Improve Video Rendering**: Optimize "Build Shotstack Timeline" and "ShotStack Render Video" with predefined templates to reduce rendering time. Add Analytics Tracking**: Include a node to fetch YouTube Analytics post-upload for performance monitoring. Error Handling**: Add error-catching nodes (e.g., "If" nodes) to retry failed image or video generations. Notification System**: Incorporate email or Slack notifications for key milestones (e.g., script completion, video upload).

📝 POSTIZ MEDIA UPLOAD WORKFLOW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 PURPOSE: Automated media upload pipeline that downloads videos and images from Google Drive and uploads them to Postiz storage for social media posting. 🔄 WORKFLOW PROCESS: Webhook triggers the workflow Fetch media metadata from Airtable Download video + image from Google Drive Upload both files to Postiz storage Save Postiz file paths back to Airtable 🔧 TECHNICAL DETAILS: • API: Postiz /upload endpoint (multipart-form-data) • Storage: Converts Google Drive files → Postiz URLs • Integration: Updates Airtable with Postiz paths • Required: All media must be uploaded before posting 📱 SOCIAL MEDIA POSTING WORKFLOW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 PURPOSE: Automated multi-platform social media posting using Postiz API. Distributes content across Instagram, Twitter/X (2 accounts), LinkedIn, and Facebook with platform-specific content cleaning and formatting. 🔄 COMPLETE WORKFLOW PROCESS: 📊 Fetch social media content from Airtable database 🔗 Get integration IDs for all connected social platforms 🔀 Route each platform to appropriate content processor 🧹 Clean content to prevent JSON formatting errors 📱 Post to respective social media platforms simultaneously 📋 PLATFORM COVERAGE: • 📸 Instagram (Visual content + captions) • 🐦 Twitter/X Main Account (Text + images) • 🐦 Twitter/X Alt Account (Duplicate posting) • 💼 LinkedIn (Professional content) • 📘 Facebook (Meta ecosystem posting) ⚠️ CRITICAL CONTENT CLEANING: • Removes line breaks (\n), carriage returns (\r), tabs (\t) • Replaces multiple spaces with single spaces • Prevents 'JSON parameter needs to be valid JSON' errors • ESSENTIAL: Without cleaning, all API calls fail! 🔧 TECHNICAL SPECIFICATIONS: • API: Postiz /posts endpoint (POST) • Authentication: HTTP Header Auth • Content-Type: application/json • Posting Type: Immediate ('now') + 1 minute delay • Media: References pre-uploaded Postiz image paths • Rate Limit: 30 requests/hour (API beta limitation) 🔗 DATA SOURCES: • Content: Airtable • Media: Pre-uploaded via separate media upload workflow • Fields: instagram_caption, linkedin_post, twitter single, faceboook • Images: References 'postiz image' field paths ⚡ EXECUTION FLOW: Airtable → Integrations → Platform Router → Content Cleaners → Social Publishers 🚨 TROUBLESHOOTING: • JSON Errors: Check content cleaning nodes • 500 Errors: Verify integration IDs and account connections • Missing Media: Ensure media upload workflow ran first • Rate Limits: Space out executions (30/hour limit) 🔄 DEPENDENCIES: • Requires: Media upload workflow (for image/video paths) • Connects to: Analytics and monitoring workflows • Updates: Airtable with posting status and URLs ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⚠️ CRITICAL NOTES: • Cannot use external URLs in Postiz posts • Files must be uploaded to google drive first - id referenced in airtable • Enables reference tracking for all platforms 📊 DATA FLOW: Google Drive → Download → Postiz Upload → Airtable Update 🔗 CONNECTS TO: Main social media posting workflows that reference these uploaded file paths for Instagram, Twitter, LinkedIn, Facebook, and YouTube posting. 🎬 VIDEO POSTING WORKFLOW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 PURPOSE: Automated video content distribution across Instagram, Facebook, and YouTube using Postiz API. Specialized workflow for video content with platform-specific processing and cleaning. 🔄 WORKFLOW EXECUTION: 📊 Fetch video content from Airtable database (recuoYjg4icStHsMK) 🔗 Get integration IDs for video-enabled platforms 🔀 Route platforms to appropriate video processors 🧹 Clean content for Instagram & Facebook (YouTube bypassed) 📹 Publish to video platforms simultaneously 📹 PLATFORM COVERAGE: • 📱 Instagram: Video posts & Reels (✅ Working) • 📘 Facebook: Video content (⚠️ Test mode) • 🎬 YouTube: Long-form videos (🚨 Broken) ⚡ EXECUTION FLOW: Airtable → Integrations → Video Router → [3 Parallel Paths] ├── Instagram: Cleaner → Publisher ├── Facebook: Cleaner → Publisher └── YouTube: [Direct] → Publisher 🗄️ DATA SOURCE: • Base: Netkreatives.com • Table: Youtube tool • Video Field: 'postiz video' • Content Fields: instagram_caption, faceboook 🔧 TECHNICAL SPECS: • Method: POST • Auth: HTTP Header (Postiz credentials) • Timing: Immediate posting (+1 minute delay) • Media: Pre-uploaded video paths • Content-Type: application/json

🎬 Social Media Content Generator Workflow Overview Automated social media content creation from video transcripts 🎯 Trigger: Airtable Webhook Action**: Receives webhook from Airtable automation Data**: RecordId and action type (e.g., "post-ig") Purpose**: Starts the content generation pipeline 📊 Step 1: Fetch Record Node**: Airtable (Get Record) Action**: Retrieves full record data using RecordId Data**: Name, transcript, and other fields 📁 Step 2: Create Google Drive Folder Node**: Google Drive (Create Folder) Action**: Creates blue folder in /tutorials directory Name**: Uses record Name field Updates**: Stores folder ID back to Airtable 🤖 Step 3: AI Content Analysis Node**: AI Agent with Google Gemini 2.5 Flash Input**: Video transcript from Airtable Structured Output**: JSON with all social formats: YouTube title & description YouTube thumbnail text Twitter thread (array) LinkedIn post Instagram caption TikTok caption YouTube Shorts caption Relevant tags 💾 Step 4: Save Transcript File Node**: Google Drive (Create from Text) Action**: Saves transcript as text file Location**: Inside the created folder Name**: Uses record Name field 📋 Step 5: Update Airtable Results Node**: Airtable (Update Record) Data**: All AI-generated social media content Special**: Twitter thread array joined with newlines 🎯 Result: Complete social media content suite ready for multi-platform publishing, organized in Google Drive with all data stored in Airtable.

Overview This n8n workflow template automates the entire process of publishing Instagram Reels from content stored in Google Sheets and Google Drive. It's designed for content creators, social media managers, and businesses who maintain a content calendar in spreadsheets and need automated publishing with AI-generated captions. Workflow Steps Trigger Phase Schedule Trigger**: Runs every 12 hours (configurable) Google Sheets Trigger**: Alternatively triggers when new rows are added Retrieves the next unposted video from the spreadsheet (where POSTED = FALSE) Content Preparation Downloads video from Google Drive using file ID from spreadsheet Processes video with FFmpeg to add custom text overlays: Title text overlay Numbering overlay Sales hook text Sends processed video using SSH Caption & Metadata Generation Extracts video filename and metadata Uses AI Agent (DeepSeek) to generate engaging Instagram captions: 2-4 engaging sentences 3-5 relevant hashtags Clear call-to-action Under 150 characters total Stores caption and metadata in Airtable for record-keeping Instagram Publishing Creates Facebook/Instagram media container with video URL and caption Waits and polls for video processing completion Publishes the Reel when ready Updates Google Sheet to mark content as posted (POSTED = TRUE) Cleanup Removes temporary video files from disk

Who is this for? Creators, designers, and developers exploring AI-powered image generation. Automation enthusiasts who want to integrate image creation into n8n workflows. Telegram bot builders looking to add visual AI capabilities. Marketers or freelancers automating creative content workflows. What problem is this workflow solving? Creating AI images usually requires multiple tools and manual setup. This workflow removes the complexity by: Connecting Nano Banana (AI image model) directly to n8n. Allowing image generation via Telegram chatbot. Providing a no-code setup that is fully automated and scalable. What this workflow does This workflow demonstrates how to generate AI images using Nano Banana and n8n, with an integrated Telegram chatbot interface. The process includes: Connecting Gemini Nano Banana to n8n. Automating image generation requests triggered from Telegram. Returning AI-generated images back to the user. Allowing customization of prompts and styles dynamically. By the end, you’ll have a fully functional automation to generate and send AI-created images through Telegram — no coding required. Setup Create accounts: Sign up on n8n.io and ensure you have Telegram Bot API access. Connect your Nano Banana or Gemini API endpoint. Set up your Telegram Bot: Use BotFather to create a new bot and get the token. Add the “Telegram Trigger” node in n8n. Configure Nano Banana connection: Add an HTTP Request node for Nano Banana API. Insert your API key and prompt parameters. Handle responses: Parse the AI-generated image output. Send the image file back to the Telegram user. Test and Deploy: Run a sample image prompt. Verify that Telegram returns the correct generated image. How to customize this workflow to your needs Modify prompts or styles to fit different artistic use cases. Add conditional logic for image size, aspect ratio, or filters. Integrate with Google Drive or Notion for image storage. Schedule automatic image generation for campaigns or content creation. Expand with OpenAI or Stability AI for hybrid workflows. Notes Nano Banana API may have rate limits depending on usage. Ensure your Telegram bot has permission to send files and images. You can host this workflow on n8n Cloud or self-hosted setups. Want A Video Tutorial on How to Setup This Automation:  https://youtu.be/0s6ZdU1fjc4

Shopify Digital Product Automation (from just and image to complete Shopify product page.) This Shopify Digital Product Automation is an advanced n8n-powered workflow that leverages AI (Google Gemini), Airtable, and Shopify API to generate product details from images and automatically post them to Shopify. It fully automates the process — from uploading images to publishing Shopify products — with minimal manual effort. 💡 Key Advantages Our Shopify Digital Product Automation offers five core advantages: 🔗 Shopify Product Sync — Automatically posts product details including title, description, SEO fields, and matched category to Shopify. ✍️ AI-Powered Product Generation — Gemini analyzes uploaded images and generates engaging, SEO-friendly product titles, descriptions, and metadata. 🗂️ Structured Output — Outputs JSON-ready product data compatible with Shopify, ensuring smooth automation. 📄 Airtable Integration — Tracks uploaded images, analyzed data, and generated products to prevent duplication. 📤 End-to-End Automation — Handles the complete workflow from image upload to Shopify posting without manual intervention. ⚙️ How It Works The workflow follows a step-by-step automated process: Step-by-Step Process Upload Images – Add your digital artwork or poster images to Google Drive and record them in Airtable. Image Analysis – AI fetches new images and analyzes visual elements like characters, series, poster text, and style. Store Analysis Results – Updates analyzed data in Airtable and marks images as Used. Fetch Shopify Collections – Retrieves current collections from your Shopify store for category matching. Generate Product Details – Gemini generates product title, description, matched category, SEO page title, meta description, and URL handle. Save Generated Products – Stores generated product details in Airtable and marks them as generated. Post Products to Shopify – Automatically creates new products in Shopify using the API. Update Status – Marks products as posted in Airtable after successful posting. 🛠️ Setup Steps Required Node Configuration To implement this workflow, configure the following n8n nodes: Trigger Node** – Start workflow manually or via scheduler. Airtable Node** – Fetch raw images and store processed product details. Google Drive Node** – Access image files. HTTP Request Node** – Fetch Shopify collections. Code Node** – Refine AI outputs and format product data. Split & Limit Nodes** – Process images and products in batches. LangChain / Gemini Node** – Generate product titles, descriptions, and SEO data. Shopify Node** – Create products via Shopify API. Status Update Node** – Update Airtable with processing and posting status. 🔐 Credentials Required Before running the workflow, ensure you have the following credentials configured: Shopify Access Token** – For posting products and fetching collections. Gemini API Key** – For AI-powered product generation. Airtable API Key** – For storing and tracking workflow data. Google Drive OAuth** – To access image files. 👤 Ideal For This automation workflow is designed for: Shopify store owners managing hundreds of digital products Ecommerce teams automating product listings Marketing teams needing scalable, AI-driven product content workflows 💬 Bonus Tip The workflow is fully modular and customizable. You can extend it to: Automatically assign prices or discounts Multi-language product description generation Social media promotion of new products Email campaign integration All extensions can be implemented within the same n8n flow, making it a complete digital product automation solution.

How it works This powerful automation turns LinkedIn influencer activity into high performing Amazon seller content, fully hands-off. It runs in two phases: AI Content Generator Retrieves influencer usernames from Airtable Scrapes their most recent LinkedIn post via Apify Uses OpenAI (GPT-4o) to generate original Amazon focused post content Generates a branded LinkedIn image using AI (WeSpark visual identity) Saves content & image link to Google Drive Creates a record in Airtable with Status = In review Scheduled Publisher Every day at 4 PM, one post from Airtable with Status = Approved is: Downloaded from Drive Published on LinkedIn Marked as Posted in Airtable ⚙️ Set Up Steps Time to set up:** 15–20 minutes Create two Airtable tables: influencers with UserName (LinkedIn usernames only) posts with fields: Description (text) Image (Drive link) InfluencerUsername InfluencerPost InfluencerPostCreatedAt Status (In review, Approved, Posted, Rejected) Add Google Drive OAuth2 credentials for saving & downloading images Configure OpenAI GPT-4o key (for text + image generation) Set up Apify LinkedIn scraper and add header credentials Link your LinkedIn account (company or personal profile) Workflow Phases AI Generator (Triggered manually) Loops over influencer usernames Scrapes latest LinkedIn post Skips if already stored Uses GPT-4o to: Rewrite the post uniquely for Amazon sellers Generate JSON with text + image prompt Saves AI-generated image to Google Drive Logs post to Airtable with In review status Daily Publisher (Scheduled) Runs every day at 4 PM Filters Airtable for Status = Approved Picks 1 record, downloads image from Drive Publishes to LinkedIn Updates Airtable status to Posted Airtable Setup Example influencers Table: | UserName | | ----------- | | jon-derkits | posts Table: | Description | Image | InfluencerUsername | InfluencerPost | InfluencerPostCreatedAt | Status | | ------------------------------ | ------------- | ------------------ | --------------- | ----------------------- | --------- | | Amazon Listing Optimization... | \[Drive Link] | jon-derkits | \[LinkedIn URL] | 2025-06-18 19:30:01 | In review | Status field options: In review Approved Posted Rejected Example LinkedIn Visuals | Caption | Image | | -------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------- | | Boost Your Amazon ROI! Data-driven strategies are your secret weapon... | View Image | | Boost Sales with 5–10% Higher Conversions! Utilize Enhanced Brand Content and Smart PPC... | View Image | | Grow Your Amazon Business WeSpark – Amazon Consulting Agency... | View Image | | Amazon Growth Strategies Embrace the power of smart optimization... | View Image | ✅ Best For: Amazon agencies and FBA consultants B2B SaaS tools targeting eCommerce LinkedIn ghostwriters and creators Content marketing teams for Amazon sellers

Who is this for? This template is designed for content creators, marketing teams, educators, or media managers who want to repurpose video content into written blog posts with visuals. It's ideal for anyone looking to automate the process of transforming YouTube videos into professional blog articles and custom images. What problem is this workflow solving? Creating written content from video material is time-consuming and manual. This workflow solves that by automating the entire pipeline: from detecting new YouTube video uploads to transcribing the audio, turning it into an engaging blog post, generating a matching visual, and saving both in Airtable. It saves hours of work while keeping your blog or social feed active and consistent. What this workflow does This automation listens for new YouTube videos added to a Google Drive folder, extracts the full transcript using Dumpling AI, and sends it to GPT-4o to generate a blog post and image prompt. Dumpling AI then turns the prompt into a 16:9 visual. The blog and visual are saved into Airtable for easy publishing or curation. Setup Google Drive Trigger Create a folder in Google Drive and upload your YouTube videos there. Link this folder in the "Watch Folder for New YouTube Videos" node. Enable polling every minute or adjust as needed. Download & Prepare the Video The video is downloaded and converted into base64 format by the next two nodes: Download Video File and Convert Downloaded Video to Base64. Transcription with Dumpling AI The base64 video is sent to Dumpling AI’s extract-video endpoint. You must have a Dumpling AI account and an API key with access to this endpoint: Dumpling AI Docs Generate Blog Content with GPT-4o GPT-4o takes the transcript and generates: A human-like blog post A descriptive prompt for AI image generation Make sure your OpenAI credentials are configured. Generate the Visual The prompt is passed to Dumpling AI’s generate-ai-image endpoint using model FLUX.1-pro. The result is a clean 1024x576 image. Save to Airtable Blog content is stored under the Content field in Airtable. The image prompt is also added to the Attachments column as a visual reference. Ensure Airtable base and table are preconfigured with the correct field names. How to customize this workflow to your needs Change the GPT prompt to alter the tone or format of the blog post (e.g., add bullet points or SEO tags). Modify the Dumpling AI prompt to generate different image styles. Add a scheduler or webhook trigger to run at different intervals or through other integrations. Connect this output to Ghost, Notion, or your CMS using additional nodes. 🧠 Sticky Note Summary Part 1: Transcription & Blog Prompt Watches a Google Drive folder for new video uploads. Downloads and encodes the video. Transcribes full audio with Dumpling AI. GPT-4o writes a blog post and descriptive image prompt. Part 2: Image Generation & Airtable Save Dumpling AI generates a visual from the image prompt. Blog content is saved to Airtable. The image prompt is patched into the Attachments field in the same record. ✅ Use this if you want to automate repurposing YouTube videos into blog content with zero manual work.

💅 AI Agents Generate Content & Automate Posting for Beauty Salon Social Media 📲 Who Is This For? This workflow is for beauty salons who want consistent, high‑quality social media content without writing every post manually. It also suits agencies and automation builders who manage multiple beauty brands and want a reusable, AI‑driven posting system they can adapt per client. What Problem Is This Workflow Solving? Many beauty businesses struggle to post regularly because research, copywriting, and design all take time and marketing skills. This workflow automates research, writing, image creation, and posting, so your channels stay active and relevant while you focus on clients and services. What This Workflow Does Generates short, engaging posts tailored to a beauty‑salon audience (hair, nails, skincare, make‑up, self‑care) using an AI agent. Uses Tavily Internet Search to pull up‑to‑date information and trends based on a reference link or topic. Turns each post into a detailed, photorealistic image prompt and creates a matching visual with an AI image model (for example, gpt‑image‑1 or other connected providers). Automatically sends the final text and image to Telegram, and can be extended to other social platforms from the Split Out node. How It Works Trigger the workflow Scheduled automatic generation:** Run the parent workflow on a schedule (for example, once per day at 9 AM) to publish new content regularly. Google Sheets trigger:** Generate content when a new row with a reference link or topic is added to your sheet. Use it when you manage ideas or briefs in Google Sheets and want the workflow to react as soon as a new idea appears. RSS Feed trigger:** Start the workflow when new items appear in a selected RSS feed. Ideal for turning fresh blog posts, news, or industry updates into social media content or automated summaries. Meta (Facebook/Instagram) webhook:** Use the Meta Reference trigger to fire the workflow on incoming webhooks from Meta (for example, new comments, messages, or events). Helpful when you want to auto‑respond, log activity, or generate follow‑up content from Meta activity. Airtable trigger:** Start the workflow when records in a selected Airtable base/table change (for example, a new idea, brief, or status update), so your posts react instantly to updates in your Airtable content board. Postgres trigger:** Fire the workflow when new rows are inserted or existing rows are updated in a connected PostgreSQL table, letting you drive content generation from events in your app database or Supabase‑style back end. Manual start:* Hit Execute workflow* whenever you want to spin up a batch of posts on demand, test new prompt settings, or debug the flow step by step. Research and generate copy The GENERATE TEXT agent calls Tavily to gather fresh information on the topic. It writes a post under 1024 characters with a hook, practical tips, relevant hashtags, and a closing line with your salon address and contact. Create the visual The GENERATE PROMPT agent converts the post into a single, clear description of the scene (client, service, salon interior, lighting, mood) with a strict “no text on image” rule. An image model such as gpt‑image‑1 or one of the HTTP image APIs renders a matching beauty visual. Distribute the content The Split Out node fans out the result so Telegram receives a photo post with the generated caption. Additional social or content nodes (for example Facebook, LinkedIn, X, template tools) can be wired after this step for multi‑channel posting. How to Customize This Workflow to Your Needs Brand voice** Edit the system message in the GENERATE TEXT node to adjust tone (luxury, friendly, clinical, playful), language, services, and city. Update the final address and phone line to match your salon details. Topics and triggers** Point the Google Sheets Trigger to your own document ID, sheet, and columns for ideas, links, or campaign themes. Use the Schedule Trigger for fully automatic posting or rely on the Manual Trigger for controlled, batch generation sessions. Models and providers** Swap GPT‑5 llm and the default image model for alternatives such as Mistral, Gemini, Anthropic, DeepSeek, or custom HTTP image APIs by enabling the corresponding nodes and adding credentials. Channels and outputs** Connect or remove social nodes after Split Out depending on which platforms you actively use. Add extra processing steps (for example resizing images or adding UTM parameters) before each channel if needed. Visual style** Tweak the GENERATE PROMPT instructions to control composition (close‑up vs. full‑body), color palette, lighting, and overall salon aesthetic, while keeping the constraint of no text or logos in the image.

Who is this for? This workflow is ideal for: HR professionals* and recruiters* who want to automate and enhance the hiring process Organizations** seeking AI-driven, consistent, and data-backed candidate evaluations Hiring managers** using Airtable as their recruitment database What problem is this workflow solving? Screening candidates manually is time-consuming, inconsistent, and difficult to scale. This workflow solves that by: Automating resume intake and AI evaluation** Matching candidates to job postings dynamically** Generating standardized suitability reports** Notifying HR only when candidates meet the criteria** Storing all applications in a structured Airtable database** What this workflow does This workflow builds an end-to-end AI-powered hiring pipeline using Airtable, OpenAI, and Google Drive. Here's how it works: Accept candidate applications via a public web form, including resume upload (PDF only) Extract text from uploaded resumes for processing Store resumes in Google Drive and generate shareable links Match the application to a job posting stored in Airtable Use AI to evaluate candidates (via OpenAI GPT-4) against job descriptions and requirements Generate suitability results including: Match percentage Screening status: Suitable, Not Suitable, Under Review Detailed notes Combine AI output and files into one data object Create a new candidate record in Airtable with all application data Automatically notify HR via Gmail if a candidate is marked “Suitable” Setup View & Copy the Airtable base here: 👉 Candidate Screening – Airtable Base Template Set up Google Drive folder Connect your OpenAI API key for the AI agent model Connect your Gmail account for email notifications Deploy the public-facing form to start receiving applications Test the workflow using a sample job and resume How to customize this workflow to your needs Expand file support**: Allow DOC or DOCX uploads by adding format conversion nodes Add multi-recipient email alerts**: Extend Gmail node for multiple HR recipients Handle “Under Review” differently**: Add additional logic to notify or flag these candidates Send rejection emails automatically**: Extend the IF branch for “Not Suitable” candidates Schedule interviews**: Integrate with Google Calendar or Calendly APIs Add Slack notifications**: Send alerts to team channels for real-time updates Contact me for consulting and support: 📧 [email protected]

Workflow Documentation: HR Job Posting and Evaluation with AI Detailed Description The HR Job Posting and Evaluation with AI workflow is designed to streamline and enhance recruitment for technical roles, such as Automation Specialists. By automating key stages in the hiring process, this workflow ensures a seamless experience for both candidates and HR teams. From collecting applications to evaluating candidates using AI and scheduling interviews, this workflow provides an end-to-end solution for recruitment challenges. Who is this for? This workflow is ideal for: HR Professionals**: Managing multiple job postings and candidates efficiently. Recruitment Teams**: Handling large volumes of applications for technical positions. Hiring Managers**: Ensuring structured and objective candidate evaluations. What problem does this workflow solve? Time-Consuming Processes**: Automates repetitive tasks like data entry, CV management, and scheduling. Fair Candidate Evaluation**: Leverages AI to provide objective insights based on resumes and job descriptions. Streamlined Communication**: Ensures timely and personalized candidate interactions, improving their experience. What this workflow does This workflow automates the following steps: Form Submission: Collects candidate information via a structured application form. Data Storage: Stores applicant details in Airtable for centralized tracking. CV Management: Automatically uploads resumes to Google Drive for easy access and organization. AI-Powered Candidate Evaluation: Scores candidates based on their resumes and job descriptions using OpenAI, providing actionable insights. Interview Scheduling: Automates scheduling based on candidate and interviewer availability. Communication: Sends customized emails to candidates for interview invitations and feedback. Setup Prerequisites To use this workflow, you’ll need: n8n Account**: To create and run the workflow. Airtable Account**: For managing applicant data. Google Drive Account**: For storing candidate CVs. OpenAI API Key**: For AI-powered candidate scoring. SMTP Email Account**: For sending candidate communications. Setup Process Airtable Configuration: Create a base in Airtable with tables for Applicants and Job Positions. Google Drive Setup: Create a folder for CV storage and ensure you have write permissions. Integrate Airtable in n8n: Use the Airtable API key to connect Airtable to n8n. Integrate Google Drive in n8n: Authorize Google Drive to enable CV storage automation. OpenAI Integration: Add your OpenAI API key to n8n for candidate scoring. Email Configuration: Set up your SMTP email account in n8n for sending notifications and invitations. How to customize this workflow Tailor the workflow to fit your unique recruitment needs: Edit Job Descriptions: Adjust the form parameters to match the specific role and qualifications. Refine AI Evaluation Criteria: Modify OpenAI prompts to reflect the skills and competencies for the desired position. Personalize Email Templates: Update email content to match your organization’s tone and branding. Add New Features: Incorporate additional steps like feedback collection or integration with other HR tools. Conclusion The HR Job Posting and Evaluation with AI workflow simplifies and automates the recruitment process, enabling HR teams to focus on engaging with candidates rather than handling administrative tasks. With its powerful integrations and customization options, this workflow helps organizations hire efficiently while improving the candidate experience.

Who Is This For? This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents. ​ Whether you run a blog, SaaS, personal brand, newsletter, or client accounts, this tool helps you keep a consistent content pipeline without manually writing every article, creating images, and posting to each platform one by one. ​ ​ 💪🏼 While the template is wired around classic blog + social media distribution, the underlying logic is universal. You can easily adapt it to any niche by editing prompts, swapping models, and re‑wiring nodes. You can plug in any LLM you like, from ChatGPT to Claude, Gemini, Mistral, DeepSeek, OpenRouter, or even local models through Ollama. ​ What Problem Is This Workflow Solving? 🤯 Most teams waste hours on the same repetitive loop: research a topic, gather links, write a blog post, craft social captions, generate visuals, upload everything to multiple platforms, and archive assets. ​ ​ 💎 This workflow solves that by automating the full content chain—from research and blog‑post generation to image creation, publishing across channels, and logging everything in your content database—so your feeds stay active while you focus on strategy, not busywork. ​ What This Workflow Does ✨ Generates in‑depth blog posts tailored to your topic and target audience, enriched with fresh references from the web via Tavily/SerpAPI search tools. ​ ✨ Creates an image prompt and title from the article, generates the visual with OpenAI Images (gpt-image-1), and converts it into a ready‑to‑use image file. ​ ✨ Automatically publishes content to your connected platforms (WordPress for blog posts, Telegram, X/Twitter, Facebook, LinkedIn) while saving images to Google Drive and logging each publication in Google Sheets for tracking. ​ How It Works? Surprisingly simple ☺️ The workflow is triggered by another n8n workflow or by one of several triggers (Facebook, RSS, Google Sheets, Airtable, Postgres) that pass in the blogTopic, targetAudience, and Telegram chatID. ​ ​ The Blog Post Agent (LLM with access to Tavily/SerpAPI) researches the topic, writes a structured article for the specified audience, and sends its output to the Image Prompt Agent, which turns the content into a visual prompt and title. ​ 🎯 The end result: you provide a topic, run the workflow, and receive a complete blog post, matching image, and ready‑made social posts shipped directly to your channels and archives—no manual copy‑paste. ​ How to Customize This Workflow to Your Needs 🎨 Switch AI models and fine‑tune prompts so the agent can handle your exact formats: tutorials, case studies, listicles, product updates, thought‑leadership pieces, or campaign landing posts. 🔍 Refine research sources inside Tavily/SerpAPI to prioritize the domains, blogs, and docs your audience trusts, keeping posts accurate and up to date. ⏰ Adjust posting cadence and schedules to align with peak engagement for your audience, mixing automated slots with manual “launch” runs for special announcements. 📱 Expand or trim channels as needed: keep just WordPress + LinkedIn, add Telegram as a content feed, or plug the workflow into additional automations like email campaigns or RSS feeds. 📊 Use Google Sheets as your content hub to store ideas, angles, CTAs, references, and performance notes so you can double‑down on topics and formats that perform best. 🎬 Swap images for video by replacing the image generation node with video tools (for example, Runway‑style APIs) if your strategy is video‑first while keeping the same prompt pipeline. 💾 Build a reusable prompt library in Sheets, Notion, or Airtable so you can rotate proven prompt patterns each month and keep quality high without reinventing the wheel. 🤖 The system will continuously generate blog posts, visuals, and social updates and publish them across your selected platforms while archiving everything in Drive and Sheets—keeping your brand visible, consistent, and professional with minimal ongoing effort.

How it works Automates systematic literature review by downloading papers from Google Drive, extracting text, and evaluating them against strict inclusion/exclusion criteria using LLM agents Routes included papers to Qdrant vector stores with Gemini embeddings for semantic search, and excluded papers to a separate folder Logs all decisions to Airtable with PRISMA-compliant justification for complete audit trails Set up steps Connect Google Drive credentials to access your paper folder Configure Airtable base and table for decision logging Add OpenAI (GPT-4) and Google Gemini API credentials for LLM evaluation and embeddings Set up Qdrant instances for vector storage (supports up to 3 collections) Keep detailed descriptions of your inclusion/exclusion criteria in the sticky notes inside your workflow

Multi-Platform AI Sales Agent with RAG, CRM Logging & Appointment Booking This workflow acts as a 24/7 sales agent, engaging leads across WhatsApp, Instagram, Facebook, Telegram, and your website. It intelligently transcribes audio messages, answers questions using a knowledge base, and uses modular sub-workflows to manage your CRM in Airtable and book appointments in Google Calendar. Who Is It For? This solution is designed for service-based businesses that require a sophisticated, multi-channel lead management and appointment booking system. Agencies, consultants, and clinics** looking to automate lead qualification and booking across text and voice messages. Sales teams** needing a robust system that separates CRM and calendar logic for easier management and scalability. Advanced n8n users** who want a powerful, agent-based framework that can be easily customized and extended. Key Features & Workflow This system is composed of a parent workflow that orchestrates the conversation and calls specialized sub-workflows (agents) to perform specific tasks. Omni-Channel Engagement:* Greets and converses with leads naturally on Website Chat, WhatsApp, Instagram, Facebook, and Telegram*. Voice Message Transcription:* Automatically transcribes incoming audio/voice notes from WhatsApp and Telegram* into text, allowing the AI to understand and respond without manual intervention. RAG-Powered Intelligence:* The AI agent draws answers from your dedicated PostgreSQL Knowledge Base (RAG)*, providing accurate information about your services, pricing, and process. A built-in tool allows you to load new knowledge documents from Google Drive. Modular CRM Agent (Sub-Workflow):* When the conversation requires CRM actions (like creating a contact or updating an opportunity), the main agent calls a dedicated Airtable CRM sub-workflow* to handle the task. Modular Calendar Agent (Sub-Workflow):* To book appointments, the main agent calls a separate Google Calendar sub-workflow*, which manages event creation, updates, and deletions. What You'll Need This workflow framework requires credentials for the following services: An AI provider (OpenAI is used for the main agent, transcription, and embeddings). PostgreSQL** database with the pgvector extension (for RAG and chat memory). Airtable** account (for the CRM sub-workflow). Google Calendar** account (for the Calendar sub-workflow). Telegram Bot** credentials. A Meta Developer Account (for WhatsApp, Instagram & Facebook). (Optional) Google Drive for loading knowledge documents. (Optional) Google Gemini for embeddings. How to Set It Up This is a modular system. You must set up the sub-workflows first. Deploy Sub-Workflows: Create two new, separate workflows using the provided templates for the CRM Agent and the Calendar Agent. Configure the credentials (Airtable, Google Calendar) within those workflows, then save and activate them. Link Sub-Workflows in Main Workflow: Return to this main workflow. In the "CRM Agent" and "Consultation Agent" tool nodes, select the new workflows you just created from the dropdown list. Configure Main Credentials: Securely add the remaining credentials (OpenAI, PostgreSQL, Telegram, and your Meta App) in this main workflow. Personalize the AI Agent: In the "Update Agent Details" node, fill in your business name, the agent's persona name, and your key services to customize the AI's personality. Load Your Knowledge (Optional): To populate the RAG database, use the manual trigger path starting with "When clicking ‘Execute workflow’" to download a document from Google Drive and insert it into your PostgreSQL vector store. Activate: Configure your channel-specific details (e.g., Phone Number ID in WhatsApp nodes), save the workflow, and activate it. Demo CRM Table: View on Airtable

HUMAN-IN-THE-LOOP Content Automation Pro with Deep Research & Airtable for Power Users \- Collaborative AI for WordPress Blog Automation The BEST n8n Content Automation workflow in the market is getting even better, now enabling you to have full control over the entire process. It’s time to unlock the power of true collaborative creation with GenAI\! Want to leverage AI automation but don't want to give up full control over the whole content creation process? Get the best of both worlds \- get “Human-in-the-Loop” with this supreme n8n workflow template\! This template blends the power of AI with the crucial oversight of human expertise and intervention, all managed through a central, streamlined Airtable interface. Say goodbye to generic content and hello to high-quality, deeply researched articles published directly to your WordPress site with full control. Check out my Youtube channel for a full walkthrough. What problem is this workflow solving? / Use cases Fully automated content generation tools often lack the nuance, accuracy, and strategic control necessary for truly impactful content. This workflow solves that critical gap by integrating powerful AI capabilities into a structured, human-supervised content creation process managed via a simple interface. It automates the most repetitive and time-consuming tasks – like research gathering, chapter ideations, domain copywriting – while strategically embedding essential human review points at critical junctures. Instead of simply providing a topic and receiving a finished article of uncertain quality, you actively guide the process step-by-step within an interface. You review, refine, and approve AI suggestions for chapters and content before finalizing and publishing. This approach makes it perfect for creating high-quality, deeply researched, and brand-aligned blog posts for WordPress more efficiently, without ever sacrificing essential editorial control. Who is this for? This workflow template is meticulously designed for individuals and teams deeply involved in content creation who seek a powerful blend of AI-driven efficiency and essential human-controlled quality assurance: Content Creators & Bloggers:** Who want to leverage AI for drafting and research but maintain full editorial control. Marketing Teams:** Looking to scale content production efficiently while ensuring brand voice and quality consistency. SEO Specialists:** Needing to produce well-researched, structured, and SEO-optimized content regularly. Agencies:** Managing content creation for multiple clients with a structured, repeatable process. Anyone who prefers a "human-in-the-loop" approach** over fully automated "black box" content generators. How this workflow works This template automates significant portions of the WordPress content creation process, utilizing Airtable as the central hub for management and user interaction, while leveraging AI for research and copywriting. The system is composed of four interconnected n8n flows, each handling a distinct stage of the content lifecycle. In addition, there is a sub-workflow dedicated to the research tool (Perplexity). Content Creation Process in Airtable The entire journey from idea to published post is managed within your Airtable base, offering transparency and control. Progress through each tab sequentially to complete the content creation process and produce a high-quality article that fulfills your requirements. Configure Settings (“Settings” Table): Define global parameters (website details, target audience, writing style, category IDs, about us, CTA etc.) in the “Settings” table. These serve as default inputs for the AI. Create Topics (“Create Topics“ Table): Add a record to the “Create Topics” table for each new blog post idea. Mark the topic as ready by setting its 'Status' field to “To Do” and ticking the 'Execute Flow' checkbox to initiate the first flow. Generate Chapters (“Generate Chapters“ Table): The first flow calls to the sub-workflow to do online research and generates potential chapter outlines based on your topic and settings, saving them to the “Generate Chapters” table. Select Chapters to Write (“Select Chapters“ Table): Review the suggested chapters in the “Select Chapters“ Table. Select the chapters you want to proceed with by setting their 'Status' to “To Do” and ticking the 'Execute Flow' checkbox. Generate Content for selected Chapters (“Generate Content“ Table): The second flow calls to the sub-workflow to research each selected chapter and generates draft content, saving it to the “Generate Content” table, where you have the opportunity to review and modify if necessary. Select Chapter Content (“Select Content“ Table): Review and edit the AI-generated text directly in Airtable. Approve the content for each chapter. Once all necessary content is approved, trigger the third flow for the final assembly by setting the status to “To Do” and ticking the 'Execute Flow' checkbox. Finalize Post (“Finalize Post“ Table): The third flow aggregates the approved content, generates the title, SEO metadata, tags, chapter images and featured image, placing all compiled information in the “Finalize Post” table for your final review. When the final article is ready to be published on your website, mark the status as "To Do" and check the "Ready to Publish" box to activate the fourth and final flow. Publish & Backup Post (“Backup Post“ Table): the fourth flow publishes the post to the website and creates a backup record in the “Backup Post” table, archiving key details including the live URL of the published article. n8n Workflow Functions (JSON Files) The automation is handled by four separate n8n flows, each triggered by specific changes in Airtable: Flow 1 (Topic Initiation & Chapter Generation): Trigger: Monitors the “Create Topics” table; activates when a record's 'Status' is "To Do" AND 'Execute Flow' checkbox is ticked. Action: Fetches settings from Settings. Performs initial research (e.g., via Perplexity). Uses AI to generate chapter outlines. Saves suggestions as new records in the “Generate Chapters” table. Flow 2 (Content Generation & Internal Linking): Trigger: Monitors the “Select Chapters” table; activates when a record's 'Status' is "To Do" AND 'Execute Flow' checkbox is ticked. Action: Fetches chapter details and settings. Gathers internal links (e.g., by parsing sitemap). Performs online/ deep research per chapter. Uses AI to write draft content, incorporating research and links. Saves drafts into corresponding records in the “Generate Content” table. Flow 3 (Post Assembly & Image Generation): Trigger: Monitors the “Select Content” table; activates when all content for a topic is approved and final assembly is triggered when a record's 'Status' is "To Do" AND 'Execute Flow' checkbox is ticked. Action: Fetches all content from the “Generate Content” table. Aggregates text. Uses AI for title, SEO metadata, tags, and image prompts. Generates chapter images and a featured cover image (e.g., via AI image model DALL-E). Converts content to HTML. Saves compiled data and image info into the “Finalize Post” table. Flow 4 (WordPress Publishing & Backup): Trigger: Monitors the “Finalize Post” table; activates when a record is marked Status' is "To Do" AND ‘Post to Website’ checkbox is ticked. Action: Fetches finalized data. Uploads images to WordPress. Creates WordPress post (status set to “published” by default) with content, metadata, tags, and image. Creates a record in the “Backup Post” table, with a link to the post on the website. This modular approach ensures each stage is handled distinctly, orchestrated via updates on Airtable interface. Unique Features Human-in-the-Loop Design:** Guarantees quality and relevance through mandatory user review and approval stages within Airtable for chapters, content, and the final post. Collaborative AI Partnership:** Leverages AI as a powerful assistant for research, structuring, and drafting, significantly boosting productivity while relying on human expertise for refinement and final judgment. Airtable as Interface & Control Center:** Utilizes Airtable as an intuitive interface and central database to manage the entire content lifecycle, offering clear progress tracking and facilitating team collaboration. Deep Research Integration:** Incorporates external research tools (like Perplexity) to ensure content is based on fresh, up-to-date information, crucial for accuracy and authority. Modular n8n Structure:** Simplifies complexity by dividing the process into four manageable, interconnected flows plus one sub-flows, making the system easier to understand, troubleshoot, and customize. Rate-limit Aware:** Includes built-in Wait nodes and logic designed to mitigate API rate limit issues from AI and research tools, enhancing workflow reliability during intensive use. Multiple-Image Generation:** Generates and adds images for each chapter, as well as a featured image for the article. Direct WordPress Integration:** Streamlines publication by automatically sending finalized, formatted content, metadata, tags, and the featured image directly to your WordPress site. Internal Linking:** Embeds internal website links strategically within each chapter and throughout the article, boosting SEO and enhancing user navigation. Integrated Backup:** Provides data security by automatically archiving key post details in Airtable and optionally saving text and image files to Google Drive. Future Features “Deeper Research”:** Plans for multi-level research capabilities to enable the creation of even more comprehensive reports or e-book length content. Content Sample:** Provide content samples for the AI to learn from and mimic in terms of writing style and guidelines. Category-Specific Styling:** Aiming to allow users to define styles per category for the AI to learn and imitate, ensuring greater brand consistency. Advanced Link Insertion:** Developing more sophisticated strategies for inserting relevant internal and external links, including automatic source citation and dynamic internal link density adjustments. Requirements Airtable Account: create a Airtable account for free. WordPress Website: Requires an Application Password with permissions to create posts and upload media. Must have the REST API enabled. OpenAI API Key: Or a key from another compatible AI provider for text and image generation (DALL-E is the default for images). Perplexity API Key: Or an API key for your chosen online research tool. Google Drive: for the optional backup feature to Google Drive. Setup Step-by-Step Import n8n Workflows: Download the .json workflow files and import them into your n8n instance. There is one main/ “month” workflow and one sub/ “child” workflow. Name the workflows to your needs. Get Airtable Base: Duplicate the companion Airtable Base template. Configure Credentials: Add new credentials in n8n for Airtable, WordPress (use Application Password), OpenAI API, PerplexityAI API, and Google (for Drive backup). Connect Workflow Nodes: Open each workflow in n8n and assign the correct credential to every node that requires authentication (Airtable, WordPress, AI, HTTP Request, Google nodes). Link the main workflow to the sub-workflow: Access the Research Tool nodes and establish a connection between the main workflow to sub-workflow. Configure Airtable Nodes: Update all Airtable nodes across all workflows. Verify that all 'Table' and 'Field' names in the nodes exactly match your duplicated base. Populate Airtable Settings: Fill in your specific details in the Settings table of your Airtable base (Website URL, Audience, Style, Category IDs, CTA, etc.). Test Connections: Run manual executions on key nodes within each flow to ensure connections and basic configurations are correct before activating. Activate Workflow: Toggle the "Active" switch ON for the main/ “mother” workflow in your n8n list. No need to activate the sub/ “child” workflow. Start Creating: Go to the Create Topics table in Airtable, add a new topic, go through the process and get amazed by AI magic\! Airtable Database Explanation Airtable is the central hub, acting as the database, user interface, and trigger mechanism for this workflow. Structure:** The base uses linked tables to manage the process: Settings: Global configurations. Create Topics: Initiates new content pieces. Generate Chapters: Stores AI-generated chapter outlines for review. Select Chapters: Facilitates user selection of chapters to write. Generate Content: Stores AI-generated draft content for selected chapters. Select Content: Manages user approval of drafted content before final assembly. Finalize Post: Holds the compiled post (text, metadata, image info) for final review and publish trigger. Backup Post: Archives data (including live URL) of successfully published posts. Workflow Interaction:** User updates trigger fields in Airtable (e.g., sets Status='To Do' & Execute Flow=true). n8n Airtable Trigger nodes detect these specific changes. The corresponding n8n flow runs, fetching data from Airtable. AI and other tools process data and generate outputs. Results are written back to the appropriate Airtable tables/fields. User reviews results in Airtable and triggers the next stage via status AND checkbox updates. Setup:* Using the exact* duplicated Airtable base template is mandatory, as n8n workflows expect specific table and field names. Tips for Pros AI Prompts:** Modify prompts in the AI nodes to refine tone, style, format, or incorporate specific instructions. AI Models:** the workflow is optimized for OpenAI's GPT-4o model due to its consistent performance. While you can replace the AI models in the nodes with alternatives (if you have the credentials for them), keep in mind that the workflow may not function. AI Research Model:** PerplexityAI is the tool of choice for research. The "sonar" model is the default for research in this workflow due to its speed and cost-effectiveness. However, you are welcome to explore Perplexity's other models, such as the "sonar-deep-research" model, which is specifically designed for in-depth research. AI Image Model:** The default AI model for image generation is OpenAI’s Dall-E. However, the outputs of this model are not impressive. While OpenAI's 4o multimodal is expected to be available via API soon, better/ superior image quality can be achieved in the meantime by using alternative AI image models (such as FLUX.1). Airtable Base:** Add or modify fields/tables to match your specific tracking needs, but remember to update corresponding n8n nodes accordingly. 3rd-party Integrations:** Replace research tools, image generators, or modify the final step to publish to a different CMS or add post-publication steps like social sharing. Error Handling:** For production reliability, incorporate an “Error Handling” workflow in n8n for this automation to catch failures and send notifications Important Considerations API Rate Limits:* AI and research tools have usage limits. High volume processing might cause errors. The included Wait* nodes help, but may need adjustment based on your API plans. Testing Costs:** API calls to AI models aren't free. To ensure the workflow runs correctly, start testing with OpenAI's GPT-4o. Once you've confirmed functionality, explore using other AI models which may be cheaper to keep costs down. Be aware that the workflow may not be as reliable with models other than GPT-4o. Keep an eye on your API provider's billing dashboard to monitor usage and costs. Sequential Processing:* The workflow processes one topic fully at a time to ensure stability and manage API limits. For fully automated, parallel processing from a list, consider the alternative template: [“\[n8n\] Content Automation Pro – with DEEP RESEARCH – WordPress Blog Automation”*](https://n8n.io/workflows/3041-wordpress-auto-blogging-pro-with-deep-research-content-automation-machine/).

Video Guide I prepared a comprehensive guide detailing how to automate the parsing of invoices using n8n and LlamaParse, seamlessly capturing and storing vital billing information. Youtube Link Who is this for? This workflow is ideal for finance teams, accountants, and business operations managers who need to streamline invoice processing. It is particularly helpful for organizations seeking to reduce manual entry errors and improve efficiency in managing billing information. What problem does this workflow solve? Manually processing invoices can be time-consuming and error-prone. This automation eliminates the need for manual data entry by capturing invoice details directly from uploaded documents and storing structured data efficiently. This enhances productivity and accuracy across financial operations. What this workflow does The workflow leverages n8n and LlamaParse to automatically detect new invoices in a designated Google Drive folder, parse essential billing details, and store the extracted data in a structured format. The key functionalities include: Real-time detection of new invoices via Google Drive triggers. Automated HTTP requests to initiate parsing through Lama Cloud. Structured storage of invoice details and line items in a database for future reference. Google Drive Integration: Monitors a specific folder in Google Drive for new invoice uploads. Parsing with LlamaParse: Automatically sends invoices for parsing and processes results through webhooks. Data Storage in Airtable: Creates records for invoices and their associated line items, allowing for detailed tracking. Setup N8N Workflow Google Drive Trigger: Set up a trigger to detect new files in a specified folder dedicated to invoices. File Upload to LlamaParse: Create an HTTP request that sends the invoice file to LlamaParse for parsing, including relevant header settings and webhook URL. Webhook Processing: Establish a webhook node to handle parsed results from LlamaParse, extracting needed invoice details effectively. Invoice Record Creation: Create initial records for invoices in your database using the parsed details received from the webhook. Line Item Processing: Transform string data into structured line item arrays and create individual records for each item linked to the main invoice.

Most service businesses and freelancers track their quotes in Airtable (or something similar), but when it comes to actually sending the quote, they're still manually copying data into a document, exporting a PDF, attaching it to an email, and then going back to update the record. This workflow cuts all of that out. Who is this for Freelancers, agencies, and small service businesses who already use Airtable to track client work and want to stop manually creating quote documents. If you've ever caught yourself copying the same line items into a Google Doc for the third time in a week, this is for you. How it works The workflow starts with a webhook. You can call it from an Airtable automation (when a record hits "Ready to Send", for example) or trigger it manually from Postman or any HTTP client. Once triggered, it pulls the quote record from Airtable, grabs the client details and line items, and builds a branded HTML document with proper formatting, subtotals, tax calculation, and a grand total. That HTML then gets converted to a PDF through pdf.co's free API. From there, the PDF gets uploaded to a Google Drive folder and emailed to the client as an attachment via Gmail. The Airtable record is updated with the Drive link and marked as "Sent" so you have a clear audit trail. How to set it up Create an Airtable base with a "Quotes" table. You'll need these columns: Client Name, Client Email, Line Items (long text, one per line in the format Description | Qty | Price), Tax Rate, Notes, and Status Open the "Configure Settings" node in the workflow and fill in your business name, email address, physical address, and Google Drive folder ID Connect your Airtable, Gmail, and Google Drive accounts in n8n Sign up for a free pdf.co account and add the API key as an HTTP Header Auth credential Activate the workflow and test it by sending a POST request with {"recordId": "rec..."} to the webhook URL Requirements Airtable account (free tier works) Gmail account with OAuth connected in n8n Google Drive for PDF storage pdf.co API key (free tier gives you 100 credits/month, each conversion costs 1 credit) Customizing the workflow The HTML template lives inside the "Build HTML Quote" code node. You can change the layout, fonts, colors, and add your logo by editing the HTML string directly. The brand color is pulled from the Configure Settings node, so changing it there updates the whole document. You can also adjust the quote validity period (default is 30 days) or change the reference number format in the same code node. If you want to swap pdf.co for another HTML-to-PDF service, just update the HTTP Request node URL and payload format.

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 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. 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/

Automated Invoice Intelligence: PDF-to-JSON Financial Orchestrator 🎯 Description This is an elite enterprise-grade solution for Accounts Payable and Finance Ops teams. It automates the high-volume extraction of unstructured data from PDF invoices using the HTML to PDF (Parse PDF to JSON) node, transforming raw email attachments into validated, audit-ready financial records across multiple platforms. ✨ The Sovereign Lifecycle Intelligent Intake & Validation - Monitors Gmail for incoming invoices. Implements a strict validation layer to ensure only valid PDF binaries enter the intelligence stream, filtering out noise and non-invoice attachments. Atomic JSON Transformation - Leverages the HTML to PDF (Parse PDF to JSON) node to decompose monolithic PDF files into structured data objects. This allows the system to treat document text as actionable data points. AI Ledger Mapping - A sophisticated hybrid-intelligence Code Node acts as a virtual "Financial Controller." It uses advanced pattern matching to extract key fields (Vendor Name, Invoice Number, Tax, and Total Amount) and calculates a Confidence Score for every entry. Conditional Approval Gating - Implements a "Trust-but-Verify" architecture: Auto-Process: High-confidence extractions of standard value invoices are posted immediately. Human-in-the-Loop (HITL): Low-confidence results (<0.7) or high-value invoices (>$5,000) are automatically diverted to a Review Queue in Google Sheets. Multi-Platform Ledger Sync - Simultaneously synchronizes data across Google Sheets (for real-time reporting) and Airtable (for project management), ensuring a single source of truth. Forensic Archival & Alerts - Moves original files to a secure Google Drive archive. High-priority items trigger instant Slack and Gmail alerts for the finance team. 💡 Key Technical Features Heuristic Pattern Matching:** Dynamically handles various invoice layouts by analyzing financial context and keywords. Math Integrity Check:** Automatically verifies if (Subtotal + Tax = Total) to boost extraction confidence. Bi-Directional Governance:** Keeps track of every document with a unique Processing ID and metadata log for regulatory compliance. 🚀 Benefits ✅ 95% Reduction in Data Entry - Shifts human effort from manual typing to high-level oversight. ✅ Financial Risk Mitigation - Automatically flags high-value transactions and extraction anomalies before they hit the books. ✅ Real-Time Visibility - Instant updates to financial dashboards the moment an invoice is received. Tags: #finance #accounts-payable #pdf-to-json #automation #fintech #google-sheets #airtable Category: Finance & Operations | Difficulty: Advanced

Enterprise Legal Vault: AI Classification & Multi-Jurisdictional Security 🎯 Description This enterprise-grade legal document management system provides end-to-end automation for securing, classifying, and managing the lifecycle of sensitive documents. It is designed to handle high-stakes data across multiple jurisdictions (GDPR, CCPA, HIPAA) with AI-powered intelligence. ✨ What This Workflow Does Intelligent Intake & Deduplication - Monitors Google Drive, Email, and Webhooks. It uses SHA-256 fingerprinting to ensure every document is unique and to prevent redundant processing. AI-Powered Analysis Engine - Utilizes OpenAI/Claude to classify documents (NDA, MSA, Employment Agreements), detect jurisdiction, and assign a composite Risk Score (1-100). Dynamic Security Enforcement - Translates business rules from Airtable into technical enforcement using the HTML to PDF (Lock) node: Ultra-High Risk (90+): AES-256 encryption with disabled Print, Copy, and Modify permissions. High Risk (50-89): AES-128 encryption with dynamic recipient-specific watermarking. Public Filings: Timestamped watermarking with no encryption. Lifecycle & Retention Automation - Automatically calculates retention expiry dates based on legal requirements. It sets Google Calendar renewal reminders at 90, 60, and 30-day intervals. Intelligent Distribution Matrix - Verified: Attached to HubSpot Deals and synced to Dropbox client folders. Review: Flagged items are sent to a manual review queue with a Slack preview. Failed: Isolated in a Quarantine folder with incident logging in Airtable. 💡 Key Features Jurisdictional Logic:** Automatically adapts security and retention rules based on regional laws fetched from Airtable. Forensic Watermarking:** Embeds tracking data (User ID, Timestamp) to deter and identify data leaks. Fail-Safe Quarantine:** Prevents unverified or risky documents from ever entering the primary company storage. 📦 Requirements HTML to PDF Node* - Essential for tiered Lock* operations. Airtable** - Acts as the central "Business Rules Engine." Google Drive & HubSpot** - For storage and CRM synchronization. OpenAI/Claude API** - For document classification and risk assessment. 🚀 Benefits ✅ Zero Manual Security Setup - Documents are locked according to corporate policy the moment they are uploaded. ✅ Regulatory Compliance - Meets strict GDPR "Right to be Forgotten" and data localization standards automatically. ✅ Proactive Risk Management - High-liability clauses and auto-renewals are flagged instantly to the legal team. Tags: #legal #compliance #pdf-lock #encryption #gdpr #sec-ops #hubspot #airtable Category: Legal & Compliance Difficulty: Advanced

Automated Podcast Generation with n8n, OpenAI & Buzzsprout This workflow automatically turns any audio file uploaded to Google Drive into a complete podcast episode. It handles transcription, content generation, blog drafting, social copy creation, thumbnail generation, Airtable record updates, Buzzsprout publishing and finally notifies your team via Slack. It is a full “audio-to-published-podcast” automation that requires no manual editing. ⚡ Quick Start: 10-Step Fast Implementation Connect Google Drive, OpenAI, Airtable, Slack & Buzzsprout credentials. Upload an audio file to the Drive folder. Workflow triggers automatically. Audio → Text transcription via OpenAI Whisper. AI converts transcript into title, show notes, tags, publish date, etc. AI generates social content & blog article. AI generates YouTube thumbnail (URL saved). Data saved to Airtable. Episode uploaded to Buzzsprout. Slack receives final “Episode Published” notification. What It Does This workflow automates the complete lifecycle of podcast publishing. Once an audio file is placed inside a Google Drive folder, the system takes over: it transcribes the audio, generates structured metadata, creates rich content including a blog post and multiple social media captions and produces a YouTube-ready thumbnail. Generated content is saved into Airtable, ensuring you always have a centralized database of episode metadata. The workflow then uploads the processed audio file to Buzzsprout, creating a ready-to-publish podcast entry. Finally, it sends a Slack notification summarizing the episode details. This workflow eliminates hours of manual podcast editing, writing and uploading — providing a fast, reliable and repeatable content automation pipeline. Who’s It For Podcasters who want to automate production and publishing Marketing teams managing multiple content channels Creators who want to repurpose audio into blogs & social content Agencies or studios producing podcasts for clients Anyone wanting a hands-free “record → upload → publish” podcast system Airtable Table Structure (Required Fields) To run this workflow successfully, you must create one Airtable table that stores all generated podcast episode data. Below is the exact list of fields (with correct Airtable field types) that the workflow expects. | Field Name | Airtable Field Type | Purpose | | -------------------------- | ------------------- | --------------------------------------------------------- | | episode_title | Single line text | Title generated from the audio transcript | | record_Id | Auto number | Automatically generated unique internal record identifier | | episode_description | Long text | Description of the episode (AI-generated) | | show_notes | Long text | Detailed show notes generated from transcript | | suggested_publish_date | Single line text | Publish date suggested by AI | | blog_draft_markdown | Long text | SEO-optimized full blog draft | | linkedin_post | Long text | LinkedIn long-form post | | instagram_caption | Long text | Instagram caption + hashtags | | twitter_thread | Long text | Thread text (converted from array → single string) | | tiktok_script | Long text | Short TikTok/Shorts script | | youtube_thumbnail_url | URL | Thumbnail image URL generated by OpenAI | | buzzsprout_episode_id | Number | Episode ID returned from Buzzsprout | | audio_url | Single line text | Buzzsprout final audio file URL | | published_at | Single line text | Actual published datetime returned by Buzzsprout | | guid | Single line text | Unique GUID assigned by Buzzsprout | Notes for Users Setting Up the Table Do not use array fields — arrays are converted into strings before saving. record_Id is Airtable auto-number will generate it and it used for update record. published_at, audio_url, guid and buzzsprout_episode_id are populated after Buzzsprout upload. youtube_thumbnail_url is populated after the AI Image Generation node. Requirements To use this workflow, you need: n8n** self-hosted or cloud Google Drive account** (folder monitored for new audio uploads) OpenAI API Key** (Whisper + GPT + Image Generation) Airtable Base & API Key** Buzzsprout Podcast ID & API Token** Slack App / Bot Token** Audio file in MP3/WAV/M4A format How It Works & Setup Steps Step 1 — Google Drive Trigger Monitors a specific folder. When an audio file is uploaded, the workflow starts. Step 2 — Transcribe Audio with OpenAI Uses Whisper model to convert speech → text. Returned transcript is cleaned and extracted. Step 3 — Extract Episode Metadata Title Description Show notes Episode tags Suggested publish date All parsed and structured via OpenAI. Step 4 — Generate Social Media Content LinkedIn article post Twitter/X thread Instagram caption TikTok short script Step 5 — Generate Blog Draft Full SEO-optimized Markdown article created by OpenAI. Step 6 — Create YouTube Thumbnail OpenAI Image API 1280×720 thumbnail URL stored in Airtable. Step 7 — Save Everything to Airtable One single table Stores episode title, description, tags, blog draft, social content, thumbnail URL, and transcript. Step 8 — Upload Episode to Buzzsprout Audio file from Google Drive → uploaded via multipart/form-data Title & description set Response returns audio URL and episode ID These are stored in Airtable. Step 9 — Slack Notification Sends message containing: Episode Title Buzzsprout Episode ID Published At Date Thumbnail URL How to Customize Nodes Google Drive Trigger Change the folder ID to monitor a different source directory. OpenAI Metadata Prompt Adjust tone, style, summarization level or tag generation. Social Content Node Modify the prompt to produce longer posts, more thread tweets or add new channels. Image Generation Customize thumbnail style: minimal, realistic, bold text, brand colors, etc. Buzzsprout Upload Node Set episode[published_at] to schedule future releases. Slack Notification Add more fields such as show notes or Airtable record links. Add-Ons (Optional Enhancements) You may extend the workflow with: Auto-post to LinkedIn, X, Instagram, TikTok** via Buffer API Notion page creation** for drafting content Automatic transcript** upload to Google Docs Email notification** to hosts or guests Auto-publish** YouTube video version (using static background + audio) Use Case Examples Podcast Production Automation – Record audio, upload to Drive and get a fully published episode automatically. Content Repurposing Workflow – Turn one audio file into several content formats instantly. Marketing Team Efficiency – Auto-generate social posts for multiple platforms. Client Podcast Management – Agencies can manage episodes with zero manual work. Internal Communications – Convert internal voice memos into polished summaries and blogs. (There can be many more such use cases depending on customization.) Troubleshooting Guide | Issue | Possible Cause | Solution | | ------------------------------------- | ---------------------------------- | -------------------------------------------------------------------- | | Buzzsprout upload missing audio | Wrong field name or missing binary | Ensure file field is binary & set to correct Drive binary property | | Episode title missing in Buzzsprout | OpenAI JSON not parsed correctly | Check parse code & that episode_title exists | | Social content not stored in Airtable | Airtable field type mismatch | Convert arrays into strings before writing | | Thumbnail not displaying | Expired OpenAI image URL | Regenerate or store static copy in Drive | | Workflow not triggering | Wrong Drive folder ID | Update folder ID in trigger node | Need Help? If you need assistance customizing this workflow, adding new features or building similar automations, WeblineIndia’s n8n automation developers can help you design, optimize and scale enterprise-grade n8n workflows. Feel free to reach out for professional support anytime.

How it works The workflow detects incoming job-application emails, extracts resumes, and parses them for AI analysis. It evaluates each candidate against three open roles and assigns a fit score with structured reasoning. Low-scoring applicants are stored for review, while strong candidates move into an automated scheduling flow. The system checks availability on the next business day, books the slot, sends a confirmation email, and records all details in Airtable. Step-by-step Detect and collect job-application data Gmail Trigger1** – Monitors inbox for all new emails. Message a model2** – Classifies whether the email is a job application. If2** – Continues only when the AI result is YES. Get a message1** – Fetches the full message and attachments. Upload file1** – Uploads the resume to Google Drive. Extract from File1** – Converts the PDF resume into text. Analyze the resume and evaluate fit Available Positions1** – Defines the three open roles. Message a model3** – Produces recommended role, fit score, strengths, gaps, skills, and reasoning. If3** – Routes candidates based on fit_score ≥ 8. Create a record3** – Stores lower-scoring applicants in Airtable. Get Next Business Day1** – Calculates the schedule window for qualified candidates. Check availability on the next business day AI Agent1** – Orchestrates availability search using calendar nodes. Get Events1** – Retrieves events for the target day. Check Availability1** – Evaluates free 1-hour slots. OpenAI Chat Model2** – Reasoning engine for the agent. Structured Output Parser1** – Returns clean JSON with start_time and end_time. OpenAI Chat Model3** – Supports structured parsing. Schedule the interview and notify the candidate Create an event1** – Books the interview in Google Calendar. Send a message1** – Sends an HTML confirmation email to the candidate. Create a record2** – Saves shortlisted candidate and interview data in Airtable. Why use this? Removes manual screening by automating email intake and resume parsing. Ensures consistent AI-based role matching and scoring. Books interviews automatically using real calendar availability. Keeps all applicant and scheduling data organized in Airtable. Provides a fully hands-off, end-to-end hiring pipeline.

This n8n template demonstrates how to automate YouTube content repurposing using AI. Upload a video to Google Drive and automatically generate transcriptions, A/B testable titles, AI thumbnails, short-form clips with captions, and YouTube descriptions with chapter timestamps. Use cases include: Content creators who publish 1-2 long-form videos per week and need to extract 5-10 short-form clips, YouTube agencies managing multiple channels, or automation consultants building content systems for clients. Good to know Processing time is approximately 10-15 minutes per video depending on length Cost per video is roughly $1.00 (transcription $0.65, AI generation $0.35) YouTube captions take 10-60 minutes to generate after upload - the workflow includes automatic polling to check when captions are ready Manual steps still required: video clipping (using provided timestamps), social media posting, and YouTube A/B test setup How it works When a video is uploaded to Google Drive, the workflow automatically triggers and creates an Airtable record The video URL is sent to AssemblyAI (via Apify) for transcription with H:MM:SS.mmm timestamps GPT-4o-mini analyzes the transcript and generates 3 title variations optimized for A/B testing When you click "Generate thumbnail" in Airtable, your prompt is optimized and sent to Kie.ai's Nano Banana Pro model with 2 reference images for consistent branding After uploading to YouTube, the workflow polls YouTube's API every 5 minutes to check if auto-generated captions are ready Once captions are available, click "Generate clips" and Grok 4.1 Fast analyzes the transcript to identify 3-8 elite clips (45+ seconds each) with proper start/end boundaries and action-oriented captions GPT-4o-mini generates a YouTube description with chapter timestamps based on the transcript All outputs are saved to Airtable: titles, thumbnail, clip timestamps with captions, and description How to use Duplicate the provided Airtable base template and connect it to your n8n instance Create a Google Drive folder for uploading edited videos After activating the workflow, copy webhook URLs and paste them into Airtable button formulas and automations Upload your edited video to the designated Google Drive folder to trigger the system The workflow automatically generates titles and begins transcription Add your thumbnail prompt and 2 reference images to Airtable, then click "Generate thumbnail" Upload the video to YouTube as unlisted, paste the video ID into Airtable, and check the box to trigger clip generation Use the provided timestamps to manually clip videos in your editor Copy titles, thumbnail, clips, and description from Airtable to publish across platforms Requirements Airtable account (Pro plan recommended for automations) Google Drive for video upload monitoring Apify account for video transcription via AssemblyAI actor OpenAI API key for title and description generation (GPT-4o-mini) OpenRouter API key for clip identification (Grok 4.1 Fast) Kie.ai account for AI thumbnail generation (Nano Banana Pro model) YouTube Data API credentials for caption polling Customising this workflow Tailor the system prompts to your content niche by asking Claude to adjust them without changing the core structure Modify the clip identification criteria (length, caption style, number of clips) in the Grok prompt Adjust thumbnail generation style by updating the image prompt optimizer Add custom fields to Airtable for tracking performance metrics or additional metadata Integrate with additional platforms like TikTok or Instagram APIs for automated posting

AI Sales Analyst & Lead Router This n8n template handles the post-call process for your business. It uses the call recording to extract valuable data and handles the prospect based on their budget. Some use cases: Sales follow-ups, auto-qualifying leads based on budget, monetizing low-budget leads, and automatic data entry. How it works Ingestion: When a call recording is uploaded to a specific Google Drive folder, the workflow is triggered. Transcription: OpenAI's model transcribes the call recording. Analysis: The GPT-4o model analyzes the transcript and extracts crucial information. Lead classification: The extracted budget is checked against your defined threshold (e.g., $5,000). Hot leads (Budget > 5k): The workflow logs the data in Airtable (CRM), creates a high-priority task, and instantly alerts the team via a Slack channel. Warm leads (Budget < 5k): The workflow logs the data, creates a low-priority task, and emails the lead, offering a cheaper alternative. Logging: Every execution is logged in Airtable. How to use the workflow Configure Google Drive: Open the Trigger node and select the destination folder for the call recordings. Set your Threshold: Open the If node and set your desired budget (currently set to 5,000). Customize the email: Open the Gmail node in Phase 2B and modify the email according to your own preferences. Database mapping: Ensure that your Airtable base has the following columns: Client Name, Budget, Sentiment, Summary, Date, and Timeline. Test it out! Generate a sample audio file on ElevenLabs and upload it to your Google Drive folder. Requirements Google Drive** (For storing audio recordings) OpenAI API Key** (Access to OpenAI models) Airtable** (For CRM and System Logging) Trello** (For Task Management) Slack** (For Team Notifications) Gmail** (For sending automated emails)

How it works This template creates a fully automated "hands-off" pipeline for processing financial documents. It's perfect for small businesses, freelancers, or operations teams who want to stop manually entering invoice and receipt data. When you drop a new image/multiple images file into a specific Google Drive folder, this workflow automatically: Triggers and downloads the new file. Performs OCR on the file using a local AI model (Nanonets-OCR-s) to extract all the raw text. Cleans & Structures the raw text using a second local AI model (command-r7b). This step turns messy text into a clean, predictable JSON object. Saves the structured data (like InvoiceNumber, TotalAmount, IssueDate, etc.) to a new record in your Airtable base. Moves the original file to a "Done" or "Failed" folder to keep your inbox clean and organized. Requirements Google Drive Account:** For triggering the workflow and storing files. Airtable Account:** To store the final, structured data. Ollama (Local AI):** This template is designed to run locally for free. You must have Ollama running and pull two models from your terminal: ollama pull benhaotang/Nanonets-OCR-s:F16 ollama pull command-r7b:7b-12-2024-q8_0 How to set up Setup should take about 10-15 minutes. The workflow contains 7 sticky notes that will guide you step-by-step. Airtable: Use the link in the main sticky note ([1]) to duplicate the Airtable base to your own account. Ollama: Make sure you have pulled the two required models listed above. Credentials: You will need to add three credentials in n8n: Your Google Drive (OAuth2) credentials. Your Airtable (Personal Access Token) credentials. Your Ollama credentials. (To do this, create an "OpenAI API" credential, set the Base URL to your local server (e.g., http://localhost:11434/v1), and use ollama as the API Key). Follow the Notes: Click through the workflow and follow the numbered sticky notes ([1] to [6]) to connect your credentials and select your folders for each node. How to customize the workflow Use Cloud AI:** This template is flexible! You can easily swap the local Ollama models for a cloud provider (like OpenAI's GPT-4o or Anthropic's Claude 3). Just change the credentials and model name in the two AI nodes (OpenAI Chat Model and Data Cleaner). Add More Fields:** To extract more data (e.g., SupplierVATNumber), simply add the new field to the prompt in the Data Cleaner node and map it in the AirTable - Create a record1 node.

This n8n workflow receives files sent in a Telegram chat, uploads them to Google Drive, extracts text using OCR (for images and PDFs), and stores the extracted content in Airtable for quick search and retrieval. Users can later search through documents using a Telegram /search command. Key Features Accepts images and documents from Telegram Uploads files to Google Drive automatically Detects file type and runs OCR if eligible Extracts text from images & PDFs via Google Vision Stores file metadata + text in Airtable Search documents using /search command in Telegram Sends result previews and file links Error handling & user notifications included Use Cases Personal document vault with search Team knowledge filing system Receipt & invoice OCR archive Legal documents store & retrieval Research papers & notes indexing Company file inbox for AI knowledge base Workflow Steps | Step | Action | Description | | ---- | --------------------- | ---------------------------------------------------------- | | 1 | Telegram Trigger | Detects incoming docs/images or /search command | | 2 | Filter File or Search | Routes based on whether message has file or search command | | 3 | Extract Metadata | Reads file info such as name, MIME type, user | | 4 | Download File | Downloads file via Telegram API | | 5 | Upload to Drive | Saves file in Google Drive | | 6 | OCR Check | Determines if file supports OCR | | 7 | Google OCR | Runs OCR for images/PDFs | | 8 | Extract Text | Pulls text output from OCR | | 9 | Merge OCR Text | Combines file data + text | | 10 | Save to Airtable | Indexes with metadata + text | | 11 | Success Reply | Sends link + success message | | 12 | /search Flow | Parse search query | | 13 | Airtable Search | Full-text search for records | | 14 | Send Results | Sends matches to Telegram | | 15 | Error Handler | Notifies user on failure | Input Formats File Messages Supported Images PDFs Documents Search Command /search keyword Example: /search invoice Output After Upload: ✅ File saved & indexed successfully! 🔗 Drive Link: <link> After Search: Returns structured result: File name Preview text snippet Google Drive link Data Stored in Airtable | Field | Description | | ------------- | ------------------------- | | File Name | Original name | | File Link | Google Drive link | | MIME Type | File type | | Telegram User | Sender info | | OCR Text | Extracted searchable text | | Uploaded Date | Timestamp | Technical Requirements Telegram Bot Token Google Drive API connection Google Vision API key Airtable API key & table Benefits Automatically organizes Telegram files Makes PDFs & images searchable Saves manual sorting and indexing time AI-ready data storage (future LLM integration) Fast search experience right in Telegram Enhancement Ideas Add Whisper for voice message transcription Add chat GPT summarization for large docs Build dashboard for uploaded files Auto-tag documents (invoice, ID, receipt etc.) Multi-language OCR support Status ✅ Ready for production ✅ Handles images, PDFs, and files ✅ End-to-end automation 🛠 Optional: add more AI enrichment later

🚀 HR Resume Screening Workflow — Smart Hiring on Autopilot 🤖 🎯 Overview: "This workflow builds an AI-powered resume screening system inside n8n. It begins with Gmail and Form triggers that capture incoming resumes, then uploads each file to Google Drive for storage. The resume is downloaded and converted into plain text, where two branches run in parallel: one extracts structured contact details, and the other uses an AI agent to summarize education, job history, and skills while assigning a suitability score. A cleanup step normalizes the data before merging both outputs, and the final candidate record is saved into Google Sheets and Airtable, giving recruiters a centralized dashboard to identify top talent quickly and consistently.” 🔑 Prerequisites: To run this workflow successfully, you’ll need: Gmail OAuth** → to read incoming resumes. Google Drive OAuth** → to upload and download resume files. Google Sheets OAuth** → to save structured candidate records. Airtable Personal Access Token** → for dashboards and record-keeping. OpenAI / OpenRouter API Key** → to run the AI summarizer and evaluator. ⚙️ Setup Instructions: Import the Workflow Clone or import the workflow into your n8n instance. Add Credentials Go to n8n → Credentials and connect Gmail, Google Drive, Google Sheets, Airtable, and OpenRouter/OpenAI. Configure Key Nodes Gmail Trigger → Update filters.q with the job title you are hiring for (e.g., "Senior Software Engineer"). Google Drive Upload → Set the folderId where resumes will be stored. Google Sheets Node → Link to your HR spreadsheet (e.g., “Candidates 2025”). Airtable Node → Select the correct base & table schema for candidate records. Test the Workflow Send a test resume (via email or form). Check Google Sheets & Airtable for structured candidate data. Go Live Enable the workflow. It will now run continuously and process new resumes as they arrive. 📊 End-to-End Workflow Walkthrough: 🟢 Section 1 – Entry & Intake Nodes: 📧 Gmail Trigger → Polls inbox every minute, captures job application emails, and downloads resume attachments (CV0, CV1, …). 🌐 Form Trigger → Alternate entry for resumes submitted via a careers page or job portal. ✅ Quick Understanding: Think of this section as the front desk of recruitment - resumes received either by email or online form, and the system immediately grabs them for processing. 📂 Section 2 – File Management Nodes: ☁️ Upload File (Google Drive) → Saves the incoming resume into a structured Google Drive folder, naming it after the applicant. ⬇️ Download File (Google Drive) → Retrieves the stored resume file for further processing. 🔎 Extract from File → Converts the resume (PDF/DOC) into plain text so the AI and extractors can work with it. ✅ Quick Understanding: This is your digital filing room. Every resume is safely stored, then converted into a readable format for the hiring system. 🤖 Section 3 – AI Processing (Parallel Analysis) Nodes: 🧾 Information Extractor → Pulls structured contact information (candidate name, candidate email and candidate phone number) using regex validation and schema rules. 🤖 AI Agent (LangChain + OpenRouter) → Reads the full CV and outputs: 🎓 Educational Qualifications 💼 Job History 🛠 Skills Set 📊 Candidate Evaluation Score (1–10) 📝 Justification for the score ✅ Quick Understanding: Imagine having two assistants working in parallel, one quickly extracts basic contact info, while the other deeply reviews the CV and gives an evaluation. 🛠️ Section 4 – Data Cleanup & Merging Nodes: ✏️ Edit Fields → Standardizes the AI Agent’s output into a consistent field (output). 🛠 Code (JS Parsing & Cleanup) → Converts the AI’s free-text summary into clean JSON fields (education, jobHistory, skills, score, justification). 🔗 Merge → Combines the structured contact info with the AI’s evaluation into a single candidate record. ✅ Quick Understanding: This is like the data cleaning and reporting team, making sure all details are neat, structured, and merged into one complete candidate profile. 📊 Section 5 – Persistence & Dashboards Nodes: 📑 Google Sheets (Append Row) → Saves candidate details into a Google Sheet for quick team access. 🗄 Airtable (Create Record) → Stores the same structured data into Airtable, enabling dashboards, analytics, and ATS-like tracking. ✅ Quick Understanding: Think of this as your HR dashboard and database. Every candidate record is logged in both Google Sheets and Airtable, ready for filtering, reporting, or further action. 📊 Workflow Overview Table: | Section | Key Roles / Nodes | Model / Service | Purpose | Benefit | | --- | --- | --- | --- | --- | | 📥 Entry & Intake | Gmail Trigger, Form Trigger | Gmail API / Webhook | Capture resumes from email or forms | Resumes collected instantly from multiple sources | | 📂 File Management | Google Drive Upload, Google Drive Download, Extract from File | Google Drive + n8n Extract | Store resumes & convert to plain text | Centralized storage + text extraction for processing | | 🤖 AI Processing | Information Extractor, AI Agent (LangChain + OpenRouter) | Regex + OpenRouter AI {gpt-oss-20b (free)} | Extract contact info + AI CV analysis | Candidate details + score + justification generated automatically | | 🛠 Data Cleanup & Merge | Edit Fields, Code (JS Parsing & Cleanup), Merge | n8n native + Regex Parsing | Standardize and merge outputs | Clean, structured JSON record with all candidate info | | 📊 Persistence Layer | Google Sheets Append Row, Airtable Create Record | Google Sheets + Airtable APIs | Store structured candidate data | HR dashboards & ATS-ready records for easy review and analytics | | 🔄 Execution Flow | All connected | Gmail + Drive + Sheets + Airtable + AI | End-to-end automation | Automated resume → structured record → recruiter dashboards | 📂 Workflow Output Overview: Each candidate’s data is standardized into the following fields: Candidate Name Candidate Email Contact Number Educational Qualifications Job History Skills Set AI Score (1–10) Justification 📌 Example (Google Sheet row): 📊 Benefits of This Workflow at a Glance: ⏱️ Lightning-Fast Screening** → Processes hundreds of resumes in minutes instead of hours. 🤖 AI-Powered Evaluation** → Automatically summarizes candidate education, work history, skills, and gives a suitability score (1–10) with justification. 📂 Centralized Storage** → Every resume is securely saved in Google Drive for easy access and record-keeping. 📊 Data-Ready Outputs** → Structured candidate profiles go straight into Google Sheets and Airtable, ready for dashboards and analytics. ✅ Consistency & Fairness** → Standardized AI scoring ensures every candidate is evaluated on the same criteria, reducing human bias. 🛠️ Flexible Intake** → Works with both Gmail (email applications) and Form submissions (job portals or career pages). 🚀 Recruiter Productivity Boost** → Frees HR teams from manual extraction and data entry, allowing them to focus on interviewing and hiring the best talent. 👉 Practical HR Use Case: “Screen resumes for a Senior Software Engineer role and shortlist top candidates.” Gmail Trigger → Captures incoming job applications with CVs attached. Google Drive → Stores resumes for record-keeping. Extract from File → Converts CVs into plain text. Information Extractor → Pulls candidate name, email, and phone number. AI Agent → Summarizes education, job history, skills, and assigns a suitability score (1–10). Code & Merge → Cleans and combines outputs into a structured candidate profile. Google Sheets → Logs candidate data for quick HR review. Airtable → Builds dashboards to filter and identify top-scoring candidates. ✅ Result: HR instantly sees structured candidate records, filters by score, and focuses interviews on the best talent.

Transform your expense tracking with automated AI receipt processing that extracts data and organizes it instantly. What this workflow does Monitors Google Drive for new receipt uploads (images/PDFs) Downloads and processes files automatically Extracts key data using verified VLM Run node (merchant, amount, currency, date) Saves structured data to Airtable for easy tracking Setup Prerequisites: Google Drive account, Airtable account, VLM Run API credentials, n8n instance. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Configure Google Drive OAuth2, Airtable OAuth2 Create receipt upload folder Add VLM Run API credentials Create Airtable table with columns: Customer, Merchant, Amount, Currency, Date Update folder/table IDs in workflow nodes Test and activate How to customize this workflow to your needs Extend functionality by: Adding expense categories and approval workflows Connecting to accounting software (QuickBooks, Xero) Including Slack notifications for processed receipts Adding data validation and duplicate detection This workflow transforms manual receipt processing into an automated system that saves hours while improving accuracy. > ⚠️ Disclaimer: This workflow requires a self-hosted n8n setup because it uses custom nodes (VLM Run) that are not available on the managed n8n.cloud service.

Simplify expense tracking with AI-powered automation that extracts receipt data and organizes it instantly. What this workflow does Watches Google Drive for new receipt uploads (images/PDFs) Automatically downloads and prepares files for processing Parses key details using the trusted VLM Run node (merchant, customer, amount, currency, date) Stores structured records in Airtable for real-time tracking Setup Prerequisites: Google Drive & Airtable accounts, VLM Run API credentials, n8n instance. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Configure Google Drive OAuth2 and create a receipt upload folder Add VLM Run API credentials Create an Airtable base with fields: Customer, Merchant, Amount, Currency, Date Update folder/base IDs in workflow nodes Test and activate How to customize this workflow to your needs Extend functionality by: Adding categories, budgets, or approval steps Syncing with accounting tools (QuickBooks, Xero) Sending Slack or email alerts for processed receipts Enabling error handling and duplicate checks This workflow eliminates manual data entry and creates a seamless, automated system that saves time and improves accuracy.

🎥 Auto-Save Zoom Recordings to Google Drive + Log Meetings in Airtable This workflow automatically saves Zoom meeting recordings to Google Drive and logs all important details into Airtable for easy tracking. Perfect for teams that want a searchable meeting archive. ⚙️ How It Works Zoom Recording Webhook Listens for recording.completed events from Zoom. Captures metadata (Meeting ID, Topic, Host, File Type, File Size, etc.). Normalize Recording Data A Code node extracts and formats Zoom payload into clean JSON. Download Recording Uses HTTP Request to download the recording file. Upload to Google Drive Saves the recording into your chosen Google Drive folder. Returns the file ID and share link. Log Result Combines Zoom metadata with Google Drive file info. Save to Airtable Logs all details into your Meeting Logs table: Meeting ID Topic Host File Type File Size Google Drive Saved (Yes/No) Drive Link Timestamp 🛠️ Setup Steps Zoom Create a Zoom App → enable recording.completed event. Add the workflow’s Webhook URL as your Zoom Event Subscription endpoint. Google Drive Connect OAuth in n8n. Replace YOUR_FOLDER_ID with your destination Drive folder. Airtable Create a base with table Meeting Logs. Add columns: Meeting ID Topic Host File Type File Size Google Drive Saved Drive Link Timestamp Replace YOUR_AIRTABLE_BASE_ID in the node. 📊 Example Airtable Output | Meeting ID | Topic | Host | File Type | File Size | Google Drive Saved | Drive Link | Timestamp | |------------|-------------|-------------------|-----------|-----------|--------------------|------------|---------------------| | 987654321 | Team Sync | [email protected] | MP4 | 104 MB | Yes | 🔗 Link | 2025-08-30 15:02:10 | ⚡ With this workflow, every Zoom recording is safely archived in Google Drive and logged in Airtable for quick search, reporting, and compliance tracking.

Portrait Photo Upscaler Workflow Overview Automated workflow that retrieves portrait photos from Airtable, upscales them using AI, and stores the enhanced images in Google Drive with organized folder structure. Features Automated Folder Creation**: Creates timestamped folders in Google Drive AI-Powered Upscaling**: Uses Replicate's Real-ESRGAN for 2x image enhancement Batch Processing**: Handles multiple images efficiently with loop processing Error Handling**: Continues processing even if individual images fail Airtable Integration**: Retrieves images from specified database records Prerequisites Required Credentials Google Drive OAuth2 API**: For folder creation and file uploads Airtable Token API**: For accessing image records Replicate HTTP Header Auth**: For AI upscaling service Airtable Setup Column name: PortraitFotoAuswahl Column type: Attachment field containing image files Required: Valid Airtable Base ID and Table ID Workflow Steps Manual Trigger: Initiates the workflow execution Create Folder: Generates new Google Drive folder with custom name Get Airtable Record: Retrieves specified record containing portrait images Extract URLs: Processes attachment URLs from Airtable field Loop Processing: Iterates through each image for individual processing AI Upscaling: Enhances images using Replicate's Real-ESRGAN (2x scale) Download Results: Retrieves processed images from Replicate Upload to Drive: Stores enhanced images in created folder Configuration Required Inputs Folder Name**: Custom name for Google Drive folder Record ID**: Airtable record identifier containing images Base ID**: (configurable) Table ID**: (configurable) Upscaling Settings Scale Factor**: 2x (configurable) Face Enhancement**: Disabled (configurable) Model**: Real-ESRGAN v1.3 Technical Details Node Configuration Error Handling**: Continue on individual failures Response Format**: File binary for image processing Naming Convention**: LoRa{timestamp}.png Batch Processing**: Automatic item splitting API Endpoints Replicate**: https://api.replicate.com/v1/predictions Model Version**: nightmareai/real-esrgan:f121d640bd286e1fdc67f9799164c1d5be36ff74576ee11c803ae5b665dd46aa Use Cases Portrait photography enhancement Batch image processing for portfolios Automated content preparation workflows Quality improvement for archived images Output Enhanced images stored in Google Drive Organized folder structure with timestamps Preserved original filenames with processed variants Failed processes continue without stopping workflow Template Benefits Scalable**: Processes unlimited images in single execution Reliable**: Built-in error handling and continuation logic Organized**: Automatic folder management and file naming Professional**: High-quality AI upscaling for commercial use

WordPress Blog Automation with human-in-the-loop and deeper research in Airtable v2 Take full control of your AI-powered content creation with this advanced human-in-the-loop workflow. Designed for power users who demand both automation and editorial oversight, this template transforms Airtable into a command center for producing deeply researched, long-form articles and publishing them directly to WordPress. This system elevates content creation by introducing a hierarchical structure of chapters and subchapters, allowing you to build comprehensive articles, guides, or even e-books with unparalleled detail. From initial research to final publication, you guide the AI at every critical step \- from content structure to the final visuals \- ensuring the final output is high-quality, brand-aligned, and perfectly structured. This version v2 is a major upgrade from the HUMAN-IN-THE-LOOP Content Automation Pro with Deep Research & Airtable for Power Users \- Collaborative AI for WordPress Blog Automation. For more powerful n8n templates, visit our website at aiautomationpro.org. What's New in V2: Deeper Research & More Control This version introduces significant upgrades for creating more authoritative and well-structured content: Conditional Deeper Research: The workflow now generates both **chapters and subchapters, allowing you to create more detailed, long-form articles with a clear, logical flow. Granular Research and Writing: The AI performs research and writes content at the **subchapter level, resulting in more in-depth and comprehensive articles before automatically compiling them into full chapters. Manual Image Override**: Gain full control over your article's visuals. You can now manually upload your own images for both the featured image and individual chapters, overriding the AI-generated suggestions. Multi-Language Support**: You can now define a target language in the Airtable settings, enabling the AI to generate content for different global audiences. Dynamic WordPress Categorization & Tagging**: The AI intelligently assigns your post to the most relevant existing WordPress categories and generates a list of relevant tags, improving on-site organization and SEO. Simplified Architecture with Native Perplexity Node:** Thanks to updates in n8n's Perplexity node, the separate "Research Tool" sub-workflow has been eliminated. All research calls are now made directly within the Main Flow. This simplifies the template's structure from three workflows down to two, making it easier to set up, manage, and debug. What it does Fully automated content generation tools often lack the nuance, accuracy, and strategic control necessary for truly impactful content. This workflow solves that critical gap by integrating powerful AI capabilities into a structured, human-supervised content creation process. It automates the most repetitive tasks \- like research gathering and chapter ideation \- while embedding essential human review points at critical junctures. Instead of simply providing a topic and receiving a finished article of uncertain quality, you actively guide the process step-by-step. This approach makes it perfect for creating high-quality, deeply researched, and brand-aligned blog posts for WordPress more efficiently, without ever sacrificing editorial control. Who is this for? This workflow template is meticulously designed for individuals and teams who seek a powerful blend of AI-driven efficiency and human-controlled quality assurance: Content Creators & Bloggers:** Who want to leverage AI for drafting and research but maintain full editorial control. Marketing Teams:** Looking to scale content production while ensuring brand voice and quality consistency. SEO Specialists:** Needing to produce well-researched, structured, and SEO-optimized content regularly. Agencies:** Managing content creation for multiple clients with a structured, repeatable process. Anyone who prefers a "human-in-the-loop" approach** over fully automated "black box" content generators. How it works This template automates the WordPress content creation process using Airtable as the central hub and leveraging AI for research and copywriting. The system is composed of four interconnected processes within a single workflow, each triggered by specific changes in Airtable. Content Creation Process in Airtable The entire journey from idea to published post is managed within your Airtable base. Configure Settings: Define global parameters (website details, target audience, writing style, language, max word count, numbers of chapters and subchapters, etc.) in the “Settings” table. Create Topics: Add a new blog post idea and trigger the first process. Generate Chapters: The workflow performs online research and generates potential chapters and subchapters based on your topic. Select Chapters to Write: Review the suggested chapters and trigger the content generation phase. Generate Content: The second process researches each subchapter and generates draft content for your review and modification. Select Chapter Content: Approve the content for each chapter. Select Chapter Images: After content is approved, the workflow generates AI images for each chapter. In Airtable, you can review these images and choose to either keep them or manually upload your own for each chapter before triggering the final assembly. Finalize Post: The next process aggregates the content and images, generates the featured image (which you can also manually override in this step), creates the title and SEO metadata, and places the compiled information in the “Finalize Post” table. Publish & Backup Post: The final process publishes the post to your website and creates a backup record with the live URL. n8n Workflow Functions The automation is handled by four separate triggers within the main workflow: Flow 1 (Topic Initiation & Chapter/Subchapter Generation):** Fetches settings, performs initial research, and uses AI to generate chapter and subchapter outlines. Flow 2 (Content Generation & Internal Linking):* Gathers internal links, performs deep research per subchapter*, and uses AI to write draft content. Flow 3 (Post Assembly & Image Generation):** Aggregates text, uses AI for metadata and image prompts, generates chapter images (with manual override), converts content to HTML, and saves the compiled post to Airtable. Flow 4 (WordPress Publishing & Backup):** Fetches finalized data, uploads the selected images, creates the WordPress post with dynamically assigned categories, and creates a backup record. Unique Features Human-in-the-Loop Design:** Guarantees quality through mandatory user review and approval stages within Airtable. Airtable as Control Center:** Utilizes Airtable as an intuitive interface to manage the entire content lifecycle. Manual Image Override**: Maintain complete visual control by manually uploading your own featured and chapter images, overriding the AI-generated options at any stage. Conditional Deeper Research:** Choose on a per-topic basis whether to generate simple chapters or a more detailed structure with chapters and subchapters for maximum depth. Multi-Language Content Generation**: Define your desired output language in the Airtable settings to create content for different global audiences. Multiple-Image Generation:** Generates and adds unique AI images for each chapter, as well as a featured image for the article. Automatic Categorization:** The AI intelligently assigns your post to the most relevant existing categories on your WordPress site. AI-Powered Tag Generation:** The workflow automatically generates a list of relevant SEO tags for your article to improve discoverability. Advanced Internal & External Linking:** Automatically inserts relevant internal links by analyzing your sitemap and includes external source links from its research. Direct WordPress Integration:** Streamlines publication by automatically sending finalized content, metadata, tags, images, and categories to your WordPress site. Rate-Limit Aware:** Includes configurable Wait nodes to prevent API errors during intensive processing. Native Perplexity Integration:** Simplifies online research with n8n's built-in Perplexity node. Requirements Airtable Account:** A free Airtable account is sufficient to start. WordPress Website:** Requires an Application Password with permissions to create posts and upload media. Must have the REST API enabled. OpenAI API Key:** For text and image generation. Perplexity API Key:** Or an API key for your chosen online research tool. Google Drive:** for the backup feature. Setup Step-by-Step Import n8n Workflow: Import the workflow JSON file into your n8n instance. Get Airtable Base: Duplicate the companion Airtable Base template. Find the link to the Airtable Base template in the automated email you received after order confirmation. Do not request access to the Airtable base linked in the n8n template itself, as this is a live production base. Configure Credentials: Add credentials in n8n for Airtable, WordPress, OpenAI, Perplexity, and Google Drive. Connect Workflow Nodes: Assign the correct credentials to every relevant node in the workflow. Configure Airtable Nodes: This step is critical. Warning: When you connect your own Airtable base to a node, n8n will automatically erase all pre-configured field mappings. To prevent losing these settings, you must copy them before connecting your base. Here are two recommended methods. Method 1 \- Side-by-Side Comparison: Import the template twice into n8n. Keep one workflow open as a reference, and customize the other. This allows you to easily copy and paste the field mappings from the original to your version after connecting your base. Method 2 \- Text Editor Method: Before connecting your base, open each Airtable node individually, copy its field settings into a text editor for safekeeping, connect your base, and then paste the settings back into the correct fields. Populate Airtable Settings: Fill in your details in the "Settings" table of your Airtable base. Activate Workflow: Toggle the "Active" switch ON for the workflow in n8n. Start Creating: Go to the "Create Topics" table in Airtable to begin. Go through all the tables in Airtable from left to right to complete all the steps of the content creation process and get the final blog post at the end. Finalize SEO in WordPress: The workflow saves the generated SEO meta title and meta description to the Backup Post table in your Google Sheet. After the post is created in WordPress (as a draft), you must manually copy these values from the table and paste them into your SEO plugin's fields (e.g., Yoast, Rank Math) on the WordPress post editor. Tips for Pros AI Models:** The workflow is optimized for OpenAI's GPT-4o. You can swap in alternatives, but performance may vary. Perplexity's "sonar" model is used for research due to its speed and cost-effectiveness. AI Prompts:** Modify prompts in the AI nodes to refine tone, style, or formatting. Integrations:** Replace research tools, image generators, or modify the final step to publish to a different CMS. Error Handling:** For production reliability, connect an "Error Handling" workflow in n8n to catch failures and send notifications. Important Considerations API Rate Limits:* The included Wait* nodes help mitigate API rate limits, but may need adjustment based on your usage and API plans. Testing Costs:** API calls to AI models are not free. Monitor your usage and costs on your provider's billing dashboard. Sequential Processing:** The workflow processes one topic at a time to ensure stability.

📋Instant Proposal Generator Automatically convert sales call transcripts into professional client proposals by extracting key details with AI, dynamically populating Google Slides templates, and tracking progress in Airtable, all in one seamless workflow. 🎯 What does this workflow do? This end-to-end automation creates client-ready proposals by: Taking call transcripts via chat interface The AI analyzes the transcript to extract key details like company name, goals, budget, and requirements, then structures this data as JSON for seamless workflow integration. Generating customized documents using Google Slides template with dynamic variables, Auto populating {Company_Name}, {Budget}, etc. from extracted data. Delivering finished proposals: Sharing final document with client, and Updating CRM status automatically. ⚙️ How it works User input: Paste call transcript in chat trigger node AI analysis: OpenAI node processes text to extract structured JSON, Identifies company name, goals, budget, requirements, etc. Document copy: it copies the file from Google Drive, and name it {company name} proposal. Variables replacement: Replaces all template variables ({Company_Name}, {Budget}, etc.) with extracted data from ChatGPT. Delivery & tracking: Shares finalized proposal with client via email, an Updates Airtable "Lead Status" to "Proposal Sent". 🔑 Required setup OpenAI API Key: Create a key from here Google Cloud Credentials: Setup here Required scopes: Google Slides edit + file creation Airtable Access Token: Create one from here

Who’s it for This workflow is perfect for recruiters, HR professionals, and startup founders who receive job applications by email and want to automate the process of parsing, matching, and evaluating resumes. If you want to save time by having candidate data and AI scores automatically organized in Google Sheets, this workflow is for you. How it works Monitors a Gmail inbox for new emails with resume attachments (PDF) Extracts the job title from the email subject and matches it against open positions stored in Airtable Uploads the resume file to a designated Google Drive folder for storage Builds a prompt with all relevant context and sends it, along with the resume file, to Gemini AI for analysis Gemini scores the candidate, extracts their name and phone, and provides a one-sentence explanation All results—including candidate info, AI score, feedback, and a download link for the resume—are appended as new rows in Google Sheets How to set up Create accounts and APIs: You’ll need Google (Gmail, Drive, Sheets), Airtable, and Gemini API access. Prepare your Airtable base: Add your job descriptions (title, code, description, skills, etc.)—these are matched against incoming applications. Prepare your Google Sheet: Create a spreadsheet to store applicant data and scores. Connect credentials in n8n: Set up Gmail, Google Drive, Google Sheets, Airtable, and Gemini API credentials in n8n’s credential manager. Import this workflow: Use the workflow import feature in n8n and connect your credentials to each node. Test: Send a test application email with a PDF resume to your connected Gmail—watch the data appear in Google Sheets! Requirements Google account with access to Gmail, Drive, and Sheets Airtable account for job data Gemini API key (no hardcoded keys—use n8n environment variables or credentials) n8n instance (cloud or self-hosted) How to customize the workflow Job matching logic**: Edit the EmailMatcher node to fine-tune how subjects are matched to job titles. Scoring criteria**: Adjust the prompt in PromptBuilder to change what Gemini evaluates. Supported file types**: Modify the ReadyAttachment node to accept other resume formats if needed. Sheet columns**: Edit the Google Sheets node to map new data points or change the output format. Notifications**: Add Slack or email nodes to notify you when a strong candidate is found.

Effortless Captions for Your Social Photos – Fully Automated Save time and keep your content fresh. This workflow automatically grabs photos from a Google Drive folder, analyzes them using AI (OpenAI GPT-4o-mini), writes an engaging, Instagram-ready caption, and stores everything neatly in Airtable. Once used, the photo is moved to a separate folder so you never repeat posts. 🔹 Zero coding needed 🔹 Works with Google Drive, OpenAI & Airtable 🔹 No emojis, hashtags, or fluff—just solid, engaging captions 🔹 Perfect for content creators, marketers, and social media teams Built on n8n – open source, customizable, and easy to extend.

Who is this workflow template for? This workflow template is perfect for freelancers, small business owners, accounting teams, or anyone responsible for managing and recording invoices regularly. If you deal with multiple invoices and spend considerable time manually entering invoice data into a database, this automation will significantly simplify your daily operations and reduce potential errors. What this workflow does The workflow automates the entire invoice logging process. It continuously monitors a designated Google Drive folder every minute for new PDF invoice uploads. Once a new invoice is detected, it is automatically converted from PDF to an image format using the ILovePDF API. After conversion, Google's Gemini AI analyzes the image, intelligently extracting essential details such as vendor name, item description, invoice amount, invoice date, payment date, and bank reference numbers. Finally, this structured data is automatically recorded in an Airtable database (or optionally in a Google Sheet), ensuring organized, accessible records. Detailed Workflow Explanation Step 1: Invoice Detection** Monitors Google Drive for newly uploaded PDF invoices. Step 2: PDF to Image Conversion** Converts PDFs into images using ILovePDF. Step 3: Data Extraction via Gemini AI** Uses Gemini AI to analyze the invoice image. Extracts data such as Vendor, Description, Amount, Invoice Date, Paid Date, and Bank Reference. Provides clear descriptions even when original invoice descriptions are vague or missing by analyzing vendor context. Step 4: Structured Data Storage** Automatically sends extracted data to Airtable or Google Sheets. Step 5: File Management** Moves processed PDF files into a separate "Done" folder to clearly differentiate between processed and unprocessed invoices. Step-by-Step Setup Instructions Set Up Google Drive: Log in to Google Drive and create two folders: One named Invoices (for incoming PDF files) One named Processed (for processed files) Obtain API Credentials: ILovePDF API: Sign up at ILovePDF Developers. Retrieve your API key from your account dashboard. Google Gemini AI API: Register at Google AI and generate an API key. Airtable Database Preparation: Create an Airtable base with the following columns: Vendor (Text) Description (Text) Amount (Number or Text) Invoice Date (Date) Paid Date (Date) Bank Reference (Text) Import and Configure Workflow in n8n: Import the provided workflow JSON file into your n8n instance. Connect your Google Drive, ILovePDF, Google Gemini AI, and Airtable accounts by entering your credentials in their respective nodes. Adjust Workflow Settings: In the Google Drive nodes, ensure your newly created Invoices and Processed folders are correctly selected. Update the ILovePDF public key in the appropriate HTTP Request node. Customize the Gemini AI prompt to refine or expand data extraction according to your specific needs. Testing Your Setup: Upload a sample PDF invoice into the Invoices folder. Execute the workflow by clicking Test Workflow in n8n and verify if data extraction and Airtable logging operate correctly. Airtable Column Specifications Ensure your Airtable includes the following structure: Vendor**: Single Line Text Description**: Single Line Text Amount**: Currency or Single Line Text Invoice Date**: Date (formatted as YYYY-MM-DD) Paid Date**: Date (formatted as YYYY-MM-DD) Bank Reference**: Single Line Text How to Customize the Workflow System Prompt:** Adjust the AI instructions by modifying the prompt text to focus on additional or fewer invoice details. Structured Output Parser:** Modify the JSON schema in the parser node to match the structure and data points your project specifically requires: By following these instructions, you’ll have a fully automated, reliable system for handling and logging invoice data, significantly enhancing your productivity.

AI Background Removal Workflow This workflow automatically removes backgrounds from images stored in Airtable using the APImage API 🡥, then downloads and saves the processed images to Google Drive. Perfect for batch processing product photos, portraits, or any images that need clean, transparent backgrounds. The source (Airtable) and the storage (Google Drive) can be changed to any service or database you want/use. 🧩 Nodes Overview Remove Background (Manual Trigger) This manual trigger starts the background removal process when clicked. Customization Options: Replace with Schedule Trigger for automatic daily/weekly processing Replace with Webhook Trigger to start via API calls Replace with File Trigger to process when new files are added Get a Record (Airtable) Retrieves media files from your Airtable "Creatives Library" database. Connects to the "Media Files" table in your Airtable base Fetches records containing image thumbnails for processing Returns all matching records with their thumbnail URLs and metadata Required Airtable Structure: Table with image/attachment field (currently expects "Thumbnail" field) Optional fields: File Name, Media Type, Upload Date, File Size Customization Options: Replace with Google Sheets, Notion, or any database node Add filters to process only specific records Change to different tables with image URLs Code (JavaScript Processing) Processes Airtable records and prepares thumbnail data for background removal. Extracts thumbnail URLs from each record Chooses best quality thumbnail (large > full > original) Creates clean filenames by removing special characters Adds processing metadata and timestamps Key Features: // Selects best thumbnail quality if (thumbnail.thumbnails?.large?.url) { thumbnailUrl = thumbnail.thumbnails.large.url; } // Creates clean filename cleanFileName: (record.fields['File Name'] || 'unknown') .replace(//g, '_') .toLowerCase() Easy Customization for Different Databases: Product Database**: Change field mappings to 'Product Name', 'SKU', 'Category' Portfolio Database**: Use 'Project Name', 'Client', 'Tags' Employee Database**: Use 'Full Name', 'Department', 'Position' Split Out Converts the array of thumbnails into individual items for parallel processing. Enables processing multiple images simultaneously Each item contains all thumbnail metadata for downstream nodes APImage API (HTTP Request) Calls the APImage service to remove backgrounds from images. API Endpoint: POST https://apimage.org/api/ai-remove-background Request Configuration: Header**: Authorization: Bearer YOUR_API_KEY Body**: image_url: {{ $json.originalThumbnailUrl }} ✅ Setup Required: Replace YOUR_API_KEY with your actual API key Get your key from APImage Dashboard 🡥 Download (HTTP Request) Downloads the processed image from APImage's servers using the returned URL. Fetches the background-removed image file Prepares image data for upload to storage Upload File (Google Drive) Saves processed images to your Google Drive in a "bg_removal" folder. Customization Options: Replace with Dropbox, OneDrive, AWS S3, or FTP upload Create date-based folder structures Use dynamic filenames with metadata Upload to multiple destinations simultaneously ✨ How To Get Started Set up APImage API: Double-click the APImage API node Replace YOUR_API_KEY with your actual API key Keep the Bearer prefix Configure Airtable: Ensure your Airtable has a table with image attachments Update field names in the Code node if different from defaults Test the workflow: Click the Remove Background trigger node Verify images are processed and uploaded successfully 🔗 Get your API Key 🡥 🔧 How to Customize Input Customization (Left Section) Replace the Airtable integration with any data source containing image URLs: Google Sheets** with product catalogs Notion** databases with image galleries Webhooks** from external systems File system** monitoring for new uploads Database** queries for image records Output Customization (Right Section) Modify where processed images are stored: Multiple Storage**: Upload to Google Drive + Dropbox simultaneously Database Updates**: Update original records with processed image URLs Email/Slack**: Send processed images via communication tools Website Integration**: Upload directly to WordPress, Shopify, etc. Processing Customization Batch Processing**: Limit concurrent API calls Quality Control**: Add image validation before/after processing Format Conversion**: Use Sharp node for resizing or format changes Metadata Preservation**: Extract and maintain EXIF data 📋 Workflow Connections Remove Background → Get a Record → Code → Split Out → APImage API → Download → Upload File 🎯 Perfect For E-commerce**: Batch process product photos for clean, professional listings Marketing Teams**: Remove backgrounds from brand assets and imagery Photographers**: Automate background removal for portrait sessions Content Creators**: Prepare images for presentations and social media Design Agencies**: Streamline asset preparation workflows 📚 Resources APImage API Documentation 🡥 Airtable API Reference 🡥 n8n Documentation 🡥 ⚡ Processing Speed: Handles multiple images in parallel for fast batch processing 🔒 Secure: API keys stored safely in n8n credentials 🔄 Reliable: Built-in error handling and retry mechanisms

This workflow automatically fetches newly uploaded files from a specific folder in Google Drive, shares them via email with specified recipients, and logs the file details (name, ID, created time, modified time) into Airtable for easy tracking. It streamlines the process of file sharing and management while keeping track of important metadata in a central place. Step-by-Step Instructions Google Drive Node (Fetch New File) Action: This node fetches newly uploaded files from the specific folder you’ve mentioned in your Google Drive. Configuration: Set the folder ID in the Google Drive node where the files are uploaded. Use the “New File in Folder” trigger to automatically detect new files added to the folder. Send Email Node (Share File via Email) Action: After detecting the new file, this node shares the file via email with the recipient you specify. Configuration: Set the recipient's email address. Include the file URL from the Google Drive node in the email body, allowing easy access to the file. Add the file name as part of the email subject or body to notify the recipient about the new file. Airtable Node (Store File Metadata) Action: This node stores the file’s metadata, such as name, ID, creation time, modification time, and the email address to which it was sent, in your Airtable database. Configuration: Set up Airtable with a table. Map the output from the Google Drive node to store the file metadata, and use the email address from the email node for tracking. About WeblineIndia WeblineIndia specializes in delivering innovative and custom AI solutions to simplify and automate business processes. If you need any help, please reach out to us.