使用 RapidAPI 抓取 Shopify 店铺数据并保存到 Google Sheets
中级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 FormTrigger, HttpRequest, GoogleSheets 等节点。 使用 RapidAPI 抓取 Shopify 店铺数据并保存到 Google Sheets
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f7d16185-7d9b-4a5c-8d9a-25d91afae61c",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "3f11b0c2-c212-41d0-af45-4d4ca1523882",
"parameters": {
"options": {},
"formTitle": "Shopify Scraper",
"formFields": {
"values": [
{
"fieldLabel": "website"
}
]
},
"formDescription": "Shopify Scraper"
},
"typeVersion": 2.2
},
{
"id": "16736d7a-af75-482e-8465-5b9924fe7b17",
"name": "店铺信息抓取请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
240,
-140
],
"parameters": {
"url": "https://shopify-scraper4.p.rapidapi.com/shopinfo.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "shopify-scraper4.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "253cd194-c8c2-42f2-a285-d562af502ab6",
"name": "产品抓取请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
240,
180
],
"parameters": {
"url": "https://shopify-scraper4.p.rapidapi.com/products.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "shopify-scraper4.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "9af8038d-06e1-4cf5-a2ef-64816d51e374",
"name": "在Google Sheets中追加产品数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
480,
180
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "body_html",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "body_html",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published_at",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "published_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "created_at",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "created_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updated_at",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "updated_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "vendor",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "vendor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "product_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tags",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "variants",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "variants",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "images",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "images",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "options",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "options",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 265041704,
"cachedResultUrl": "",
"cachedResultName": "Products"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "Shopify"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "e0ac4258-a0ff-4e39-a05c-3d20713eaa36",
"name": "在Google Sheets中追加店铺信息",
"type": "n8n-nodes-base.googleSheets",
"position": [
480,
-140
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "province",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "province",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "currency",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "myshopify_domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "myshopify_domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ships_to_countries",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ships_to_countries",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "money_format",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "money_format",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published_collections_count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "published_collections_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published_products_count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "published_products_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "shopify_pay_enabled_card_brands",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "shopify_pay_enabled_card_brands",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "offers_shop_pay_installments",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "offers_shop_pay_installments",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Shop Info"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "Shopify"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "e5b2f242-68cf-4cb0-83ea-5c84c3d6bc60",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-300
],
"parameters": {
"width": 780,
"height": 1300,
"content": "# 🛍️ Shopify爬虫工作流（n8n）"
},
"typeVersion": 1
},
{
"id": "b21191f6-2be1-4e4c-8c98-24eada3019c8",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-120
],
"parameters": {
"height": 300,
"content": "**表单提交时**"
},
"typeVersion": 1
},
{
"id": "aaa36bf5-e830-4266-ba04-c153fe2abaaf",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-280
],
"parameters": {
"height": 260,
"content": "**店铺信息抓取请求**"
},
"typeVersion": 1
},
{
"id": "4316983c-dfd3-4c28-94eb-8081d0e1089a",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
20
],
"parameters": {
"height": 300,
"content": "**产品抓取请求**"
},
"typeVersion": 1
},
{
"id": "144e9688-648c-4ab5-a70b-fa3390b25cc8",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-280
],
"parameters": {
"height": 260,
"content": "**在Google Sheets中追加店铺信息**"
},
"typeVersion": 1
},
{
"id": "76000e5a-8bff-4c9a-942d-f32f60ad00ee",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
20
],
"parameters": {
"height": 320,
"content": "**在Google Sheets中追加产品数据**"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"On form submission": {
"main": [
[
{
"node": "Store Info Scrap Request",
"type": "main",
"index": 0
},
{
"node": "Products Scarp Request",
"type": "main",
"index": 0
}
]
]
},
"Products Scarp Request": {
"main": [
[
{
"node": "Append Products Data In Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Store Info Scrap Request": {
"main": [
[
{
"node": "Append Store Info Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用顶级反向链接检查器API分析网站反向链接并记录到Google Sheets
使用顶级反向链接检查器API分析网站反向链接并记录到Google Sheets
Code
Form Trigger
Http Request
+2
13 节点Sk developer
市场调研
使用RapidAPI和Google Sheets自动化SEO关键词分析
使用RapidAPI和Google Sheets自动化SEO关键词分析
Code
Form Trigger
Http Request
+2
9 节点Sk developer
市场调研
批量检查域名权威指标并记录到Google表格
使用RapidAPI批量检查域名权威指标并记录到Google表格
Code
Form Trigger
Http Request
+2
9 节点Sk developer
市场调研
使用Semrush API和Google Sheets进行SEO竞争对手分析与数据记录
使用Semrush API和Google Sheets进行SEO竞争对手分析与数据记录
Code
Form Trigger
Http Request
+2
21 节点Sk developer
市场调研
使用 RapidAPI 从 Indeed、LinkedIn 等平台抓取职位并保存到 Google Sheets
使用 RapidAPI 从 Indeed、LinkedIn 等平台抓取职位并保存到 Google Sheets
Code
Form Trigger
Http Request
+2
9 节点Sk developer
市场调研
追踪网站 SEO 指标
使用 Moz API 和 Google Sheets 集成追踪网站 SEO 指标
If
Code
Form Trigger
+3
11 节点Sk developer
市场调研
