n8n

How to Automate Airtable Product Catalog?

Turn logo sheets into a clean product catalog without manual typing. A simple form lets you upload one image, and the system reads each logo, gathers product names, tags, and similar tools, then fills your Airtable base. Great for marketing and research teams that track categories and competitors.

It starts with a form submission. An AI vision agent reads the image and outputs a structured list of tools with attributes and similar items. The flow splits each tool, loops through every attribute, creates missing attributes in Airtable, and maps them to the right records. A hash is generated from each name to keep IDs stable. Similar tools are also matched and upserted. Everything is merged and saved back to Airtable.

Set up requires an Airtable base with Tools and Attributes tables and an OpenAI API key. Expect faster intake, cleaner tags, and easier comparison across products. Use it for competitive scans, partner lists, or internal catalogs made from event one pagers or vendor sheets.

What are the key features?

  • Public form trigger collects a single image and an optional prompt to guide extraction.
  • OpenAI vision agent reads the image and returns names, attributes, and similar tools.
  • Structured output parser forces clean JSON so fields map into Airtable with fewer errors.
  • Attribute loop checks Airtable and creates missing attributes with upsert logic.
  • Name hashing uses a unique hash for each product and similar item to keep stable IDs.
  • Record ID mapping converts attribute and similar names into Airtable record links.
  • Upsert for Tools writes or updates records and links attributes and similar relations.
  • Merge and code steps align outputs from different branches before saving to Airtable.

What are the benefits?

  • Reduce manual data entry from 2 hours to 10 minutes per logo sheet
  • Automate 90 percent of repetitive tagging and linking work
  • Improve data accuracy by 80 percent with structured parsing and upsert rules
  • Handle 10 times more product uploads without adding headcount
  • Connect form uploads and Airtable so data lands in the right tables every time

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Airtable and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. In Airtable, create a base with two tables. Tools table has Name, Attributes linked to Attributes table, Hash, Similar linked to Tools. Attributes table has Name and Tools linked to Tools.
  4. In n8n Credentials, create Airtable Personal Access Token. Double click an Airtable node, choose Create new credential, then paste your token from the Airtable account page. Name the credential clearly.
  5. In n8n Credentials, create OpenAI API Key. Double click the OpenAI node, choose Create new credential, then paste your API key from your OpenAI account. Name it so your team can recognize it.
  6. Open the Form Trigger node and confirm the path and form fields. Keep the file upload field and optional prompt field as provided.
  7. Open the AI Agent node and review the system message and prompt instructions. Keep the output format since the flow depends on that structure.
  8. Check Airtable nodes for the correct base and table selections. Use the dropdown to pick your base and the Tools and Attributes tables. Save each node.
  9. Run a test by opening the public form URL, upload a logo sheet image, and submit. In n8n, watch the execution and confirm the Structured Output Parser returns tools, attributes, and similar lists.
  10. Verify Airtable. New attributes should appear once per unique name. Tools should be created or updated and linked to the right attributes and similar tools.
  11. If you see missing fields, adjust the prompt in the Agent node. If upserts fail, check table permissions and confirm the token has access to the base.
  12. If images are very large, try a smaller file. If parsing fails often, submit again or add more context in the optional prompt field.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.