Hello everyone! 🙂 I'm working on my first project and I need assistance. Here are the steps I want to take:
1. Retrieve attachments: I need to retrieve attachments from emails, even if there are multiple attachments in a single email. It's important to check all the attachments for the required information. Additionally, there are different types of attachments such as images, PDFs, or Excel files.
1. Extract data from attachments: I want to extract specific data, such as names and invoice numbers, from the attachments. This extracted data will be used to populate a form automatically.
1. Fill in a form automatically: Once the data is extracted, I need to automatically fill in a form with the extracted information.
1. Store forms in department-specific lists: Each department should have its own list to store the filled-in forms. The forms need to be categorized and stored in their respective department lists.
1. Prevent duplicates: To avoid duplicates, I want to implement a mechanism that checks if the invoice number already exists. If an invoice number is already present, I'll skip the form filling process for that particular invoice.
As I'm relatively new to this process, I'm seeking advice on the best approach, recommended connectors, and any helpful techniques from those who have experience with similar tasks.
I appreciate any help or suggestions you can provide. Thank you in advance!