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

Inquiry-Agent. Uses @digitalocean/n8n-nodes-digitalocean-gradient-serverless-inference, stopAndError, googleDocs, gmail. Event-driven trigger; 59 nodes.

@Digitalocean/N8N Nodes Digitalocean Gradient Serverless Inference, Stop And Error, Google Docs +4
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

💥 AI Image to Professional Video Workflow using NanoBanana Ultra & Kling AI. Uses googleSheets, googleDrive, httpRequest, editImage. Event-driven trigger; 45 nodes.

Google Sheets, Google Drive, HTTP Request +2
AI & RAG

Template 13195. Uses slackTrigger, googleSheets, httpRequest, slack. Event-driven trigger; 31 nodes.

Slack Trigger, Google Sheets, HTTP Request +2