The Scenario
You are a content architect at an e-commerce company. The taxonomy team has just finished a six-week classification project: 200 product category terms, each with a label, a definition, and a parent concept. The terms are in a Google Sheet—column A has the label, column B has the definition, column C has the parent concept name.
All 200 terms need to be added to Contentful's organization taxonomy under the correct concept scheme before the catalog relaunch. The relaunch is next Tuesday.
The bad version of this week:
- You open Contentful, navigate to Organization > Taxonomy
- You click "Add concept," type the label, type the definition, scroll down to find the parent concept, click Save
- You repeat for 200 terms
- Around term sixty you mistype a definition and do not notice until a QA reviewer flags it two days later
- Some parent concept names in the sheet do not exactly match the concept names in Contentful and the taxonomy tree ends up wrong
- The catalog relaunch is delayed while someone manually fixes 30 misplaced concepts.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the taxonomy sheet and calls Contentful's taxonomy API for each row, so you do not have to click through the UI for 200 terms.
Open the SheetXAI sidebar and type:
Create a Contentful taxonomy concept for each row in this sheet. Use the term label from column A, the definition from column B, and the parent concept from column C. Add each concept to the concept scheme called Product Categories.
SheetXAI reads all 200 rows, creates a concept for each one, and links it to the correct parent in the Product Categories scheme.
What You Get
200 Contentful taxonomy concepts created, organized under the right scheme:
- Labels — from column A, exactly as written
- Definitions — from column B, no retyping
- Parent linkage — each concept placed under the correct parent in the scheme
- Concept IDs — ask SheetXAI to write each new concept ID back to column D and you have an audit trail
Parent concept matching is handled by SheetXAI, not by you. If column C says "Apparel" and the Contentful concept is called "Apparel & Clothing," SheetXAI resolves the closest match rather than failing silently.
What If the Data Is Not Quite Ready
Taxonomy sheets assembled over six weeks tend to accumulate inconsistencies.
When parent concept names are inconsistent
Column C has "Electronics," "Consumer Electronics," and "Electronics / CE" all pointing to the same parent.
Before creating concepts, normalize the parent concept names in column C to the canonical names in the Contentful taxonomy. Map "Consumer Electronics" and "Electronics / CE" to "Electronics." Then create each concept under the correct parent.
When some terms are missing definitions
About thirty rows have a blank column B because the taxonomy team ran out of time.
For rows where column B is blank, write a one-sentence definition based on the label in column A. Then create the Contentful taxonomy concept for each row using the label from column A, the generated or existing definition from column B, and the parent from column C.
When you only want to add concepts for a specific parent branch
The relaunch is starting with just the Home & Garden branch of the taxonomy.
Filter to rows where column C is "Home & Garden" or a child of that concept. Create Contentful taxonomy concepts only for those rows.
When the sheet has duplicate labels and needs deduplication before creation
The taxonomy was assembled from four regional teams and has fifty duplicate labels.
Deduplicate rows by the label in column A, keeping the first occurrence. Then create a Contentful taxonomy concept for each unique row using the label, definition, and parent concept from columns A, B, and C. Write the new concept ID to column D.
The pattern: taxonomy cleanup and concept creation happen in the same prompt. You do not pre-clean the sheet; you describe the cleaning rules and SheetXAI applies them before creating the entries.
Try It
Get the 7-day free trial of SheetXAI and open any taxonomy planning sheet, then ask it to create the concepts in Contentful. The Contentful integration is included in every SheetXAI plan. For related workflows, see how to bulk-create content entries or the Contentful in Google Sheets overview.