Hi everyone,I'm working on a Zap that processes a list of webinars published on YouTube, stored in a Google Sheet. I use Dumpling AI to fetch the YouTube transcript, which typically contains around 9519 words / 49,409 characters.Since the transcripts often contain inaccuracies—especially for technical terms, company names, and speaker names—I pass the text through ChatGPT to clean it up. I provide contextual inputs (speaker name, company, generic terms, etc.) from the Google Sheet manually in the prompt, and the results are quite satisfying.However, because the transcript is so long, I’ve implemented Formatter by Zapier to split the content, and then Looping by Zapier to process each chunk individually with ChatGPT.I’ve followed the guides: Modify large data for your AI prompts Loop your Zap actions Workflow overviewGoogle Sheet Data SheetStep 1 to Step 4 (see configuration) Step 5 (see configuration) to Step 7 Step 7 (see Setup) to Step 8 Issue #1 – Google Docs step failsWhen I manually test step 8, a document titled {{Title}} - 1 is correctly created even if the output is a bit short (310 words). When running full test, at the end of the loop, I'm trying to create a Google Doc for each cleaned chunk, but I get this error: "This Google Docs step hit an error. Required field 'Document Content' (file) is missing." Issue #2 – Joining the loop resultsIdeally, I’d like to combine all the cleaned chunks into one Google Doc, but it seems Zapier’s loop doesn’t support storing all the outputs and combining them natively in the same Zap.Is my only option to trigger a separate Zap for that? Or is there a workaround to accumulate looped outputs into a single step within the same Zap?Thanks in advance for your help!

Hi @Arnaud JolyFor Issue #1, we would need to see screenshots with how your GDoc step is configured in EDIT mode with the field mappings visible.For Issue #2, you need to add more logic to fix.You need logic like this:Use a unique OpenAI ConversationMemory Key across each Zap Run BUT that will be the same for all Loop Iterations.For all of the Loop iterations you need to include prompt instructions that say something to the effect of: I will be giving you pieces of the overall content to process, so wait until I tell you that you have all of the content to process to continueInclude info in the prompt that says this is loop iteration X of Y (e.g. 1 of 3)These variables come from the Looping stepNOTE: Loop iterations run in parallel unless programmed otherwiseInfo on how to run sequential loop iterations:https://community.zapier.com/show%2Dtell%2D5/guide%2Dhow%2Dto%2Ddo%2Dsequential%2Dlooping%2Diterations%2Din%2Dzap%2Dsteps%2D31166Add a Filter step to only continue if the Loop Iteration Last = TRUEAdd another OpenAI Conversation step after the Filter stepInclude prompt instructions that say something to the effect of: ok now you have all of the content, you can continue to do XUse the output from the OpenAI step after the Filter step to use in the GDoc stepLooping help:https://zapier.com/apps/looping/integrations#help

Troubleshooting Google Docs integration with Looping and ChatGPT in Zapier

Hi everyone,

I'm working on a Zap that processes a list of webinars published on YouTube, stored in a Google Sheet. I use Dumpling AI to fetch the YouTube transcript, which typically contains around 9519 words / 49,409 characters.

Since the transcripts often contain inaccuracies—especially for technical terms, company names, and speaker names—I pass the text through ChatGPT to clean it up. I provide contextual inputs (speaker name, company, generic terms, etc.) from the Google Sheet manually in the prompt, and the results are quite satisfying.

However, because the transcript is so long, I’ve implemented Formatter by Zapier to split the content, and then Looping by Zapier to process each chunk individually with ChatGPT.

I’ve followed the guides:

Workflow overview

Issue #1 – Google Docs step fails

When I manually test step 8, a document titled {{Title}} - 1 is correctly created even if the output is a bit short (310 words). When running full test, at the end of the loop, I'm trying to create a Google Doc for each cleaned chunk, but I get this error: "This Google Docs step hit an error. Required field 'Document Content' (file) is missing."

Issue #2 – Joining the loop results

Ideally, I’d like to combine all the cleaned chunks into one Google Doc, but it seems Zapier’s loop doesn’t support storing all the outputs and combining them natively in the same Zap.
Is my only option to trigger a separate Zap for that? Or is there a workaround to accumulate looped outputs into a single step within the same Zap?

Thanks in advance for your help!

Page 1 / 1

Hi @Arnaud Joly

For Issue #1, we would need to see screenshots with how your GDoc step is configured in EDIT mode with the field mappings visible.

For Issue #2, you need to add more logic to fix.

You need logic like this:

Use a unique OpenAI Conversation Memory Key across each Zap Run BUT that will be the same for all Loop Iterations.
For all of the Loop iterations you need to include prompt instructions that say something to the effect of: I will be giving you pieces of the overall content to process, so wait until I tell you that you have all of the content to process to continue
- Include info in the prompt that says this is loop iteration X of Y (e.g. 1 of 3)
  - These variables come from the Looping step
- NOTE: Loop iterations run in parallel unless programmed otherwise
  - Info on how to run sequential loop iterations: https://community.zapier.com/show%2Dtell%2D5/guide%2Dhow%2Dto%2Ddo%2Dsequential%2Dlooping%2Diterations%2Din%2Dzap%2Dsteps%2D31166
Add a Filter step to only continue if the Loop Iteration Last = TRUE
Add another OpenAI Conversation step after the Filter step
- Include prompt instructions that say something to the effect of: ok now you have all of the content, you can continue to do X
Use the output from the OpenAI step after the Filter step to use in the GDoc step

Looping help: https://zapier.com/apps/looping/integrations#help

Hi @Arnaud Joly,

We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.

We're looking forward to your response.

Hello @Troy Tessalone

Thanks a lot for the detailed reply!

For Issue #1

I’ve attached a screenshot of the Google Docs step in edit mode showing the “Document Content” field populated with the ChatGPT output. Let me know if anything looks misconfigured.

For Issue #2

Thanks a lot for the thorough explanation. This architecture makes a lot of sense. I’ll rebuild the Zap accordingly and test it with a full set of chunks.

Thanks again for the excellent support — I’ll report back once it’s fully running!

Hi @Arnaud Joly,

Thanks for sharing the update and screenshot! Your Google Docs step looks well-configured, with the ChatGPT output correctly mapped and dynamic naming in place. Please double-check that you're pulling the correct field from ChatGPT (like Message Content), and test step 7 to ensure it returns full content for each loop. Also, ensure the ChatGPT and document creation steps are inside the loop to avoid empty or repeated content. It's great to hear you're rebuilding with whole chunks — that approach should make your Zap more reliable. Let us know how it goes.

Issue #1 – Google Docs step fails

Issue #2 – Joining the loop results

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded