DeepSeek Chat Model and Google Gemini Chat Model integration

Who Is This For? 🚘This workflow is designed for auto service / car repair businesses looking to streamline their social media marketing with Ai tools and automation via n8n. Whether you’re a small garage owner, a car repair shop, an automotive specialist or automechanic - this tool helps you maintain an active online presence without spending hours creating content. 💪🏼 Though this template is set up for Auto Service daily content uploads, but the underlying logic is universal. You can easily adapt it for any niche by editing prompts, adding nodes, and creating or uploading a variety of content to any platform. You can use any LLM and generative AI of your choice. Personally, I prefer the smooth and effective results from ChatGPT 4.1 combined with GPT Image 1. But you can generate videos instead of images for your posts as well 😉 What Problem Is This Workflow Solving? 🤦‍♂️ Many auto service businesses struggle with consistently posting engaging content due to time constraints or lack of marketing expertise. 💎This workflow solves that by automating the content creation and posting process, ensuring your social media channels stay fresh and active, ultimately attracting more customers. What This Workflow Does: Generates daily social media posts tailored specifically to the auto service niche using AI. Allows easy customization of post and image prompts. Integrates research links through the Tavily Internet Search tool for relevant content. Supports starting posts based on reference article links via Google Sheets. Automatically publishes posts to your connected social media platforms. Enables scheduled or trigger-based posting for maximum flexibility. How It Works? Easy, actually ☺️ AI creates daily social media content made just for Auto Service. You can simply edit prompts for both posts and images, set up news or articles research links via the Tavily Internet Search tool. You can also start the workflow with a reference article link through Google Sheets. 🎯 Consistently posting relevant and actual niche content helps attract new customers, all while leveraging AI and n8n tools to keep the process seamless and cost-effective. Set Up Steps: I kept it quick and simple for you ✨ If you’re happy with the current LLM and image model configurations, just connect your OpenAI API credentials to enable AI content generation. Link your social media accounts (Facebook, Telegram, X, etc.) for autoposting. Optionally connect Google Sheets if you want to trigger posts based on sheet updates with reference links. Customize prompts as needed to match your brand voice, style and marketing tasks. Choose between: 1) Scheduled automatic generation and posting at the same time as socials algorythms like it. 2) Google Sheets trigger with reference. 3) Manual start. How to Customize This Workflow to Your Needs? Switch AI models and edit prompts to better reflect your specific services or promotions. Add or modify research links in Tavily to keep your posts timely and relevant. Adjust posting schedules to match peak engagement times for your audience. Expand or reduce the number of social platforms integrated depending on your marketing strategy. Use Google Sheets to batch upload ideas or curate specific content topics. After adjusting a few settings, activate the workflow and let it run. 🤖 The system will then automatically publish your content across your selected social platforms — saving you time and effort. 📌 You’ll find more detailed tips and additional ai models for customizing ai generation process inside the workflow via sticky notes. 💬 Need help? For additional guidance, feel free to message me — here’s my profile in the n8n community for direct contact 👈 click!

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

