Scrape Shopify Store Data with RapidAPI and Save to Google Sheets

An automated workflow that scrapes Shopify store information and product data using the Shopify Scraper API from RapidAPI, triggered by a user submitting a website URL, then logs data into Google Sheets for easy access and analysis.

Node-by-Node Explanation

On form submission**
Triggers when a user submits a Shopify store website URL.

Store Info Scrap Request**
Sends a POST request to shopify-scraper4.p.rapidapi.com/shopinfo.php to fetch store metadata (name, location, domain, etc.).

Products Scarp Request**
Sends a POST request to shopify-scraper4.p.rapidapi.com/products.php to retrieve detailed product data (titles, prices, tags, etc.).

Append Store Info Google Sheets**
Appends store metadata into the "Shop Info" sheet in Google Sheets.

Append Products Data In Google Sheets**
Appends product data into the "Products" sheet in Google Sheets.

Use Case
Ideal for businesses or analysts who want to quickly gather Shopify store insights and product catalogs without manual data collection, enabling data-driven decision-making or competitive analysis.

Benefits
Automates Shopify data extraction with the powerful Shopify Scraper API on RapidAPI.
Saves time by collecting and organizing data automatically into Google Sheets.
Easily scalable and adaptable for multiple Shopify stores. 🔑 How to Get API Key from RapidAPI Shopify Scraper

Follow these steps to get your API key and start using it in your workflow:

Visit the API Page
👉 Click here to open Shopify Scraper API on RapidAPI

Log in or Sign Up
Use your Google, GitHub, or email account to sign in.
If you're new, complete a quick sign-up.

Subscribe to a Pricing Plan
Go to the Pricing tab on the API page.
Select a plan (free or paid, depending on your needs).
Click Subscribe.

Access Your API Key
Navigate to the Endpoints tab.
Look for the X-RapidAPI-Key under Request Headers.
Copy the value shown — this is your API key.

Use the Key in Your Workflow
In your n8n workflow (HTTP Request node), replace: "x-rapidapi-key": "your key" with: "x-rapidapi-key": "YOUR_ACTUAL_API_KEY" `