This workflow starts by taking a “Ready” ASIN from Airtable, marking it as In Progress, and fetching live product details from the Rainforest API using a single HTTP Request. You’ll combine Airtable for task management, n8n core nodes (Trigger, Airtable, HTTP Request) for automation, and the Rainforest API as your data source to build a clean, reliable starting point for your product analysis flow.

Trigger & Pull One Ready ASIN

To start, you'll create the workflow's entry point and pull one Ready ASIN record from Airtable. This ensures the workflow always begins with a single, clean item to process — avoiding duplicates or overloads.

• Add Trigger manually.

• Add Airtable → Search Records

  • Resource: Records
  • Operation: Search
  • Base/Table: your ASIN queue

Next, you'll need to filter your Airtable data so the workflow only retrieves ASINs that are marked as Ready. In the Filter by formula field, enter the following expression:

{Status} = "Ready"

This ensures that n8n selects only one ASIN waiting to be processed. Set Return all to Off and Max results to 1 so you're working with a single record at a time. Then execute the node to confirm that you get an item containing the ASIN, Status, and related fields.

Mark that record In Progress

Once you've pulled the ASIN record, the next step is to update its status so you don't accidentally process it again. This marks the record as In Progress, signaling that it's currently being handled by the workflow.

• Add Airtable and Update Record

  • Base/Table: same as before;

  • IDs to match: map the record id from the Search Records output (schema view);

  • Fields to update:

    • Status set In Progress;
    • Map ASIN through for audit or logging purposes.

Execute the node and confirm in Airtable that the record's Status has changed to In Progress.

After marking the record as In Progress, it's time to fetch live product details from the Rainforest API. This step connects your ASIN from Airtable to real-time Amazon data, giving you everything needed for downstream processing.

• Add HTTP Request node

  • Method: GET
  • Response: JSON
  • URL: https://api.rainforestapi.com/request

Now configure the query parameters to define what data the API should return.

Execute the node once and confirm that the response includes all expected product fields such as title, ASIN, images, price, rating, and reviews.