Split Array Aggregator with 15.000 data into packages of 50

How To
1

Hello you all,

Im trying to do the following:
-I’m getting a list of company names in Google Sheets
-Then I’m loading these names into Make to use them with Openai
-Openai gets me the company url
-After that I want to send the company url through the HTTP Request to app.companyenrich
-The API enriches the data for the company and saves it back in the google sheet

Now to my problem:
-The list will contain 15.000 company names
-Therefore I need to batch request the enrichment
-The API of company enrich only allows 50 urls with each request
-Therefore I need to “split” the bundle of openai results into packages of 50 → Send them to the HTTP request → Get the enrichment data → save them in the corresponding cells → and get the next 50

I have tried some “copiloting” with ChatGPT and researched the array aggregators, but I’m rather new in Make.

I thank you for every response!

image
image1560×211 34.9 KB

1 Like
2

Hi @P7Make ,

For testing, we have created a Google Sheet with around 249 records. To split that into bundles of 10, we can use a Text Aggregator and group by:

{{ceil({{bundle order position}} / 10)}}

image
image985×489 31.9 KB

image
image1580×657 55.7 KB

image
image1349×744 81.6 KB

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

3 Likes
4

Welcome to the Make community!

For more information, do view these similar questions previously asked by other community members, which may answer your question:

Next time, please try to search this forum first for existing answers. This may help you get to the solution faster, and also help keep the forum organised. Thanks for your cooperation!

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.