Quick Overview
This workflow receives a product image upload via webhook, uses Anthropic Claude to extract product features and generate SEO content, pulls competitor keywords/prices/reviews with SerpAPI, then creates a Shopify product, logs it to Google Sheets, and notifies a Slack channel.
How it works
- Receives a webhook request containing a product image URL (and optional category) when a product image is uploaded.
- Downloads the image and sends it to Anthropic Claude Vision to extract structured product features, then generates accessibility-friendly alt text from the extracted attributes.
- Queries SerpAPI Google Shopping to collect competitor product titles/keywords, routes the item into a category-based pricing search, and calculates a suggested competitive price from the competitor price distribution.
- Fetches product reviews through SerpAPI Google Product and derives simple sentiment, themes, and average rating from the returned review data.
- Uses Anthropic (agent + Claude) to generate structured SEO content (title, description, bullets, meta description, tags, and a quality score) using the image analysis, competitor keywords, pricing intelligence, and sentiment signals.
- Validates the generated JSON and content-length rules, regenerating corrected content with Anthropic if the output is invalid.
- Creates the product in Shopify with the generated title/description/tags and the source image URL, appends the result to a Google Sheets review queue, and posts a formatted notification to Slack.
Setup
- Create an Anthropic credential (Claude 3.5 Sonnet) and ensure the Anthropic nodes can access it for both vision and text generation.
- Add a SerpAPI API key and replace the placeholder value in the configuration step used by all SerpAPI HTTP requests.
- Provide your Shopify store domain and Admin API access token in the configuration step, and confirm the Admin API version/permissions allow creating products.
- Connect Google Sheets OAuth, set the target spreadsheet ID in the configuration step, and ensure a sheet named “Review Queue” has columns matching the mapped fields.
- Connect Slack credentials, set the target channel ID/name in the configuration step, and update the workflow’s webhook URL in the system that sends product image uploads.