Data Extraction from Document Into Airtable

[Jake_O]

Hello, I am new to Airtable and I am looking for a simple solution to this problem if possible. I am looking to be able to upload a PDF into Airtable (it would be 1 page). Once the PDF is uploaded, I would like to extract the title and put it in the name column next to the document in the same row automatically. I know there are software’s out there that can handle this type of thing like Parseur, but the documents might not all look exactly the same (or the titles might not always be in the same spot every time). Any assistance would be greatly appreciated! Thanks!

[ScottWorld]

Airtable’s native automations will let you pull the entire filename of the file (including the file extension as well).

For an even easier way to do this, I would highly recommend using Make's Airtable automations & integrations.

In this Airtable podcast episode, I show how to work with attachment arrays in Make.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[Jake_O]

Hello, I am actually not trying to get the file name, I actually want to get the title from the actual document because the file name will be different than the title unfortunately. Do you know if this is something that is possible?

[ScottWorld]

Absolutely. You can get this information — and much more — with any PDF API tool that is available on the web.

For example, let's say that you chose PDF.co as your PDF API tool. Then, you can use Make's PDF.co integrations to integrate with Airtable.

Same thing if you chose PDFFiller as your PDF tool. You would use Make’s PDFFiller tools to do whatever you wanted to do.

And there are tons of other PDF API tools out there as well. If Make doesn’t natively support it, you can always create your own custom API calls by using Make’s HTTP module.

There is a small learning curve with Make, which is why I created this basic navigation video to help. I also provide the links to a few other Make training resources there as well.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[Eric_NEMO]

Hey, 

I don't know if this can be helpfull, but there is a tool that does exaclty this and is built around Airtable !
www.askair.ai

- First you set up your table with every columns you need, and you add descriptions to your columns
- Second you connect askair to it, you obtain an email for the extractor
- Third, you send your document to the extractor email, it parses the document and it fills an airtable record for you !

Hope that helps !