Global creative numbering across all brands. Single source of truth — back it up to Google Sheets any time.
Creatives
Add New Creative
TOF
MOF
BOF
Schedule
Performance
Live Platform Tracking (fill once the creative actually goes live)
Custom Metrics — shown on every creative & on the dashboard
Add Brand
E-commerce / D2CLead Generation
🔗 Google Sheet Sync
Backup & share Creative Tracker data via Google Sheets
📋 One-time setup (3 steps): 1. Click "Copy Apps Script Code" below 2. Open script.google.com → New Project → paste code → Deploy → New deployment → Web app
(Execute as: Me | Who has access: Anyone — or restrict to your team's domain) 3. Copy the Web App URL → paste below → Save
🔒 Team access happens here, not in this tool: this file has no login system — anyone with the file can use it. Real access control = who you let access the Apps Script Web App URL and the Google Sheet itself. In step 2, set "Who has access" to specific people or your Workspace domain only. Every teammate who opens this file with the same Sheet URL configured will auto-pull the latest shared data when they open it.
👥 Team Access
How to share this tool so your whole team sees the same data
This file has no login system — it's a single HTML file, not a hosted website. There are 3 things to set up, in order:
Step 1 — Connect Google Sheet (you've likely done this)
Open Google Sheet Sync in the sidebar, set up the Apps Script Web App URL. This Sheet becomes the shared "meeting point" for everyone's data.
Step 2 — Send this exact file to your team
WhatsApp / Email / Google Drive — any way works. Everyone opens it the same way you did: download → double-click → opens in their browser.
Step 3 — Each teammate pastes the SAME Sheet URL
In their copy, they open Google Sheet Sync and paste the same Apps Script URL you used. From then on, the tool auto-pulls the latest data every time they open it, and "Push to Sheet" sends their changes back.
Activity Log & "Acting as" names
These also travel through the same Sheet — but only at the moment someone hits Push or Pull, not instantly. So if Akansha adds her name and edits a creative, Pratham will see her name in his dropdown and her entries in the Activity Log only after he Pulls (and her data only shows up on the Sheet after she Pushes). Everyone's history merges together — no one's log entries or name get overwritten by someone else's sync.
Controlling WHO can access
This is set on the Google side, not in this file:
Restrict the Sheet: open the Google Sheet → Share → add only specific teammate emails
Restrict the Web App: in Apps Script → Deploy → Manage deployments → edit access to "Anyone within [your domain]" or specific people instead of "Anyone"
🔐 Admin Panel
Manage email access — only listed emails can login
Server-backed access control. Invited users receive an email — they click the link to login directly. Only admins can manage the team.
Invite by Email
Enter email address → Choose role → Invite will be sent. User clicks the link, sets their name, and logs in directly.
Member: Can add/edit creatives | Admin: Full access — brands, metrics, delete, team manage