Adding multiple results from ChatGPT to Google Sheets Rows

[karla]

Hi all.

We have ChatGPT creating random color names and we have a set up to separate those colors into individual values.

We’re looking for a way to add each color into a google sheets row, but looks like the Array Aggregator is not the best way to solve this, because it adds the word “Collection” into 1 cell.

How can we add each individual color to a new row?

[samliew]

You can map individual items in an array into fields, by using the built-in functions map & get. This is basically the “bread and butter” of arrays in Make.

For more information, see

• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
  Basics
• Mapping – What is mapping? What can I map? ← CHECK THIS OUT
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT

[ManishMandot]

Hey @karla

You can use an iterator instead of an aggregator and map the values in Google Sheets.

[karla]

Unfortunately this doesn’t work

[ManishMandot]

@karla

Use split function first in “set variable”

and map output in “iterator”

And map value in “google sheet” module

[karla]

Hi @ManishMandot - Thank you! It works!

Would you know how I can prevent the steps after the Google Sheet add to repeat themselves? I only need to add the multiple rows to the sheet, but only send 1 email…