Use Glide AI to Extract Text from PDF and Generate JSON

[@GeremyDeMelo]

The power of this is endless. Thanks for once again bringing an amazing and eye opening video Robert. We can really get creative and squeeze to the max all the tools and resources inside Glide. 🚀🚀🚀

[@RobertPetittoWA]

Glad you enjoyed it! I love pushing the boundaries of what Glide can accomplish!

[@erwinblom]

I've said if before and I will say it again, Robert Petitto is the best when you want to learn Glide. I learned so much about JSON in this video!

[@RobertPetittoWA]

Amazing right?!

[@erwinblom]

@@RobertPetittoWA the combi JSON - AI seems king.

[@BGary65]

My question would be how would you format the JSON so then the line items could be displayed in a table component instead of HTML format?

[@RobertPetittoWA]

You’ll need to use the “miracle method” of parsing out the json into their own rows using a helper table. I refer to it here: kzbin.info/www/bejne/Z4LFfIeZmLNra5Isi=C4DFERkXyoF53Qe2

[@florisdelaat5613]

Hi Robert, can it also read a dropbox direct download link? Or do I need to change a few items? It works now when I upload the file directly on Glide, but not with other links.

[@PatchitForward]

So much to learn in this video. Thanks Bob!

[@RobertPetittoWA]

Ya I go down the rabbit hole a bit on this one!

[@langakambi-shamba7029]

Great Video! Thanks Robert

[@RobertPetittoWA]

Magic, right?

[@christianjohnson8171]

Trying this out and getting errors on the text output. Looks like it doesn't work on private files., but when I make the google drive file open to the public, the text just lists the name of the file + "Google Drive Loading...". Do you know how to fix this?

[@RobertPetittoWA]

This won’t work with Google Drive files unless you’re providing the direct download link

[@AndreasBonschak]

Are the instructions with the new AI function "Text to JSON" now obsolete or outdated? I tried both, your version worked, the new function didn't and hallucinated..thanks for your response! Andy from Vienna, Europe

[@AndreasBonschak]

PS Can you make a video with this new AI function "Text to JSON"?

[@RobertPetittoWA]

Yeah, I haven’t been too impressed with the text to JSON function. It should work the same way though, just define what structure you want.

[@miguelxmarin]

hello robert, can we leverage document to text to extract a excel table of 1000 rows and convert it into a glide table that dynamically changes every time the user uploads a new file. the display of this information is user specific. is that possible?

[@RobertPetittoWA]

Should be! You’d use a 1k row helper table to parse out the the contents of the upload

[@zippytechnologies]

Can I hire you to consult and help build an app for my business?

[@RobertPetittoWA]

For sure! Https://calendly.com/robert-petitto

[@guivo167]

Excelente... Fuerza y éxito... ✋

[@RobertPetittoWA]

Mil gracias