Tasking ChatGPT with collecting product URLs from a CSV BOM

Prompting
1

I am a relatively new GPT user( 2-3 months)

I am trying to leverage the power of ChatGPT to do the following:
Receive and parse a CSV BOM(could also be XLSX instead) - this could be small to medium qty of BOM items, ranging from 10 items to 900, and retrieve the Product URLs & Specifications/Datasheet URLs if available.

The CSV BOM will have these columns:
Quantity
Manufacturer
Description
Product URL (to be enriched via GPT)
Specifications URL (Optional - to be enriched via GPT - could be the same as the Product URL)
Datasheet URL (Optional - to be enriched via GPT)

Required process flow:

  1. review file name for hygiene

2)aggregate the BOM items to Unique Product IDs with QTY sum

  1. group BOM items by manufacturer

  2. for each manufacturer, process the BOM by unique Product IDs
    a) confirm part number in BOM via searching to find authoritative product page (complicated by the fact that some different product brands are now same company/family/distributor due to mergers/acquisitions)
    b) enrich the sheet with the Product URL
    c) scrape the Product URL for specifications and/or links to Datasheet
    d) enrich the sheet with Specifications URL( Could be the product page)
    e) enrich the sheet with Datasheet URL (optional - may not exist)
    f) cycle through BOM items not yet with a resolved defensible URL that loads a real page for user inputs of a product page URL or snip with link and Product ID & Manufacturer

Output in XLSX or CSV to be the original uploaded CSV

I have tried this:
via simple prompts after uploading a CSV
via creating a custom GPT with structures SOT
-File naming Convention.docx (enforces hygiene for traceability)
-Output Template.XLSX
-GPT Instruction Protocol.docx

Both routes end in sadness
-Way to much user input required. i may as well have just searched and found the URLS myself)
-GPT blatant disregard for hardcoded instruction in the GPT Instruction Protocol.docx
a) using foreign language symbology in the output against instructions
b) regularly hallucinating untruths
c) Indicating completion but nowhere near
d) arbitrary undisclosed decisions to omit BOM items
e) upon completion, creating whole other separate work flow for me to incorporate(install Python, run a script) to create the output required that the whole exercise was to complete

The sophistry is killing me

Any suggestions/Guidance?

2

maybe this is wrong place, i have since joined the discord and and waiting to be able to post there

3

Welcome to the community!

I just wanted to jump in and say that I think this is a reasonable place to ask, since it relates to ChatGPT workflows, file handling, prompting and avoiding hallucinated results.

That said, from what you describe and if I’m understanding you correctly, this may need more than ChatGPT alone, likely some external tooling or automation around the spreadsheet/search/validation part.

There are users here who are much more experienced with those kinds of workflows, so hopefully someone can point you toward the right setup.

4

Thanks,
Adjacent to that, the tool is for myself, but may be shared with other users, so trying to design with that in mind. Not everybody is going to have python skills( i dont yet, but i will), let alone the environment to run without jumping through hoops to get IT to allow new software installed