This workflow automates the complete blog publishing process. It removes manual work from content creation, image generation, category management, and WordPress publishing by using AI and n8n. It helps agencies, SEO teams, and content creators manage blogs at scale. Key Features Scheduled or manual blog publishing Automated topic research and content writing AI-generated featured and in-content images using Ideogram Dynamic WordPress category detection and creation Automatic media upload with SEO-friendly alt text Internal linking using sitemap data Google Sheets logging for published URLs Error notifications for failed executions What This Workflow Does Input Blog topics or keywords stored in Google Sheets Target WordPress site details Publishing rules and schedule Processing Triggers the workflow on a schedule or manual run Fetches blog posting data from Google Sheets Validates active projects or websites Performs topic and SEO research Writes long-form, SEO-optimized blog content Generates image prompts and creates images using Ideogram Uploads images to WordPress with alt text Detects or creates blog categories dynamically Publishes the blog post to WordPress Output Live published blog post URL Updated Google Sheet with publishing details Notification alerts if any step fails Setup Instructions Prerequisites n8n instance (cloud or self-hosted) WordPress site with REST API access Google Sheets access AI model credentials (Google Gemini, OpenAI, or DeepSeek) Ideogram API access Notification service (Discord or Slack) Step 1: Import the Workflow Download or copy the workflow JSON In n8n, go to Workflows → Import from file / JSON Import the workflow Step 2: Configure Credentials Set up the required credentials inside n8n's credential manager: Google Sheets OAuth**: For reading posting data and saving URLs WordPress API**: For publishing posts and uploading media AI Model**: Connect Google Gemini, OpenAI, or DeepSeek Ideogram API**: For AI image generation Discord/Slack Webhook**: For error notifications Important: No credentials are hardcoded. All must be connected via n8n's credential manager. Step 3: Configure Google Sheets Prepare a Google Sheet containing: Blog topic or keyword Target website or domain Publishing status fields Domain ID for tracking Update the Sheet ID inside the Get_Post_Data node after import. Step 4: Configure Website Access Update the PBN_Website_Access node with your WordPress site access endpoint or API. This node should return: Complete WordPress URL Basic authentication token Sitemap post URL Step 5: Configure Publishing & Schedule Adjust the Schedule Trigger if auto-publishing is required Modify publishing frequency or time zone Review WordPress post status (draft or publish) Step 6: Test & Activate Add one test row in Google Sheets Run the workflow manually Verify: Content creation Image generation WordPress publishing Sheet updates Activate the workflow Usage Guide Adding New Blog Posts Add a new row in the connected Google Sheet with the required blog topic and website details. The workflow will automatically process and publish the post on the next execution. Understanding the Output After execution, the workflow: Publishes a complete blog post on WordPress Attaches featured and in-content images Assigns the correct category Logs the live URL back to Google Sheets Workflow Node Breakdown Get_Post_Data Fetches blog posting details from Google Sheets based on the current day. It pulls keywords, landing pages, domain IDs, and posting websites. get_client_status Checks the client's project status from the project sheet. It verifies whether the client is active or inactive before proceeding further. This prevents publishing content for paused or stopped clients. PBN_Website_Access Fetches WordPress website access details such as site URL, authentication token, and sitemap URL. These details are required for publishing posts, uploading images, and managing categories. Do the Research on the Topic Performs deep SEO research on the target keyword. It analyzes search intent, content gaps, and audience needs. This ensures the generated content is informative, relevant, and SEO-optimized. sitemap_crawl (internal_linking) Crawls the website sitemap to collect internal URLs. These URLs are later used for internal linking inside the blog content. Internal links help improve SEO and site structure. write_content Uses AI to write an 800-1000 word SEO-optimized blog article based on research data. The content includes proper HTML formatting, internal links, and anchor keyword placement. extract_title_body Separates the H1 title from the blog body content for proper WordPress publishing format. classify_category Automatically determines the most suitable category for the blog post by analyzing the blog title and content context. This keeps the website's category structure clean and relevant. get_category & create_category Checks if the determined category exists in WordPress. If not, it creates a new category automatically. generate_image_prompt Analyzes the blog content and generates AI prompts for creating relevant images including thumbnail and in-content images. Thumbnail Image Generator & Blog Image Generator Generate high-quality images using Ideogram API based on AI-generated prompts. Images are created with proper resolution and rendering settings. Thumbnail Uploading & Blog Image Uploading Upload generated images to WordPress media library and retrieve media IDs for post attachment. Add Alt Text in Images Adds SEO-friendly alt text to uploaded images to improve accessibility and search engine optimization. Blog and Photo Merge Merges the generated images into the blog content at appropriate positions within the article. publish_blog Publishes the complete blog post to WordPress with title, content, category, featured image, and publish status. save_live_url Saves the live published blog URL back into Google Sheets along with keyword, website URL, and timestamp for tracking and reporting. If Error Existed Then Get Notified Sends instant Discord or Slack notifications when any error occurs during workflow execution, ensuring no failure goes unnoticed. Customization Options Change blog length or tone in the content generation node Modify image style or resolution in Ideogram nodes Add multi-site publishing using Switch nodes Replace notification channel (Discord to Slack or Email) Extend workflow to social media posting Troubleshooting Blog not published Check WordPress credentials and REST API permissions. Images not generated Verify Ideogram API credentials and prompt formatting. Sheet not updating Ensure correct Sheet ID and OAuth permissions. Workflow stopped Review execution logs and error notification messages. Use Cases SEO blog automation for agencies Content publishing for niche websites Scalable blog management AI-assisted content operations Hands-free WordPress publishing Final Notes This workflow is designed to be reusable, scalable, and creator-friendly. It follows n8n best practices, avoids hardcoded credentials, and is suitable for public sharing as a workflow template. For any questions or support, please contact: [email protected] or fill out this form: https://www.incrementors.com/contact-us/

