Expert n8n Engineer for Multi-Site SEO/AEO/GEO Automation Build (Google Sheets + WP REST)

We are seeking an expert Automation Engineer to build, fully deploy, and test a centralized, multi-site content generation, link-building, and technical monitoring engine using n8n. The goal of this project is to automate the operational heavy lifting across multiple WordPress web properties to optimize for traditional SEO, Answer Engine Optimization (AEO), and Generative Engine Optimization (GEO). The entire infrastructure will be controlled by a centralized database control hub (Notion/Google Sheets) and use low-cost, high-performance LLMs (Gemini Flash / DeepSeek-V3 via OpenRouter). All technical architectures, data models, tracking triggers, and prompt structures have already been mapped out. We are looking for an execution specialist who will write the workflows, hook them up to all of our live target websites, loop them smoothly, and ensure everything is working 100% on the live servers before project close. Scope of Work & Deliverables You will build, connect, and fully verify three separate, decoupled workflows within our n8n environment: Workflow 1: The Automated GEO Publisher & Schema Factory The Build: Read a central database (Content_Pipeline) to identify unsubmitted keywords, cross-reference with a master Sites_Registry tab to fetch target site credentials, scrape top competitor pages via Firecrawl API, generate answer-first content using an LLM node, and automatically publish it to WordPress via the native REST API. The Schema & Indexing: Pass the post back to the LLM to generate highly structured, validated JSON-LD schema (FAQPage/Article/Organization) mapping all core entities, inject it into the WordPress page header, and ping the Google Indexing API to force an immediate crawl. Multi-Site Requirement: You must configure the looping logic so this workflow dynamically cycles through all websites in our registry without hitting API timeouts or mixing up data lines. Workflow 2: The Programmatic Data Magnet Engine (Passive Link Building) The Build: Ingest raw, public industry/cost data feeds, direct an LLM node to synthesize the arrays into a high-density list of 15–20 core industry statistics, and automatically publish a localized authority statistics asset page across the websites in the registry. Workflow 3: The Technical SEO Guardian & Tracking Trigger Loop Technical Check: Run a weekly audit across all root URLs to check server status codes (flagging 404/500 errors) and ping the Google PageSpeed Insights API to capture Core Web Vitals. Performance Slip Trigger: If a site's SEO impressions drop, or if it loses its citation status inside AEO/GEO engine scraps, this node must automatically trigger a targeted update loop, draft an optimization payload, and push it to a "Pending Approval" database queue for review. Alerting: Pipe any critical performance drops or server errors instantly to a Slack/Discord Webhook node. Technical Stack & Constraints Core Automation Platform: n8n (Latest Stable Version). Database / UI: Notion API or Google Sheets API. Scraping Elements: Firecrawl API, native HTTP Request nodes. AI Models: Gemini 1.5 Flash / DeepSeek-V3 via OpenRouter API. Publishing Target: WordPress REST API (Using secure Multi-site Application Passwords). Strict Implementation & Verification Standards End-to-End Hookup: You are responsible for connecting these workflows to every single live website in our portfolio. Delivering a standalone "template" or unhooked workflow is not acceptable. Live Testing Verification: Before milestone release, we will run live end-to-end tests for every site to confirm that content generates properly, schema injects cleanly, index requests fire, and technical errors successfully trigger Slack/Discord alerts. Error Handling & Guardrails: Every API node must be configured with robust error-handling logic (Conditional paths, fallback loops, retry limits, and budget caps) so that an error on one domain does not crash the entire batch run. Budget & Terms Project Type: Fixed Price. Budget: $100 TOTAL. This is a firm, non-negotiable fixed price for the completed build, multi-site hookup, and live testing verification. Do not apply if you cannot deliver the entire functional, multi-site connected architecture within this budget. Let's respect each other's time. To apply, please provide a brief summary of how you plan to handle the multi-site looping structure inside n8n without hitting API timeout limits. Generic, AI-written cover letters that do not reference n8n, WordPress REST API, and the $100 fixed budget for full multi-site deployment will be automatically archived.