How do I extract data from pdf to excel or csv
Status: Closed · Asked by YOUKOT on · 0 views
Can you please help
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.
