Automate Personal Assistant Tasks with n8n and Google Gemini

What this workflow does

This workflow listens for chat messages that give commands.

It uses Google Gemini AI to understand those commands in plain language.

It keeps a simple memory to remember the conversation context.

Then it works with Google Sheets to add, find, or update contacts.

It manages Google Calendar to create or change events.

Finally, it drafts emails in Gmail ready for review.

This saves many hours each week and avoids errors in scheduling and contact data.

Who should use this workflow

This is for busy people who do many tasks like scheduling meetings, managing contacts, and sending emails manually.

It fits well for anyone who uses Google Sheets, Calendar, and Gmail together often.

The workflow helps those who want less manual work and fewer mistakes.

Tools / services used

• Langchain Chat Trigger node: Receives chat messages as commands.
• Google Gemini Chat Model node: Interprets natural language commands.
• Simple Memory node: Keeps recent chat context for better replies.
• MCP Server Trigger and MCP Client nodes: Manage chat communication sessions.
• Google Sheets nodes: Add, search, and update contact rows.
• Google Calendar nodes: Create, update, and find events.
• Gmail Draft Email node: Prepare email drafts with AI-generated text.

Inputs, processing, and outputs

Inputs

• User chat messages sent to the Webhook node.
• Google Sheets for contact database.
• Google Calendar events user owns.

Processing

• Google Gemini Chat Model understands commands like adding contacts or scheduling meetings.
• Simple Memory node stores context for ongoing conversations.
• Google Sheets nodes manage contacts as per commands.
• Google Calendar nodes handle event creation and updates.
• Gmail Draft Email node composes email drafts based on AI content.

Outputs

• Updated contact rows in Google Sheets.
• Calendar events created or changed.
• Email drafts available in Gmail for review.
• Chat responses sent back to user interface.

Beginner step-by-step: How to use this workflow in n8n

Step 1: Import the workflow

1. Download the workflow file using the Download button on this page.
2. Go to n8n editor and select “Import from File” to upload the workflow.

Step 2: Add credentials and IDs

1. Add Google API credentials for Calendar, Sheets, and Gmail nodes using OAuth2.
2. Check and update the Google Sheets document ID and sheet name if needed.
3. Set Google Calendar account and calendar ID properly.
4. Verify the webhook URL in the Webhook node matches the one used to receive chat messages.

Step 3: Test the workflow

1. Send test chat messages to the webhook URL, like “Add contact John” or “Create meeting tomorrow at 10 am”.
2. Observe node executions in n8n editor to confirm actions work as expected.

Step 4: Activate for production

1. Turn the workflow ON in the n8n editor.
2. Optionally set up notifications for errors or task completions.
3. For better data privacy and control use self-host n8n.

Customization ideas

• Change the AI model to a different Gemini version by editing the modelName in the Gemini node.
• Switch Google Sheets or Calendar IDs to use your own data sources.
• Adjust the Simple Memory node settings to remember longer or shorter conversation history.
• Make the email node send emails automatically instead of drafting by changing the operation parameter.
• Add extra notification nodes like Slack or Telegram to get real-time alerts.

Edge cases and troubleshooting

Problem: Google Gemini API quota exceeded

Cause: API usage limits reached on Google Cloud.

Solution: Check quotas in Google Cloud Console and reduce prompt size or upgrade plan.

Problem: Webhook not triggering on messages

Cause: Wrong webhook URL or inactive Webhook node.

Solution: Verify the URL is correct and ensure the node and workflow are active.

Problem: Google Sheets read/write errors

Cause: Wrong spreadsheet ID, no permission, or expired credentials.

Solution: Confirm IDs, permissions, and refresh OAuth2 tokens.

Summary of benefits

✓ Saves about 70% time on scheduling, emailing, and contact tasks.

✓ Reduces errors like double bookings or missing contact info.

✓ Keeps Google Sheets contacts, Calendar events, and Gmail drafts in sync.

→ Helps the user focus more on important work rather than manual routine.