Using Chat GPT to parse bill data and add to Airtable

I’m trying to use the “Transform Text to Structured Data” ChatGPT module. I’m pretty new to Make so I think I’m missing something pretty basic.

There’s a part of the configuration of the module where you need to define both a “structured data definition” and an “object definition”. The documentation really doesn’t show any examples beyond the simplest; in my case I think I need to create an array of objects. A bill contains a list of services, and each service has several parameters (date, code, description, fee).

Specifically, I see how to define the array of objects type, but I’m very unclear how to use this UI to define the object it should contain. I look for examples and documentation about “object definitions” but I can’t really find any references to this term outside the single doc about the structured text extraction module. Is this a core concept that is referred to elsewhere using different terminology? Or is this something that is just new and poorly documented / not used widely?

There are posts here showing how to do something like this but they all use JSON; this module seems to be attempting to simplify things and let you do it all in one step.

Welcome to the Make community!

For Structured data definition (SDD), you are “declaring” the overall data you want extracted from the document.

You want to parse a bill. Therefore, the SDD just have to be a single item saying it’s a bill/invoice, as an Object (“Collection”).

Then you will add one property for each value in the invoice in Object Definition 1.


Alternatively, you can use DumplingAI or Groq to describe the data in JSON like format.

This is probably the easiest and quickest way to set-up, because all you need to do is to describe the content that you want, instead of inserting fields individually, and makes it easier to make changes in the future.

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.

Thank you. I’d figured out that part. The thing I am struggling with is how to handle arrays of objects, not single fields. The bill includes a list of services, each of which has multiple fields. Do you have an example of how that would work?

Change the data type into an array of objects.

Hi Robert,
Would you mind sharing your setup with us? I think that many will benefit from it.
Many thanks in advance!