Bibliothek / Dateien & Cloud-Speicher
Dateien & Cloud-Speicher
OCR receipts from Google Drive
When you run it, it manages files using Google Drive, Google Sheets.
Was sie bewirkt
# Recognize invoices and convert them into structured JSON ## Video Demo {{ $env.WEBHOOK_URL }} ## Quick OCR playground ### 1. Get your OakPDF OCR API key here: {{ $env.API_BASE_URL }} ### 2. Poceed to the OCR Playground and upload your document or use example files: {{ $env.WEBHOOK_URL }} The API can recognize any document format: medical, financial, legal -- let me know which format you want to try and I will be happy to add it to the Playground! ## Running the n8n Workflow This workflow allows you to recognize a folder with receipts or invoices (make sure your files are in .pdf, .png, or .jpg format). The workflow can be triggered via the "Test workflow" button, and it also monitors the folder for new files, automatically recognizing them. ### 1. n8n import glitch After import, the trigger node "When clicking 'Test workflow'" might be disconnected. You need to connect it via 2 arrows to "Google Sheets1" and "Google Drive" nodes. So, the workflow has 2 triggers - via button, and via Google Sheets "new file" event - both of these triggers should be connected to 2 nodes. Here is how it should looks like: {{ $env.WEBHOOK_URL }} ### 2. Set up RapidAPI HTTP auth key Create new "HTTP header" n8n credential and paste your RapidAPI key from {{ $env.API_BASE_URL }} into it. {{ $env.API_BASE_URL }} Make sure "HTTP Request" node uses this credential. ### 3. Set up your Google Auth You need a Google connection to work with your Google Sheets and Google Drive accounts: {{ $env.WEBHOOK_URL }} ### 4. Set up Google Sheets Copy this Google Sheets document: {{ $env.WEBHOOK_URL }} # Custom document formats and advanced usage Email: contact@scrapeninja.net Linkedin: {{ $env.WEBHOOK_URL }}
Die Schritte
- When clicking ‘Test workflow’
- OCR recognize
- Unserialize response JSON
- On new file in Google Drive
- Load files from Google Drive folder
- Filter processed files
- Download file for OCR
- Save OCR result into Sheets
- Get already processed rows from Sheets
Ähnliche Automatisierungen
Finanzen, Rechnungen & BuchhaltungGmail-Belege mit OpenAI in Drive und Sheets speichern12 SchritteFinanzen, Rechnungen & BuchhaltungYAPE-Zahlungsbelege aus Telegram in Google Sheets übertragen14 SchritteDokumente, PDF & OCRGmail-Rechnungen und -Belege mit OpenAI klassifizieren und in Drive ablegen18 SchritteE-Mail-AutomatisierungSend quotes, invoices, receipts and reminders from Google Sheets with Koutei and Gmail35 Schritte