Show HN: Chat with G-Drive Folder in Sheets

[cdm83]

Q&A PDF, Google Doc, and .docx files without leaving Google Sheets. Uses Drive API and PDF.js to take in a G-Drive folder URL, fetch docs and extract document text. It processes fairly quickly, ~1000 pages extracted+chunked+embedded in ~7 seconds.

The script creates an HTML modal to let the script use browser functionality, getting around some of Apps Scripts (Google's built-in, lightweight scripting platform) limitations and another HTML modal is used to Q&A the documents in a conversational way, all within a Google Sheets tab.

I was already doing this by downloading files/using a script or another platform to analyze them with an LLM. Most of my files are in G-Drive, so this skips an annoying step.

Would love to see any comments/feedback or discuss similar projects you're working on.

[pbmango]

Great demo! Going to try this with a huge folder of call recordings that I would love to search across. Does it work with Google Docs as well as PDF?

[cdm83]

yep - Google Doc and MS Word files exported from Drive API as text and PDF files' text extracted with PDF.js