Save business card contacts from LINE photos to Google Sheets with Gemini
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 Create a LINE Messaging API channel and obtain a Channel Access Token Prepare a Google Sheet with columns: Timestamp, Name, Company, Title, Phone, Email, Address, LINE_UID Get a Google Gemini API key from Google AI Studio Set up a Slack Incoming Webhook URL Enter all credentials in the Set Configuration Parameters node 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 Log in to LINE Developers Console Create a new provider (or select an existing one) Create a Messaging API channel Issue a long-lived Channel Access Token and copy it Set the Webhook URL after configuring n8n 2. Prepare Google Sheets Create a new spreadsheet Add the following headers in row 1: | A | B | C | D | E | F | G | H | |---|---|---|---|---|---|---|---| | Timestamp | Name | Company | Title | Phone | Email | Address | LINE_UID | Copy the spreadsheet ID from the URL (between /d/ and /edit) 3. Set up Slack Incoming Webhook Create a new app at Slack API Enable Incoming Webhooks Select a channel and copy the Webhook URL 4. Get a Google Gemini API key Go to Google AI Studio Create an API key Add it as a Google PaLM API credential in n8n 5. Configure the n8n workflow Import the workflow JSON into n8n Open the Set Configuration Parameters node and enter: LINE_CHANNEL_ACCESS_TOKEN GOOGLE_SHEET_ID SLACK_WEBHOOK_URL Set up Google Sheets OAuth2 credentials Set up Gemini Chat Model credentials 6. Register the LINE Webhook URL Return to LINE Developers Console Enter the n8n Webhook URL Enable Webhook usage Disable auto-reply messages 7. Test Activate the workflow Send a business card photo to your LINE bot Confirm the contact is saved in Google Sheets Confirm the Slack notification is received Confirm the LINE confirmation message is received Tags ai gemini line google-sheets slack crm image-recognition automation. An n8n automation workflow template by TakatoYamada.
TakatoYamada
web
free
Others in the same category, ranked by how often they are opened.
