Audit product feed quality with Reach Dog and Google Sheets

Quick overview

This workflow manually audits a product feed stored in Google Sheets by calling the Reach Dog API to detect missing attributes, taxonomy mappings, and product type, then writes audit results back to the spreadsheet with an approval step to confirm estimated token usage.

How it works

1. Runs when you start the workflow manually.
2. Reads product rows from the Google Sheets “Feed” tab and excludes rows with missing or duplicate client_product_id values or missing titles.
3. Writes excluded rows and reasons to the Google Sheets “Excluded” tab.
4. Calls the Reach Dog API usage endpoint to estimate token cost for auditing all valid rows and pauses for an approval form response.
5. If approved, sends each product to the Reach Dog title-matches endpoint with an idempotency key and retries after a delay when the API returns transient errors or retry-after headers.
6. Appends or updates the Google Sheets “Audit” tab with product_type, missing_attributes, taxonomy_mappings, charge metadata, and any errors, then continues until all rows are processed.

Setup

1. Create a Google Sheets spreadsheet with “Feed”, “Excluded”, and “Audit” tabs and the required columns (including client_product_id, title, optional description, and the output columns used by the workflow).
2. Add Google Sheets credentials in n8n and set the spreadsheet ID plus a stable run_label and HTTPS api_origin value in the Configuration step.
3. Add an HTTP Header Auth credential for the Reach Dog API and connect it to the Reach Dog HTTP Request nodes.
4. Run the workflow manually and use the approval form within 15 minutes to approve or reject the estimated token charge.