Generate and push AI SEO product content to PrestaShop with Google Gemini and Sheets

Description

Who Is This For?

This workflow is built for PrestaShop store owners, eCommerce managers, and digital agencies who need to bulk-generate professional, SEO-optimized product content in Spanish or any other language — without writing a single word manually.

What Problem Does It Solve?

Writing titles, descriptions, meta tags, and SEO slugs for hundreds of products is one of the most time-consuming tasks in eCommerce. This workflow automates the entire process using an AI Agent powered by Google Gemini, pulling real product data from the web and pushing it directly into PrestaShop via the REST API.

How It Works

Reads unprocessed products from a Google Sheet filtered by an "Updated" status column
Limits to 50 products per run to stay within API rate limits
Extracts the PrestaShop Product ID from each product URL using regex
Loops through products one at a time
AI Agent researches the product online using trusted Spanish pharmacy sources and generates Title, Short Description, Long Description in HTML, Meta Title, Meta Description, and SEO-friendly URL Slug — all in Spanish
Structured Output Parser enforces clean JSON output every single time — no fragile regex parsing
Sends a PATCH request to the PrestaShop Admin API to update the product
Logs the result back to Google Sheets and marks the row as Updated
Waits 8 seconds between each product to respect API rate limits

What You Need to Set Up

[ ] Google Sheets OAuth2 credential
[ ] Google Gemini API credential
[ ] PrestaShop Bearer API token — paste into the Arrange Data node
[ ] A Google Sheet with these columns: Address | Previous Title | Title | Short Description | Long Description | Meta Title | Meta Description | Slug | Update

Nodes Used

Google Sheets, AI Agent, Google Gemini Chat Model, Structured Output Parser, HTTP Request, Loop Over Items, Code, Filter, Limit, Wait, Set

📩 Support & Contact

📧 Email: [email protected]
💼 LinkedIn: Salman Mehboob