A professional BIM-to-cost pipeline that extracts data from Revit models (2015–2026), classifies elements with AI, decomposes them into construction works, and generates detailed cost estimates using the open-source DDC CWICR database. Produces HTML reports and Excel exports with full resource breakdown. Who's it for BIM Managers** automating quantity takeoff and cost estimation Cost Engineers** integrating 5D workflows into design pipelines Construction Companies** standardizing estimates from Revit models General Contractors** doing rapid budget checks during design MEP Engineers** pricing mechanical/electrical/plumbing systems Developers** building custom BIM-to-cost integrations What it does Extracts BIM data from Revit model via converter (RvtExporter) Classifies building vs non-building elements using AI Detects project type (Residential/Commercial/Industrial) Generates construction phases and assigns element types Decomposes each BIM type into detailed work items Searches DDC CWICR vector database for matching rates Calculates costs with unit mapping and resource breakdown Validates work completeness and checks for gaps Generates professional HTML report + Excel file How it works ┌─────────────────────────────────────────────────────────────────────────────┐ │ REVIT MODEL (.rvt) │ │ Revit 2015–2026 supported │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 1: CONVERSION │ │ RvtExporter.exe → Excel with BIM element schedules │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 2: DATA LOADING & CLASSIFICATION │ │ • Filter 3D View elements only │ │ • AI analyzes headers → aggregation rules (sum/mean/last) │ │ • AI classifies building vs non-building elements │ │ • Hard exclude: Grids, Levels, Annotations, Views, etc. │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 3: PROJECT ANALYSIS (Stages 0–3) │ │ STAGE 0: Collect filtered BIM data │ │ STAGE 1: AI detects project type │ │ STAGE 2: AI generates construction phases │ │ STAGE 3: AI assigns element types to phases │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 4: WORK DECOMPOSITION (Stage 4) │ │ Loop through each BIM type: │ │ • AI decomposes type into work items │ │ • Example: Window → Demolition, Installation, Sealing, Hardware │ │ • Prepares search queries for pricing │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 5: PRICING & CALCULATION (Stages 5–7) │ │ STAGE 5: Vector search in Qdrant (text-embedding-3-large, 3072 dim) │ │ STAGE 6: Map BIM units → Rate units (m² → 100 m²) │ │ STAGE 7: Calculate costs (Qty × Unit Price) │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 6: VALIDATION & AGGREGATION │ │ STAGE 7.5: AI validates work completeness │ │ STAGE 8: Aggregate costs by phases │ └─────────────────────────────────────────────────────────────────────────────┘ ↓ ┌─────────────────────────────────────────────────────────────────────────────┐ │ BLOCK 7: REPORT GENERATION (Stage 9) │ │ • Professional HTML report with expandable rows │ │ • Excel-compatible XLS file │ │ • Auto-opens in browser │ └─────────────────────────────────────────────────────────────────────────────┘ Pipeline Stages | Stage | Name | Description | |-------|------|-------------| | 0 | Collect | Gather filtered BIM data | | 1 | Project Type | AI detects Residential/Commercial/Industrial | | 2 | Phases | AI generates construction phases | | 3 | Assignment | AI assigns element types to phases | | 4 | Decomposition | AI breaks types into work items | | 5 | Vector Search | Query Qdrant for pricing rates | | 6 | Unit Mapping | Convert BIM units to rate units | | 7 | Calculation | Compute costs (Qty × Price) | | 7.5 | Validation | AI checks completeness, finds gaps | | 8 | Aggregation | Sum costs by phases | | 9 | Reports | Generate HTML + XLS outputs | Prerequisites | Component | Requirement | |-----------|-------------| | n8n | v1.30+ with Execute Command node | | Revit Exporter | RvtExporter.exe (provided separately) | | OpenAI API | For embeddings + LLM tasks | | Qdrant | Vector DB with DDC CWICR collections | | DDC CWICR Data | GitHub | | Windows | For Revit converter execution | Setup Configure File Paths In Setup - Define file paths node: { "path_to_converter": "C:\\path\\to\\RvtExporter.exe", "project_file": "C:\\path\\to\\your_project.rvt", "group_by": "Type Name", "language_code": "DE" } Select Language & Region | Code | Language | City | Currency | |------|----------|------|----------| | AR | Arabic | Dubai | AED | | ZH | Chinese | Shanghai | CNY | | DE | German | Berlin | EUR | | EN | English | Toronto | CAD | | ES | Spanish | Barcelona | EUR | | FR | French | Paris | EUR | | HI | Hindi | Mumbai | INR | | PT | Portuguese | São Paulo | BRL | | RU | Russian | St. Petersburg | RUB | Configure AI Model Connect your preferred LLM in the model nodes: | Provider | Model | Notes | |----------|-------|-------| | OpenAI | GPT-4o | Default, recommended | | Anthropic | Claude Opus 4 | High quality | | Google | Gemini 2.5 Pro | Good for large contexts | | xAI | Grok 4 | Fast inference | | DeepSeek | DeepSeek Chat | Cost-effective | | OpenRouter | Various | Multi-model access | Set Up Qdrant Ensure DDC CWICR collections are loaded: DE_BERLIN_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR ENG_TORONTO_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR RU_STPETERSBURG_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR ... Configure OpenAI Credentials Set up OpenAI API credential for: Embeddings (text-embedding-3-large, 3072 dimensions) LLM calls (if using OpenAI as primary model) Features | Feature | Description | |---------|-------------| | 🏗️ Revit Integration | Direct extraction from .rvt files (2015–2026) | | 🤖 Multi-LLM Support | OpenAI, Claude, Gemini, Grok, DeepSeek | | 🔍 Smart Classification | AI separates building from non-building elements | | 📊 Work Decomposition | Breaks BIM types into detailed work items | | 🎯 Vector Search | Semantic matching via Qdrant + OpenAI embeddings | | 🧮 Unit Mapping | Automatic conversion (m² → 100 m², pcs → sets) | | ✅ AI Validation | Checks for missing works and duplications | | 📈 Phase Aggregation | Costs grouped by construction phases | | 📄 HTML Report | Professional report with quality indicators | | 📑 Excel Export | XLS file with formulas and links | | 🌍 9 Languages | Full localization + regional pricing | Hard Exclude Categories The pipeline automatically excludes non-physical elements: Levels, Grids, Reference Planes Annotations, Dimensions, Text Notes Tags, Views, Sheets, Schedules Legends, Viewports, Section Boxes Scope Boxes, Match Lines Model Groups, Detail Groups Entourage (RPC people, cars, plants) Example Output Input: Residential building Revit model (45 element types) Processing: Project type detected: Residential Multi-Family Phases generated: Foundations → Structure → Envelope → MEP → Finishes Types assigned: 45 types → 5 phases Works decomposed: 45 types → 280 work items Rates found: 245/280 (87.5%) Output Files: project_2024-12-08.html → Professional HTML report project_2024-12-08.xls → Excel with full breakdown HTML Report Features: KPI summary (total cost, items, phases) Expandable phase sections Quality indicators (● green/yellow/red) Resource breakdown per work item Clickable rate codes Responsive design Output Structure 📊 Cost Estimate: Residential Building ├── 📁 Phase 1: Foundations │ ├── Foundation walls — 125.5 m³ — €12,450 │ ├── Concrete footings — 45.2 m³ — €8,340 │ └── Waterproofing — 280 m² — €4,200 ├── 📁 Phase 2: Structure │ ├── Concrete columns — 18 pcs — €9,720 │ ├── Floor slabs — 450 m² — €67,500 │ └── Stairs — 3 flights — €8,100 ├── 📁 Phase 3: Envelope │ ├── Exterior walls — 680 m² — €95,200 │ ├── Windows — 42 pcs — €25,200 │ └── Roof system — 225 m² — €33,750 └── 💰 TOTAL: €485,240 Notes & Tips First run:** Conversion takes 1–3 minutes depending on model size Cached conversion:** Subsequent runs skip conversion if Excel exists Testing mode:** Limit to 10 types for faster debugging Rate accuracy:** Depends on DDC CWICR coverage for your region Custom phases:** AI adapts phases based on project type Missing rates:** Flagged with red indicator in report Extending the Pipeline Add custom rates:** Extend Qdrant collection with your pricing Chain to PM tools:** Connect to OpenProject, Monday, Asana Email reports:** Add email node after report generation Cloud storage:** Upload to Google Drive, OneDrive, S3 Webhook trigger:** Replace manual trigger for API access Categories AI · Data Transformation · Document Ops · Files & Storage Tags bim, revit, cost-estimation, 5d-bim, 4d-bim, qdrant, vector-search, openai, construction, quantity-takeoff, html-report, multilingual Author DataDrivenConstruction.io https://DataDrivenConstruction.io [email protected] Consulting & Training We help AEC firms implement: BIM-to-cost automation pipelines 4D/5D integration workflows Custom Revit data extractors AI-powered estimation systems Vector database deployment for construction data Contact us to adapt this pipeline to your Revit templates and regional pricing. Resources DDC CWICR Database:** GitHub Qdrant Documentation:** qdrant.tech/documentation OpenAI Embeddings:** platform.openai.com n8n Execute Command:** docs.n8n.io ⭐ Star us on GitHub! github.com/datadrivenconstruction/DDC-CWICR

