Hi everyone,
I’m trying to figure out if this kind of workflow is possible with n8n. We get a lot of emails from clients, we need to automatically extract that data and use it to fill out a PDF form we use regularly. Once the form is filled, it should be sent back by email. And ideally, We’d also want to send the extracted data into a SharePoint list.
Is this something that can be done with native n8n nodes, or would I need to use an external service for the form filling part?
Appreciate any tips or suggestions.
1 Like
Use the Email Trigger (IMAP) or Email Read (IMAP) node, configuring an IMAP connection and filters (such as the subject and inbox). This node triggers the flow when a relevant email arrives.
If the data is in the body: you can easily parse it with an HTML Extract node. If it’s in a PDF attachment: you can use the PDF Extract node, or for greater precision, connect an extraction service like Unstract. With it, you send the PDF to its API and receive JSON with the mapped fields.
n8n doesn’t include a native node to modify PDFs. You need to extract data (JSON). You make an HTTP request to the service that populates the PDF (input: template + JSON). You get the already populated PDF as a binary response.
Use n8n’s Send Email node, which allows you to send attachments (in this case, the PDF), even using the “Send and wait for response” option for approval if desired.
With an HTTP Request node configured with the SharePoint REST API, you can format the JSON as a list row and POST after extracting data.
Summary flow in n8n:
- IMAP Email Trigger → filters incoming emails.
- PDF Extract (or HTML Extract) → extracts data.
- HTTP Request to external service that populates the PDF.
- Send Email with PDF attachment.
- HTTP Request → records data in SharePoint.
2 Likes
We’ve handled this kind of setup using instafill.ai alongside n8n. The email gets forwarded to a specific address, and Instafill takes care of extracting the data, filling out the PDF, and emailing the completed form back. From there, we just use n8n to monitor the inbox and push the extracted values into SharePoint, no custom parsing.
2 Likes
PDF Generator API node is built directly into n8n (you can find it in the nodes list) and has a dedicated action for this. PDF Form Filling (Your Question): This is where you’ll use the PDF Generator API node.
Select the Fill Form action. > You’ll connect your PDF template (which you’ve uploaded to your PDF Generator API account). > You can then easily map the data extracted from step 2 (e.g., {{ $json.client_name }}, {{ $json.order_id }}) directly to your PDF’s form fields. > The node will output the completed PDF file’s binary data for the next step.
2 Likes