PDF Bank transactions table to Google Sheet

[Google Pony]

Hello, everyone!

I hope everything is going well for you.

I have a couple of questions for you.

1. Can PDF data be converted to Google Sheets?

2. I have a PDF document with bank transactions (tables) that I'd like to convert to Google Sheets using Google Apps Script.

3. What are the things I need to keep in mind while extracting, such as the structure of the pdf, the objects in the pdf, and the extraction?

Could you please provide me with any information on this?

Thank you very much, Pony.

[Jon Couch]

Pony,

Amit has a couple posts that can probably help you do this. 

https://www.labnol.org/extract-text-from-pdf-220422

https://www.labnol.org/code/20566-extract-text-pdf/

I would start with them but I'm sure there are other examples. You might get some other ideas from the folks here, but in the meantime, that should give you something to work with.

It's been said "The difference between an average programmer and a great programmer is all in their Googling skills."

Good luck,

Jon

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJfauaq1ED%3DG5QeGaA09Qct6bMzKyA%2BjVooU-MHzYiWuvaQz4g%40mail.gmail.com.

[Bruce Mcpherson]

Hello

The answer is probably to be found here

https://cloud.google.com/document-ai

I'm working on some Apps Script Integration with this api at the moment, but I won't be publishing it till early next year. For the moment, you could explore what it can do and whether you see if you can use the API.

bruce

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CADjEj86MYf8faXJRf3jfiLbWVCfTAWWuR-0Woaj1C9pybjYYAg%40mail.gmail.com.