Merging multiple operations data returned in to one combined file

How To
1

My problem is essentially this one and it didn’t have an answer sadly. How to merge multiple operations into a single Google Sheet Row - #3 by Sebastiaan_Posma

{E44AAADE-3BE2-4A83-BBC7-C7EB7A333E77}
{E44AAADE-3BE2-4A83-BBC7-C7EB7A333E77}2904×405 105 KB

I have a file that is split in to pieces, sent individually to Chat GPT, it does its thing and creates multiple operations and the output data (result is JSON text string) from each operational output i want to recombine the results in to one file.

Every method i have tried always and repeatedly send each operations output individually.

I have spent a fortune in operations trying to get it to work, and what is now hours and hours on YouTube, the forum, google, Anthropic and OpenAI, and this is my last hope of a solution.

Some one please help, this cant be that hard and I put it down to me and my lack of understanding… but I just cant get it to do the thing!

The image i added it here for some kind of visuals… its changed so much with multiple variations (there is variable in the one above that has no current purpose)

1 Like
2

Hi @Stuart_R

In text aggregator, select the source module as “match pattern”. Then you will be able to combine the results.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

1 Like
3

Appreciate the reply @Msquare_Automation so wow, that was the solution to generating the one output.

Now as you mentioned I now need to combine the bundles in to one to create the document… any advice would be appreciated… but I will keep digging. almost there.

1 Like
4

Hi @Stuart_R

The text aggregator generates a single combined text output, which can be directly mapped to the “Create a Document” module. To format the text content in Google Docs, you need to use HTML formatting. You can either request GPT to provide the output in HTML format or use a Markdown-to-HTML module to achieve this.

Best Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

2 Likes