How do I extract data from pdf to excel or csv

Status: Closed · Asked by YOUKOT on · 0 views

YOUKOT — Question ·
I am trying to extract data from pdf in a readable format/tags so i can send it to serve manager API. I am having difficulty in a basic workflow I designed where Garnishee or court or Garnishee Address values are being split as the are multiple rows.
Can you please help
Pabbly Support — Reply ·

Hello,

Thank you for reaching out to Pabbly Support.

Pabbly Connect does not have a dedicated built-in feature to parse the contents of a PDF attachment. When the PDF comes into the workflow, it is exposed only as a downloadable file URL. To extract structured data from the PDF, the recommended pattern is:

1. Trigger the workflow with your incoming source so the PDF's download URL becomes available.
2. Pass the file URL to ChatGPT (an OpenAI action step) and explicitly tell the model in the prompt that it is a PDF and exactly which fields you want extracted (for example Garnishee, Court, Garnishee Address). Describing the structure clearly in the prompt helps avoid values being split across rows.
3. Map the parsed output from ChatGPT into your downstream action to send the data to your Serve Manager API.

A couple of tips for your case:
- Since values like Garnishee or Garnishee Address are splitting into multiple rows, instruct ChatGPT in the prompt to return these as single consolidated fields and specify the exact output format you need.
- Normalize any date/number formatting directly in the prompt.

Thanks & Regards,

Adeel Akhtar
🌐 Pabbly.com

Signature image

Back to all forum threads · Log in to reply