ChatGPT + Zapier + Sheets integration project
Job Details
Description
Summary I’m looking for an experienced automation specialist to build a scalable analytics system that automatically organizes and updates Instagram and Meta Ads performance data into Google Sheets. This is not just a spreadsheet project. The goal is to build a system that becomes the single source of truth for my organic content, trial reels, Meta ads, and creative performance over time. The finished system should be easy to maintain, highly organized, and built with long-term scalability in mind. ⸻ Current Stack * Google Sheets * Zapier * ChatGPT (GPT-5.5) * Instagram * Meta Ads Manager Future integrations may include: * GHL * Meta API * Google Analytics ⸻ Scope I need someone to: 1. Design a normalized Google Sheets database Rather than one massive spreadsheet, I’d like multiple related tabs. Examples include: * Posts * Performance Snapshots * Audience * Reel Retention * Carousel Analytics * Ads Manager Metrics * Creative Scores * Creative Tags * Experiments / A/B Tests * Benchmarks * Strategy / Insights * Audit Log The structure should be designed for years of growth. ⸻ 2. Build Zapier automations The automation should support: * Creating new posts * Appending new performance snapshots * Updating existing records * Looking up existing posts by Post ID * Updating only specific metrics when needed * Never overwriting historical snapshots ⸻ 3. Create a scalable Post ID system Every piece of content should have a permanent ID. Examples: * R-0001 * C-0001 * P-0001 These IDs will connect every table together. ⸻ 4. Support multiple update types The database needs to handle: Organic Instagram Insights Meta Ads Manager Audience updates Creative analysis Performance updates over time ⸻ 5. Historical snapshots Every time metrics are updated, previous values should remain intact. For example: Initial 7-day 30-day 60-day 90-day Lifetime No historical data should ever be overwritten. ⸻ Metrics The database will track approximately 150–200 metrics including: Instagram Insights Meta Ads Manager Audience demographics Reel retention Hook rate Hold rate Average play time Traffic sources Creative metadata Content classification Business outcomes Derived performance scores Qualitative creative analysis A complete schema has already been designed. ⸻ Deliverables ✅ Google Sheets database ✅ Relationships between tables ✅ Zapier automation(s) ✅ Easy process for adding new data ✅ Documentation explaining how everything works ⸻ Nice to Have Experience with: * Meta Ads Manager * Instagram Insights * Google Apps Script * APIs * Airtable * Data normalization * Dashboard design * Marketing analytics * SQL/database architecture ⸻ About Me I’m a permanent makeup artist and photographer who creates a large amount of educational content. I analyze every post I publish. The purpose of this system is to identify long-term content patterns, improve creative performance, and make future content decisions using data instead of guesswork. ⸻ To Apply Please include: 1. Examples of Google Sheets databases you’ve built. 2. Examples of Zapier automations you’ve created. 3. Experience integrating ChatGPT with Google Sheets. 4. Whether you would recommend Zapier, Make.com, Google Apps Script, or another solution for this project, and why. 5. A brief explanation of how you would architect this system to ensure it remains scalable over time. ⸻ Budget I’m open to either a fixed-price project or hourly, depending on your experience and proposed solution.
Skills
Automation Data Extraction Google Sheets Automation Scripting Zapier Google Sheets ChatGPTNotification History
| Channel | Type | Status | Sent | Error |
|---|---|---|---|---|
| telegram | pre_ai_job_alert | sent | Thu, Jul 2, 2026 6:08 PM | - |
User Actions
| Action | Acted at |
|---|---|
| No actions. | |