Googleフォーム即時通知

• •Googleアカウント + Gmail API認証情報
• •Google Sheets API認証情報

{
  "id": "5eFDTDVU6obMSRgd",
  "meta": {
    "instanceId": "b7b2db9d6a461f902b25d685e4550cab3c88fcbb3254a8654e06246b67e4ff5c",
    "templateCredsSetupCompleted": true
  },
  "name": "Google Form Instant Notification",
  "tags": [
    {
      "id": "5iQR5Cw05Bzz7Aqt",
      "name": "Google",
      "createdAt": "2025-08-02T17:36:32.751Z",
      "updatedAt": "2025-08-02T17:36:32.751Z"
    },
    {
      "id": "PlBq4GrfRsEhR6mN",
      "name": "google form",
      "createdAt": "2025-08-14T09:57:38.641Z",
      "updatedAt": "2025-08-14T09:57:38.641Z"
    },
    {
      "id": "S94PaeZJiPKn5Ei9",
      "name": "gmail",
      "createdAt": "2025-08-14T09:57:18.678Z",
      "updatedAt": "2025-08-14T09:57:18.678Z"
    },
    {
      "id": "Unbn35P90TtJuAQC",
      "name": "email",
      "createdAt": "2025-08-14T09:57:13.394Z",
      "updatedAt": "2025-08-14T09:57:13.394Z"
    },
    {
      "id": "h2TBJOs7feXDIfbL",
      "name": "google sheet",
      "createdAt": "2025-08-14T09:57:22.041Z",
      "updatedAt": "2025-08-14T09:57:22.041Z"
    },
    {
      "id": "rYuINsb3Y1XjrgNv",
      "name": "Productivity",
      "createdAt": "2025-08-02T17:36:49.812Z",
      "updatedAt": "2025-08-02T17:36:49.812Z"
    }
  ],
  "nodes": [
    {
      "id": "c07717f4-b7b0-4628-a71d-0eb1016934fd",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        -320
      ],
      "parameters": {
        "color": 3,
        "height": 176,
        "content": "## Required\n\n\n- Google account\n- Google Form\n- Google Sheet linked to the form"
      },
      "typeVersion": 1
    },
    {
      "id": "7d6c113d-07c0-4808-87a0-a0dd999fa45c",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        -320
      ],
      "parameters": {
        "color": 4,
        "width": 560,
        "height": 848,
        "content": "## 2. Send the email\n\nThe code node, will create the message and gather all the informations wanted about the row newly added. So you'll get a new message with the new informations.\n\n\nHow to setup:\n- Connect with your Gmail account credentials."
      },
      "typeVersion": 1
    },
    {
      "id": "33e3c6da-fa71-4882-95da-fcb6c3380f83",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        -320
      ],
      "parameters": {
        "color": 2,
        "width": 416,
        "height": 848,
        "content": "## 1.Workflow trigger et data gathering\n\nThe workflow is **triggered automatically** as soon as a new request is received (a new row in the Google sheet from the Google Form). \n\nHow to setup:\n- Set up your Google form and link it to a google sheet\n- link the google sheet to this workflow"
      },
      "typeVersion": 1
    },
    {
      "id": "6fb8f4e7-0e51-4c54-a5e9-55c75b77fcb8",
      "name": "メール生成",
      "type": "n8n-nodes-base.code",
      "position": [
        832,
        0
      ],
      "parameters": {
        "jsCode": "const item = $input.item.json;\n\nlet html = `\n  <h2>📬 You just got a new question received</h2>\n  <p><strong>From:</strong> ${item[\"Adresse e-mail\"] || \"N/A\"}</p>\n  <p><strong>Request:</strong> ${item[\"Please write your request\"] || \"N/A\"}</p>\n`;\n\nreturn [{ json: { html } }];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "21ee131e-0206-4244-b16a-a5124a786b9b",
      "name": "行追加時のトリガー",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        416,
        0
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "id"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "url"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "3Ibd0h6fDr3TCJ1v",
          "name": "Google Sheets Trigger account"
        }
      },
      "notesInFlow": false,
      "typeVersion": 1
    },
    {
      "id": "95b749c3-12fa-4c8c-a946-2e4177908847",
      "name": "即時メール",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1040,
        0
      ],
      "webhookId": "9a9b4d63-e0ca-4ae5-8854-31229a1c1db3",
      "parameters": {
        "sendTo": "email",
        "message": "={{$json.html}}",
        "options": {},
        "subject": "The requests you received today"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "88G2Fa5bxsnrjAYu",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "053a5a9a-940f-4a93-a121-9d16d23d0665",
  "connections": {
    "6fb8f4e7-0e51-4c54-a5e9-55c75b77fcb8": {
      "main": [
        [
          {
            "node": "95b749c3-12fa-4c8c-a946-2e4177908847",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "21ee131e-0206-4244-b16a-a5124a786b9b": {
      "main": [
        [
          {
            "node": "6fb8f4e7-0e51-4c54-a5e9-55c75b77fcb8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}