# Exporting Data from PDF into Google Sheets **URL:** \ **Category:** Questions\ **Tags:** google-sheets, functions\ **Created:** [May 13, 2025, 10:08pm UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332 "2025-05-13T22:08:58Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Jay-CS](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@Jay-CS](https://community.make.com/u/Jay-CS)\ **Post date:** [May 13, 2025, 10:08pm UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/1 "2025-05-13T22:08:58Z")
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. ☹ What am I missing? Thanks ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [May 14, 2025, 4:01pm UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/2 "2025-05-14T16:01:35Z")
Hey Jay, can you share some screenshots demonstrating the issue? ---
**Author:** ![Jay-CS](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@Jay-CS](https://community.make.com/u/Jay-CS)\ **Post date:** [May 14, 2025, 7:45pm UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/3 "2025-05-14T19:45:36Z")
![Bildschirmfoto 2025-05-14 um 21.42.54](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d7be32ca5a5d8714c23d559b97cedb07860f241.jpeg) ![Bildschirmfoto 2025-05-14 um 21.43.07](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/c/acceed032b882426548088ee53d4580cebb83331.jpeg) 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. ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [May 15, 2025, 2:42pm UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/4 "2025-05-15T14:42:58Z")
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? ---
**Author:** ![Jay-CS](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@Jay-CS](https://community.make.com/u/Jay-CS)\ **Post date:** [May 15, 2025, 7:57pm UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/5 "2025-05-15T19:57:36Z")
![Bildschirmfoto 2025-05-15 um 21.52.32](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/0/9046b5fdb4d81d857ca2181da21ef2abd2eb56a4.png) ![Bildschirmfoto 2025-05-15 um 21.52.55](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/f/ffb737b60916d01234e423b9f040a7ffb83a6e3b.png) 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? ---
**Author:** ![Jay-CS](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@Jay-CS](https://community.make.com/u/Jay-CS)\ **Post date:** [May 23, 2025, 6:32am UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/6 "2025-05-23T06:32:43Z")
Still need help. Does anyone have solution or know why the problem occurs? ---
**Author:** ![SierraV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sierrav/32/72484_2.png) [@SierraV](https://community.make.com/u/SierraV)\ **Post date:** [May 23, 2025, 10:41am UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/7 "2025-05-23T10:41:11Z")
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: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/9/f92e661366642ed708ea67d8bfaa9ba672b0aa6c.png) 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: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/b/6bcb81cd8b56a2d8d9e618506cec6ac509d4746c.png) 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 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [August 21, 2025, 10:47am UTC](https://community.make.com/t/exporting-data-from-pdf-into-google-sheets/82332/8 "2025-08-21T10:47:29Z")