Airtable + n8n Automation Developer Needed to Build AI-Driven SEO System
Project OverviewI 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 + DraftsFor 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 processMy 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)DeliverablesThe freelancer must build:Airtable BaseTables needed:• Clients• Projects• Organic Keywords• Keyword Clusters• Content(We already have the structure defined.)n8n Workflows1.Workflow 1: SEMrush → Airtable• Pull rankings for client + competitors• Parse and store data2. Workflow 2: Keyword Clustering• Transform raw keywords into clusters with page-type logic3. Workflow 3: Content Generation• Generate outlines + drafts for selected clustersDocumentation• Clear explanation of each flow• How to edit API keys• How to run each workflow• Written guidance for extending the system laterRequired SkillsMandatory• 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 automationsNice-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 & BudgetThis is Phase 1 of a larger automation system.Timeline: 2–4 weeks for a fully functioning V1Potential for long-term work (Phase 2 and Phase 3)Please include in your application:1. A short note on your experience with n8n, Airtable, and API integrations2. Examples of past automation projects3. Confirmation that you understand:• SEMrush API• Airtable linked records• Multi-step flows with decision logic4. Your estimated timeline5. Your hourly rate or fixed bolthires for Phase 1Bonus: If you’ve built anything related to SEO automation, content automation, or AI agents, please include examples.Apply tot his job