An intelligent n8n workflow that automates your entire blog content pipeline—from keyword research to WordPress publishing. Using Google Gemini, DeepSeek, and Perplexity, this workflow generates SEO-optimized blog posts and publishes them automatically while tracking everything in Google Sheets. What this workflow does This automation handles your complete blog creation process: Scheduled content research:** Fetches approved topics from Google Sheets and conducts deep SEO research using Perplexity AI-powered writing:** Uses DeepSeek for competitor analysis and Google Gemini to write 800-1000 word SEO-optimized articles with FAQs Automated publishing:** Publishes directly to WordPress via REST API and updates tracking in Google Sheets Smart scheduling:** Runs daily at 7 AM, respects weekly frequency settings, and processes multiple clients in batches Setup requirements Tools you'll need: Active n8n instance (self-hosted or n8n Cloud) Google Sheets with OAuth access WordPress site with REST API enabled API keys: Google Gemini, DeepSeek, Perplexity (optional) Estimated setup time: 20-25 minutes Step-by-step setup Prepare your Google Sheets Create two sheets: Client projects sheet: Columns: Client ID | Website URL | Blog API | GMB Name | Weekly Frequency | On Page Sheet Example: CLIENT001 | https://example.com | xxxx xxxx xxxx | Example Co | Mon,Wed,Fri | Sheet URL Content topics sheet (one per client, named "Content Requirement & Posting"): Columns: S.No. | Focus Keyword | Content Topic | Internal Linking URLs | Words | Topic Approval | Content Approval | Publish URLs | Weekly Frequency Example: 1 | best investment tips | Top 10 Investment Tips | https://example.com/page | 1000 | Approved | Approved | (empty) | Mon,Wed Connect Google Sheets In n8n: Credentials → Add credential → Google Sheets OAuth2 API Complete OAuth authentication Open "Load Active Client Projects" node → Select your client sheet URL and credential Open "Get Approved Blog Topics from Sheet" node → Select credential (document URL is dynamic) Add AI API credentials Google Gemini: Get API key: https://makersuite.google.com/app/apikey Add credential in n8n: Google PaLM API Select in "Gemini - Content Writing Model" node DeepSeek: Get API key: https://platform.deepseek.com/ Add credential in n8n: DeepSeek API Select in "DeepSeek - Research Model" node Perplexity (optional): Get API key: https://www.perplexity.ai/settings/api Add credential in n8n: Perplexity API Select in "Perplexity - Web Search Tool" node Set up WordPress WordPress admin → Users → Profile → Application Passwords Create new application password (format: xxxx xxxx xxxx xxxx xxxx xxxx) Add to your Google Sheet: Blog API column: Paste application password Website URL column: Enter full URL (e.g., https://example.com) Configure schedule Open "Daily Blog Publishing Schedule" node Set time (recommended: 7:00 AM) Choose timezone Save settings Test and activate Add one test row in your sheets with today's day in Weekly Frequency Click "Daily Blog Publishing Schedule" → Execute node Verify: Blog published in WordPress, URL updated in Google Sheet Toggle workflow Active at the top How it works Schedule & filtering (7 AM daily) Loads client projects from Google Sheets Filters clients by Weekly Frequency (e.g., only those publishing today) Content fetching Loops through each client Fetches approved topics (Topic Approval = "Approved", Publish URLs = empty) Selects first pending topic AI content creation Research phase:** DeepSeek + Perplexity analyze competitors, search intent, content gaps, LSI keywords Writing phase:** Google Gemini writes 800-1000 word article with FAQs in conversational English Publishing Extracts title and body content Publishes to WordPress via REST API Updates Google Sheet with publish URL Continues to next topic/client Key features ✅ Automated research: Deep competitor analysis and SEO insights with Perplexity ✅ Dual AI models: DeepSeek for research, Gemini for writing ✅ SEO optimized: Natural keyword integration, LSI keywords, FAQs ✅ Batch processing: Handles multiple clients and topics in one run ✅ Smart scheduling: Publishes only on specified weekdays ✅ Complete tracking: End-to-end visibility in Google Sheets ✅ WordPress ready: Direct publishing with proper HTML formatting Troubleshooting Google Sheets not connecting: Re-authenticate OAuth credentials Verify sheet URLs and column names match exactly (case-sensitive) Check sharing permissions on sheets AI API errors: Verify API keys are active and have credits Check rate limits on API dashboards Reduce token usage if hitting limits WordPress publishing fails: Test REST API: Visit https://yoursite.com/wp-json/wp/v2/posts Verify application password is correct (with spaces) Ensure user has Author/Editor role Check Website URL includes https:// No topics being processed: Verify Topic Approval = "Approved" and Content Approval = "Approved" Ensure Publish URLs column is empty Check today's day matches Weekly Frequency setting Confirm sheet name is exactly "Content Requirement & Posting" Use cases Marketing agencies: Manage 10+ client blogs, scale without hiring writers SEO teams: Execute keyword strategies at scale with consistent quality Solo bloggers: Save 5-10 hours/week, maintain regular publishing schedule Content teams: Run company blog on autopilot with oversight and tracking Publishers: Operate multiple niche blogs, reduce costs by 70-80% Expected results Time savings:** 5-10 hours per week per client Output:** 10-20 SEO-optimized posts per week SEO impact:** Improved rankings within 2-3 months Cost efficiency:** 70-80% reduction vs. hiring writers Reliability:** Never miss a publishing deadline Workflow Customization & Next Steps This workflow (Part 1) focuses on content research and writing. To complete the full automation, you will need Part 2, which you will get in the next post. Please ensure you set it up as well, as it manages WordPress publishing along with featured images. Resources n8n documentation Google Gemini API DeepSeek API docs WordPress REST API Support Need help or custom development? 📧 Email: [email protected] 🌐 Website: https://isawow.com/