Building the Core Flow
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.
Casing must match exactly (Status header and Ready value).
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.
If you don't already have a visible record ID column in Airtable, create a Formula field with RECORD_ID() to make referencing IDs easier.
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.
Tack för dina kommentarer!
Fråga AI
Fråga AI
Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal
Can you explain how to map the ASIN from Airtable to the HTTP Request node?
What should I do if the Rainforest API response is missing some expected fields?
How can I handle errors if the API call fails during the workflow?
Awesome!
Completion rate improved to 4.17Building the Core Flow
Svep för att visa menyn
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.
Casing must match exactly (Status header and Ready value).
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.
If you don't already have a visible record ID column in Airtable, create a Formula field with RECORD_ID() to make referencing IDs easier.
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.
Tack för dina kommentarer!
