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