Scrape Amazon Keyboard Products with Scrapegraphai to Google Sheets

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "id": "JpP0OwP6cBEOvIgP",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Amazon Keyboard Product Scraper with AI and Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "69b249d2-cc60-42c5-9e26-a9a739fb82a9",
      "name": "Automated Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        700,
        820
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "3f475331-5783-4b67-bfa3-99333f53255d",
      "name": "AI-Powered Amazon Product Scraper",
      "type": "n8n-nodes-scrapegraphai.scrapegraphAi",
      "position": [
        1380,
        820
      ],
      "parameters": {
        "userPrompt": "Extract all the products from this site. Use the following schema for response { \"title\": \"Logitech MX Keys Advanced Wireless Illuminated Keyboard\", \"url\": \"https://www.amazon.com/dp/B07S92QBCX\", \"category\": \"Electronics\" }",
        "websiteUrl": "https://www.amazon.com/s?k=keyboard&crid=2FI5OSSH1T0Q8&sprefix=keyboar%2Caps%2C191&ref=nb_sb_ss_p13n-pd-dpltr-ranker_ci_hl-bn-left_1_7"
      },
      "credentials": {
        "scrapegraphAIApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "07915798-e59c-46af-b333-a9270e8dd2d8",
      "name": "Google Sheets Data Storage",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2980,
        820
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "category",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "category",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": []
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "bdc19893-aa0b-4e30-89cb-3fccc2d2d0ae",
      "name": "Data Formatting and Processing",
      "type": "n8n-nodes-base.code",
      "notes": "Hey this is where \nyou \nformat results ",
      "position": [
        2140,
        820
      ],
      "parameters": {
        "jsCode": "// Get the input data\nconst inputData = $input.all()[0].json;\n\n// Extract products array from result\nconst products = inputData.result.products;\n\n// Map each product and return only title, url, category\nreturn products.map(product => ({\n  json: {\n    title: product.title,\n    url: product.url,\n    category: product.category\n  }\n}));"
      },
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "36debe48-6a09-4036-af3f-5465aad6386e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        460
      ],
      "parameters": {
        "color": 5,
        "width": 574.9363634768473,
        "height": 530.4701664623029,
        "content": "# Step 2: AI-Powered Amazon Product Scraper \ud83e\udd16\n\nThis is the core node which uses ScrapeGraphAI to intelligently extract product information from Amazon.\n\n## How to Use\n- Configure the Amazon search URL\n- Use natural language to describe what data to extract\n- The AI will automatically parse and structure the results\n\n## Configuration\n- **Website URL**: Amazon search results page for keyboards\n- **User Prompt**: Natural language instructions for data extraction\n- **API Credentials**: ScrapeGraphAI API key required\n\n## Example\n- **Website**: Amazon keyboard search results\n- **Instruction**: \"Extract product titles, URLs, and categories\"\n\n\u26a0\ufe0f **Note**: This is a community node requiring self-hosting"
      },
      "typeVersion": 1
    },
    {
      "id": "127e5d40-1c71-4752-97b4-6a25a00921d1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        460
      ],
      "parameters": {
        "color": 5,
        "width": 574.9363634768473,
        "height": 530.4701664623029,
        "content": "# Step 3: Data Formatting and Processing \ud83e\uddf1\n\nThis node transforms and structures the scraped data for optimal Google Sheets compatibility.\n\n## What it does\n- Extracts products array from ScrapeGraphAI response\n- Maps each product to standardized format\n- Ensures data consistency and structure\n- Prepares clean data for spreadsheet storage\n\n## Data Structure\n- **title**: Product name and model\n- **url**: Direct Amazon product link\n- **category**: Product classification\n\n## Customization\n- Modify the JavaScript code to extract additional fields\n- Add data validation and cleaning logic\n- Implement error handling for malformed data"
      },
      "typeVersion": 1
    },
    {
      "id": "43a90a8b-c1b8-4129-8090-cc1e4110cc72",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        460
      ],
      "parameters": {
        "color": 5,
        "width": 574.9363634768473,
        "height": 530.4701664623029,
        "content": "# Step 1: Automated Schedule Trigger \u23f1\ufe0f\n\nThis trigger automatically invokes the workflow at specified intervals to keep data fresh and up-to-date.\n\n## Configuration Options\n- **Frequency**: Daily, weekly, or custom intervals\n- **Time Zone**: Configure for your business hours\n- **Execution Time**: Choose optimal times for data collection\n\n## Best Practices\n- Set appropriate intervals to respect rate limits\n- Consider Amazon's peak hours for better data quality\n- Monitor execution logs for any issues\n- Adjust frequency based on your analysis needs"
      },
      "typeVersion": 1
    },
    {
      "id": "554bbdbe-1292-4947-8427-c29f817479be",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2680,
        460
      ],
      "parameters": {
        "color": 5,
        "width": 574.9363634768473,
        "height": 530.4701664623029,
        "content": "# Step 4: Google Sheets Data Storage \ud83d\udcca\n\nThis node securely stores the processed keyboard product data in your Google Sheets for analysis and tracking.\n\n## What it does\n- Connects to your Google Sheets account via OAuth2\n- Appends new product data as rows\n- Maintains historical data for trend analysis\n- Provides structured data for business intelligence\n\n## Configuration\n- **Spreadsheet**: Select or create target Google Sheets document\n- **Sheet Name**: Configure worksheet (default: Sheet1)\n- **Operation**: Append mode for continuous data collection\n- **Column Mapping**: Automatic mapping of title, url, category fields\n\n## Data Management\n- Each execution adds new product entries\n- Historical data preserved for analysis\n- Easy export and sharing capabilities\n- Built-in Google Sheets analytics and filtering"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a36e4f30-7663-4b7e-be9b-3e2a06cd58d1",
  "connections": {
    "Automated Schedule Trigger": {
      "main": [
        [
          {
            "node": "AI-Powered Amazon Product Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Formatting and Processing": {
      "main": [
        [
          {
            "node": "Google Sheets Data Storage",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI-Powered Amazon Product Scraper": {
      "main": [
        [
          {
            "node": "Data Formatting and Processing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• googleSheetsOAuth2Api
• scrapegraphAIApi

About this workflow

E-commerce analysts and researchers Product managers tracking competitor keyboards Data analysts monitoring Amazon keyboard market trends Business owners conducting market research Developers building product comparison tools

Source: https://n8n.io/workflows/6394/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.