The Scenario
You are a marketing operations manager. The product launch is in eight days. You have a Google Sheet of 25 campaign entries and 10 assets that all need to go live together—no partial publishing, no staggered rollout.
The plan is to group everything into a single Contentful release so the whole launch can be reviewed and published as one coordinated action. Entry IDs are in column A. Asset IDs are in column B.
The bad version of this morning:
- You open Contentful, navigate to Releases, click "New release," type a name
- You click "Add entries," search for the first entry ID from your sheet, click Add
- You repeat for 25 entries
- You switch to assets, search for the first asset ID, click Add
- You repeat for 10 assets
- Halfway through you accidentally add a duplicate entry and do not notice
- The release goes out with 26 entries instead of 25, including one that is still in draft from last quarter.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the entry and asset IDs and calls Contentful's releases API to build the release for you.
Open the SheetXAI sidebar and type:
Create a Contentful release named "Q2 Product Launch" and add all entry IDs from column A and asset IDs from column B as entities in the release.
SheetXAI reads both columns, deduplicates if needed, creates the release, and adds all 35 entities. Your release is ready for review in Contentful without a single manual search.
What You Get
One Contentful release with all campaign assets grouped:
- 25 entries — added from column A
- 10 assets — added from column B
- Release name — "Q2 Product Launch" as specified
- Release ID — ask SheetXAI to write it to a named cell so you can reference it later
The release is the coordination layer. Once it exists, your team reviews it in Contentful, editors make last-minute changes to the entries, and when the launch date arrives you publish the whole release in one action.
If you need to add more entries later, tell SheetXAI the release ID and it will add the new rows to the existing release.
What If the Data Is Not Quite Ready
Campaign sheets assembled under deadline pressure have their own issues.
When column A has blank rows between entry IDs
The sheet was formatted with gaps for readability and some rows are blank.
Skip any blank rows in column A and column B. Create a Contentful release named "Q2 Product Launch" with all non-blank entry IDs from column A and all non-blank asset IDs from column B.
When you want the release name to come from the sheet itself
The campaign name is in cell A1 and you want the release to match it exactly.
Create a Contentful release using the name from cell A1. Add all entry IDs from column A starting at row 2 and all asset IDs from column B starting at row 2 as entities.
When some entries should be excluded based on status
A few entries in column A are still in review and should not be in this release.
Before creating the release, check column C for each row. Include only entries where column C says "Approved." Then create the Contentful release with those approved entry IDs and all asset IDs from column B.
When you need to validate all entities exist in Contentful before building the release
A prior campaign had orphaned IDs in the sheet that caused the release to fail validation.
Before creating the release, verify that each entry ID in column A and each asset ID in column B exists in the Contentful master environment. Write "Valid" or "Not Found" to column D for each row. Then create the release using only the valid IDs.
The pattern: validation, filtering, and release creation happen in one prompt. You describe the rules and SheetXAI handles the rest.
Try It
Get the 7-day free trial of SheetXAI and open any campaign launch sheet, then ask it to build the Contentful release. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to bulk-publish draft entries or the Contentful in Google Sheets overview.