The Recap AI - 歯科音声アシスタント

• •HTTP Webhookエンドポイント（n8nが自動生成）
• •Google Sheets API認証情報
• •Google Gemini API Key

{
  "id": "r2cQWoLPpK7BNtlA",
  "meta": {
    "instanceId": "06e5009344f682419c20ccd4ecdcb5223bbb91761882af93ac6d468dbc2cbf8d",
    "templateCredsSetupCompleted": true
  },
  "name": "The Recap AI - Dentist Voice Agent",
  "tags": [],
  "nodes": [
    {
      "id": "a352b87c-e6b9-45b2-bdf8-78d892543168",
      "name": "webhookトリガー",
      "type": "n8n-nodes-base.webhook",
      "position": [
        48,
        -32
      ],
      "webhookId": "4fe15a31-6365-4b96-a3d5-3b02bbe3d31a",
      "parameters": {
        "path": "4fe15a31-6365-4b96-a3d5-3b02bbe3d31a",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    },
    {
      "id": "5b2a46d3-2444-4dce-b2de-1f6526b761b3",
      "name": "空き状況取得",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        544,
        256
      ],
      "parameters": {
        "options": {
          "timezone": {
            "__rl": true,
            "mode": "list",
            "value": "America/Chicago",
            "cachedResultName": "America/Chicago"
          }
        },
        "timeMax": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End_Time', `The end time will always be the Start Time plus 1 hour.`, 'string') }}",
        "timeMin": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start_Time', `The start timestamp for the dental appointment.`, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "emailPlaceholder",
          "cachedResultName": "emailPlaceholder"
        },
        "resource": "calendar"
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "TG3WC49qzJvApajF",
          "name": "Lucas Google Calendar"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "82d08e14-44d7-45b0-be6b-b4736cf5f8be",
      "name": "思考",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        384,
        256
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "05ece507-6dea-4f3a-9a3b-aed813319118",
      "name": "予約作成",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        704,
        256
      ],
      "parameters": {
        "end": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End', `End time for the dental appointment. This should be 1 hour AFTER the start time. This will be in the Central Time Zone (CST).`, 'string') }}",
        "start": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start', `Start time for the dental appointment. You should assume this is a central timezone timestamp (CST).`, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "emailPlaceholder",
          "cachedResultName": "emailPlaceholder"
        },
        "additionalFields": {
          "summary": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Summary', 'The title/summary of this event should be in the format of \"Dental Appointment | {patient_name}\" where `patient_name` is the provided name of the patient.', 'string') }}"
        }
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "TG3WC49qzJvApajF",
          "name": "Lucas Google Calendar"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "cb872431-a32d-4098-b112-776cab3b4a2b",
      "name": "webhook応答",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        864,
        -32
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.4
    },
    {
      "id": "a9f97d50-49d0-4b5e-a35f-3d16a205ad17",
      "name": "gemini-2.5-flash",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        48,
        256
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "qp1NlMiIctmGD0Uu",
          "name": "Google Gemini (PaLM)"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
      "name": "歯科エージェント",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        352,
        -32
      ],
      "parameters": {
        "text": "=## Request Data\n\n{{ JSON.stringify($json.body, null, 2)}}\n",
        "options": {
          "systemMessage": "=## Role\n\nYou are an AI agent responsible for handling back office operations at the dental office \"Pearly Whites Dental\". You must make a decision about the data you receive and make a call into the appropriate tool in order to process this request and return the appropriate data necessary.\n\nYou should look at the provided `tool` value in the request body to help decided which tool to use.\n\nPay close attention to the constraints for number of times a tool is able to be used.\n\nYou have secure access to the following internal tools:\n  - `think` → you MUST use this to think carefully about how to handle the provided request data. This tool must be used on every turn and tool call interaction.\n  - `get_availability` → returns true/false availability on the Dental Office Calendar for the given start timestamp in CST (Central Time). **For availability requests, you MUST call this tool multiple times to find AT LEAST 2 available timeslots if they exist.** Matches the `get_availability` tool value included in the request.\n  - `create_appointment` → creates a 1-hour appointment event for the provided start time. This tool may only be called ONCE (1 time) in a given request. Do NOT use this tool multiple times. Matches the `create_appointment` tool value included in the request. If you use this tool more than once, your task will be considered a FAILURE.\n  - `log_patient_details` → logs the provided call details and patient details to a Google Sheet. This should ONLY be called and used once for a provided request since we are logging details ONCE per call/patient. In order to use this tool, you need to be given the patient name / insurance provider / optional questions and concerns - if you don't have this information, you should NOT use this tool. This will be used only at the very end of the call when all details are provided. Matches the `log_patient_details` tool value included in the request. If you use this tool more than once, your task will be considered a FAILURE.\n\n\n## Special Instructions for get_availability Tool\n\nWhen handling availability requests:\n\n1. **Always aim to return 2 available timeslots** when possible\n2. **Call get_availability multiple times** to check different time slots on the requested date\n3. **Search strategy:**\n   - Start with the requested time (if provided)\n   - If that's not available, check nearby times in 30-minute or 1-hour increments\n   - Check both earlier and later times on the same day\n   - Continue checking until you find 2 available slots OR exhaust reasonable options\n\n4. **Response format:** Return an array of available timeslots in ISO format (Central Time Zone CST):\n   ```json\n   {\n     \"availableSlots\": [\n       \"2024-01-15T14:00:00Z\",\n       \"2024-01-15T16:00:00Z\"\n     ]\n   }\n   ```\n\n5. **If fewer than 2 slots are found:**\n   - Return whatever available slots you found (even if just 1)\n   - It's better to return 1 slot than none\n\n6. **Time checking sequence example:**\n   - If user requests \"2:00 PM on Tuesday\"\n   - Check: 2:00 PM, 1:30 PM, 2:30 PM, 1:00 PM, 3:00 PM, 12:30 PM, 3:30 PM, etc.\n   - Stop when you have 2 available slots or have checked reasonable business hours\n\n7. **Business hours assumption:** \n   - Check times between 8:00 AM and 5:00 PM unless specified otherwise\n   - Skip lunch hour (12:00-1:00 PM) if applicable\n\nRemember: The get_availability tool can be called multiple times for availability requests, but create_appointment and log_patient_details must only be called ONCE per request.\n\nRemember: All times are in CST (Central Time Zone)"
        },
        "promptType": "define"
      },
      "typeVersion": 2
    },
    {
      "id": "17d6dacb-b331-4def-8469-f11f0f59234c",
      "name": "患者詳細記録",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        864,
        256
      ],
      "parameters": {
        "columns": {
          "value": {
            "Patient Name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Patient_Name', `Name of the patient booking their appointment.`, 'string') }}",
            "Call Timestamp": "={{ $now.toString() }}",
            "Insurance Provider": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Insurance_Provider', `Name of the insurance provider.`, 'string') }}",
            "Questions & Concerns": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Questions___Concerns', `Optional questions or concerns raised by the patient booking the appointment.`, 'string') }}",
            "Appointment Timestamp": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Appointment_Timestamp', `Timestamp the appointment is booked for.`, 'string') }}"
          },
          "schema": [
            {
              "id": "Call Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Call Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Patient Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Patient Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Insurance Provider",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Insurance Provider",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Questions & Concerns",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Questions & Concerns",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Appointment Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Appointment Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Patient Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "url",
          "cachedResultName": "Appointments"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D9WO3JbzZ472pDvR0GGKDm5Jz8KkTpg_EtSgK9yVZtg",
          "cachedResultUrl": "url",
          "cachedResultName": "Pearly Whites Dental Appointments"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "C8jshnaDinQz6p7c",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "fc64c0e2-838c-43a8-91f3-dcf1c062c13d",
      "name": "シンプルメモリ",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        224,
        256
      ],
      "parameters": {
        "sessionKey": "={{ $('webhook_trigger').item.json.headers['cf-ray'] }}",
        "sessionIdType": "customKey",
        "contextWindowLength": 10
      },
      "typeVersion": 1.3
    },
    {
      "id": "d8048dc8-78cd-4b5b-a9d1-6c85447c862d",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        -608
      ],
      "parameters": {
        "color": 5,
        "width": 624,
        "height": 1008,
        "content": "## AI dental appointment booking with Google Calendar and Sheets\n\n### Who's it for\n\nThis workflow is perfect for dental practices, medical offices, and healthcare providers who want to automate their appointment scheduling process. It's ideal for practices that receive high volumes of appointment requests and want to reduce manual booking while maintaining accurate patient records.\n\n### What it does\n\nThis AI-powered voice agent handles complete appointment booking workflows for \"Pearly Whites Dental.\" When patients call or submit requests, the system:\n\n- Analyzes the request using Google Gemini AI to understand patient needs\n- Checks calendar availability in real-time via Google Calendar integration\n- Automatically finds and offers up to 2 available appointment slots when the preferred time isn't available\n- Books confirmed appointments directly to the practice calendar\n- Logs all patient information (name, insurance, concerns) to Google Sheets for record-keeping\n- Maintains conversation context across interactions for natural dialogue flow\n\n\nThe workflow operates in Central Time Zone and assumes standard business hours (8 AM - 5 PM, excluding lunch). This can be changed / configured for your needs in the prompt + tool descriptions.\n\n### How it works\n\nThe system receives webhook requests containing patient interaction data. The AI agent processes this information and determines which tools to use based on the request type. For availability checks, it intelligently searches multiple time slots in 30-minute increments until finding suitable options. All appointments are automatically formatted as \"Dental Appointment | [Patient Name]\" and logged with complete patient details.\n\n### Requirements\n\n- Google Calendar API access with OAuth2 credentials\n- Google Sheets API access for patient data logging\n- Google Gemini API key for AI processing\n- Webhook endpoint for receiving requests\n- Pre-configured Google Calendar and Sheets document\n"
      },
      "typeVersion": 1
    },
    {
      "id": "32a1a022-707a-467f-bc19-c20229805d8b",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        16,
        -608
      ],
      "parameters": {
        "color": 6,
        "width": 624,
        "height": 528,
        "content": "### How to set up\n\n1. **Configure Google Calendar credentials** in the calendar tool nodes\n2. **Set up Google Sheets integration** with your patient tracking spreadsheet\n3. **Add your Google Gemini API key** to the language model node\n4. **Update the calendar ID** in both calendar nodes to match your practice calendar\n5. **Modify the Google Sheets document ID** to point to your patient records sheet\n6. **Test the webhook endpoint** to ensure proper request processing\n\n### How to customize the workflow\n\n- **Adjust business hours** by modifying the availability checking logic in the system prompt\n- **Change appointment duration** by updating the end time calculation (currently set to 1 hour)\n- **Modify patient data fields** by updating the Google Sheets column mapping\n- **Update practice name** by changing \"Pearly Whites Dental\" references in the system prompt\n- **Customize response format** by adjusting the AI agent's instructions for different appointment types"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e38ef05e-3ff0-4878-806b-1ba327cdfca4",
  "connections": {
    "82d08e14-44d7-45b0-be6b-b4736cf5f8be": {
      "ai_tool": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f": {
      "main": [
        [
          {
            "node": "cb872431-a32d-4098-b112-776cab3b4a2b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fc64c0e2-838c-43a8-91f3-dcf1c062c13d": {
      "ai_memory": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "a352b87c-e6b9-45b2-bdf8-78d892543168": {
      "main": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a9f97d50-49d0-4b5e-a35f-3d16a205ad17": {
      "ai_languageModel": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "5b2a46d3-2444-4dce-b2de-1f6526b761b3": {
      "ai_tool": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "05ece507-6dea-4f3a-9a3b-aed813319118": {
      "ai_tool": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "17d6dacb-b331-4def-8469-f11f0f59234c": {
      "ai_tool": [
        [
          {
            "node": "2ecea651-1cca-4eef-8772-3ecfe9ef3a5f",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}