The Scenario
You've just been handed a performance review request from the VP of retention — they want to see how every Sendlane campaign has tracked against revenue over the past quarter. You've got the revenue data in column D of your Google Sheet, already tagged by campaign. What you don't have is the campaign IDs to match against.
Your Sendlane account has 40-something campaigns. The UI shows you names. The revenue data uses IDs. And you've never exported a full campaign list before.
The bad version:
- Open the Sendlane dashboard, click into each campaign one by one, copy the campaign ID from the URL bar, and paste it into the sheet.
- Repeat for all 40+ campaigns, tracking which ones you've already pulled so you don't skip any or double up.
- Lose your place when a Slack notification pulls you away, then spend five minutes figuring out where you were in the list.
The review is going to the VP in two hours. Manual ID harvesting from a UI that wasn't designed for it is not where this afternoon needs to go.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that sits inside your Google Sheet, reads the data, and talks to Sendlane directly. You open the SheetXAI sidebar, describe what you want, and it does the fetch and write in one pass.
List all my Sendlane email campaigns and write each campaign's name and ID into columns A and B of this sheet, one row per campaign.
What You Get
- Column A fills with every campaign name, exactly as it appears in Sendlane.
- Column B fills with the corresponding campaign ID.
- The data starts at row 1 and runs through however many campaigns are in the account — no pagination limit to manage.
- Once it's written, your existing VLOOKUP in column D can pull the revenue figures automatically.
What If the Data Is Not Quite Ready
The sheet already has headers and you don't want to overwrite row 1
List all my Sendlane email campaigns and write the campaign name in column A and the campaign ID in column B, starting at row 2. Leave row 1 untouched.
You need campaign status as well, not just name and ID
List all my Sendlane email campaigns and write the campaign name into column A, the campaign ID into column B, and the campaign status into column C, starting at row 2.
You only want campaigns that are active — not drafts or archived
List all my Sendlane email campaigns, filter to only those with a status of "active," and write the campaign name and ID into columns A and B starting at row 2.
You need to reconcile what's in Sendlane against what's already in the sheet
Compare the campaign IDs already listed in column B of this sheet against all campaigns in my Sendlane account. For any campaign in Sendlane that's missing from column B, write its name in column A and its ID in column B on the next available row. Mark "already exists" in column C for rows that were already there.
The pattern: one prompt that handles the lookup, the comparison, and the conditional write together — rather than pulling all campaigns and then doing the deduplication step manually.
Try It
Open any Google Sheet that's waiting on Sendlane campaign data, then Get the 7-day free trial of SheetXAI and ask it to pull the list. Link to Bulk Create Sendlane Mailing Lists From a Google Sheet or back to the Sendlane integration overview.