Extract Amazon Product Data to Sheets with Olostep API

This n8n workflow demonstrates how to extract product data from Amazon using the Olostep API and prepare it for further processing, potentially for storage in a Google Sheet or similar database. It features a form-triggered initiation, data transformation, and batch processing capabilities.

What it does

This workflow automates the following steps:

1. Triggers on Form Submission: The workflow starts when an n8n form is submitted. This form is expected to provide the necessary input to initiate the product data extraction.
2. Prepares Data for API Request: It uses a "Data table" node to define or structure the data that will be sent to the Olostep API.
3. Makes API Request to Olostep: An HTTP Request node is configured to call the Olostep API, likely to fetch Amazon product details based on the input received.
4. Splits Out Nested Data: The "Split Out" node processes the API response, separating any nested arrays or objects into individual items for easier handling.
5. Loops Over Items: The "Loop Over Items (Split in Batches)" node iterates through the processed items, allowing for individual handling of each product's data.
6. Conditional Processing: An "If" node introduces conditional logic, enabling different actions based on specific criteria within the product data.
7. Edits Fields: The "Edit Fields (Set)" node modifies or adds fields to the product data, standardizing it or enriching it with additional information.
8. Introduces a Delay: A "Wait" node pauses the workflow for a specified duration, which can be useful for respecting API rate limits or allowing time for external systems to process data.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to import and execute the workflow.
• Olostep API Key: Access and an API key for the Olostep service to extract Amazon product data.
• n8n Form: A configured n8n form to trigger the workflow.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure the n8n Form Trigger:
   • Open the "On form submission" node.
   • Ensure the form is configured to capture the necessary input for the Olostep API (e.g., Amazon product ASINs, URLs, or search queries).
3. Configure the Data table node:
   • Review and adjust the "Data table" node to match the expected input format for the Olostep API.
4. Configure the HTTP Request node:
   • Update the "HTTP Request" node with your Olostep API endpoint.
   • Add your Olostep API Key to the HTTP headers or query parameters as required by the Olostep API documentation.
   • Ensure the request body or parameters correctly map to the data from the previous nodes.
5. Adjust Split Out and Loop Over Items:
   • If the Olostep API response structure changes, you might need to adjust the "Split Out" node to correctly parse the nested data.
   • The "Loop Over Items" node can be configured for batch size if needed.
6. Define Conditional Logic:
   • Customize the "If" node with the conditions relevant to your use case (e.g., filter products by price, availability, or specific keywords).
7. Configure Edit Fields:
   • Modify the "Edit Fields (Set)" node to transform the extracted data into your desired format (e.g., rename fields, combine data, add default values).
8. Set Wait Duration:
   • Adjust the "Wait" node's duration if necessary to comply with API rate limits or manage workflow execution speed.
9. Activate the workflow: Once all configurations are complete, activate the workflow. It will now run automatically upon form submissions.