Turn simple chat requests into real actions in Gmail, Google Calendar, and Google Sheets. A smart assistant handles meeting plans, email drafts, and contact updates so teams move faster with less manual work.

A chat message starts the flow. A Google Gemini model with short term memory drives a personal assistant that decides which tool to use. Through the MCP link, it can search inboxes, draft replies, create and update calendar events, and add or edit contact rows in Sheets. It can also find single or multiple events and look up emails by query. Key fields like email subject, message body, and event ID are filled by AI to reduce data entry and back and forth.

Setup is simple once you connect your Google accounts and the Gemini key in n8n. Point the MCP Client to the MCP Server Trigger URL, pick the right calendar and spreadsheet, and you are ready to test. Expect faster follow ups, cleaner contact data, and less context switching. Great for daily scheduling, client booking, and quick CRM edits from one chat.

• Chat message trigger starts the assistant when a new message arrives.
• Google Gemini powers replies and tool decisions with short term memory for context.
• MCP Server and MCP Client link the assistant to tool nodes for reliable actions.
• Gmail tools search emails and create drafts with AI filled subject and message.
• Google Calendar tools create, update, and find events by ID or time range.
• Google Sheets tools add, find, and update contact rows for simple CRM tasks.
• AI field mapping fills Event ID and email content to cut manual typing.
• Find multiple events or emails to build summaries for daily plans and follow ups.

• Reduce manual admin work from 2 hours to 15 minutes by delegating scheduling, email drafting, and contact updates.
• Streamline meeting scheduling by 70% with one chat request that creates or updates events.
• Improve contact data accuracy by 90% by updating one source of truth in Google Sheets.
• Connect Gmail, Google Calendar, and Google Sheets in one assistant to cut context switching.
• Handle 3 times more meeting and email requests without adding headcount.

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Gemini, Gmail, Google Calendar and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Gemini Chat Model node and in the Credential to connect with dropdown click Create new credential. Follow the on screen steps to add your Gemini API key and save.
4. Open the Gmail nodes (Find emails and Draft email). In each node, choose Credential to connect with, click Create new credential, and follow the on screen Google sign in flow to grant Gmail access.
5. Open the Google Calendar nodes (Create event, Update event, Find single event, Find multiple events). Create new Google Calendar credentials and sign in. In Create event and Update event, choose your target calendar from the dropdown.
6. Open the Google Sheets nodes (Add new row, Find row, Update row). Create new Google Sheets credentials and sign in. Select your spreadsheet and sheet, then confirm column mapping in each node.
7. Open the MCP Server Trigger node and copy its webhook or SSE URL. Then open the MCP Client node and paste that URL into the SSE endpoint field so the assistant can send tool calls.
8. Check the Personal Assistant node to confirm it uses the Google Gemini model and the Simple Memory node is connected as AI memory.
9. Review AI field mappings: in Draft email confirm Subject and Message are set by AI, and in Update event confirm the Event ID is filled by AI. Adjust prompts if you need more detail.
10. Run a test: send a chat message like Create a meeting with Sam tomorrow at 9 AM. Confirm the event appears in your Google Calendar. Ask Draft an email to Sam with the details and check your Gmail Drafts folder.
11. Test CRM actions: message Add a new contact row for Rick or Update Rick's email. Confirm Google Sheets shows the new or updated row.
12. If you see permission errors, recheck Google credential scopes in n8n and ensure you selected the correct calendar and spreadsheet. If the MCP Client does not receive updates, confirm the SSE URL matches the MCP Server Trigger URL.