Google Calendar+Gmail管理器

• •Google 账号和 Gmail API 凭证
• •Google Gemini API Key

{
  "meta": {
    "instanceId": "4bddd4c66accca8d5ebb7f241f9454e06e9433070d1d486bf090c10a91392d5c",
    "templateCredsSetupCompleted": true
  },
  "name": "Google Calendar+GMail Manager",
  "tags": [],
  "nodes": [
    {
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        760,
        -160
      ],
      "parameters": {
        "options": {
          "systemMessage": "# n8n AI Agent System Prompt: Personal Assistant\n\nYou are an advanced AI Personal Assistant operating within an n8n workflow. Your primary function is to serve as a cognitive engine that translates user requests into specific, executable tool calls. You are precise, methodical, and you do not act without sufficient information.\n\n---\n\n## Core Operating Principles\n\n1.  **Tool-Centric Operation:** You can only perform actions for which you have been explicitly provided a tool. Before acting, you will review the `Tool Manifest` to confirm you have the required capability. If a user's request does not map to any available tool, you **MUST** clearly state that you cannot perform the action and why. For example: \"I am sorry, but I cannot set a reminder as I do not have a tool for that function.\"\n2.  **Clarification Mandate:** If a user's request is ambiguous or is missing a required parameter for a tool, you **MUST** ask clarifying questions before proceeding. Never guess or assume details like timezones, email recipients, or event durations.\n3.  **Single-Focus Execution:** Handle one primary task at a time. If a user asks to schedule a meeting and check emails, process the meeting first unless the user specifies otherwise.\n4.  **User Confirmation:** Before executing actions that create data or notify others (e.g., creating an event, sending an email), briefly state your plan of action for the user to confirm. Example: \"I will schedule an event titled 'Project Sync' for 3 PM tomorrow and invite 'bob@example.com'. Is that correct?\"\n\n---\n\n## Tool Manifest & Usage Protocols\n\nYou have access to the following tools. Adhere strictly to their parameters and usage triggers.\n\n#### Tool: `system_getCurrentTime`\n* **Description:** Retrieves the current date and time.\n* **When to Use:** When the user asks for the current time, date, or uses relative terms like \"today\", \"tomorrow\", \"this week\". This tool is often a dependency for other tools.\n* **Parameters:**\n    * `timezone` (string, required): The IANA timezone identifier (e.g., 'America/New_York', 'Asia/Kolkata').\n* **Protocol:** If the user asks for the time without providing a `timezone`, you **MUST** respond by asking: \"Certainly. In which timezone would you like the time?\" You will output the time in `HH:MM` format as requested.\n\n#### Tool: `googleCalendar_getEvents`\n* **Description:** Fetches a list of events from the user's Google Calendar within a specified date range.\n* **When to Use:** When the user asks \"What's on my schedule?\", \"Am I busy?\", or asks about events for a specific day, week, or month.\n* **Parameters:**\n    * `startDate` (string, ISO 8601 format, required): The start of the time period.\n    * `endDate` (string, ISO 8601 format, required): The end of the time period.\n* **Protocol:** Use `system_getCurrentTime` to establish the date for relative queries. \"This week\" means from today's date for the next 7 days. \"Today\" means from the start of the current day to the end of the current day.\n\n#### Tool: `googleCalendar_createEvent`\n* **Description:** Creates a new event on the user's Google Calendar.\n* **When to Use:** When the user asks to \"schedule\", \"book\", \"create\", or \"add\" an event, meeting, or appointment.\n* **Parameters:**\n    * `summary` (string, required): The title of the event.\n    * `startTime` (string, ISO 8601 format, required): The start time of the event.\n    * `endTime` (string, ISO 8601 format, required): The end time of the event.\n    * `attendees` (array of strings, optional): A list of attendee email addresses.\n* **Protocol:** If the user mentions other people in the scheduling request, automatically include their names/emails in the `attendees` parameter. You must have all required parameters before calling this tool.\n\n#### Tool: `gmail_sendMessage`\n* **Description:** Composes and sends an email via Gmail.\n* **When to Use:** When the user asks to \"email\", \"send a message\", or \"contact\" someone.\n* **Parameters:**\n    * `recipient` (string, required): The primary recipient's email address.\n    * `subject` (string, required): The email subject line.\n    * `body` (string, required): The content of the email.\n* **Protocol:** The `subject` must be detailed and relevant to the body's content. The `body` should be professionally written and clearly articulate the user's message without unnecessary embellishment.\n\n#### Tool: `gmail_getMessages`\n* **Description:** Retrieves a list of emails from the user's Gmail account.\n* **When to Use:** When the user asks to \"check my email\", \"see recent emails\", or \"find an email from someone\".\n* **Parameters:**\n    * `startDate` (string, ISO 8601 format, optional): The start date to filter emails from.\n    * `endDate` (string, ISO 8601 format, optional): The end date to filter emails to.\n    * `from` (string, optional): Filter emails from a specific sender.\n* **Protocol:** Use `system_getCurrentTime` to define date ranges for requests like \"emails from this morning\".\n\n---\n\n## Defined Workflow: \"Schedule a Meeting and Send Invite\"\n\nWhen a user's request involves both scheduling a meeting and notifying the attendees, you **MUST** follow this exact sequence of tool calls:\n\n1.  **Acknowledge and Gather:** Acknowledge the request. Check if you have all the necessary information (`topic/summary`, `attendees`, `proposed time/date`, `duration`). If not, ask for the missing details.\n2.  **Step 1: Check Availability (`googleCalendar_getEvents`)**: Use the `googleCalendar_getEvents` tool to check the user's schedule for the proposed `startTime` and `endTime`.\n3.  **Step 2: Report & Decide**:\n    * **If Conflict Exists:** Report the scheduling conflict to the user, mentioning the existing event. State: \"You already have '[Existing Event Title]' scheduled at that time. Would you like to find a different time?\" Await further instructions.\n    * **If No Conflict:** Proceed to the next step.\n4.  **Step 3: Create Event (`googleCalendar_createEvent`)**: Once the time is confirmed to be free, call this tool with the gathered `summary`, `startTime`, `endTime`, and `attendees`.\n5.  **Step 4: Notify Attendees (`gmail_sendMessage`)**: After the event is successfully created, immediately call this tool to send an invitation email.\n    * `recipient`: The `attendees` from the event.\n    * `subject`: \"Meeting Invitation: [Event Summary]\".\n    * `body`: \"Hello,\\n\\nThis is an invitation to schedule '[Event Summary]' on [Date] at [Time]. Please check your calendar for the official Google Calendar invite.\\n\\nBest regards,\"\n6.  **Step 5: Final Confirmation**: Report to the user that the event has been scheduled and the invitation email has been sent."
        }
      },
      "retryOnFail": true,
      "typeVersion": 2.2,
      "id": "AI-Agent-0"
    },
    {
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        272,
        16
      ],
      "parameters": {
        "options": {}
      },
      "notesInFlow": true,
      "typeVersion": 1,
      "id": "Google-Gemini-Chat-Model-1"
    },
    {
      "name": "Simple Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        448,
        64
      ],
      "parameters": {
        "contextWindowLength": 10
      },
      "typeVersion": 1.3,
      "id": "Simple-Memory-2"
    },
    {
      "name": "Send a message in Gmail",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        592,
        64
      ],
      "parameters": {
        "sendTo": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('To', ``, 'string') }}",
        "message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
        "options": {
          "appendAttribution": true
        },
        "subject": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}"
      },
      "notesInFlow": true,
      "typeVersion": 2.1,
      "id": "Send-a-message-in-Gmail-3"
    },
    {
      "name": "Get many messages in Gmail",
      "type": "n8n-nodes-base.gmailTool",
      "notes": "You Get Details Of the Mail of the User, You are able to Read through them and if the user says a time frame you only give for the specific time frame",
      "position": [
        752,
        80
      ],
      "parameters": {
        "limit": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Limit', `If the User Specifies a certain time frame, lets make it so that it returns it from that specific time frame and not from other than that time frame. ALSO IF IT ASKS FOR A CERTAIN TIME FRAME GIVE ALL IN THAT TIME FRAME `, 'number') }}",
        "simple": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Simplify', `Dont give a very short summary, give a more detailed Summary than a breif summary`, 'boolean') }}",
        "filters": {
          "q": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Search', ``, 'string') }}"
        },
        "options": {},
        "operation": "getAll"
      },
      "notesInFlow": true,
      "typeVersion": 2.1,
      "id": "Get-many-messages-in-Gmail-4"
    },
    {
      "name": "Get many events in Google Calendar",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        896,
        80
      ],
      "parameters": {
        "options": {},
        "timeMax": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Before', ``, 'string') }}",
        "timeMin": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('After', ``, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "p70157015@gmail.com",
          "cachedResultName": "p70157015@gmail.com"
        },
        "operation": "getAll"
      },
      "typeVersion": 1.3,
      "id": "Get-many-events-in-Google-Calendar-5"
    },
    {
      "name": "Date & Time",
      "type": "n8n-nodes-base.dateTimeTool",
      "position": [
        1040,
        64
      ],
      "parameters": {
        "options": {
          "timezone": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Timezone', ``, 'string') }}"
        },
        "outputFieldName": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Output_Field_Name', ``, 'string') }}"
      },
      "typeVersion": 2,
      "id": "Date-Time-6"
    },
    {
      "name": "Get availability in a calendar in Google Calendar",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        1184,
        64
      ],
      "parameters": {
        "options": {},
        "timeMax": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End_Time', ``, 'string') }}",
        "timeMin": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start_Time', ``, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "p70157015@gmail.com",
          "cachedResultName": "p70157015@gmail.com"
        },
        "resource": "calendar"
      },
      "typeVersion": 1.3,
      "id": "Get-availability-in-a-calendar-in-Google-Calendar-7"
    },
    {
      "name": "Create an event in Google Calendar",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        1360,
        64
      ],
      "parameters": {
        "end": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End', ``, 'string') }}",
        "start": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start', ``, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "p70157015@gmail.com",
          "cachedResultName": "p70157015@gmail.com"
        },
        "additionalFields": {
          "attendees": [
            "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('attendees0_Attendees', `you add attendees here, add there email here`, 'string') }}"
          ],
          "description": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Description', ``, 'string') }}",
          "conferenceDataUi": {
            "conferenceDataValues": {
              "conferenceSolution": "hangoutsMeet"
            }
          }
        },
        "useDefaultReminders": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Use_Default_Reminders', ``, 'boolean') }}"
      },
      "notesInFlow": true,
      "typeVersion": 1.3,
      "id": "Create-an-event-in-Google-Calendar-8"
    },
    {
      "name": "Update an event in Google Calendar",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        1536,
        64
      ],
      "parameters": {
        "eventId": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Event_ID', ``, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "p70157015@gmail.com",
          "cachedResultName": "p70157015@gmail.com"
        },
        "operation": "update",
        "updateFields": {}
      },
      "typeVersion": 1.3,
      "id": "Update-an-event-in-Google-Calendar-9"
    },
    {
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -192
      ],
      "parameters": {
        "color": 4,
        "content": "### 🗣️ Chat Node\nIf you wish to, you can switch to a different Messenger app like discord,Whatsapp and Telegram"
      },
      "typeVersion": 1,
      "id": "Sticky-Note-10"
    },
    {
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -336
      ],
      "parameters": {
        "width": 320,
        "height": 144,
        "content": "### 🤖 AI Agent  \nThe “brain” of the workflow. Interprets your requests and chooses the right tool. Asks for clarification if details are missing and confirms before important actions."
      },
      "typeVersion": 1,
      "id": "Sticky-Note1-11"
    },
    {
      "name": "Chat Node",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        96,
        -160
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.3,
      "id": "Chat-Node-12"
    },
    {
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        48
      ],
      "parameters": {
        "color": 5,
        "width": 272,
        "height": 192,
        "content": "### 🧠 Google Gemini Chat Model (or any LLM)  \nThe AI language model that powers the assistant. You can swap Gemini with OpenAI, Claude, or another model. (i have used gemini since its free and easy to setup here is the link to get your own [AI API Key](https://aistudio.google.com/apikey)"
      },
      "typeVersion": 1,
      "id": "Sticky-Note2-13"
    },
    {
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        240
      ],
      "parameters": {
        "color": 6,
        "width": 272,
        "height": 128,
        "content": "### 📌 Simple Memory  \nKeeps short-term context of the last ~10 interactions so the agent remembers what “it” refers to in your requests."
      },
      "typeVersion": 1,
      "id": "Sticky-Note3-14"
    },
    {
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        272
      ],
      "parameters": {
        "color": 7,
        "width": 1024,
        "height": 624,
        "content": "## Tools\nThe tools consists of the following\n\n\n### 📧 Send a message in Gmail  \nSends emails from your Gmail account. Requires recipient, subject, and body. Generates clear, professional text.\n\n### 📥 Get many messages in Gmail  \nChecks your inbox. Can filter by timeframe or sender. Returns detailed summaries, not just one-liners.\n\n### 📅 Get many events in Google Calendar  \nLists your events for a chosen date range. Useful for “What’s on my schedule this week?”\n\n### ⏰ Date & Time  \nConverts natural phrases like “tomorrow at 3 PM” into exact ISO date-time values.\n\n### ✅ Get availability in Google Calendar  \nChecks if you’re free during a specific time slot. Prevents double-booking before scheduling.\n\n### 📝 Create an event in Google Calendar  \nSchedules a new meeting. Adds title, start/end times, attendees, description, and Google Meet link.\n\n### ✏️ Update an event in Google Calendar  \nEdits an existing meeting. Change time, attendees, or details without creating a new event.\n"
      },
      "typeVersion": 1,
      "id": "Sticky-Note4-15"
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "bde719eb-a0f0-4658-9044-8c02b3cf1eff",
  "connections": {
    "Chat-Node-12": {
      "main": [
        [
          {
            "node": "AI-Agent-0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Date-Time-6": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Simple-Memory-2": {
      "ai_memory": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Send-a-message-in-Gmail-3": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google-Gemini-Chat-Model-1": {
      "ai_languageModel": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get-many-messages-in-Gmail-4": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create-an-event-in-Google-Calendar-8": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get-many-events-in-Google-Calendar-5": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Update-an-event-in-Google-Calendar-9": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get-availability-in-a-calendar-in-Google-Calendar-7": {
      "ai_tool": [
        [
          {
            "node": "AI-Agent-0",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}