Developer & DevOps
Extract Image Data and Populate Google Sheets Automatically
6 nodes
301
148
Manual trigger
Workflow Description
Automate image analysis using AWS Rekognition to detect text and objects, then automatically insert extracted data into Google Sheets rows. Eliminates manual data entry and streamlines document processing workflows.
How it works
- 1.Trigger the automation manually and provide an image for processing
- 2.Send image to AWS Rekognition to detect text, objects, and data elements
- 3.Transform and format extracted data using function nodes
- 4.Append results directly to the target Google Sheets worksheet
Use cases
- Digitize receipts and invoices by extracting data into structured spreadsheets
- Create automated image archive indexes with extracted metadata in sheets
Requirements
- Active AWS account with Rekognition API permissions configured
- Google Sheets document with edit access and proper column structure
- n8n connected to both AWS and Google APIs with authentication tokens
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Aws Rekognition
Google Sheets
Details
Trigger
Manual trigger
Nodes
6
Apps
2
Views
301
Downloads
148
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (6)
AWS Rekognition
Aws Rekognition
HTTP Request
HTTP Request
HTTP Request1
HTTP Request
Set1
Set
Function1
Function
Google Sheets1
Google Sheets