n8n recipe · ai

Typeform → Google Gemini → Google Sheets

A Typeform answer is sorted into a category by Google Gemini, then logged as a Google Sheets row.

타입폼 답이 오면 구글 제미나이가 어떤 문의인지 분류하고 구글 시트에 한 줄 적어요.

Steps

  1. When when a typeform is submitted — Typeform node
  2. Then classify the answer with gemini — Google Gemini node
  3. Then add a row to google sheets — Google Sheets node

Fields to fill (5)

The file has every node wired up. These are the blanks only you can fill (your form, your sheet, your words).

NodeWhat to do
Typeformfill formId (Form which should trigger workflow on submission)
Google Geminifill modelId (Model)
Google Sheetsfill documentId (Document)
Google Sheetsfill sheetName (Sheet)
Google Sheetsfill columns (Columns)

Accounts to connect (3)

In n8n, pick or add a credential on each node — one of the types below.

Get the n8n file

Download typeform-classify-to-sheets.json

  1. Open a new, empty workflow in n8n.
  2. Open the workflow menu (⋯) and choose Import from File — or copy the JSON below and paste it onto the canvas (Ctrl/Cmd+V).
  3. Connect the accounts, fill the fields above, run one test, then turn the workflow on.
Or copy the JSON 
{
  "name": "A Typeform answer is sorted into a category by Google Gemini",
  "nodes": [
    {
      "id": "n1",
      "name": "Typeform Trigger",
      "type": "n8n-nodes-base.typeformTrigger",
      "typeVersion": 1.1,
      "parameters": {
        "formId": ""
      },
      "position": [
        240,
        300
      ],
      "notes": "step: when a typeform is submitted"
    },
    {
      "id": "n2",
      "name": "Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "typeVersion": 1.2,
      "parameters": {
        "resource": "text",
        "operation": "message",
        "messages": {
          "values": [
            {
              "role": "user",
              "content": "=Classify the answer:\n\n{{ JSON.stringify($json) }}"
            }
          ]
        },
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "position": [
        460,
        300
      ],
      "notes": "step: classify the answer with gemini"
    },
    {
      "id": "n3",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "parameters": {
        "resource": "sheet",
        "operation": "append",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": []
        }
      },
      "position": [
        680,
        300
      ],
      "notes": "step: add a row to google sheets"
    }
  ],
  "connections": {
    "Typeform Trigger": {
      "main": [
        [
          {
            "node": "Google Gemini",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "active": false
}