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

Workflow overview

Why this workflow matters

Improves internal consulting operations and productivity. Relevant for managed services and support workflows.

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 AlekSystem 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.

Best fit

Need another direction?