Back to Contentful in Excel
SheetXAI logo
Contentful logo
Contentful · Excel Guide

Group an Excel Workbook of Entries Into a Contentful Release

The Scenario

You are a marketing operations manager. The product launch is in eight days. You have an Excel workbook of 25 campaign entries and 10 assets that all need to go live together. Entry IDs are in column A. Asset IDs are in column B.

The plan is to group everything into a single Contentful release for a coordinated launch.

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, click Add
  • You repeat for 25 entries, then 10 assets
  • Halfway through you add a duplicate entry
  • The release goes out with 26 entries instead of 25, including one 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 Excel workbook 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.

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"
  • Release ID — ask SheetXAI to write it to a named cell for reference

The release is the coordination layer. Your team reviews it in Contentful, makes last-minute edits, and publishes the whole thing in one action on launch day.

What If the Data Is Not Quite Ready

Campaign workbooks assembled under deadline pressure have their own issues.

When column A has blank rows between entry IDs

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 workbook itself

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

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

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.

Try It

Get the 7-day free trial of SheetXAI and open any campaign launch workbook, 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 Excel overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more