CloudflareドメインとDNSレコード・設定をGoogle Sheetsにエクスポート

上級

これはDevOps分野の自動化ワークフローで、22個のノードを含みます。主にIf, Set, Code, Wait, Mergeなどのノードを使用。 Cloudflareドメイン、DNSレコード、設定をGoogleシートに書き出し

前提条件
  • ターゲットAPIの認証情報が必要な場合あり
  • Google Sheets API認証情報

カテゴリー

ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "meta": {
    "instanceId": "fe41feb5409a7d5eb53f7743740840b086b13d9f15b9a1b3a5f34f2bb43129c3",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "9fd3e8a6-291f-4aba-bdc2-9055bd0e6d6b",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        380
      ],
      "parameters": {
        "color": 7,
        "width": 500,
        "height": 240,
        "content": "# Requirements\n\nFor storing and processing of data in this flow you will need:\n\n- CloudFlare.com API key/token - for retrieving your data (https://dash.cloudflare.com/:account/api-tokens) (need full access)\n- Google Spreadsheet auth connected\n- Copy [my sheet](https://docs.google.com/spreadsheets/d/1jt6od8FMt-Yo7A_CPGuyfqWzL7HJk6SZmQQFO6kkWBo/edit?usp=sharing) as template to your account and match ID in 'Export' node to your newly created."
      },
      "typeVersion": 1
    },
    {
      "id": "f4b9ee64-9c52-43bb-a91e-ad03a6286e3c",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        640
      ],
      "parameters": {
        "color": 7,
        "width": 500,
        "height": 600,
        "content": "# Author\n![Kpendic](https://gravatar.com/avatar/8e343ec0d9b4fb672f921e822a8561be?size=188)\n### Kresimir Pendic\nSenior BE professional, specializing in automation, AI and data analysis. \n\n## Say hi!\nhttps://www.linkedin.com/in/mkdizajn/\n\n\n### Video overview\nhttps://youtu.be/sW85-AxMp6g\n\n## Check out my other templates\n### 👉 https://n8n.io/creators/kres/\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b47eb629-9241-420c-8490-669d3ee1b037",
      "name": "付箋6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        1260
      ],
      "parameters": {
        "width": 500,
        "height": 140,
        "content": "# Need help?\nFor getting help with this workflow, please create a topic on the community forums here:\nhttps://community.n8n.io/c/questions/"
      },
      "typeVersion": 1
    },
    {
      "id": "00f46c50-55a1-48f8-a519-621973f2a886",
      "name": "付箋8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        220
      ],
      "parameters": {
        "color": 4,
        "width": 2000,
        "height": 140,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b5f368ea-72ae-4cb0-b09b-e80b9818f779",
      "name": "付箋9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1300,
        260
      ],
      "parameters": {
        "color": 4,
        "width": 740,
        "height": 80,
        "content": "# CloudFlare dump => Google Sheets"
      },
      "typeVersion": 1
    },
    {
      "id": "2536518c-90b5-49be-8a22-0b3e542831f1",
      "name": "「Test workflow」クリック時",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        1280,
        600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e206aea7-d544-43c2-89cd-9808ec164b03",
      "name": "メモ4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        380
      ],
      "parameters": {
        "color": 5,
        "width": 1480,
        "height": 920,
        "content": "## Fetch TLDs, each dns & settings & Transform data\n\n1. Get your CloudFlare domains and basic info\nhttps://dash.cloudflare.com/:account/api-tokens\n2. Adapt your Transformings to your specific needs\n3. Easily expand to add your custom endpoints - follow CloudFlare api docs:\nhttps://developers.cloudflare.com/api/"
      },
      "typeVersion": 1
    },
    {
      "id": "fa2397fa-baee-4aca-8ca3-8c0d1d2fada4",
      "name": "待機",
      "type": "n8n-nodes-base.wait",
      "position": [
        1380,
        1020
      ],
      "webhookId": "34f21572-31a2-4c5b-a08a-d4be2e33651d",
      "parameters": {
        "amount": 0.3
      },
      "typeVersion": 1.1
    },
    {
      "id": "da801aa4-e3f1-4e56-93e4-928eda0962d5",
      "name": "ページ設定",
      "type": "n8n-nodes-base.set",
      "position": [
        1520,
        600
      ],
      "parameters": {
        "values": {
          "number": [
            {
              "name": "page",
              "value": "={{$json[\"next_page\"] || 1}}"
            }
          ]
        },
        "options": {},
        "keepOnlySet": true
      },
      "executeOnce": true,
      "typeVersion": 1
    },
    {
      "id": "5ae6a35b-5090-449f-a689-b82a13ced8b3",
      "name": "ページ増加",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        820
      ],
      "parameters": {
        "values": {
          "number": [
            {
              "name": "next_page",
              "value": "={{ $('Set Page').first().json.page+1 }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "deb40a37-4e32-4dc6-8620-8322ef8014ea",
      "name": "追加ページ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1840,
        1080
      ],
      "parameters": {
        "conditions": {
          "number": [
            {
              "value1": "={{ $('Set Page').first().json.page }}",
              "value2": "={{ $('Get TLDs').first().json.result_info.total_pages }}"
            }
          ]
        }
      },
      "executeOnce": false,
      "typeVersion": 1
    },
    {
      "id": "fcd860d3-021e-4cb1-a347-ffbe1d61a184",
      "name": "マージ",
      "type": "n8n-nodes-base.merge",
      "position": [
        1620,
        820
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition",
        "numberInputs": 3
      },
      "executeOnce": false,
      "typeVersion": 3.1
    },
    {
      "id": "2348687c-8ce7-440a-9209-7ddc39c046ca",
      "name": "TLD取得",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1720,
        600
      ],
      "parameters": {
        "url": "https://api.cloudflare.com/client/v4/zones",
        "options": {},
        "sendQuery": true,
        "authentication": "genericCredentialType",
        "genericAuthType": "httpCustomAuth",
        "queryParameters": {
          "parameters": [
            {
              "name": "page",
              "value": "={{ $json.page }}"
            }
          ]
        }
      },
      "credentials": {
        "httpCustomAuth": {
          "id": "6l2hwj0eyB10vHc2",
          "name": "CloudFlare headers"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.1
    },
    {
      "id": "542fad7f-13d5-4ddd-8558-23858b62764e",
      "name": "各ホスト",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1900,
        600
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "result"
      },
      "executeOnce": false,
      "typeVersion": 1
    },
    {
      "id": "0e2582e1-c058-4b18-a062-7f199beb56ef",
      "name": "DNS取得",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2160,
        760
      ],
      "parameters": {
        "url": "=https://api.cloudflare.com/client/v4/zones/{{ $json.id }}/dns_records",
        "options": {},
        "authentication": "genericCredentialType",
        "genericAuthType": "httpCustomAuth"
      },
      "credentials": {
        "httpCustomAuth": {
          "id": "6l2hwj0eyB10vHc2",
          "name": "CloudFlare headers"
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "09d1c96b-dc94-43bd-8847-5ba40747747a",
      "name": "設定取得",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2180,
        540
      ],
      "parameters": {
        "url": "=https://api.cloudflare.com/client/v4/zones/{{ $json.id }}/settings",
        "options": {},
        "authentication": "genericCredentialType",
        "genericAuthType": "httpCustomAuth"
      },
      "credentials": {
        "httpCustomAuth": {
          "id": "6l2hwj0eyB10vHc2",
          "name": "CloudFlare headers"
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "12cf6091-df4b-4f8a-be93-79933778f667",
      "name": "付箋7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2120,
        1000
      ],
      "parameters": {
        "color": 3,
        "width": 540,
        "height": 280,
        "content": "## 2. Add credentials for Google Sheets & save"
      },
      "typeVersion": 1
    },
    {
      "id": "57f125f5-319c-4607-b3ed-522ee9d086c2",
      "name": "フラット化",
      "type": "n8n-nodes-base.code",
      "position": [
        2240,
        1080
      ],
      "parameters": {
        "jsCode": "\nfunction flatten(obj, prefix = '', res = {}) {\n  for (const key in obj) {\n    const value = obj[key];\n    const prefixedKey = prefix ? `${prefix}_${key}` : key;\n    \n    if (typeof value === 'object' && value !== null && !Array.isArray(value)) {\n      flatten(value, prefixedKey, res);\n    } else {\n      if (prefixedKey === \"json_records\") {\n        // Format DNS records: type + name + content\n        const formattedRecords = value\n          .map(record => `${record.type} ${record.name} ${record.content}`)\n          .join('\\n');\n        res[prefixedKey] = formattedRecords;\n        continue;\n      }\n      \n      if (prefixedKey === \"json_resultSETT\") {\n        // For each setting in the array, create a new column with setting.id as key\n        value.forEach(setting => {\n          res[setting.id] = setting.value;\n        });\n        continue;\n      }\n      \n      res[prefixedKey] = value;\n    }\n  }\n  return res;\n}\n\nreturn $input.all().map(item => ({\n  json: flatten(item)\n}));"
      },
      "typeVersion": 2
    },
    {
      "id": "3c84495b-1c2d-4252-bb9e-6f77d009a660",
      "name": "TLDフィルター",
      "type": "n8n-nodes-base.code",
      "position": [
        1840,
        820
      ],
      "parameters": {
        "jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n  let validKeys = [ 'id', 'name', 'paused', 'name_servers' ];\n  Object.keys(item.json).forEach((key) => validKeys.includes(key) || delete item.json[key]);\n}\n\nreturn $input.all();"
      },
      "typeVersion": 2
    },
    {
      "id": "d57e934d-d000-401f-938a-f9eeed756ff2",
      "name": "DNSフィルター",
      "type": "n8n-nodes-base.code",
      "position": [
        2400,
        800
      ],
      "parameters": {
        "jsCode": "for (const item of $input.all()) {\n  // Extract the result array and clean up the DNS records\n  const dnsRecords = item.json.result;\n  \n  // Clean up each DNS record\n  for (let dnn of dnsRecords) {\n    let validKeys = ['type', 'content', 'name'];\n    Object.keys(dnn).forEach((key) => validKeys.includes(key) || delete dnn[key]);\n  }\n  \n  // Replace the item's json with a new object containing the array\n  item.json = {\n    records: dnsRecords\n  };\n}\n\nreturn $input.all();"
      },
      "typeVersion": 2
    },
    {
      "id": "820d2a47-77c6-47bb-a236-9f91351ad343",
      "name": "設定フィルター",
      "type": "n8n-nodes-base.code",
      "position": [
        2440,
        560
      ],
      "parameters": {
        "jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n  item.json.resultSETT = item.json.result;\n  delete item.json.result;\n  delete item.json.success;\n  delete item.json.errors;\n  delete item.json.messages;\n}\n\nreturn $input.all();"
      },
      "typeVersion": 2
    },
    {
      "id": "c5cb1263-7b24-48be-9af4-25eba131db17",
      "name": "エクスポート",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2460,
        1080
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "json_id",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "json_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "json_domain",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "json_domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "json_paused",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "json_paused",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "json_name_servers",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "json_name_servers",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "0rtt",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "0rtt",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "advanced_ddos",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "advanced_ddos",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "always_online",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "always_online",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "always_use_https",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "always_use_https",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "automatic_https_rewrites",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "automatic_https_rewrites",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "brotli",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "brotli",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "browser_cache_ttl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "browser_cache_ttl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "browser_check",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "browser_check",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "cache_level",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "cache_level",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "challenge_ttl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "challenge_ttl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ciphers",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ciphers",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "cname_flattening",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "cname_flattening",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "development_mode",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "development_mode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "early_hints",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "early_hints",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "edge_cache_ttl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "edge_cache_ttl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email_obfuscation",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email_obfuscation",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "filter_logs_to_cloudflare",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "filter_logs_to_cloudflare",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "hotlink_protection",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "hotlink_protection",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "http2",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "http2",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "http3",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "http3",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ip_geolocation",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ip_geolocation",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ipv6",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ipv6",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "log_to_cloudflare",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "log_to_cloudflare",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "max_upload",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "max_upload",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "min_tls_version",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "min_tls_version",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "minify",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "minify",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "mirage",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "mirage",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "mobile_redirect",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "mobile_redirect",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "opportunistic_encryption",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "opportunistic_encryption",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "opportunistic_onion",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "opportunistic_onion",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "orange_to_orange",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "orange_to_orange",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "origin_error_page_pass_thru",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "origin_error_page_pass_thru",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "polish",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "polish",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "prefetch_preload",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "prefetch_preload",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "privacy_pass",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "privacy_pass",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "proxy_read_timeout",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "proxy_read_timeout",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "pseudo_ipv4",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "pseudo_ipv4",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "response_buffering",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "response_buffering",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "rocket_loader",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "rocket_loader",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "security_header",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "security_header",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "security_level",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "security_level",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "server_side_exclude",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "server_side_exclude",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sort_query_string_for_cache",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "sort_query_string_for_cache",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ssl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ssl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "tls_1_2_only",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "tls_1_2_only",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "tls_1_3",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "tls_1_3",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "tls_client_auth",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "tls_client_auth",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "true_client_ip_header",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "true_client_ip_header",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "visitor_ip",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "visitor_ip",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "waf",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "waf",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "webp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "webp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "websockets",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "websockets",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ech",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ech",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "long_lived_grpc",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "long_lived_grpc",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "pq_keyex",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "pq_keyex",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "replace_insecure_js",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "replace_insecure_js",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "json_records",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "json_records",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "pairedItem_item",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "pairedItem_item",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 974904725,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1jt6od8FMt-Yo7A_CPGuyfqWzL7HJk6SZmQQFO6kkWBo/edit#gid=974904725",
          "cachedResultName": "data"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "=1jt6od8FMt-Yo7A_CPGuyfqWzL7HJk6SZmQQFO6kkWBo"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "1G0QLMadkHt22pU8",
          "name": "Google Sheets account"
        }
      },
      "executeOnce": false,
      "typeVersion": 4.5
    }
  ],
  "pinData": {},
  "connections": {
    "fa2397fa-baee-4aca-8ca3-8c0d1d2fada4": {
      "main": [
        [
          {
            "node": "5ae6a35b-5090-449f-a689-b82a13ced8b3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fcd860d3-021e-4cb1-a347-ffbe1d61a184": {
      "main": [
        [
          {
            "node": "deb40a37-4e32-4dc6-8620-8322ef8014ea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "57f125f5-319c-4607-b3ed-522ee9d086c2": {
      "main": [
        [
          {
            "node": "c5cb1263-7b24-48be-9af4-25eba131db17",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0e2582e1-c058-4b18-a062-7f199beb56ef": {
      "main": [
        [
          {
            "node": "d57e934d-d000-401f-938a-f9eeed756ff2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2348687c-8ce7-440a-9209-7ddc39c046ca": {
      "main": [
        [
          {
            "node": "542fad7f-13d5-4ddd-8558-23858b62764e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "da801aa4-e3f1-4e56-93e4-928eda0962d5": {
      "main": [
        [
          {
            "node": "2348687c-8ce7-440a-9209-7ddc39c046ca",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "542fad7f-13d5-4ddd-8558-23858b62764e": {
      "main": [
        [
          {
            "node": "09d1c96b-dc94-43bd-8847-5ba40747747a",
            "type": "main",
            "index": 0
          },
          {
            "node": "0e2582e1-c058-4b18-a062-7f199beb56ef",
            "type": "main",
            "index": 0
          },
          {
            "node": "3c84495b-1c2d-4252-bb9e-6f77d009a660",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d57e934d-d000-401f-938a-f9eeed756ff2": {
      "main": [
        [
          {
            "node": "fcd860d3-021e-4cb1-a347-ffbe1d61a184",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "3c84495b-1c2d-4252-bb9e-6f77d009a660": {
      "main": [
        [
          {
            "node": "fcd860d3-021e-4cb1-a347-ffbe1d61a184",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "deb40a37-4e32-4dc6-8620-8322ef8014ea": {
      "main": [
        [
          {
            "node": "fa2397fa-baee-4aca-8ca3-8c0d1d2fada4",
            "type": "main",
            "index": 0
          },
          {
            "node": "57f125f5-319c-4607-b3ed-522ee9d086c2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "57f125f5-319c-4607-b3ed-522ee9d086c2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "09d1c96b-dc94-43bd-8847-5ba40747747a": {
      "main": [
        [
          {
            "node": "820d2a47-77c6-47bb-a236-9f91351ad343",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ae6a35b-5090-449f-a689-b82a13ced8b3": {
      "main": [
        [
          {
            "node": "da801aa4-e3f1-4e56-93e4-928eda0962d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "820d2a47-77c6-47bb-a236-9f91351ad343": {
      "main": [
        [
          {
            "node": "fcd860d3-021e-4cb1-a347-ffbe1d61a184",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "2536518c-90b5-49be-8a22-0b3e542831f1": {
      "main": [
        [
          {
            "node": "da801aa4-e3f1-4e56-93e4-928eda0962d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

上級 - DevOps

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

ワークフロー情報
難易度
上級
ノード数22
カテゴリー1
ノードタイプ10
難易度説明

上級者向け、16ノード以上の複雑なワークフロー

作成者
KPendic

KPendic

@kres

With 15 years on my back, carrying clients' web apps through the storms of bad code, tight deadlines, and ever-changing tech trends, I now do stuff as an AI Automation Engineer, with focus on streamlining backend services, making systems faster, smarter, and more sustainable.

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34