🔬 Extract text from images with Apify Google Lens OCR and Google Sheets
⚡ 34 views · 🔬 Document Extraction & Analysis
Description
Quick overview
Turn image URLs into clean, structured text and log it to Google Sheets automatically. No OCR library, no setup, powered by Apify Google Lens.
How it works
- Runs manually when you click Test workflow.
- Sets the target public image URL to process.
- Sends the image URL to Apify (Google Lens OCR) to extract the full text and related OCR metadata.
- Keeps the key fields (image URL, detected language, full text, and scrape timestamp) from the OCR result.
- Appends the extracted text and metadata as a new row in Google Sheets.
Setup
- Install the Apify community node and add an Apify API token credential for the OCR step.
- Add a Google Sheets OAuth credential.
- Replace the Google Sheets document ID with your spreadsheet ID and confirm the target sheet name/columns for auto-mapping.
- Update the imageUrl value to a publicly accessible image you want to OCR (PNG/JPG/WebP).
🔗 Nodes Used
Google Sheets
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File