Meta Ads Data Automation — Ad-Level Reporting Dashboard in Google Sheets (Creative Testing)

We're a DTC e-commerce brand running structured creative testing on Meta. Every ad we launch is planned in a Google Sheet before it goes live. Our naming mirrors Ads Manager exactly: Ad set = batch number → #184 Ads inside it = variations → #184.1, #184.2, #184.3 What we have One thing: a roadmap tab in Google Sheets. It's where we plan each batch — the concept, format, angle, persona, desire, hook. It's been running for 119+ batches and it works well. It stays as-is. What's missing The performance data. Our creative strategy lives in Sheets, our spend lives in Meta, and nothing connects the two. So we can't answer basic questions like "which angle is actually profitable?" What we'd like you to build 1. Pull Meta data into Sheets at the ad level (not ad set level) Spend, impressions, 3-second plays, link clicks, purchases, revenue. Refreshing daily. 2. A creative tab — one row per ad, where each ad's Meta numbers sit next to its specs from the roadmap. Joined on ad name → batch number. 3. A dashboard breaking everything down by Angle, Format, Persona and Desire, showing spend, CPA, ROAS, hook rate and number of ads. I've attached rough mockups of #2 and #3. These are quick mockups I put together to show what I'm after — they don't exist yet. You'd be building them properly. Two things that really matter The numbers need to match Ads Manager. We'll spot-check. We make daily spend decisions from this. Historical data can't disappear. No rolling 30-day windows that wipe older rows. Timeline We're looking to have this implemented within 3 days. After that, we'd like you to stay on for 3 weeks to make sure the data holds up and fix anything that comes up. To apply, please cover these 4 points 1)Which connector would you use, and why? 2) Some proof you've built something similar. Screenshots, a Loom, an anonymised sheet, or a client reference — ideally ad-level Meta → Sheets specifically. 3) How you'd execute it. Short and practical: how you'd connect the data and join it to the roadmap. Proposals that cover all four will be prioritised. We move quickly on our side and would like to get started right away.