{
  "id": "b303dnFyBmuqesmB",
  "meta": {
    "instanceId": "4e49d2aa255c4285252f77c3e267713f0c6f8a8def9bdeb0721006a510b7dc8a",
    "templateCredsSetupCompleted": true
  },
  "name": "G-Sheet Workflow",
  "tags": [],
  "nodes": [
    {
      "id": "415aa112-8163-427f-b4e9-51532f4580f1",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        0,
        0
      ],
      "webhookId": "d5e8907c-1110-4e7a-8bb1-7097d13b1e4d",
      "parameters": {
        "options": {},
        "formTitle": "Assignment Form",
        "formFields": {
          "values": [
            {
              "fieldType": "textarea",
              "fieldLabel": "Name"
            },
            {
              "fieldType": "radio",
              "fieldLabel": "Gender",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Male"
                  },
                  {
                    "option": "Female"
                  }
                ]
              }
            }
          ]
        },
        "formDescription": "This is an assignment given by Abhijith"
      },
      "typeVersion": 2.6
    },
    {
      "id": "9bc03d99-2888-471c-8c46-c64bca42bd93",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        208,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $json.Name }}",
            "Gender": "={{ $json.Gender }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Gender",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Gender",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ZYBCYvy-50OvPGJToSQsaX0Wp34T1QKe5XdUSexFj7Q/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1ZYBCYvy-50OvPGJToSQsaX0Wp34T1QKe5XdUSexFj7Q",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ZYBCYvy-50OvPGJToSQsaX0Wp34T1QKe5XdUSexFj7Q/edit?usp=drivesdk",
          "cachedResultName": "n8n Test Sheet"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ck8pUOu8aRmi1mH4",
          "name": "Google Sheets OAuth2 API"
        }
      },
      "typeVersion": 4.7
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "binaryMode": "separate",
    "availableInMCP": false,
    "executionOrder": "v1"
  },
  "versionId": "21f4c5a1-8468-42d4-ae17-082bff405f83",
  "nodeGroups": [],
  "connections": {
    "On form submission": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}