⚡n8n Workflow

Intermediate

Google Image Search to AWS Rekognition Labeling to Google Sheets

Automate image analysis by finding images with Google Search, detecting labels using AWS Rekognition, and logging the image URL and tags directly into a Google Sheet.

Overview

An automated workflow that finds images based on a search query, uses AI to analyze the image content for labels, and catalogs the results in a spreadsheet.

🧠 Description & Use Case

This workflow automates the process of finding an image online, analyzing its content using AI, and logging the results into a Google Sheet. It's a powerful tool for building tagged image databases or performing automated visual research.

🔄 How It Works:

Find an Image: The HTTP Request node sends a query to the Google Custom Search API to find an image related to the term "street".
Analyze with AI: The AWS Rekognition node receives the image from the previous step and uses Amazon's machine learning service to perform detectLabels, identifying objects, scenes, and concepts within the image.
Structure the Data: The Set node organizes the key information into a clean format. It extracts the image title and URL from the Google Search result and the list of detected labels from AWS Rekognition.
Log to a Spreadsheet: Finally, the Google Sheets node takes the structured data and appends it as a new row to a specified sheet. Each row will contain the image's name, a direct link, and all the labels identified by the AI.

✅ Real-World Use Cases:

Automated Image Cataloging: Build a searchable database of images from the web, automatically tagged with relevant keywords for easy filtering.
Market Research: Analyze images used by competitors or within a specific industry to identify visual trends and common themes.
Dataset Creation: Automatically gather and label images to create training datasets for custom machine learning models.
Content Curation: Quickly find and tag relevant images for blog posts, social media, or presentations, and save them in a central, accessible spreadsheet for your team.

Instructions

Basic steps

Download workflow JSON
Import into n8n
Configure node parameters as needed
Test and enable the workflow

💡 Tips

After importing, verify all connectors and credentials match your environment.

Preview

Workflow Visualization

4 nodes

100%

Nodes

HTTP Request1

httpRequest

AWS Rekognition1

awsRekognition

Google Sheets2

googleSheets

Set3

set

Statistics

Total nodes:4

Disabled nodes:0

Node types:4

Connections:3

View full JSON structure

{
  "nodes": [
    {
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        500,
        540
      ],
      "parameters": {
        "url": "https://www.googleapis.com/customsearch/v1?imgType=photo&key=AIzaSyBQry407hE5VwMaDedHogPuwJeIbAIidQU&cx=e51ced3f3563dfac9&q=street&searchType=image",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "name": "AWS Rekognition1",
      "type": "n8n-nodes-base.awsRekognition",
      "position": [
        680,
        540
      ],
      "parameters": {
        "type": "detectLabels",
        "binaryData": true,
        "additionalFields": {}
      },
      "credentials": {
        "aws": {
          "id": "9",
          "name": "aws"
        }
      },
      "typeVersion": 1
    },
    {
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1040,
        540
      ],
      "parameters": {
        "options": {},
        "sheetId": "qwertz",
        "operation": "append",
        "authentication": "oAuth2"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "2",
          "name": "google_sheets_oauth"
        }
      },
      "typeVersion": 1
    },
    {
      "name": "Set3",
      "type": "n8n-nodes-base.set",
      "position": [
        860,
        540
      ],
      "parameters": {
        "values": {
          "number": [],
          "string": [
            {
              "name": "img_name",
              "value": "={{$node[\"HTTP Request1\"].json[\"items\"][0][\"title\"]}}"
            },
            {
              "name": "img_link",
              "value": "={{$node[\"HTTP Request1\"].json[\"items\"][0][\"link\"]}}"
            },
            {
              "name": "img_labels",
              "value": "={{$node[\"AWS Rekognition\"][\"Labels\"][\"Name\"]}}"
            }
          ]
        },
        "options": {},
        "keepOnlySet": true
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Set3": {
      "main": [
        [
          {
            "node": "Google Sheets2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "AWS Rekognition1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AWS Rekognition1": {
      "main": [
        [
          {
            "node": "Set3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Actions

Categories:

Data Workflow

Tags:

sethttprequestawsrekognitiongooglesheets

Technical Specs

Complexity:

Intermediate

Node Count:

4 nodes

Published:11 months ago

Updated:about 1 month ago

Compatibility

Platform:

N8N Cloud & Self-hosted

Min Version:

N8N v1.0.0+

Supports cloud and self-hosted deployment

License

This workflow template follows MIT license, you can freely use, modify and distribute.

Please comply with relevant third-party service terms when using.