Data input in ChatGPT: processing multiple keywords in one run

So I’m working on a scenario and basically its a google sheet with a list of keywords. I am selecting these keywords in google sheets by selecting a range of data. Works fine and outputs the keywords individually in separate output bundles.

What I’m then trying to do is input this data into chat GPT prompt in one go without having to run chat GPT x amount of times for the amount of keywords. For instance 50 keywords runs GPT 50 times when I would rather give GPT the 50 keywords in one go.

I want to feed chat GPT one list of data and get it to sort that data returning me the results. The problem I’m having is it runs x amount of times using too many tokens. I tried to use an array and it just listed [collection, collection, collection etc] so it somewhat worked but didn’t show the values from the array. I know this can be done and im sure its simple but im a beginner with make. Maybe I could utilize something else instead of sheets to do this? I’m open to any suggestions if anyone could help it would greatly appreciated.

Welcome to the Make community!

Every result (item/record) from a search/match 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. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

Click the below links to find out more:

In your case, since you want to pass all the searched results as a single “Text” variable, you might want to consider using the “Text Aggregator”.

2 Likes