Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Show HN: Chat with G-Drive Folder in Sheets (github.com/cdm823)
2 points by cdm83 on April 1, 2024 | hide | past | favorite | 2 comments
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.



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?


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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: