Data Automation Workflow in Make/n8n

I’m looking for an experienced freelancer to design and build an automation workflow in Make (Integromat) or n8n.
The goal is to automatically enrich product data for an e-commerce catalog by searching the internet using EAN codes and then filling in missing product attributes and categories.

The system should:

Search for product information online based on EAN codes (and optionally product names),

Collect key data such as product name, brand, size, and description,

Send the data to OpenAI GPT API (GPT-4 or GPT-4o),

Let GPT determine the correct category from my predefined category tree and generate short descriptive content,

Write all results back into an Excel or Google Sheet.

Input

Excel or CSV file containing:

EAN – barcode (main identifier)

Product Name – optional but helpful

Output

The automation should return a structured dataset with:

EAN

Product Name

Category (exact match from provided tree)

Brand / Manufacturer

Product Type / Usage

Volume / Weight (if available)

Short Description (SEO-friendly, suitable for e-commerce)

Confidence (0–1 score of accuracy)

Source URLs (websites where data was found)

Workflow Logic

For each product:

Perform a web search using the EAN code (e.g. via Google, SerpAPI, or another API).

Extract the product title and text description.

Pass this data to OpenAI GPT API along with the predefined category tree.

GPT selects the most relevant category, identifies the brand and attributes, and generates a short e-shop-friendly description.

The output is written back to a spreadsheet or database.

If the product cannot be confidently identified, the system should return "UNCERTAIN".

Example of Category Tree
Drogerie/Personal Care/Soaps
Drogerie/Personal Care/Shampoos and Conditioners
Drogerie/Cleaning and Household/Universal Cleaners
Drogerie/Paints and Varnishes/Wood Paints
Drogerie/Paints and Varnishes/Metal Paints
Drogerie/Auto Chemicals/Car Care Products
Drogerie/Decorations and Candles/Candles
Drogerie/Seasonal/Grilling
Drogerie/Household Supplies/Preserving
Drogerie/Pet Care/Cosmetics
Drogerie/Stationery and Office/Accessories
...


(Full list of categories will be provided in Excel or text format.)

Technical Requirements

Must be built in Make (Integromat) or n8n

Must support batch processing (hundreds or thousands of EANs)

Use OpenAI GPT API for categorization and content generation

Use SerpAPI or Google Custom Search API (or similar) for product lookup

Export results to Excel, Google Sheets, or CSV

The category tree and prompt should be easily editable

Optional caching of already-processed EANs is a plus

I Will Provide

Full category tree in Excel

OpenAI API key

SerpAPI or Google API key

Sample product dataset

Success Criteria

The project will be considered complete when:

The automation processes all EANs and fills in most attributes automatically (≈80% accuracy or better),

Categories match the provided tree,

The descriptions are clean and relevant for e-commerce,