AutomationMart
Home/Browse/Extract pay slip data with Line Chatbot and Gemini to Google Sheets
n8n

Extract pay slip data with Line Chatbot and Gemini to Google Sheets

n8nn8n12 modulesv1.0
Google SheetsGemini

Workflow Overview: Extract text from image using AI is worth because you need no code. It incorporates Google Gemini 2.0 Flash model for important text extraction from image. If you code without AI, you have to use multiple condition and may cause a lot of bug but with Google Gemini, you don't need any coding and if the Pay Slip is different, Gemini will extract it automatically. Workflow description: 1. User uses Line Messaging API to send Pay Slip image or message to the chatbot, create Line B

At a glance

Extract pay slip data with Line Chatbot and Gemini to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Gemini
Modules
12
Price
Free
Version
v1.0
Extract pay slip data with Line Chatbot and Gemini to Google Sheets workflow diagram

About this workflow

Workflow Overview: Extract text from image using AI is worth because you need no code. It incorporates Google Gemini 2.0 Flash model for important text extraction from image. If you code without AI, you have to use multiple condition and may cause a lot of bug but with Google Gemini, you don't need any coding and if the Pay Slip is different, Gemini will extract it automatically. Workflow description: 1. User uses Line Messaging API to send Pay Slip image or message to the chatbot, create Line Business ID from here: Line Business 2. Classify the message which is image or text 3. If the message is Pay Slip image, it will process using Gemini 2.0 Flash EXP and extract important information and response in JSON format without coding by using the following prompt: Analyze image and then return in JSON Response that has the only following value: Status, From, To, Date, Amount To get Google AI Studio API Key, you can find from the following link: Google AI Studio API Key 4. Create Google Sheets which include the fileds (Status, From, To, Date, Amount) that we have created related to the AI prompt Google Sheets as the following example: 5. If the message is text, it will process using Gemini 2.0 Flash EXP model as the AI Assistant else if the message is image, it will extract the important fields then reply to the User and insert into Google Sheets Key Features: Extract text from image with No Code Without N8N, we have to write code to extract text from image, but with N8N and Google Gemini 2.0 Flash EXP together, we don't need to code and it will process all slip vendors or other document vendors. Multipurpose Chatbot this chatbot accept both text and image so we don't have to create many chatbot accounts Reduce human error this workflow let any officer to verify document status when the job ends Note: You can change the information by changing your prompt and also Google Sheets Column names relatively.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Export Mailjet contacts to Google Sheets

Export all Mailjet contacts to Google sheets.(Limit 3200 records applies).

Free

Audit competitor SEO content with Decodo, Gemini, and Google Sheets

Never guess your SEO strategy again. This advanced workflow automates the most time-consuming part of SEO: auditing competitor articles and identifying exactly where your brand can outshine them. It extracts deep content from top-ranking URLs, compares it against your specific brand identity, and generates a ready-to-use "Action Plan" for your content team. The workflow uses Decodo for high-fidelity scraping, Gemini 2.5 Flash for strategic gap analysis, and Google Sheets as a dynamic "Brand Brai

Free

Validate and create LEDGERS contacts from Google Sheets with error handling

Before Using this Template first search LEDGERS in the nodes list and Update! The workflow automates contact creation in LEDGERS from a Google Sheets document, while performing validation checks on contact data to ensure data quality. Key Features: ✅ Google Sheets Trigger – Polls the sheet every minute to detect new or updated rows. ✅ Contact Name Validation – Checks if the contact name is provided; sends an email notification if missing. ✅ Email & Mobile Validation – Uses custom code to validat

Free

Generate SWOT analysis reports with OpenAI, Google Sheets & APITemplate PDF Export

SWOT Analysis Generator That Produces PDF Reports In n8n Want to skip the manual work and instantly generate SWOT analyses for your business plans, investor decks, or strategy docs? 🚀 This workflow lets you automate the entire SWOT (Strengths, Weaknesses, Opportunities, Threats) process—using AI and no-code tools! Whether you're using this for yourself or creating documents for clients, this workflow will save you hours of time and help identify the key components of growing any business.

Free

Update Google Sheets with product details from Shopify

Automatically update Google Sheets with product details from Shopify. Sync product data effortlessly between Shopify and Google Sheets for streamlined inventory management.

Free

Create an Emma audience member from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create an audience member in Emma.

Free

Generate invoices, save to Drive and send email to customer with JS + G Sheets

This workflow automates invoice generation from form submissions, ensuring unique order IDs, creating PDF invoices, storing files, emailing customers, and logging invoice data — all seamlessly integrated. --- 🔹 Workflow Overview 1. Trigger (Webhook) Starts when an order form is submitted, capturing customer and order details. 2. Generate Random Order ID A Function node creates a unique alphanumeric invoice ID (e.g., INV-X92B7D). 3. Check for Duplicate Order ID Goog

Free

Summarize YouTube transcripts in any language with Google Gemini & Google Docs

YouTube Transcript Summarization in Any Language for Social Media This n8n workflow automates the process of: 1. Retrieving YouTube Video Transcripts: It fetches the transcript for any YouTube video URL provided using the YouTube Transcript API from RapidAPI. 2. Generating a Concise Summary in Any Language: The workflow uses Google Gemini (PaLM) to create a concise summary of the transcript

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free