I want to read the PDF files (invoice) from Gmail and extract the data and load into any erp system

My use case
I want to establish a gmail connection and get all the email previous day and extract the text from the pdf files (Invoice) that is attached to the email and post the data to any erp system.

As i am new activepieces, i want help how can i achieve this

@Arudhra

Perhaps you shouldn’t start with such a demanding project right away?

For example, you could begin by tackling the core task: extracting information from the PDF file using the GPT vision prompt.

If the results are satisfactory, then you can consider how to retrieve emails from Gmail and how to feed the ERP systems with that data.

So, start as follows:

Step 1:
Read Google Drive file.
Step 2:
OpenAI / Vision Prompt.

I would like to know something like this. I’ve struggled to upload a Gmail message attachment to my Google Drive. I can get the email ID and attachment ID but beyond that I’m stuck. Can anyone help?