AutomationFlowsAI & RAG › Automate Bulk Update Magento 2 Product Prices via Google Sheets

Automate Bulk Update Magento 2 Product Prices via Google Sheets

ByKanaka Kishore Kandregula @kmyprojects on n8n.io

Error messages from failed updates are parsed and logged clearly, making it easy to monitor and correct issues directly from the spreadsheet. Ideal for store managers and merchandisers who need a faster, error-resistant alternative to manual updates in the admin panel.

Event trigger★★★★☆ complexity9 nodesGoogle SheetsHTTP Request
AI & RAG Trigger: Event Nodes: 9 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #6933 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "104ab3e4-ce8a-4d3a-af6b-49aa959ec760",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -260,
        -260
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5045c0c1-2337-4fed-bfa9-f5f3b692afc5",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        400,
        -260
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "f3a8d8d2-f57b-4cdb-93b4-961a1570d316",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        840,
        -260
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "dc4e0c84-fcac-4dfe-a06c-0510f37100f5",
      "name": "Log Error Message",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1280,
        -160
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "d563619b-8949-4fda-b0d1-a775166f007d",
      "name": "Read Price Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -40,
        -260
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "8882e054-7a20-4ddd-8b34-9fd7d0954894",
      "name": "Convert to Array",
      "type": "n8n-nodes-base.code",
      "position": [
        180,
        -260
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6908822a-f2ca-4851-8fc7-6bca711ff335",
      "name": "Format Error",
      "type": "n8n-nodes-base.code",
      "position": [
        1060,
        -160
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2e8b96ce-e8ce-40c0-90bb-674a5abc842d",
      "name": "Log Success Timestamp",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1060,
        -360
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "1a0b0be0-6971-442c-a88e-9315b3569d38",
      "name": "Updates Magento 2 Product",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        620,
        -260
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Log Success Timestamp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Format Error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Error": {
      "main": [
        [
          {
            "node": "Log Error Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Read Price Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          },
          {
            "node": "Updates Magento 2 Product",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to Array": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Price Sheet": {
      "main": [
        [
          {
            "node": "Convert to Array",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Updates Magento 2 Product": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Error messages from failed updates are parsed and logged clearly, making it easy to monitor and correct issues directly from the spreadsheet. Ideal for store managers and merchandisers who need a faster, error-resistant alternative to manual updates in the admin panel.

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

More AI & RAG workflows → · Browse all categories →

Related workflows

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

AI & RAG

CLEAN Agent - Manual Trigger. Uses googleDrive, googleSheets, httpRequest. Event-driven trigger; 49 nodes.

Google Drive, Google Sheets, HTTP Request
AI & RAG

Secretary — Gmail Manager (gelsonmascarenhas@gmail.com). Uses gmailTrigger, httpRequest, googleCalendar, gmail. Event-driven trigger; 47 nodes.

Gmail Trigger, HTTP Request, Google Calendar +2
AI & RAG

Automatically fetches daily sales, shifts, and receipts from Loyverse. Calculates gross profit, net operating profit, other key metrics, saves them to a Google Sheet and sends out a daily report via e

Google Sheets, HTTP Request, Email Send
AI & RAG

This n8n workflow automates outbound phone calls to new leads using Retell AI, with built-in timezone detection to ensure you're only calling during business hours.

HTTP Request, Google Sheets Trigger, Google Sheets
AI & RAG

Who this is for

YouTube, Form Trigger, Google Sheets +2