n8n Workflow: Image Collection from Web Search Results and Google Sheets Integration

This n8n workflow automates the process of finding images from web search results, analyzing them with AWS Rekognition, and then storing relevant image data in a Google Sheet. It's designed to streamline the collection and categorization of visual content based on specific criteria.

What it does

This workflow performs the following steps:

1. Initial Data Setup: A Function node is used to define the initial data structure, likely including search terms or image URLs to begin the process.
2. HTTP Request for Image Data: An HTTP Request node is used to fetch data, presumably from a web search API or a web page containing image results. This step is responsible for retrieving the raw image information.
3. Data Transformation (Edit Fields): An Edit Fields (Set) node processes the data received from the HTTP request. This node is typically used to extract, rename, or manipulate specific fields from the incoming JSON, preparing it for subsequent steps.
4. Image Analysis with AWS Rekognition: An AWS Rekognition node is used to analyze the images. This could involve tasks like object detection, facial recognition, or content moderation, providing rich metadata about the images.
5. Store Results in Google Sheets: Finally, a Google Sheets node takes the processed image data and the analysis results from AWS Rekognition and appends them to a specified Google Sheet. This centralizes the collected image information for easy access and further analysis.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Account: For Google Sheets integration. You'll need to configure Google Sheets credentials in n8n.
• AWS Account: For AWS Rekognition. You'll need to configure AWS credentials (Access Key ID and Secret Access Key) in n8n with appropriate Rekognition permissions.
• Web Search API/Source: Access to a web search API or a web page from which to extract image results. The HTTP Request node will need to be configured with the appropriate URL and parameters.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Google Sheets: Locate the "Google Sheets" node. Click on the "Credential" field and either select an existing Google Sheets credential or create a new one. Follow the n8n instructions to authenticate with your Google account.
   • AWS Rekognition: Locate the "AWS Rekognition" node. Click on the "Credential" field and either select an existing AWS credential or create a new one. Provide your AWS Access Key ID and Secret Access Key, ensuring the user has permissions for Rekognition services.
3. Configure HTTP Request:
   • Locate the "HTTP Request" node.
   • Update the "URL" and any necessary "Headers", "Query Parameters", or "Body" to target your desired web search API or image source.
4. Configure Function Node:
   • Locate the "Function" node.
   • Modify the JavaScript code within this node to define the initial data or search parameters that will kick off your image collection.
5. Configure Edit Fields (Set) Node:
   • Locate the "Edit Fields (Set)" node.
   • Adjust the fields being set or modified to match the structure of the data you expect from the HTTP Request and what you want to pass to AWS Rekognition and Google Sheets.
6. Configure Google Sheets Node:
   • Locate the "Google Sheets" node.
   • Specify the "Spreadsheet ID" and "Sheet Name" where you want the image data and Rekognition results to be stored.
   • Ensure the "Operation" is set to "Append Row" or a suitable alternative, and map the incoming data fields to your Google Sheet columns.
7. Activate the Workflow:
   • Once all configurations are complete, save the workflow.
   • Click the "Activate" toggle in the top right corner to enable the workflow.
   • You can manually test the workflow by clicking "Execute Workflow".