Airtable + n8n Automation Developer Needed to Build AI-Driven SEO System
Project Overview I run a digital marketing agency and I am building a custom AI-powered SEO automation system that will replicate and automate our internal SEO processes using Airtable, n8n, SEMrush API, and OpenAI. I am looking for an experienced no-code/automation developer who understands: • n8n (or Make/Zapier equivalents) • Airtable database design • Working with external APIs (SEMrush, OpenAI) • JSON parsing, CSV parsing, webhooks • Basic SEO concepts (category pages, product pages, service pages, keyword research, SERP intent) This project is not for a beginner. You must have experience building multi-step workflows and connecting multiple systems. ⸻ What We Want to Build (Phase 1) We want to create the first version of an automation that will: 1. Pull Keyword Data from SEMrush • Use SEMrush API to fetch current ranking keywords for: • The client’s domain • Competitor domains (multiple) • Parse CSV/JSON • Store all rows inside Airtable (Organic Keywords table) 2. Cluster Keywords Using OpenAI • Take the imported keywords • Use OpenAI to: • Group them into keyword clusters • Determine search intent (Informational, Commercial, Hybrid) • Assign page type (Category, Product, Service, Guide, Blog) • Save each cluster to Airtable (Keyword Clusters table) 3. Generate Content Outlines + Drafts For each keyword cluster marked as “Generate Content”: • Create content outlines using OpenAI • Based on the page type (Category / Product / Service) • Generate a full content draft • Write outputs back to Airtable (Content table) 4. Follow a defined SEO process My SEO rules (which the system must use): • Category seeds = broad product types • Product seeds = existing ranking keywords or main product terms • Service seeds = main service or sub-service keywords • Clustering logic = SERP similarity + intent • Page type = based on commercial vs informational intent • Content structures will be provided • Approval required before publishing (no auto-publish yet) ⸻ Deliverables The freelancer must build: Airtable Base Tables needed: • Clients • Projects • Organic Keywords • Keyword Clusters • Content (We already have the structure defined.) n8n Workflows 1. Workflow 1: SEMrush → Airtable • Pull rankings for client + competitors • Parse and store data 2. Workflow 2: Keyword Clustering • Transform raw keywords into clusters with page-type logic 3. Workflow 3: Content Generation • Generate outlines + drafts for selected clusters Documentation • Clear explanation of each flow • How to edit API keys • How to run each workflow • Written guidance for extending the system later ⸻ Required Skills Mandatory • n8n (advanced workflow building) • Airtable (linked tables, base design) • SEMrush API experience (or similar SEO API experience) • OpenAI API usage (prompting, JSON mode, handling long responses) • Strong understanding of structured data and parsing • Ability to build stable, error-handled automations Nice-to-Have • Understanding of SEO • Experience building AI agent workflows • Experience with Make.com • Experience with WordPress API or Webflow API (future phases) Project Scope & Budget This is Phase 1 of a larger automation system. Timeline: 2–4 weeks for a fully functioning V1 Potential for long-term work (Phase 2 and Phase 3) ⸻ How to Apply Please include in your application: 1. A short note on your experience with n8n, Airtable, and API integrations 2. Examples of past automation projects 3. Confirmation that you understand: • SEMrush API • Airtable linked records • Multi-step flows with decision logic 4. Your estimated timeline 5. Your hourly rate or fixed cost for Phase 1 Bonus: If you’ve built anything related to SEO automation, content automation, or AI agents, please include examples. Apply tot his job