Make.com + OpenAI Automation Engineer for AI Content Intelligence System

I run a fast-growing real estate + lifestyle brand with multiple offers (coaching membership, events, affiliate tools).

We produce high-volume short-form content across:

• TikTok

• Instagram

• YouTube Shorts

I want to build a hybrid AI system (Make.com + OpenAI + Custom GPT integration) that:

1. Ingests my TikTok analytics (CSV exports weekly)

2. Analyzes performance patterns

3. Mines competitor content (via Sandcastles or provided data)

4. Generates high-probability content ideas in my voice

5. Drafts scripts aligned with my tone

6. Tracks performance over time

7. Continuously improves recommendations

This is NOT basic ChatGPT scripting.

This is a structured, data-driven content intelligence system.

⸻

Required Skills

• Make.com (advanced workflows)

• OpenAI API integration

• Data ingestion + transformation (CSV → structured format)

• Prompt engineering

• Experience building automation systems

• Webhook handling

• Google Drive integration

• Optional: TikTok API familiarity (bonus)

⸻

Project Scope (Phase 1)

Phase 1 must include:

1. TikTok analytics ingestion via CSV

2. Pattern extraction engine (hooks, length, engagement metrics)

3. Weekly content intelligence report

4. Script drafting workflow (review-based, not autonomous posting)

5. Storage system for outputs (Google Drive or ClickUp)

Future phases will expand to:

• Competitor mining

• Email campaign suggestions

• Omnichannel repurposing

⸻

Important Constraints

• Must use Make.com for automation layer

• Must integrate OpenAI via API

• Must allow me to edit prompts easily

• Must build modular workflows

• Must provide Loom walkthrough documentation

• No overengineering

⸻

Deliverables

1. Working Make.com scenario(s)

2. OpenAI integration setup

3. Google Drive or ClickUp output system

4. Structured prompt architecture

5. 10–15 minute Loom walkthrough

6. Documentation of architecture

⸻

To Apply

Include:

1. 2 Loom videos of automation systems you’ve built

2. Brief explanation of how you’d structure the feedback loop

3. Confirmation you can build this modularly

4. Your estimated timeline for Phase 1

Apply Now

Apply Now