Writes an SEO meta title and description for each product in your Wix catalog into a spreadsheet for you to review.
Uses
Claude
Google Sheets
Wix
Draft SEO meta titles and descriptions for Wix products
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 emptyYes
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 nameErrorTry
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 emptyYes
Skip to the next item.Skip to the next item.No
No steps
If alreadyDrafted contains productNameIf alreadyDrafted contains productNameYes
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 draftErrorTry
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: 64Trim titleResponse.response_text and save it as metaTitle.Trim titleResponse.response_text and save it as metaTitle.If metaTitle is emptyIf metaTitle is emptyYes
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: 200Trim descriptionResponse.response_text and save it as metaDescription.Trim descriptionResponse.response_text and save it as metaDescription.If metaDescription is emptyIf metaDescription is emptyYes
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.