You are a beast of a content creator and your free templates are great, keep the same ethos and you will be among the top creators in the AI and/or automation space!
Great video! Thanks. If you want to hide certain output you can use the replace function and then add a emptystring that's more reliable than hoping that chat GPT does his job.
Great video as always, very informative and well explained! I have a question regarding the automation process. How can I design the automation so that header data of the invoice (such as invoice number, date, client information, etc.) is repeated for each item in the invoice detail when the data is extracted to Google Sheets? Considering that the number of items in the invoice can vary, I would like to get each item as a separate record, for later processing rather than having item1, item2, etc as columns. What would be the best way to structure this in the automation? Maybe iterate through items pulling the same header information for each invoice line? Thanks so much, you rock!
Hey! Great question - you had the right answer :) You'll want to use the array iterator to go through each line item, one at a time. When you deal with iterating, what is happening is you're going through an array (i.e. a list of line items in this case) one at a time. When you're iterating through the first line item, you can only access info for the first line item, but not the second, third and fourth - those are all isolated. However, all line items will be able to access the parent information, such as the invoice number, date and client info, because that parent info is not contained within the isolated array. For example: { "invoice_num": 1, "date": "2024/01/01", "line_items": [ { item: "sunglasses", price: 200 }, { item: "hat", price: 300 } ] } You can't access the amount of the sunglasses when you're iterating through hat, or vice versa, but they both can access invoice number and date, because those are parent elements outside of the line items array
@@jonocatliff thanks so much for taking the time to provide such a detailed and helpful answer, I'll certainly work on implementing this feature in your proposed make scenario. Thanks again for your excellent videos, I am learning a lot.