Scrape Shopify Store Data with RapidAPI and Save to Google Sheets

This n8n workflow automates the process of extracting product data from a Shopify store using a RapidAPI endpoint and then saving that data into a Google Sheet. It's triggered manually via an n8n form, allowing you to specify the Shopify store URL to scrape.

What it does

1. Triggers on Form Submission: The workflow starts when an n8n form is submitted. This form is configured to accept a "Shopify Store URL" as input.
2. Scrapes Shopify Store: It makes an HTTP request to a RapidAPI endpoint (likely a Shopify scraper API) using the provided store URL.
3. Saves to Google Sheets: The data received from the RapidAPI call is then appended as a new row in a specified Google Sheet.

Prerequisites/Requirements

• n8n Account: A running instance of n8n.
• Google Sheets Account: A Google account with access to Google Sheets.
• RapidAPI Account: An account with RapidAPI and a subscription to a Shopify scraping API (e.g., "Shopify Scraper" or similar). You will need an API key for authentication.
• Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth2 recommended).
• HTTP Request Credential: An n8n credential for the HTTP Request node, likely for RapidAPI authentication (e.g., API Key or Header Auth).

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Google Sheets: Locate the "Google Sheets" node. Click on the "Credential" field and either select an existing Google Sheets OAuth2 credential or create a new one. Ensure it has access to the Google Sheet you intend to use.
   • HTTP Request: Locate the "HTTP Request" node. Click on the "Credential" field and configure your RapidAPI credential. This typically involves setting an API Key in the headers (e.g., x-rapidapi-key and x-rapidapi-host).
3. Configure Google Sheets Node:
   • In the "Google Sheets" node, specify the "Spreadsheet ID" and "Sheet Name" where you want the scraped data to be saved.
   • Ensure the "Operation" is set to "Append Row" or similar, and map the incoming data fields from the HTTP Request node to the appropriate columns in your Google Sheet.
4. Configure HTTP Request Node:
   • URL: Update the URL to your specific RapidAPI endpoint for Shopify scraping. This URL will likely include a query parameter for the Shopify store URL, which you will dynamically pass from the "On form submission" node.
     • Example: https://your-rapidapi-shopify-scraper.p.rapidapi.com/scrape?shop={{ $('On form submission').item.json.shopifyStoreUrl }}
   • Headers: Add any necessary headers for RapidAPI authentication (e.g., x-rapidapi-key, x-rapidapi-host).
   • Method: Ensure the method is set correctly (e.g., GET).
5. Activate the Workflow:
   • Click the "Activate" toggle in the top right corner of the workflow editor.
6. Use the Form Trigger:
   • After activating, the "On form submission" node will provide a unique URL.
   • Open this URL in your browser.
   • Fill out the form, providing the Shopify store URL you wish to scrape.
   • Submit the form to trigger the workflow.

The workflow will then execute, scrape the specified Shopify store, and add the product data to your Google Sheet.