Enrich property inventory survey with image recognition and AI agent

5625 views

2/3/2026

api integration http request data export csv spreadsheet

This n8n workflow assists property managers and surveyors by reducing the time and effort it takes to complete property inventory surveys.

In such surveys, articles and goods within a property may need to be captured and reported as a matter of record. This can take a sizable amount of time if the property or number of items is big enough.

Our solution is to delegate this task to a capable AI Agent who can identify and fill out the details of each item automatically.

How it works

An AirTable Base is used to capture just the image of an item within the property
Our workflow monitoring this AirTable Base sends the photo to an AI image recognition model to describe the item for purpose of identification.
Our AI agent uses this description and the help of Google's reverse image search in an attempt to find an online product page for the item.
If found, the product page is scraped for the item's specifications which are then used to fill out the rest of the details of the item in our Airtable.

Requirements

Airtable for capturing photos and product information
OpenAI account to for image recognition service and AI for agent
SerpAPI account for google reverse image search.
Firecrawl.dev account for webspacing.

Customising this workflow

Try building an internal inventory database to query and integrate into the workflow. This could save on costs by avoiding fetching new each time for common items.

Enrich Property Inventory Survey with Image Recognition and AI Agent

This n8n workflow automates the process of enriching property inventory survey data by leveraging image recognition and an AI agent. It starts by retrieving data from Airtable, processes image URLs through an AI agent for recognition, and then updates the Airtable record with the extracted information.

What it does

This workflow performs the following key steps:

Triggers Manually or via Another Workflow: The workflow can be initiated manually or by another n8n workflow.
Retrieves Data from Airtable: It fetches records from a specified Airtable base and table.
Filters Records: It checks if the Image field in the Airtable record is not empty. Only records with an image URL proceed.
Prepares Data for AI Agent: It transforms the data into a format suitable for the AI agent, specifically extracting the image URL and the record ID.
Initializes AI Agent: Sets up an AI Agent using an OpenAI Chat Model and a Structured Output Parser.
Configures AI Agent Tools: Integrates a "Call n8n Workflow Tool" which likely allows the AI agent to interact with other n8n workflows or functionalities.
Processes Image with AI Agent: The AI agent receives the image URL and a prompt to recognize objects in the image. It is instructed to output the recognized objects as a JSON array.
Parses AI Agent Output: The structured output parser extracts the recognized objects from the AI agent's response.
Updates Airtable: The workflow updates the original Airtable record with the recognized objects, storing them in a designated field (e.g., Recognized Objects).

Prerequisites/Requirements

To use this workflow, you will need:

n8n Instance: A running n8n instance.
Airtable Account: With a base and table containing property inventory data, including an "Image" field (e.g., an attachment field) and a field to store "Recognized Objects".
OpenAI API Key: For the OpenAI Chat Model and OpenAI nodes used by the AI Agent.
Airtable Credentials: Configured in n8n to access your Airtable base.

Setup/Usage

Import the Workflow:
- Copy the provided JSON code.
- In your n8n instance, go to "Workflows" and click "New".
- Click the three dots next to "Save" and select "Import from JSON".
- Paste the JSON code and click "Import".
Configure Credentials:
- Airtable Node (ID: 2): Select or create your Airtable credential. Specify your Base ID and Table Name. Ensure the "Image" field name matches the column in your Airtable containing image URLs. Configure the "Update" node to target the correct record ID and the field where recognized objects should be stored.
- OpenAI Chat Model Node (ID: 1153): Select or create your OpenAI API Key credential.
- OpenAI Node (ID: 1250): Select or create your OpenAI API Key credential.
Customize AI Agent Prompt (ID: 1119):
- Review the "AI Agent" node's prompt to ensure it aligns with the type of object recognition you need. The current prompt asks for a JSON array of recognized objects.
Activate the Workflow:
- Enable the workflow by toggling the "Active" switch in the top right corner.
Execute the Workflow:
- You can execute it manually using the "When clicking ‘Execute workflow’" trigger or by calling the "Execute Workflow Trigger" node from another workflow.

This workflow provides a powerful way to automatically extract valuable insights from images associated with your property inventory, streamlining data enrichment and analysis.

Related Templates

Daily Magento 2 customer sync to Google Contacts & Sheets without duplicates

