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