Import multiple Manufacturers from Google Sheets to Shopware 6 — n8n 工作流

复杂度 触发器8 个节点🏷️ Miscellaneous👁 1,025 次查看作者:Manuel

概览

Effortlessly optimize your workflow by automatically importing hundreds of manufacturers from a Google Sheet into your Shopware online store, saving countless hours of manual work.

How it works Retrieve all manufactures from a Google Sheet Add each manufacture via Shopware sync API Endpoint to Shopware Upload a logo for each manufacture from a provided public URL to Shopware

Set Up Steps Add your Shopware url to first node called Settings Create a Google Sheet in your Google account with the f

使用的节点

Google SheetsHTTP RequestCode

工作流预览

Settings
Todo: Configure your Shopware URL
Google Sheet
Todo: Create a Google Sheet with the columns:
- name (unique)
- website
- description
- logo_url
Shopware Manufacturer Import
Todo: Connect your Shopware Account by creating a Shopw
Shopware Manufacturer Logo Upload
Todo: Connect your Shopware Account as you did two node
W
When clicking "Execute W…
S
Settings
Create Import Request Body
Upload Manufacturer Logo
Import Manufacturer
L
Loop Over Manufacturers
Get Manufacturer from Go…
I
If has Logo
8 nodes9 edges

工作原理

  1. 1

    触发器

    工作流由 触发器 触发器启动。

  2. 2

    处理

    数据流经 8 个节点, connecting code, googlesheets, httprequest。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (8)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
CO

Code

code

#3

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入
  3. 3选择下载的 import-multiple-manufacturers-from-google-sheets-to-shopware-6 文件并点击导入。
  4. 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
  5. 5点击 测试工作流 验证一切正常,然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴:

{ "name": "Import multiple Manufacturers from Google Sheets to Shopware 6", "nodes": [...], ...}

集成

codegooglesheetshttprequestifmanualtriggersetsplitinbatches

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点8
复杂度medium
触发器trigger
查看次数1,025

创建者

Manuel

Manuel

@automate-everything

标签

codegooglesheetshttprequestifmanualtriggersetsplitinbatches

n8n 新手?

n8n 是一款免费开源的工作流自动化工具,支持自托管或使用云版本。

免费获取 n8n →

Related Miscellaneous Workflows