Scan business cards with Gemini AI and log contacts to Google Sheets and Calendar

Go to Workflow
0 views
Built by Yanagita Yusuke Yanagita Yusuke
Created on June 05, 2026

Description

Who is this for

Small to medium businesses in Japan using a LINE Official Account for customer support. Ideal for retail shops, restaurants, salons, and service providers who want to reduce response times without hiring additional staff.

What this workflow does

Receives customer messages from a LINE Official Account via webhook, classifies each inquiry into four categories (FAQ, product, complaint, or other) using Google Gemini AI, sends an appropriate auto-reply in Japanese through the LINE Reply API, escalates complaints via Gmail to a staff member, and logs every interaction to Google Sheets for tracking and analysis.

How to set up

Create a LINE Official Account and enable the Messaging API
Set the webhook URL to your n8n endpoint shown in the trigger node
Create a Header Auth credential with your LINE Channel Access Token
Add your Google Gemini API key credential
Connect Google Sheets and Gmail OAuth2 credentials
Update the escalation email and business name in the Config Settings node

Requirements

LINE Official Account with Messaging API enabled
Google Gemini API key (free tier available)
Google Sheets and Gmail credentials

How to customize

Edit the classification prompt to match your business type and common inquiries. Add more categories by extending the Switch node rules.

Nodes Used (7)

AI Agent
@n8n/n8n-nodes-langchain.agent
Gmail
n8n-nodes-base.gmail
Google Calendar
n8n-nodes-base.googleCalendar
Google Drive
n8n-nodes-base.googleDrive
Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Google Sheets
n8n-nodes-base.googleSheets
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured