Summary  
This chapter demonstrates how to build an event-driven automation pipeline with conditional branching, HTTP API integration, dynamic data mapping, AI-driven processing, automated document generation, and robust error handling.  

General domain of usage  
E-commerce product listing optimization

Build a full, production-style automation that validates ASINs, fetches Amazon product data via API, analyzes it with AI, generates a Google Doc report, and links the result back to the original spreadsheet row, with proper error handling and troubleshooting.

### Workflow Overview

At this stage, the automation consists of the following steps:

* **Trigger**: Google Sheets, when a row is created or updated
* **Path 1, ASIN validation**

  * If no ASIN is found, the sheet is updated with **ASIN not found**
* **HTTP Request**: Fetch product data via the Rainforest API
* **Path 2, data quality check**

  * If the data quality is insufficient, the sheet is updated with **Poor data**
* **AI Processing**: ChatGPT analyzes the validated product data
* **Google Docs**: A report is generated automatically
* **Google Sheets**: The document link is written back to the original row

The outcome is a complete, defensive automation with clear branching logic, error handling, and automated report generation.

- **System Prompt:** Expert Amazon listing optimizer; generate a product summary and a checklist for improvements.
- **Input:** Full output from the API request.
- **Output:** Concise summary + actionable checklist.

Step 1 — Configure the AI Prompt

- **App:** Google Docs
- **Action:** Create document from ChatGPT output.
- **Settings:**
  - Name: Product Title (from API)
  - Content: AI summary + checklist
  - Folder: Chosen Drive location
- **Result:** New document in Drive contains the AI-generated info.

Step 2 — Create a Google Document

- **App:** Google Sheets
- **Action:** Update row using Row ID from trigger.
- **Link field:** Use Alternate Link from Google Docs step for a clickable URL.

Step 3 — Write Document Link Back to Sheet

A common issue during testing is the document link appearing in the wrong spreadsheet row. This usually happens because the **Row** field was hardcoded instead of dynamically mapped. To fix it, open each **Update Spreadsheet Row** action, set the **Row** field to **Custom**, and select the **Row ID from the trigger**. Every update step must use dynamic row mapping to ensure data lands in the correct row.


The AI step may appear delayed in Zapier’s UI. Refresh the page and check Zap History before assuming failure

Note

Which statement accurately describes the order of steps in the product analysis automation workflow?

Learn how Zapier works and how to build automations from simple one step zaps to advanced multi step workflows. The focus is on core automation concepts such as triggers, actions, filters, paths, and data formatting, and how they work together in real scenarios. You will gain hands on experience chaining actions, shaping data, and applying conditional logic to control workflow behavior. The course also covers webhooks and scaling strategies, enabling you to design reliable automations for real world use.

Building the Complete Product Analysis System

Workflow Overview