AI Agent Developer for Text Generator (Google Sheets + Gemini + OpenAI)

---

---

We’re building a custom AI Agent to streamline the creation of high-performing ad scripts using real campaign performance data and creative insights. The goal: automate the entire script ideation process, from analyzing top creatives to generating new scripts, using a combination of Google Sheets, Google AI Studio (Gemini API), OpenAI (GPT-4), and no-code automation tools. We’re looking for a full-stack AI workflow builder (freelancer or small team) who can own this from start to finish. What You'll Build: A fully automated agent that: 1. Ingests Campaign Data Reads a structured Google Sheet with creative assets (videos/images), hooks, CTAs, and performance metrics (CPA, CTR, ROAS, spend). Identifies top-performing creatives based on customizable rules. 2. Analyzes Creative Elements Automatically downloads top-performing assets. Uses Gemini API (Google AI Studio) to extract creative patterns (e.g. pacing, visuals, tone, structure). 3. Generates New Ad Scripts Combines campaign performance insights + creative analysis in a structured prompt to GPT-4 (OpenAI). Outputs a fully formatted table with: 3 Hook Variants 8+ Visual Scenes per Script Visual Description Spoken Line Strategic Objective (e.g. grab attention, build trust, drive action) 4. Automates the Workflow Orchestrates the entire process using Zapier, Make, n8n, or Google Apps Script. Outputs stored in Google Sheets, Notion, or Google Docs for easy access by the creative team.

Keyword: Software Development

Price: $3.0

AI Agent Development AI Builder Zapier LLM Prompt Engineering