Automatically sync newly registered Magento 2 customers to Google Contacts and Google Sheets every 24 hours — with full duplication control and seamless automation. This workflow is a plug-and-play customer contact automation system designed for Magento 2 store owners, marketers, and CRM teams. It fetches customer records registered within the last 24 hours (from 00:00:00 to 23:59:59), checks against an existing Google Sheet to avoid reprocessing, and syncs only the new ones into Google Contacts. This ensures your contact list is always fresh and up to date — without clutter or duplicates. ✅ What This Workflow Does: Automates Customer Syncing Every day, it fetches newly registered Magento 2 customers via API based on the exact date range (midnight to midnight). Deduplicates Using Google Sheets A master Google Sheet tracks already-synced emails. Before adding a customer, the workflow checks this list and skips if already present. Creates Google Contacts Automatically For each unique customer, it creates a new contact in your Google Contacts, saving fields like first name, last name, and email. Logs New Entries to Google Sheets In Google Sheets, it even records magento 2 customer group, createdat, websiteid & store_id After syncing, it adds each new email to the tracking sheet, building a cumulative record of synced contacts. Fully Scheduled & Automated Can be scheduled with the Cron node to run daily (e.g., 12:05 AM) with no manual intervention required. 🔧 Modules Used: HTTP Request (Magento 2 API) Date & Time (for filtering registrations) Google Sheets (for reading/writing synced emails) Google Contacts (for contact creation) Set, IF, and Merge nodes (for control logic) Cron (for scheduling the automation) 💼 Use Cases: Keep your email marketing tools synced with Magento 2 customer data. Build a CRM-friendly contact base in Google Contacts without duplicates. Share customer data with sales or support teams through synced Google Sheets. Reduce manual work and human error in data transfer processes. 🔒 Credentials Required Magento 2 Bearer Auth: Set up as a credential in n8n using your Magento 2 API access token. Google API 📂 Category E-commerce → Magento 2 (Adobe Commerce) 💬 Need Help? 💡 Having trouble setting it up or want to customize this workflow further? Feel free to reach out — I’m happy to help with setup, customization, or Magento 2 API integration issues. Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore

By Kanaka Kishore Kandregula

163

Send RSS feed data to webhook

Filters articles based on keywords, checks against MongoDB for unique links, then sends results to different webhooks

By dave

3968

Run bulk RAG queries from CSV with Lookio

This template processes a CSV of questions and returns an enriched CSV with RAG-based answers produced by your Lookio assistant. Upload a CSV that contains a column named Query, and the workflow will loop through every row, call the Lookio API, and append a Response column containing the assistant's answer. It's ideal for batch tasks like drafting RFP responses, pre-filling support replies, generating knowledge-checked summaries, or validating large lists of product/customer questions against your internal documentation. Who is this for? Knowledge managers & technical writers: Produce draft answers to large question sets using your company docs. Sales & proposal teams: Auto-generate RFP answer drafts informed by internal docs. Support & operations teams: Bulk-enrich FAQs or support ticket templates with authoritative responses. Automation builders: Integrate Lookio-powered retrieval into bulk data pipelines. What it does / What problem does this solve? Automates bulk queries: Eliminates the manual process of running many individual lookups. Ensures answers are grounded: Responses come from your uploaded documents via Lookio, reducing hallucinations. Produces ready-to-use output: Delivers an enriched CSV with a new Response column for downstream use. Simple UX: Users only need to upload a CSV with a Query column and download the resulting file. How it works Form submission: User uploads a CSV via the Form Trigger. Extract & validate: Extract all rows reads the CSV and Aggregate rows checks for a Query column. Per-row loop: Split Out and Loop Over Queries iterate rows; Isolate the Query column normalizes data. Call Lookio: Lookio API call posts each query to your assistant and returns the answer. Build output: Prepare output appends Response values and Generate enriched CSV creates the downloadable file delivered by Form ending and file download. Why use Lookio for high quality RAG? While building a native RAG pipeline in n8n offers granular control, achieving consistently high-quality and reliable results requires significant effort in data processing, chunking strategy, and retrieval logic optimization. Lookio is designed to address these challenges by providing a managed RAG service accessible via a simple API. It handles the entire backend pipeline—from processing various document formats to employing advanced retrieval techniques—allowing you to integrate a production-ready knowledge source into your workflows. This approach lets you focus on building your automation in n8n, rather than managing the complexities of a RAG infrastructure. How to set up Create a Lookio assistant: Sign up at https://www.lookio.app/, upload documents, and create an assistant. Get credentials: Copy your Lookio API Key and Assistant ID. Configure the workflow nodes: In the Lookio API call HTTP Request node, replace the apikey header value with your Lookio API Key and update assistantid with your Assistant ID (replace placeholders like <your-lookio-api-key> and <your-assistant-id>). Ensure the Form Trigger is enabled and accepts a .csv file. CSV format: Ensure the input CSV has a column named Query (case-sensitive as configured). Activate the workflow: Run a test upload and download the enriched CSV. Requirements An n8n instance with the ability to host Forms and run workflows A Lookio account (API Key) and an Assistant ID How to take it further Add rate limiting / retries: Insert error handling and delay nodes to respect API limits for large batches. Improve the speed: You could drastically reduce the processing time by parallelizing the queries instead of doing them one after the other in the loop. For that, you could use HTTP request nodes that would trigger your sort of sub-workflow. Store results: Add an Airtable or Google Sheets node to archive questions and responses for audit and reuse. Post-process answers: Add an LLM node to summarize or standardize responses, or to add confidence flags. Trigger variations: Replace the Form Trigger with a Google Drive or Airtable trigger to process CSVs automatically from a folder or table.

By Guillaume Duvernay

293