Email Attachment to Google Sheet

[usman]

Hi I want to create a little complicated multistep workflow where when I receive an email with an invoice as an attachment, I would like that invoice to be saved in a google drive folder, and then ask ChatGPT to analyze the invoice and return the values like date, invoice number, all the line items and their details, quantity and amount into a google sheet. I tried a part of it where I could get the email attachment in google drive but I am stuck at getting ChatGPT to analyse the invoice as it says it cannot do that to analyse external link like gdrive. Any way to achieve this or any other means to do this? Also is the case of getting all the line items in the invoice on a google sheet sounds complicated but I think we can use the iteration module somewhere. Help here would be appreciated. Thks in advance.

 

[ArshilAhmad]

We assume that the invoice you upload to Google Drive is in PDF format. For this, you can use the 'PDF.co: Document Parser' action step, which will extract the content from the PDF. You can then pass this data to ChatGPT for further analysis. Please check if this helps you extract the necessary data. Once done, we can look into how the extracted data will be added to Google Sheets.

 

[usman]

Ok used pdf.co to process the pdf. But on testing certain files took more than 25 seconds to parse and pabbly stopped it. How do we go around it or let it parse in background and we come back to it?

 

[ArshilAhmad]

Could you please share the Workflow URL where you have tried this?

 

[usman]

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[ArshilAhmad]

Pabbly Connect waits for 25 seconds to receive a response from any application. The issue you are describing occurs when an application (PDF.co) takes more than 25 seconds to process a request, and because of this, Pabbly Connect does not receive the response within 25 seconds, leading to the error you encountered. Due to the large amount of data involved in parsing the document, unfortunately, the use case you are describing doesn't appear to be possible.

 

[usman]

Pabbly Connect waits for 25 seconds to receive a response from any application. The issue you are describing occurs when an application (PDF.co) takes more than 25 seconds to process a request, and because of this, Pabbly Connect does not receive the response within 25 seconds, leading to the error you encountered. Due to the large amount of data involved in parsing the document, unfortunately, the use case you are describing doesn't appear to be po

How do we do what I have highlighted from a screenshot from the workflow part of pdf.co

 

[Preeti Paryani]

Hello @usman

You can select "True" from the Async dropdown, which will allow the process to run in the background while you continue with the next steps of your workflow. However, please note that if you have mapped data from the pdf.co step, an error may occur because the required mapped details may not be received

 

[usman]

So do I need to do a wait step to wait for the reply? Or do I need to add another step to get the details? A little
More detailed help in the above step would be appreciated.

 

[Preeti Paryani]

Hello @usman

Can you please capture a few more files in the trigger step so we can check if your use case possible?

 

[usman]

a challenge i am facing is the size of the attachement in the email to be parsed, adn then there are emails with multiple attachments. any way to increase the size of the attachments by the email parser. and how do i handle multiple attachments.

 

[usman]

i am also contemplating using async mode where once i send the attachment to pdf.co, i setuo a webhook in pabbly to get the details from pdf.co once the pdf is processed and send back the details. you think this could be a viable solution?

 

[ArshilAhmad]

a challenge i am facing is the size of the attachement in the email to be parsed, adn then there are emails with multiple attachments. any way to increase the size of the attachments by the email parser. and how do i handle multiple attachments.

I am afraid it is not possible to increase the attachment size in the Email Parser. You can try using the 'Parsio: Attachment Received' trigger step to fetch a larger attachment.

=============================================================

i am also contemplating using async mode where once i send the attachment to pdf.co, i setuo a webhook in pabbly to get the details from pdf.co once the pdf is processed and send back the details. you think this could be a viable solution?

If PDF.co supports webhooks and has a webhook event through which you can capture processed data, then yes, you can use Webhook by Pabbly to capture that data.