{"product_id":"line-ai-assistant-workflow-gemini-gmail-sheets-n8n","title":"LINE AI Assistant Workflow: Gemini + Gmail + Sheets (n8n)","description":"\u003ch3\u003eTurn LINE messages into AI-powered actions across Gmail, Calendar, Tasks, and Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you send a LINE text (or voice note) and have a Gemini + OpenAI assistant carry out real work—reading\/sending Gmail, creating Google Calendar events, managing Google Tasks, recording expenses to Google Sheets—and then replying back to you in LINE with a short Traditional Chinese response.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives messages via a webhook trigger:\u003c\/strong\u003e Incoming LINE text or audio is processed automatically in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles voice messages with OpenAI:\u003c\/strong\u003e If the message is an audio clip, the workflow downloads the audio from the LINE Messaging API and transcribes it using OpenAI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUnderstands intent with Google Gemini:\u003c\/strong\u003e The transcribed text (or original LINE text) is sent to a \u003cstrong\u003eGoogle Gemini Chat Model\u003c\/strong\u003e agent with instructions to act as a personal assistant and record expenses when requested.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Gmail tools on request:\u003c\/strong\u003e The agent can read messages or send emails using Gmail capabilities.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManages schedule and follow-ups:\u003c\/strong\u003e When requested, it creates events in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e and creates, lists, or deletes tasks in \u003cstrong\u003eGoogle Tasks\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs expenses to Google Sheets:\u003c\/strong\u003e When an expense is mentioned, it appends a new row to a target Google Sheets ledger (date, type, amount, category, description, payment method).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReplies back in LINE:\u003c\/strong\u003e The final assistant response is sent to the original LINE conversation in \u003cstrong\u003eshort Traditional Chinese\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMessage your expenses from LINE and maintain an always-up-to-date Google Sheets ledger.\u003c\/li\u003e\n  \u003cli\u003eAsk the assistant to schedule something in Google Calendar while you’re chatting.\u003c\/li\u003e\n  \u003cli\u003eTurn quick reminders into Google Tasks—create, list, or remove on demand.\u003c\/li\u003e\n  \u003cli\u003eDraft or send emails via Gmail using natural language in LINE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow trigger:\u003c\/strong\u003e LINE webhook receiver\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI components:\u003c\/strong\u003e n8nn8n-nodes-langchainagent with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e Chat Model + n8nn8n-nodes-langchainopen ai for audio transcription\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle tools:\u003c\/strong\u003e \u003cstrong\u003egmail tool\u003c\/strong\u003e, \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, \u003cstrong\u003eGoogle Tasks tool\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUtilities:\u003c\/strong\u003e HTTP Request, IF node, and integration via HTTP + LINE Messaging API audio download\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761001259187,"sku":"N8N-17842","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/f1f79Y061N_BExNDY198R_JIBrw2nI.png?v=1785920646","url":"https:\/\/buyflowscripts.com\/products\/line-ai-assistant-workflow-gemini-gmail-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}