# Create product listing copy from approved facts

Turn a SKU and approved product facts into a title, description, feature bullets, and search metadata. Keep the evidence next to the draft in Google Sheets.

**Category** Marketing · Content Creation  
**Tools** n8n, OpenAI, Google Sheets  
**Trigger** Authenticated POST from an internal content queue or form  
**Proposed catalog URL** https://uptune.io/templates/product-listing-copy  
**Package** [Workflow JSON](product-listing-copy.n8n.json) · [Test payloads](test-payloads.json) · [Validation report](validation-report.txt)

Import the workflow in n8n and run **Run with sample data**. The workflow imports inactive with **dryRun** enabled. The sample stays inside n8n and uses fictional data.

## How it works

1. Read a product brief with the SKU, name, intended audience, and three to twelve approved facts.
2. Generate copy and metadata. Check the feature bullets reference valid fact IDs and that any numbers in the copy appear in the supplied facts.
3. Save the draft in **Product Copy Queue** with **Needs review** status. A repeated request ID leaves the existing row and editorial status intact.

## How to use

1. Create a Google Sheets tab named **Product Copy Queue**. Use the exact headers **Request ID, SKU, Headline, Description, Features, SEO Title, SEO Description, Fact References, Status**. Format Request ID and SKU as plain text.
2. Enter the spreadsheet ID, OpenAI model, and your brand voice in **Setup**. Connect Google Sheets OAuth2 on both Sheets nodes and an OpenAI **Header Auth** credential using **Authorization: Bearer <API key>**.
3. Attach a separate private **Header Auth** credential to **Receive event**. Submit **requestId**, **sku**, **productName**, **audience**, and a **facts** array with **label** and **value** on each item. The webhook response acknowledges receipt. The execution and spreadsheet show the result.
4. In staging, disable dry run and send a test SKU. Compare the draft to the supplied specifications. Copy approved text to the product catalog after editorial review.

## Test and operate

- The sample returns three feature bullets and their fact references.
- An invented size, missing fact ID, or oversized SEO field stops the workflow before the sheet write.
- Use a new request ID for a new revision. Process events for the same ID serially.
- Check claims in the title and description against the product record. A valid fact reference shows what the draft cites, while the editor checks whether the wording accurately reflects it.

[n8n source by Evoort Solutions](https://n8n.io/workflows/5195-ai-powered-product-research-and-seo-content-automation/)