The Scenario
You're three weeks out from a site redesign and your CRO lead has just asked for a full inventory of every Proofly campaign running across the five landing pages you manage. She wants to know which notification types are still active, which target URLs are going away in the new architecture, and which campaigns can be archived before the migration.
You open Proofly's dashboard and start clicking. There's no bulk export for campaign metadata in the format she needs — name, type, status, and target URL in a clean sheet. You'd have to click into each campaign individually.
The bad version:
- Open each Proofly campaign one by one, copy the name and notification type into your sheet, switch tabs to grab the target URL, switch back to get the status
- Repeat for all 17 campaigns, losing your place twice because the dashboard session times out mid-way through
- Send the sheet to your CRO lead, realize you grabbed the wrong status for three campaigns that were paused last week, and redo those rows
This inventory is supposed to inform architecture decisions. Sending something with stale statuses isn't a minor inconvenience — it's a reason to delay the whole redesign kickoff. And you have two other pre-migration deliverables sitting in the same queue.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you're working with, and through its built-in Proofly integration it can pull your campaign inventory directly — no dashboard clicks, no tab-switching.
Fetch all Proofly campaigns and write each campaign's name, notification type, status, and target URL into columns A through D of this sheet
What You Get
- Column A: Campaign name as it appears in Proofly
- Column B: Notification type (e.g., recent activity, conversion counter, live visitor count)
- Column C: Enabled or disabled status, current at time of pull
- Column D: The target URL the campaign is set to display on
- One row per campaign, starting at row 2, with headers written automatically in row 1
What If the Data Is Not Quite Ready
The campaigns span multiple domains and the target URL column needs domain-only, not full URL
Fetch all Proofly campaigns into columns A–D of this sheet with name, type, status, and target URL, then add column E that extracts just the domain from each URL in column D
Some campaigns are missing a target URL entirely — you need those flagged separately
Pull all Proofly campaigns into this sheet with name, type, status, and target URL. For any campaign where the target URL is blank, write "MISSING" in column D and add a note in column E saying "needs URL before redesign"
You want to join this against a separate tab that maps old URLs to their new redesign equivalents
Fetch all Proofly campaigns into columns A–D of this sheet. Then look at the URL mapping table in the "Redesign Map" tab — column A is old URL, column B is new URL — and write the mapped new URL for each campaign into column E. If no match is found, write "NOT MAPPED"
You need the full cleanup-plus-audit in one pass before the kickoff meeting
Pull all Proofly campaigns into this sheet. Flag any with missing target URLs in column E. Join against the "Redesign Map" tab and write the mapped new URL in column F. Add column G that marks campaigns as "ARCHIVE" if their current target URL isn't in the redesign map at all. Sort the whole sheet by column G descending so the archive candidates are at the top
The underlying pattern is to combine the data pull, the cleanup logic, and the categorization in a single prompt — rather than pulling first and then layering on formulas.
Try It
Get the 7-day free trial of SheetXAI and open the sheet where you're building your pre-redesign campaign inventory, then ask it to pull your Proofly campaigns with whatever columns and flags you need. If you run A/B tests on notification types, see also: Import Proofly Activity Logs Into a Google Sheet for Engagement Analysis and the Proofly integration hub.