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

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.