Shopify Store and Product Data Extraction to Google Sheets - n8n Workflow

• E-commerce analysts looking to perform competitive research quickly.


• Marketing professionals needing bulk data on Shopify stores and products.


• Data scientists and researchers who require automated data logging using powerful n8n templates.


• Users seeking an automated n8n solution that leverages external APIs for specialized tasks.

Extracting comprehensive data from third-party e-commerce stores can be technically challenging. This efficient n8n workflow solves this by utilizing a specialized RapidAPI scraper service. Once initiated by a simple web form submission, this n8n automation simultaneously queries the API for two distinct datasets: core store metadata and a complete product listing. This design ensures speed and efficiency. By structuring the output and appending it directly into a designated Google Sheet, this n8n workflow provides analysts with clean, ready-to-use data for market analysis, inventory tracking, or competitive benchmarking without writing complex scraping scripts. This is a highly valuable n8n template for data collection specialists.

The entire process is initiated by an n8n trigger, specifically the ‘On form submission’ n8n node. The user simply provides the target Shopify store's URL.

1. Trigger and Input: The workflow starts when the internal n8n trigger form is submitted, capturing the website URL.


2. Parallel API Calls: The single input branches immediately into two parallel paths, allowing for faster data collection. Each path uses an HTTP Request n8n node to interact with the RapidAPI service (Shopify Scraper 4).

1. Data Persistence: The results from both API calls are independently written to Google Sheets using dedicated Google Sheets n8n node instances. The store information is appended to the dedicated 'Shop Info' tab, and the product data is appended to the 'Products' tab, completing the automated n8n workflow cycle.

To set up this n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON and import it directly into your n8n instance as a new n8n workflow.


2. RapidAPI Credentials: The HTTP Request n8n node instances rely on specific headers (x-rapidapi-host and x-rapidapi-key). You must replace the placeholder 'your key' in the Store Info Scrap Request and Products Scarp Request nodes with your actual RapidAPI key for the Shopify Scraper 4 service.


3. Google Sheets Setup:

1. Activate: Save and activate the n8n workflow. Use the generated form URL from the ‘On form submission’ n8n node to test the process.

• On form submission (n8n trigger): This is the starting n8n node, acting as the primary trigger. It captures the target Shopify website URL input from the user via a simple web form, launching the entire n8n workflow.


• Store Info Scrap Request (HTTP Request n8n node): Sends a POST request to the RapidAPI endpoint /shopinfo.php. It dynamically uses the input website variable (={{ $json.website }}) in the body parameters and requires the x-rapidapi-key header for authentication.


• Products Scarp Request (HTTP Request n8n node): Functions in parallel, sending a POST request to the /products.php endpoint of the RapidAPI service. This n8n node fetches the extensive product listing data.


• Append Store Info Google Sheets (Google Sheets n8n node): Configured with the operation append, this n8n node takes the data output from the store info API call and writes it to the designated 'Shop Info' sheet. It utilizes auto-mapping based on the API response keys (like name, domain, currency).


• Append Products Data In Google Sheets (Google Sheets n8n node): Also configured for append, this n8n node handles the bulk product data, saving fields like title, handle, and tags to the 'Products' sheet, ensuring all collected data is accurately logged within the n8n workflow.