Automate Image Text Extraction and Data Logging with AWS Rekognition and Google Sheets
detail.loadingPreview
This workflow automates the extraction of text from images using AWS Rekognition. The extracted text, along with image details, is then organized and saved to a Google Sheet for further analysis and record-keeping.
About This Workflow
Unlock the power of your visual data with this n8n workflow designed to extract valuable text information from images and seamlessly integrate it into your operational workflows. The process begins by fetching an image from a specified URL. This image is then fed into AWS Rekognition for advanced text detection. The detected text is parsed, relevant snippets are extracted, and along with the image's name and URL, are processed. A crucial step involves converting the extracted text to lowercase for consistent data handling. Finally, all this enriched data is appended to a designated Google Sheet, creating a structured and searchable repository of your image-based textual content. This workflow is ideal for businesses looking to automate data entry, enhance content analysis, or build intelligent image processing pipelines.
Key Features
- Automated Image Text Extraction: Leverages AWS Rekognition to accurately identify and extract text from images.
- URL-Based Image Ingestion: Easily process images hosted online by providing their URLs.
- Data Structuring and Formatting: Organizes extracted image details (name, URL) and text content.
- Text Normalization: Converts extracted text to lowercase for easier searching and filtering.
- Seamless Google Sheets Integration: Appends extracted data directly to your Google Sheet for organized storage and analysis.
How To Use
- HTTP Request Node: Configure the first 'HTTP Request' node to fetch the image you want to process. Ensure the 'Response Format' is set to 'file'.
- AWS Rekognition Node: Connect the output of the 'HTTP Request' node to the 'AWS Rekognition' node. Select 'detectText' as the operation type and ensure 'binaryData' is enabled. Configure your AWS credentials.
- Set Node: Connect the 'AWS Rekognition' node to the 'Set' node. Define the output fields: 'img_name' (using the filename from the previous HTTP Request), 'img_link' (the URL from the previous HTTP Request), and 'img_txt' (carefully constructing the desired text output by referencing specific indices of the 'TextDetections' array from Rekognition's output).
- Function Node: Connect the 'Set' node to the 'Function' node. Implement the JavaScript code provided to convert the extracted 'img_txt' to lowercase and store it in a new field named 'lowerText'.
- Google Sheets Node: Connect the 'Function' node to the 'Google Sheets' node. Choose 'append' as the operation. Configure your Google Sheets OAuth2 credentials and specify the target 'sheetId'.
Apps Used
Workflow JSON
{
"id": "265eec04-aae1-4828-94da-fc1ff38e9462",
"name": "Automate Image Text Extraction and Data Logging with AWS Rekognition and Google Sheets",
"nodes": 7,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 265eec04-aae1...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.