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:

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

2. Log in or Sign Up

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

3. 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.

4. 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.

5. 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"