Draft SEO meta titles and descriptions for Wix products

Once a week, your Wix Stores catalogue is read and the AI writes an SEO meta title and a meta description for each product not yet done. The drafts are collected in a spreadsheet tab you nominate, one row per product, with the product name, both drafts and the character count of each, so you can see at a glance which ones search engines will cut short.

Nothing is written back to your store. The drafts land in the sheet so you decide, product by product, which copy is good enough to paste into Wix yourself. The AI writes from the product name and your own guidance only, and is told never to invent price, stock, delivery or discount claims. The first column of the tab records what has been done, so a later run only adds new products and your reviewed rows are never rewritten.

Before the first run you need a spreadsheet tab for the drafts, whose header row is written for you, and a short description of your store and the search terms you want to rank for.

Run every 7 days.Run every 7 days.

Set reviewSheetUrl to blank.Set reviewSheetUrl to blank.

Set seoGuidance to blank.Set seoGuidance to blank.

Set reviewTabName to SEO meta drafts.Set reviewTabName to SEO meta drafts.

Set maxProducts to 25.Set maxProducts to 25.

Google SheetsRead column 'A' of reviewTabName in reviewSheetUrl. Save it as draftedColumn.Read column 'A' of reviewTabName in reviewSheetUrl. Save it as draftedColumn.

Set alreadyDrafted to draftedColumn.values.Set alreadyDrafted to draftedColumn.values.

If alreadyDrafted is emptyIf alreadyDrafted is empty

Yes

Google SheetsAdd a row to reviewTabName in reviewSheetUrl.Add a row to reviewTabName in reviewSheetUrl.

No

No steps

WixQuery Wix Stores products. Save it as catalog.Query Wix Stores products. Save it as catalog.

Set products to catalog.products.Set products to catalog.products.

For each product in products:For each product in products:

Set productName to blank.Set productName to blank.

If a step below fails, save the error as nameErrorIf a step below fails, save the error as nameError

Try

Trim product.name and save it as productName.Trim product.name and save it as productName.

On error

Show in the output: Skipped a catalog entry that has no product name..Show in the output: Skipped a catalog entry that has no product name..

If productName is emptyIf productName is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

If alreadyDrafted contains productNameIf alreadyDrafted contains productName

Yes

Skip to the next item.Skip to the next item.

No

No steps

If a step below fails, save the error as draftErrorIf a step below fails, save the error as draftError

Try

ClaudeAsk Claude: 'You are writing the SEO meta title for one product page in an online store.Ask Claude: 'You are writing the SEO meta title for one product page in an online store. About the store and the search terms it should rank for: seoGuidance Product name: productName Write one meta title of at most 60 characters. Lead with what the product is, work the most relevant search term in naturally, and never invent details such as price, stock, delivery or discounts. Reply with the meta title only - no quotation marks, no labels, no explanation.'. Save it as titleResponse. Maximum response length: 64

Trim titleResponse.response_text and save it as metaTitle.Trim titleResponse.response_text and save it as metaTitle.

If metaTitle is emptyIf metaTitle is empty

Yes

Show in the output: No meta title came back for productName - nothing was written to the sheet for it.Show in the output: No meta title came back for productName - nothing was written to the sheet for it.

Skip to the next item.Skip to the next item.

No

No steps

ClaudeAsk Claude: 'You are writing the SEO meta description for one product page in an online store.Ask Claude: 'You are writing the SEO meta description for one product page in an online store. About the store and the search terms it should rank for: seoGuidance Product name: productName Meta title already written for this product: metaTitle Write one meta description of at most 155 characters. Complement the meta title rather than repeating it, end with a reason to click, and never invent details such as price, stock, delivery or discounts. Reply with the meta description only - no quotation marks, no labels, no explanation.'. Save it as descriptionResponse. Maximum response length: 200

Trim descriptionResponse.response_text and save it as metaDescription.Trim descriptionResponse.response_text and save it as metaDescription.

If metaDescription is emptyIf metaDescription is empty

Yes

Show in the output: No meta description came back for productName - nothing was written to the sheet for it.Show in the output: No meta description came back for productName - nothing was written to the sheet for it.

Skip to the next item.Skip to the next item.

No

No steps

Google SheetsAdd a row to reviewTabName in reviewSheetUrl.Add a row to reviewTabName in reviewSheetUrl.

On error

Show in the output: Could not draft SEO meta for productName: draftError.message.Show in the output: Could not draft SEO meta for productName: draftError.message.