Extract all rows from Airtable (as one dataframe) to input into CHATGPT

I want to extract all the data from one Airtable table which has 6 columns and approx 50 rows
And I want to parse all that data as one file into GPT, as a variable as part of the prompt to analyse.
Make’s own AI couldn’t help, GPT4o couldn’t figure it out, (GPTo1 was even worse) and Claude couldn’t do it.
Maybe a real person knows? :wink:

Have you tried using Search Records with a high limit (like 9999), and a Text Aggregator?

Screenshot_2024-10-04_091038

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.

1 Like

Hey Sam, thanks a lot. This looks like a solution!! :slight_smile:

I assume I’m not going to create myself problems by putting some json header structure into the aggregator text input.

{
“url”: “{{1.url}}”,
“price”: “{{1.Price}}”,
“product_name”: “{{1.Product name}}”,
“meta_description”: “{{1.Meta Description}}”,
“product_description”: “{{1.Product Description}}”
}

Thanks loads!