{"product_id":"chatgpt-style-google-calendar-management-with-gemini-data-tables","title":"ChatGPT-style Google Calendar Management with Gemini \u0026 Data Tables","description":"\u003ch3\u003eManage your Google Calendar through chat—powered by Gemini, and smarter color-coding with n8n Data Tables\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you control Google Calendar using natural-language requests in an n8n chat. It uses Google Gemini to interpret what you want, manages reusable event color categories via an n8n “Categories” data table, and can create, update\/move, delete, list, and recolor events based on your instructions.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives your message via an \u003cstrong\u003en8n chat trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCreates (or attempts to create) an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e called \u003cstrong\u003e“Categories”\u003c\/strong\u003e to store category names and corresponding \u003cstrong\u003eGoogle Calendar color IDs\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFetches details for your primary Google Calendar using the \u003cstrong\u003eGoogle Calendar API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses a \u003cstrong\u003eGoogle Gemini (PaLM) chat model\u003c\/strong\u003e with conversation memory to determine which actions are required.\u003c\/li\u003e\n  \u003cli\u003eReads, adds, or deletes category records in the \u003cstrong\u003e“Categories”\u003c\/strong\u003e data table so category-to-color mapping stays consistent.\u003c\/li\u003e\n  \u003cli\u003eLists Google Calendar events to find the correct \u003cstrong\u003eevent ID\u003c\/strong\u003e, then performs the requested action: \u003cstrong\u003ecreate\u003c\/strong\u003e, \u003cstrong\u003eupdate\/move\u003c\/strong\u003e, \u003cstrong\u003edelete\u003c\/strong\u003e, and\/or \u003cstrong\u003erecolor\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReturns the assistant’s reply, or prompts for clarification if no response is produced.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e“Schedule a team standup tomorrow at 10am and color it ‘Work’.”\u003c\/li\u003e\n  \u003cli\u003e“Move my dentist appointment to next Friday and recolor it ‘Personal’.”\u003c\/li\u003e\n  \u003cli\u003e“Delete the event titled ‘Project kickoff’.”\u003c\/li\u003e\n  \u003cli\u003e“List all events for next week and categorize them by your stored color rules.”\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e set, sticky note, http request, data table, data table tool, \u003cstrong\u003en8nn8n-nodes-langchainagent\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Calendar (OAuth2 + Calendar API) and Google Gemini chat (PaLM) with conversation memory\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements:\u003c\/strong\u003e Data Tables enabled in n8n so the workflow can create and use the \u003cstrong\u003e“Categories”\u003c\/strong\u003e table\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46228904083635,"sku":"N8N-20874","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JnprpqVlGE7fLFJFtmkCn_Yq3MYdVV.png?v=1792056338","url":"https:\/\/buyflowscripts.com\/products\/chatgpt-style-google-calendar-management-with-gemini-data-tables","provider":"N8N Commerce","version":"1.0","type":"link"}