AI Logo Sheet Extractor to Airtable n8n Workflow Template

n8n workflow template · 31 nodes · Airtable

AI Logo Sheet Extractor to Airtable is a free n8n workflow template that starts when someone submits an n8n form and works with Airtable and OpenAI. It has 31 nodes, 3 of them AI nodes (AI Agent, Structured Output Parser and OpenAI Chat Model). To run it, you add your own credentials for Airtable API and OpenAI API.

Download JSON How to import into n8n

At a glance

Trigger
n8n Form Trigger (On form submission)
Nodes
31
Apps
Airtable and OpenAI
AI nodes
3
Credentials
2 types
Category
Spreadsheets, databases and docs

Apps and integrations

  • Airtable
  • OpenAI

Node types used

  • n8n Form Trigger
  • AI Agent
  • Edit Fields (Set)
  • Structured Output Parser
  • Airtable
  • Merge
  • Loop Over Items
  • Code
  • Split Out
  • Crypto
  • OpenAI Chat Model
  • HTML

How it works

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Example Logo Sheet

For these kind of sheets the Prompt is designed per default

Tools Table Fields

Required: Name (singleLineText) Attributes (multipleRecordLinks=Link to Attributes Table) Hash (singleLineText) Similar (multipleRecordLinks=Link to the Same Table:"Tools")

_Description (multilineText) _Website (url) _Category (multipleSelects)

Attributes Table Fields

Required: Name (singleLineText) Tools (multipleRecordLinks=Link to Tools Table)

Helper for Documentation (ignore or enjoy it)

Eat the provided Images, Extract the Information out of them as "Tool -> Attributes" list.

Might want to Adjust Prompt to your "Use-Case"

Attribute Creation and Mapping those created or existing Ids

Create the Tools (if not exists)

Setup notes

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Instructions

This automation enables you to just upload any Image (via Form) of a Logo Sheet, containing multiple Images of Products, most likely and bringing them in some context to one another.

After submitting an AI-Agent eats that Logo Sheet, turning it into an List of "Productname" and "Attributes", also checks if Tools are kind of similar to another, given the Context of the Image.

We utilize AI Vision capabilities for that. NOTE: It might not be able to extract all informations. For a "upload and forget it" Workflow it works for me. You can even run it multiple times, to be sure.

But if you need to make sure it extracts everything you might need to think about an Multi-Agent Setup with Validation-Agent Steps.

Once the Agent finishes the extraction, it will traditionally and deterministicly add those Attributes to Airtable (Creates those, if not already existing.) and also Upserts the Tool Informations.

It uses MD5 Hashes for turning Product Names into.. something fancy really, you could also use it without that, but I wanted to have something that looks atleast like an ID.

Setup

  1. Set Up the Airtable like shown below.
  2. Update and set Credentials for all Airtable Nodes.
  3. Check or Adjust the Prompt of the Agent matching your use-case.
  4. Activate the Workflow.
  5. Open the Form (default: )
  6. Enjoy growing your Airtable.

Enjoy the workflow! let the workf low — Workflow Automation & Development

Nodes in this workflow

The 31 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:

  1. On form submission (n8n Form Trigger)
  2. Retrieve and Parser Agent (AI Agent)
  3. JSON it (Edit Fields (Set))
  4. Structured Output Parser (Structured Output Parser)
  5. Check if Attribute exists (Airtable)
  6. Merge (Merge)
  7. Map Attribute ID (Edit Fields (Set))
  8. Loop Over Attributes (Loop Over Items)
  9. All Attributes (Edit Fields (Set))
  10. Wait for Attribute Creation (Merge)
  11. Change each Attribute to the corresponding RecID (Code)
  12. Split Out Tools (Split Out)
  13. Split Out each Attribute String (Split Out)
  14. Generate Unique Hash for Name (Crypto)
  15. Create if not Exist (Airtable)
  16. Merge Old Data + RecID (Merge)
  17. Only what we need (Edit Fields (Set))
  18. Determine Attributes we should save (Code)
  19. Split Out similar (Split Out)
  20. Merge1 (Merge)
  21. Generate Unique Hash for Similar (Crypto)
  22. It Should exists (Airtable)
  23. All Similar (Edit Fields (Set))
  24. Merge2 (Merge)
  25. Change each Smiliar to the corresponding RecID (Code)
  26. Determine Similar we should save (Code)
  27. Save all this juicy data (Airtable)
  28. Map Agent Input (Edit Fields (Set))
  29. gpt-4o (OpenAI Chat Model)
  30. make it a readable list (HTML)
  31. Get Schema (Airtable)

Credentials you need

  • Airtable API – used by Check if Attribute exists, Create if not Exist, Get Schema and It Should exists and others
  • OpenAI API – used by gpt-4o

Configure your own credentials after importing. Create each credential in n8n, then select it in the node.

How to import into n8n

  1. Download the JSON file with the button above.
  2. In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
  3. Open each node that shows a warning and select or create its credential.
  4. Read the notes on the canvas, test the workflow with sample data, then activate it.

Do you need somewhere to run it? Read our guide to self-hosted n8n.

Need this customised?

We can adapt this workflow to your apps, data and process, then deploy and support it.

Contact Us