Formatting Gong Transcripts in Google Docs via Zapier

Hi ​@alevine 

Help us have more info by posting these screenshots:

• How Zaps steps 1-4 are configured in EDIT mode with the field mappings visible
• How the DATA OUT is returned from Zap steps 1-4

​@Troy Tessalone  here you go,  its either the loop at step 5 or format text at step 6 where something isnt right

step 1 - working as expected

Step 2 - working as expected

step 3 

Step 4 -

 step 5

step 6 

​@alevine 

Screenshots do not show how Zap steps 3-4 are configured in the CONFIGURE tab with the field mappings visible.

The data returned from Zap step 2 is an array of arrays, meaning line items of line items. (e.g. 1>1, 1>2, etc.)

Nested line items get flattened.

That may be the root of the issue.

​@Troy Tessalone - i missed adding those

any suggestions on how to fix or what updates to make?

step 3 config

Step 4 config

​@alevine 

I think you should try using this action: Formatter > Utilities > Line Items to Text

I don’t think you any other steps besides these 4:

1. Trigger: Gong - New Call
2. Action: Webhook - GET API Request
3. Action: Formatter > Utilities > Line Items to Text
   1. Appears the data from Zap step 2 is returned as line items
   2. Configure like: [Speaker ID]: [Sentence Text] [:newline:]
   3. Help: https://zapier.com/apps/formatter/integrations#help
4. Action: GDocs - Append Text to Doc

thank you ​@Troy Tessalone  i played around with what you suggested but the results are the same

Transcript and speaker ID text is being lumped together, rather than keeping each speaker's dialogue separate.

and this

results 

code worked!

thank you

That’s awesome ​@alevine! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