Extract Pay Slip Data via Line Chatbot, Gemini AI to Google Sheets

This workflow enables users to send pay slip images or text messages via Line Messaging API to a chatbot. It classifies incoming messages as image or text. For pay slip images, Google Gemini 2.0 Flash EXP analyzes and extracts structured JSON data including Status, From, To, Date, and Amount without any coding required. The extracted data is then appended to a Google Sheets spreadsheet for easy tracking and analysis.

For text messages, the workflow routes them to Gemini as an AI assistant for conversational responses. This dual-mode handling ensures seamless interaction. Key benefits include no-code AI-powered OCR-like extraction, reducing bugs from traditional conditional logic, automatic adaptation to varying pay slip formats, and integration of popular tools like Line, Gemini, and Google Sheets.

Ideal use cases: HR teams automating payroll verification, finance departments logging slip data, or businesses processing employee reimbursements. It saves hours of manual data entry, minimizes errors, and scales effortlessly with AI handling diverse document layouts. Setup requires Line Business ID, Google AI Studio API key, and a prepared Google Sheets template.