ChatGPT-SEO-Description-Generator-from-Tags is a Python automation tool by Roman Slack, created while working with firearm parts supplier Jack First to optimize their product SEO using the early OpenAI API era of ChatGPT. The project addresses the practical problem of writing search-optimized product descriptions at scale for a large catalog of parts, using lists of tags as the input signal for each product.
The tool works by reading product tags from a text file in fixed-size batches and driving the ChatGPT interface through desktop UI automation. For each batch it focuses the chat input, submits the tags, waits for a generated description, copies the result, and pastes it into the correct row of a Google Sheets spreadsheet, advancing cell by cell through the catalog. It includes an emergency-stop hotkey and a helper script for capturing on-screen mouse coordinates to calibrate the automation.
Built by Roman Slack in Python, the project relies on pyautogui for mouse and keyboard automation, the keyboard library for the escape-key kill switch, and threading to monitor for the stop signal while the main loop runs. It represents an early, pragmatic approach to large-scale AI-assisted SEO content generation, automating the human-in-the-loop ChatGPT workflow before robust programmatic API pipelines were commonplace.
Key Features
- Batch reads product tags from a text file in fixed-size chunks
- Automates ChatGPT to generate SEO product descriptions from tags
- Auto-pastes generated descriptions into Google Sheets cells
- Emergency-stop hotkey to halt the automation
- Mouse-coordinate helper script for calibrating UI automation
Tech Stack
Designed and built by Roman Slack, Lead AI Platform Engineer. See more of Roman Slack's work on the projects page or get in touch via the contact page.