It's possible. But its not exactly trivial to pull off.
I'm not aware of a turn-key solution so I'd build something custom using one or more intermediary services.
Some have already recommended Google Drive OCR, but it leaves a lot to be desired especially if the content you want to extract from your PDFs have inconsistent layout.
If your PDFs fall within a common class of documents (invoices, purchase orders, etc.) I'd go for a OCR + NLP solution like Google's Document AI.
Google's Document AI Its not a free service, but its one of the more robust solutions out there. There is no native integration with Google Apps Script but there is a REST API available to can be accessed from GAS.
However, if you need an automated process that can scale to handle large volume of documents in real-time, I'd recommend using a different tech stack (GCP Cloud Functions + NodeJs).