# Can this even be done? Can't map open ai output into airtable

**URL:** <https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054>\
**Category:** Questions\
**Tags:** arrays, open-ai, airtable\
**Created:** [February 10, 2024, 4:31pm UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054 "2024-02-10T16:31:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edward](https://avatars.discourse-cdn.com/v4/letter/e/90db22/32.png) [@Edward](https://community.make.com/u/Edward)\
**Post date:** [February 10, 2024, 4:31pm UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054/1 "2024-02-10T16:31:34Z")

</div>

The goal is to map output from openai into airtable fields. I have fields called prompt1-30 in airtable.

I am using the open ai module to create 30 prompts. I want to map each prompt to its corresponding field in airtable. This is the information received from my webhook

 ![Screenshot 2024-02-10 at 16.24.14](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/3/5354d5457080aff25d339ea00460c6f49dca139f.jpeg)

The iterator then successfully outputs it all into seperate bundles:

 ![Screenshot 2024-02-10 at 16.26.19](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/4/04ed71c67d7978c71964bdb6bdb0282adbda6b42.png)

I then have this output from open ai:

 ![Screenshot 2024-02-10 at 16.28.01](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/5/e57de1aee17a83e3e2630c61b026a3ac12203415.jpeg)

The issue is that no matter what I do with text parsers, iterators, variables, nothing seems to get this data into a structure where i can simply map prompt1, prompt2 etc into corresponding airtable fields. Completely baffled 😕

 ![Screenshot 2024-02-10 at 16.31.17](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/1/51675a7b06b92960a20b1a5a160f351976c0d694.png)  
 ![Screenshot 2024-02-10 at 16.31.11](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/e/4ec4439a000c7dd9e1af732c1e91515594e5d679.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [February 10, 2024, 4:51pm UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054/2 "2024-02-10T16:51:58Z")

</div>

Welcome to the Make community!

How are you then mapping it into the Airtable module?

You might need an aggregator, or not.

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](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. The next popular aggregator is the [Text Aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator) which is very flexible and has applies to many use-cases.

---

<div class="post-metadata">

**Author:** ![Edward](https://avatars.discourse-cdn.com/v4/letter/e/90db22/32.png) [@Edward](https://community.make.com/u/Edward)\
**Post date:** [February 10, 2024, 7:08pm UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054/3 "2024-02-10T19:08:10Z")

</div>

Thanks for getting back to me. Really tearing my hair out with this. I just can’t seem to get the data into Bundle 1, Bundle 2, Bundle 3 etc, no matter what i do each prompt continues to be named Bundle 1, Bundle 1 meaning that I can’t map anything. I have even (successfully) tried to get each prompt into a datastore but i can’t even pull this data out! 😡

 ![Screenshot 2024-02-10 at 17.38.42](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/e/aeac147b4503d7481f37cbf73f7627deffa69ee2.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [February 11, 2024, 2:11am UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054/4 "2024-02-11T02:11:39Z")

</div>

Everything is named “bundle 1” because they are in different operations. You’ll just need to aggregate the results into a single array like I mentioned.

---

<div class="post-metadata">

**Author:** ![Edward](https://avatars.discourse-cdn.com/v4/letter/e/90db22/32.png) [@Edward](https://community.make.com/u/Edward)\
**Post date:** [February 11, 2024, 8:44am UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054/5 "2024-02-11T08:44:06Z")

</div>

I tried that and it just gave an empty array. It was taking too much time and after days gave up. I think Make could probably up their online tutorial/docs game. In the end I passed the payload of 30 values into lambda, split them out and pushed them to different scenarios with filters on ‘promptX’ exists. Clearly a massive hack but i just needed this to work asap.

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [May 11, 2024, 7:49am UTC](https://community.make.com/t/can-this-even-be-done-cant-map-open-ai-output-into-airtable/27054/6 "2024-05-11T07:49:03Z")

</div>


