Exporting Data from PDF into Google Sheets

Hi guys, I am having a hard time exporting data from my invoices into google sheets using ChatGPT.

The PDF ist downloaded from Google Drive and uploaded to ChatGPT. ChatGPT analyzes the data and converts it to a Json. So far so good. I then use a “Parse Json Module” to structure the data, which also works. The output are collections of all the positions in my invoices.

Then, I use the Google Sheets “Add Row Module” to import the data to my google sheet file. And it does it, but sometimes it just imports lesser collection than the output of the “Parse Json Module” provides. Instead of adding 4 rows of data, I have only 2. :frowning:

What am I missing?

Thanks

Hey Jay,

can you share some screenshots demonstrating the issue?


As you can see the Parse Json module crates 4 outputs. The structure is the same for all 4 outputs. But for some reason, only the first 2 outputs are added to my google sheets file.

Do you have any idea why?

Many thanks.

You should be able to configure the ChatGPT modules to return a JSON directly, so the parse JSON shouldn’t be needed.

Now for the issue it self - can you show the bundles and what the google sheets module actually executed?


Thank you for your reply. The data is correctly added to the google sheet. However, only the first two bundles are added. What about the rest?

Still need help. Does anyone have solution or know why the problem occurs?

Hi @Jay-CS - in your screenshot above, there’s an HTTP module after the Google Sheets (Add a row) module which in your example ran into an error:

This happened after Make created the second row in your sheet > ran into an error > stopped processing the other 2 bundles.

To test if this was the issue, right-click that last HTTP module > Add error handler > select Resume handler. (You can leave all settings blank and just click Save)

This is what it should look like:

Now, Resume will allow Make to continue creating rows even if the HTTP module runs into an error, but ideally you should solve the error of that module so your scenario can run correctly from start to finish.

If you need help with fixing the error, can you share a screenshot of what you have configured in the HTTP module and explain briefly what it’s supposed to do?


Cheers,
Sierra