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.
Hey there! If you need consulting you can book here: jonocatliff.com/coaching#consulting If you want to hire my automation agency, you can reach out here: automatable.co/ :)
Hey there, no worries and great question! I'd recommend PDF.co. You can do a ton with it for free, it has an integration into Make.com, and it'll help you convert PDFs to text. I only learned about it after this video. Hope that helps :)
You can try the PDF.co integration, it's free and does the same thing when it comes to converts PDFs to text. The only other thing to check is your balance - maybe you ran out of credits on 0CodeKit
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!
Thanks so much, I really appreciate you saying that! That's my goal :) Best of luck implementing these solutions!
Very nice!!! My goodness this is powerful!! Keep them coming buddy!!
Thanks, I'm happy you liked it, best of luck :)
oh my God i spent so many time to find this. I need to extract pdf, and then put to gpt and sheets. Thank you so much
No worries, best of luck :)
you videos are so useful and clear, thank you so much
Thank you very much :)
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.
LOL that gave me so much trouble. You're spot on, I should've done that - but I'll be using this trick for future videos. Thanks!
the OpenAI module has a secret setting in the "advanced settings": set output to JSON. Best setting ever.
This is amazing. I've been using this and it's a life saver. Thanks Sam!
@@jonocatliff does make things much more stable, yes!
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.
Amazing, happy to help! Best of luck :)
in the advanced settings of the OpenAI module you can switch the output to JSON and even tell it to parse it.
You're a lifesaver. Can't believe I didn't see this before. Thank you, you're a hero @SamSteiner :)
@@jonocatliff haha, yes, I was truly happy myself when I found that
Hahah, I actually just used this now, so definitely going to be copying this from you moving forward
I need your help building something! Glad I bumped into you, where can I be in touch?
Hey there! If you need consulting you can book here: jonocatliff.com/coaching#consulting
If you want to hire my automation agency, you can reach out here:
automatable.co/ :)
Thanks for helpful videos! Do you know if there is a free alternative to the 0codekit?
Hey there, no worries and great question! I'd recommend PDF.co. You can do a ton with it for free, it has an integration into Make.com, and it'll help you convert PDFs to text. I only learned about it after this video. Hope that helps :)
0codekit blocked me when I ran the flow the 2nd time, I did exactly step by step, nothing else. WTF?
You can try the PDF.co integration, it's free and does the same thing when it comes to converts PDFs to text. The only other thing to check is your balance - maybe you ran out of credits on 0CodeKit