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.
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.
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)
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?