Save business card contacts from LINE photos to Google Sheets using Gemini

by TakatoYamada ✓ · 23 views · created 2026-04-26 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 17 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls api.line.me over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. If: checks a condition and branches into true / false
2. Fetch Image from LINE API (HTTP Request): calls an HTTP API
3. Respond Not Image to LINE (Respond to Webhook): sends the response back to the webhook caller
4. Encode Image as Base (Code): runs custom JavaScript code
5. Extract Card Info with Gemini (Basic LLM Chain): sends a prompt to an LLM
6. Parse Gemini Output Data (Code): runs custom JavaScript code
7. Read Contacts from Sheets (Google Sheets): uses Google Sheets
8. If: checks a condition and branches into true / false
9. Send Duplicate Reply via LINE (HTTP Request): calls api.line.me (POST)
10. Append Contact to Sheets (Google Sheets): append

…plus 6 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelGoogle Sheets

HTTP calls to: api.line.me

Before you upgrade to n8n 3.0

Nodes used (9)

• Edit Fields (Set)n8n-nodes-base.set
• Webhookn8n-nodes-base.webhook
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Sheetsn8n-nodes-base.googleSheets
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

Save business card contacts from LINE photos to Google Sheets with Gemini --- Who is this for Sales professionals, account managers, and anyone who exchanges business cards regularly. Designed especially for LINE users (Japan, Taiwan, Thailand, etc.) who want…

View the original on n8n.io → Check your own copy