Skip to main content
Question

How do I stop duplicate Airtable records when splitting ChatGPT output with custom delimiters in a Zap?

  • December 16, 2025
  • 6 replies
  • 21 views

I have a Zap that takes the output from OpenAI/ChatGPT and creates feature‑request records in Airtable. The AI returns multiple rows in one string, using a custom row delimiter (<<<ROW>>>) and a column delimiter (|||). Each feature row includes the fields: Feature, Description, Meeting link, Painpoints, Status, Promised timeline, Evidence snippets, Product‑Related Action Items (so no “Requested priority”).

 

Here’s what I’ve tried:

 

  1. AI prompt: Ensured the model outputs a single line with <<<ROW>>> between rows and ||| between fields, with rules to replace those strings if they appear in the text.

  2. Flattening the array: Inserted a Formatter → Utilities → Line‑item to text step immediately after the ChatGPT step to flatten line items as recommended by the community.

  3. Splitting rows: Used Formatter → Text → Split Text on the flattened string, separator <<<ROW>>>, and captured all segments as line items.

  4. Looping: Added a Looping by Zapier → Create Loop from Line Items step to iterate over each row.

  5. Splitting columns: Inside the loop, used another Formatter → Text → Split Text with separator ||| to get each of the eight fields.

  6. Creating records: Inside the loop, mapped the 8 outputs to the corresponding fields in Airtable (plain-text “Meeting link” field).

 

Despite this, my Zap still creates duplicate records — for example, four rows appear in Airtable with the same feature, description, and meeting link. Additionally, the Promised timeline and Evidence snippets fields remain blank even though those values should be in the AI output.

 

Any ideas on what I might be missing? Is there a better way to handle splitting and looping to avoid duplicates and preserve all fields? I’d really appreciate any suggestions!

 

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 16, 2025

Hi ​@Shelyn Liu 

For us to have true context, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode, along with showing the format of the DATA OUT from the AI step.


Sparsh from Automation Jinn
Forum|alt.badge.img+6

Hey ​@Shelyn Liu,

Please post screenshots of Data In, Data Out as well as how each Zap step is configured for us to have more context. 

For live Zap runs, I would recommend checking the Zap history(https://zapier.com/app/history) to spot any issues there. Hope it helps!
 


  • Author
  • New
  • December 16, 2025

Hi ​@Shelyn Liu 

For us to have true context, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode, along with showing the format of the DATA OUT from the AI step.

 


  • Author
  • New
  • December 16, 2025

Hi ​@Shelyn Liu 

For us to have true context, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode, along with showing the format of the DATA OUT from the AI step.

 


  • Author
  • New
  • December 16, 2025

 


Sparsh from Automation Jinn
Forum|alt.badge.img+6

Hey ​@Shelyn Liu,

You didn’t post the screenshot of Data Out of the AI action. 

I would recommend have the AI action return a JSON array without the logic of the custom delimiter. From there you can pass it directly to the looping action. Hope it helps!