Extract text from images with Apify Google Lens OCR and Google Sheets

Go to Workflow
0 views
Built by Devansh Tiwari Devansh Tiwari
Created on July 11, 2026

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 (1)

Google Sheets
n8n-nodes-base.googleSheets