Reading and saving PDF information in a structured way (google sheet)

Questions
1

Hey Guys, I managed to create a workflow that read PDF documents and save all informtion into a google sheet document.

The problem I am facing is that all informtion is going to a single google sheet cell, instead os saving all information in different columns and rows. I though about adding a code node so a javascript or python code could structure it, but I had no success on it.

Thats how the information is being save into the google sheet

image
image720×532 13 KB

Thats an example of how the Output looks like inside de AI Agent node

image
image507×285 26 KB

I would like to structure all this data in cloumns, giving the possibility to use it for reports and etc. Can anyone help me out?

image
image1164×528 68.1 KB

2

Hey @Soho ,

Use a Structured Output Parser to define the desired format for the AI Agent’s output.

The parser will guide the agent to produce responses in a structured format, ensuring consistency.

Example:

{
  "valor_icms": 11.34,
  "total_a_pagar": 95.50,
  "aliquota": 21
}

By specifying the desired structure, the agent will produce outputs that are easy to parse and integrate with Google Sheets.

Let me know how it goes!

:point_right: If my reply answers your question please remember to mark it as the solution