🏙️📚Help with Generating Complete E-Books from Google Forms and ChatGPT

Aysol · February 26, 2025, 12:30am

It is very interesting to build a Custom Book on any topic that provides a general knowledge about anything with ChatGPT.
but ChatGPT Output is very limited.
So I searched and found this video from Jono: https://www.youtube.com/watch?v=ptiDZsZTdGw
I tweaked this scenario and came up with this approach.
I used Google Forms to gather information and generate chapters, subchapters, sections, and subsections. Then, I iterated on this process to build a larger book on a specific topic using ChatGPT.
However, the problem is that either iteration or ChatGPT is not generating the correct number of units, and the final result is not being saved into Google Docs.
I appreciate your Ideas and comments.
blueprint22.json (252.7 KB)

samliew · February 26, 2025, 1:11am

Welcome to the Make community!

This looks like you have likely set the Source Modules of the Aggregators incorrectly.

You need to set the “Source Module” field of the aggregator to where the bundles are coming from. This is usually an Iterator module, but can also be a search/list/repeater module.

For more information, please refer to the Make Academy.

Aggregators

Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

There are other types of aggregator modules, click the below links to find out more:

Array Aggregator – mapping multiple bundles into a complex field

The Array Aggregator module is very powerful because it allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

This is done using the “Target structure type” of an Array Aggregator module.

Here is an example:

As you can see, the “Map” toggle on complex fields are used when you have an array. You can easily build an array variable to map to a future module’s field, by using an Array Aggregator module and select the “Target Structure Type” as the future module’s field you have mapped the array into.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Aysol · February 26, 2025, 12:30pm

Thanks a lot for your help.
Actually, I am aware of this iteration, which must start at the beginning.
I corrected that.
But I get irregular results from ChatGPT modules.

Here, I get 10 instead of 8 results:

And , I get 14 instead of 18 in last sub section module.

My original request was to write a book on Berlin with:

2 chapters
2 subchapters for each chapter
2 sections for each subchapter
2 subsections for each section
A paragraph (just for testing) at the end of each subsection

Then, I wanted them bundled into a Google Doc.
After getting the wrong number of sections and subsections, I ended up with just this document:

samliew · March 7, 2025, 3:18am

While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic for any new or follow-up questions. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users too. You can refer others back to a related topic by including that link in your question.

The “New Topic” link can be found in the top-right of the header:

I would suggest completing the Make Academy before jumping into building a complete scenario with complex issues.

You can also use the Hire a Pro category to request for private 1-to-1 assistance via video call/screenshare/private messaging/etc. This may help you get your issue resolved faster especially if it is urgent or contain sensitive information. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services in other categories like here (even if it’s free/unpaid). Posting in the Hire a Pro category will allow other members to assist you over other forms of communication.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre | Tutorials – Make “Manual”
Make Academy – Basics 101: Learn Make and get certified

Help Centre Basics

Mapping – What is mapping? What can I map?
Mapping with arrays – How to map items in an array
Aggregate an array for mapping complex fields
Date Format: tokens for parseDate | tokens for formatDate
HTTP modules – Make a request, Get (download) a file
Webhooks – Error Handling, Responding to webhooks

Articles & Videos

Router Magic Formula - YouTube
Error Handlers in Make - YouTube playlist
Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
How to use Regex in Make - How to use pattern matching to extract the text you want
Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps!