Hey there!
I have a text string that is GPT generated in Airtable when a record is created and it works very well. I would like for this text to be separated out into bundles to create new records on a different table in Airtable. Any suggestions?
{
"fields": [
{
"Date": "04/30/25",
"Location": "Airbnb - 4th Street",
"Room": "Private Estate Bedroom 1"
},
{
"Date": "04/30/25",
"Location": "Airbnb - 4th Street",
"Room": "Private Estate Bedroom 2"
}
Is that what the output of your gpt is.
Can you ask it to create bundles of data instead of what you have above?
I have adapted the GPT to be more concise in to the below:
[
{“date”: “04/30/25”, “room_type”: “Private Estate Bedroom 1”, “property”: “Airbnb - 4th Street (4/24-6/10)”},
{“date”: “05/01/25”, “room_type”: “Private Estate Bedroom 2”, “property”: “Airbnb - 4th Street (4/24-6/10)”},
{“date”: “05/02/25”, “room_type”: “Private Estate Bedroom 3”, “property”: “Airbnb - 4th Street (4/24-6/10)”},
{“date”: “05/03/25”, “room_type”: “Private Estate Bedroom 1”, “property”: “Airbnb - 4th Street (4/24-6/10)”}
]
But when its found in Make, I try to iterate it into different bundles so then I can create records in Airtable, it doesn’t recongise it and separate it out:
I was able to figure it out with the Parse JSON module. Since it’s written in JSON that’s the best way to go:
3 Likes
Great job. Sorry just saw this. Glad you figured it out. Yup just using the parse json will work now.
1 Like
