Audit Etsy Listings With Claude and Send SEO Rewrites to Google Sheets

Run on a recurring interval, for example once a month, so the audit repeats as listings age and new ones go live.

Fetch the shop's listings with state set to active, 100 per page, including each listing's ID, title, tags, description, num_favorers, and created timestamp.

Go through the returned listings one at a time.

Keep a listing only if it has been live for at least 60 days and its num_favorers is below the threshold you choose, so the audit focuses on listings that aren't getting traction.

Send the listing's current title, tags, and description with instructions to act as an Etsy SEO editor: return a revised title under 140 characters that leads with the words a buyer would search, exactly 13 tags of 20 characters or fewer with no repeats of title words, a revised description whose first two sentences say what the item is and who it's for, and a one-line reason for the changes, as JSON.

Add one row per listing with the listing ID, the current title, tags, and description, Claude's proposed versions, its reason, and an empty Approved column for a person to fill in.