🔬 Extract text from Google Drive images with OCR.space, OpenRouter AI summary to sheets & Gmail
⚡ 449 views · 🔬 Document Extraction & Analysis
Description
How it works
This workflow automatically detects new image files uploaded to a Google Drive folder, extracts Japanese text using OCR, summarizes it with AI, and records the result in Google Sheets.
Finally, it sends a completion email notification with the file name and summary.
Workflow steps:
- Google Drive New File Trigger – Watches a specific Google Drive folder for new image uploads.
- Download Image File – Downloads the newly uploaded image for processing.
- Extract Text with OCR.space – Sends the image to the OCR.space API to extract text (Japanese supported).
- Format OCR Result & Check for Empty – Cleans and validates the extracted text.
- Generate Summary with OpenRouter AI – Uses an AI model to generate a short summary of the text.
- OpenRouter Chat Model – Connects the AI Agent to the OpenRouter language model.
- Append row in sheet – Adds the file name, AI summary, and processing date to Google Sheets.
- Send Completion Notification via Gmail – Sends an email with the summarized content and Google Sheets link.
- Process Completed – Marks the workflow’s successful end.
Setup steps
- Connect your Google Drive, Google Sheets, and Gmail accounts through credentials.
- Set your OCR.space API key in the HTTP Request node.
- Add your OpenRouter API key credential for the AI node.
- Replace the Google Sheet ID and folder ID with your own.
- Customize the Gmail recipient and email message as needed.
- Adjust the polling frequency (e.g., every 1 minute) depending on your workflow needs.
Ideal for
- Digitizing and summarizing handwritten or printed book pages.
- Automatically extracting and archiving text from scanned reports or notes.
- Businesses or educators automating document reading and summarization tasks.
⚙️ Note:
Each node includes a clear English Sticky Note above it for easier understanding and documentation.
🔗 Nodes Used
Google Sheets, HTTP Request, Google Drive, Gmail, Google Drive Trigger, AI Agent
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File