Automated Pay Slip Text Extraction from Line Messages

This n8n workflow automates the process of extracting key data from pay slips sent via Line messages, utilizing AI-powered analysis with Google Gemini and smooth integration with Google Sheets for data storage. The workflow begins with a webhook trigger receiving user messages, which can be either text or images of pay slips. For text messages, an AI agent processes the message to understand the user’s request. For images, the workflow fetches the content from Line’s servers and analyzes it using Google Gemini’s image model. The extracted data includes details like Status, From, To, Date, and Amount. The processed information is then responded to the user through Line, and important data points are stored in Google Sheets for record-keeping. This workflow is highly practical for automating payroll or expense management where employees submit pay slips via messaging apps, streamlining data entry and enhancing efficiency.