See llms.txt for all machine-readable content.

Back to Templates

Audit and rewrite Shopify product data with Claude, Google Sheets, and Slack

Created by

Created by: Kingsley Ken || kingsleyken
Kingsley Ken

Last update

Last update 3 days ago

Categories

Quick overview

This workflow runs every Monday to audit published Shopify products, compare each live product page’s JSON-LD data with Shopify, log per-product scores to Google Sheets, post a summary to Slack, and use Anthropic Claude to propose description rewrites that only update Shopify after Slack approval.

How it works

  1. Runs every Monday morning and validates the required configuration values (store URL, Google Sheet, and Slack channel).
  2. Fetches published products from Shopify (up to the configured limit) and checks core catalog data like description length, barcodes/GTINs, product type, image alt text, and title.
  3. Loads each public product page via HTTP, parses JSON-LD structured data, and flags issues like missing Product/Offer data or mismatched price and availability compared to Shopify.
  4. Calculates a score out of 100 per product, then appends a detailed row for each product to a Google Sheets tab.
  5. Builds and posts a Slack summary with the average score, most common problems, lowest-scoring products, and a link to the Google Sheet report.
  6. Selects a small set of products with short descriptions, asks Anthropic Claude to rewrite each description, and programmatically rejects rewrites that add unsupported numbers, facts, claims, or disallowed HTML.
  7. Sends passing rewrites to Slack with Approve/Decline buttons and updates the product description in Shopify only when someone approves within the configured wait period.

Setup

  1. Create or connect Shopify OAuth2 credentials with read_products and write_products scopes, and select them for the Shopify nodes that read products and update descriptions.
  2. Add Google Sheets OAuth credentials, create a spreadsheet, and set its URL and the target tab name (for example, “AI readiness”) in the Config values.
  3. Add Slack OAuth credentials, invite the Slack app to your target channel, and set the channel ID in the Config values.
  4. Add Anthropic credentials (or n8n AI credits) and confirm the Claude model selection used for generating rewritten descriptions.
  5. Replace the placeholder values in the Config node (storeUrl, reportSheetUrl, slackChannelId, and any limits/thresholds) before enabling the schedule.

Requirements

  • A Shopify store with public product pages (live checks are skipped on password-protected stores)
  • Google Sheets and Slack
  • An Anthropic API key or n8n AI credits

Customization

  • In Config, change how many products are checked and rewritten, the minimum description length and the approval wait.
  • Change the points per problem in Check Product Data and Compare Live Page With Shopify.
  • Add words to the claims list in Check Rewrite Against Product.

Additional info

Who is it for: Shopify store owners and e-commerce agencies who want products described correctly when shoppers ask ChatGPT, Gemini or Google AI Mode what to buy. These assistants rely on product data and on the structured data in each product page.