Combine Google Sheet cells into one text for a single ChatGPT completion

Hi, I need to combine multiple sheet cells into one text to be used in a ChatGPT completion. I was using the aggregator for it, but it returns [collectioon] when used for a completion, Can you help me?

Welcome to the Make community!

Every result (item/record) from a search module will output a bundle. To “combine” them into a single structure, 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.

However, in your case, you might want to use a Text Aggregator, since you want to get all the bundles as a single text variable.

2 Likes

Hi @Benjo

To make aggregated text. I recommend you to use text aggregator.
Input:
image
Output:

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel