Back to Templates

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

Created by

Created by: TakatoYamada || takato-door
TakatoYamada

Last update

Last update 5 hours ago

Categories

Share

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 to eliminate manual data entry after networking events or client meetings.

What this workflow does

When a user sends a business card photo to a LINE bot, Gemini AI automatically extracts contact information (name, company, job title, phone number, email, postal address) and saves it to Google Sheets. Duplicate entries are detected by email address and skipped automatically. The team receives a Slack notification for every new contact, and the user gets an instant LINE confirmation.

How to set up

  1. Create a LINE Messaging API channel and obtain a Channel Access Token
  2. Prepare a Google Sheet with columns: Timestamp, Name, Company, Title, Phone, Email, Address, LINE_UID
  3. Get a Google Gemini API key from Google AI Studio
  4. Set up a Slack Incoming Webhook URL
  5. Enter all credentials in the Set Configuration Parameters node
  6. Register the n8n Webhook URL in LINE Developer Console

Requirements

  • LINE Messaging API account (free tier available)
  • Google Sheets (any Google account)
  • Google Gemini API key (free tier available)
  • Slack workspace with Incoming Webhooks enabled

How to customize

Adjust Google Sheets columns to match your CRM fields. Add a HubSpot or Salesforce node after the Sheets node to sync contacts directly to your CRM. Replace Slack with Microsoft Teams or Discord for team notifications.

Node List

# Node Name Type Role
1 Set Configuration Parameters Set Centralizes all credentials and config values
2 When LINE Event Received Webhook Receives LINE Webhook events (POST)
3 If Image Message If Checks whether the message contains an image
4 Fetch Image from LINE API HTTP Request Downloads image from LINE Content API
5 Encode Image as Base64 Code Converts image binary to Base64 string
6 Setup Gemini for Card Data Gemini Chat Model Gemini 1.5 Flash model definition
7 Extract Card Info with Gemini LLM Chain Extracts contact info from card image as JSON
8 Parse Gemini Output Data Code Parses Gemini response into structured data
9 Read Contacts from Sheets Google Sheets Searches existing records by email address
10 If Contact Exists If Checks whether a duplicate record exists
11 Append Contact to Sheets Google Sheets Appends new contact to Google Sheets
12 Post New Contact to Slack HTTP Request Sends Slack notification for new contact
13 Send Success Reply via LINE HTTP Request Sends registration confirmation via LINE
14 Send Duplicate Reply via LINE HTTP Request Sends duplicate notification via LINE
15 Respond Not Image to LINE Respond to Webhook Responds to non-image messages
16 Acknowledge OK Webhook Respond to Webhook Returns HTTP 200 on success
17 Acknowledge Duplicate Webhook Respond to Webhook Returns HTTP 200 on duplicate

Total: 17 nodes (+ 8 Sticky Notes)

Sticky Note Compliance

# Sticky Note Title Color Role
1 Main Sticky Note (Overview) Yellow Workflow overview, How it works, Setup steps, Customization
2 Configuration setup White Covers credentials and config
3 Webhook event handling White Covers LINE webhook reception and image check
4 Image download and conversion White Covers image fetch and Base64 encoding
5 Card data extraction White Covers Gemini extraction and parsing
6 Duplicate check and contact saving White Covers Sheets read/write and duplicate logic
7 Messaging and webhook response White Covers Slack post, LINE replies, and webhook responses
8 Gemini configuration White Covers Gemini model setup

All sticky notes use H2 headings (## ) and follow n8n public guidelines.

Setup Guide

1. Create a LINE Messaging API channel

  1. Log in to LINE Developers Console
  2. Create a new provider (or select an existing one)
  3. Create a Messaging API channel
  4. Issue a long-lived Channel Access Token and copy it
  5. Set the Webhook URL after configuring n8n

2. Prepare Google Sheets

  1. Create a new spreadsheet
  2. Add the following headers in row 1:
A B C D E F G H
Timestamp Name Company Title Phone Email Address LINE_UID
  1. Copy the spreadsheet ID from the URL (between /d/ and /edit)

3. Set up Slack Incoming Webhook

  1. Create a new app at Slack API
  2. Enable Incoming Webhooks
  3. Select a channel and copy the Webhook URL

4. Get a Google Gemini API key

  1. Go to Google AI Studio
  2. Create an API key
  3. Add it as a Google PaLM API credential in n8n

5. Configure the n8n workflow

  1. Import the workflow JSON into n8n
  2. Open the Set Configuration Parameters node and enter:
    • LINE_CHANNEL_ACCESS_TOKEN
    • GOOGLE_SHEET_ID
    • SLACK_WEBHOOK_URL
  3. Set up Google Sheets OAuth2 credentials
  4. Set up Gemini Chat Model credentials

6. Register the LINE Webhook URL

  1. Return to LINE Developers Console
  2. Enter the n8n Webhook URL
  3. Enable Webhook usage
  4. Disable auto-reply messages

7. Test

  1. Activate the workflow
  2. Send a business card photo to your LINE bot
  3. Confirm the contact is saved in Google Sheets
  4. Confirm the Slack notification is received
  5. Confirm the LINE confirmation message is received

Tags

ai gemini line google-sheets slack crm image-recognition automation