AI-Powered Image Discovery and Labeling to Google Sheets
detail.loadingPreview
Automate the process of finding images online, analyzing their content using AI, and meticulously logging all relevant details, including AI-detected labels, directly into a Google Sheet. This workflow transforms raw image data into actionable insights for your projects.
About This Workflow
This robust n8n workflow empowers you to effortlessly discover images online, leverage the power of AWS Rekognition for advanced content analysis, and neatly organize the extracted information into a Google Sheet. It starts by fetching images based on your specified search query, then intelligently identifies objects, scenes, and activities within those images. Finally, it compiles the image's name, direct link, and all detected labels into structured rows, ready for further analysis or archiving in your preferred spreadsheet. Streamline your image research and data management with AI-driven automation.
Key Features
- Automated Image Discovery: Automatically fetch relevant images from the web using the Google Custom Search API based on your keywords.
- AI-Powered Image Analysis: Utilize AWS Rekognition to intelligently detect and label objects, scenes, and activities within images, providing rich metadata.
- Structured Data Logging: Seamlessly append image titles, direct links, and their corresponding AI-generated labels into a designated Google Sheet.
- Customizable Search & Analysis: Easily modify the image search query and fine-tune AWS Rekognition parameters to suit your specific data extraction needs.
How To Use
- Configure the HTTP Request node:
- Replace
AIzaSyBQry407hE5VwMaDedHogPuwJeIbAIidQUande51ced3f3563dfac9with your actual Google Custom Search API key and Custom Search Engine ID in the URL. - Adjust the
qparameter in the URL (e.g.,q=street) to your desired image search query.
- Replace
- Set up AWS Rekognition Credentials:
- Ensure your AWS credentials (Access Key ID and Secret Access Key) are configured in n8n for the AWS Rekognition node.
- Verify the
typeis set todetectLabels.
- Refine the Set node:
- Ensure
img_nameis set to={{$node["HTTP Request1"].json["items"][0]["title"]}}. - Ensure
img_linkis set to={{$node["HTTP Request1"].json["items"][0]["link"]}}. - For
img_labels, use an expression like={{$node["AWS Rekognition1"].json["Labels"].map(item => item.Name).join(', ')}}to get all detected labels as a comma-separated string, suitable for a single cell in Google Sheets.
- Ensure
- Connect Google Sheets:
- Set up your Google Sheets OAuth2 API credentials in n8n.
- Enter the
sheetIdof your target Google Sheet (e.g.,qwertz). - Ensure the
operationis set toappend.
- Execute the workflow: Run the workflow manually or set up a trigger to start fetching, analyzing, and logging image data.
Apps Used
Workflow JSON
{
"id": "20ab57d1-f4ba-4d46-8bbe-7e3350bfb4a5",
"name": "AI-Powered Image Discovery and Labeling to Google Sheets",
"nodes": 29,
"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: 20ab57d1-f4ba...
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
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.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.