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 Apply To this Job