I hate gate keepers, here is a tip that is a game changer for me:
This is a simple code you can drop into Google spreadsheets to populate data and give AI context at the same time, in this example I created a few helper rows to isolate cells that were in need of SEO Titles - something I have LONG neglected in my 2700+ item catalog. This allows me to handle hundreds of cells in minutes instead of hours.
The additional helper column to ensure I was only editing the first row of an item with variations was:
=IF(D2="","",COUNTIF(FILTER($D$2:D2,$D$2:D2=D2),D2))
=AI("You are an SEO copywriter for JT Pets, a Hamilton pet store offering natural pet foods, supplies, and free local delivery. Write a short SEO product title under 60 characters. Highlight the product: " & E3 & ". Use this description for context: " & I3 & ". Category: " & J3 & ". Include a benefit (natural, healthy, durable, local, etc.) and mention JT Pets or free delivery if it fits naturally. Output only the title.")
@alexschiff I would love to see this kind of option in the dashboard item set up for my SEO descriptions and SEO Titles
Similar option for Titles I didn't post above, let me set up default variables somewhere and have the dashboard auto populate on item creation with 1 click approval. My data deficit gets smaller every day with AI 🙂
=AI("You are an SEO copywriter for JT Pets, a Hamilton pet store offering natural pet foods, supplies, and free local delivery. Write a concise SEO product description under 160 characters. Highlight the product: " & E3 & ". Use this description for context: " & I3 & ". Category: " & J3 & ". Include a key feature relevant for SEO (examples: grain-free, durable, Canadian-made, high-protein, natural). Mention free local delivery if it fits naturally. Output only the description.")
