Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Documents, PDF & OCR

Documents, PDF & OCR

Record LINE Receipt Images in Sheets with OCR

When a receipt image is sent to the LINE bot, it saves it to Google Drive, extracts the text with OCR Space, and records the data in Google Sheets.

What it does

# LINE BOT - Google Sheets Record Receipt ## Overview Automated workflow: LINE BOT - Google Sheets Record Receipt. This workflow integrates 8 different services: webhook, stickyNote, httpRequest, code, googleDrive. It contains 20 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 20 - Node Types: 8 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Sticky Note: stickyNote - Image slip URL in Line: set - Get image to Binary: httpRequest - Line Chat Bot: webhook - Sticky Note1: stickyNote - Sticky Note2: stickyNote - Sticky Note3: stickyNote - Sticky Note4: stickyNote - Upload image to Google Drive: googleDrive - Record in Google Sheets: googleSheets - ... and 10 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. Image slip URL in Line
  2. Get image to Binary
  3. Line Chat Bot
  4. Upload image to Google Drive
  5. Record in Google Sheets
  6. Send Image URL to OCR Space for Text Extraction
  7. Extract Transaction Details
  8. Error Handler
  9. Stopanderror 1
  10. Stopanderror 2
  11. Error Handler for 172ed09e
  12. Error Handler for 79753b3d
  13. Error Handler for 802a7b11
  14. Error Handler for b37b4b7a

37 steps in total.

Similar automations