Record financial transactions from LINE to Google Sheets

• Automate financial record-keeping from LINE messages
• Extract transaction details from images sent via LINE
• Streamline data entry into Google Sheets for financial analysis

Triggers on receiving a message in LINE Extracts image URL from the LINE message Downloads the image and uploads it to Google Drive Uses OCR to extract text from the uploaded image Parses the extracted text to identify transaction details Records the parsed transaction details into Google Sheets

1. 1
   Import the workflow template into your n8n instance
2. 2
   Configure the LINE webhook with your LINE bot credentials
3. 3
   Set up Google Drive and Google Sheets credentials
4. 4
   Adjust the OCR API key in the workflow parameters
5. 5
   Test the workflow by sending a transaction image via LINE