Load viral ad research into Pinecone

An Airtable trigger watches your viral ads table and fires when a record is edited. It clears the Pinecone namespace named after that record's product type, then reads the table's rows, keeping the product, transcript, analysis, format, hook, visual hook, style, tone and the other breakdown fields.

All the rows are bundled into one text file named after the product, split into chunks, embedded with an OpenAI embeddings model and inserted into the namespace. An AI agent can then search that namespace for proven ad examples when it writes new scripts for that product.