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
- 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