ruiguerreiro Posted June 20, 2016 Share Posted June 20, 2016 Hello everyone, I was wondering if it would be possible to create a search in Alfred for a specific Google Documents spreadsheet? I know how to search Google Drive to find a document, but I would like to be able to search through the data inside a specific spreadsheet. I'm using a spreadsheet to catalog all my books, and it would be awesome if I could just type an author's name in Alfred and get back all the books associated with that author that exist in that spreadsheet. Do you think this is possible? Thank you all, Rui Link to comment
deanishe Posted June 21, 2016 Share Posted June 21, 2016 It's possible, but it's not easy. The data aren't stored locally, so you'd need a workflow that uses the Google Drive API and OAuth and all that crap. Link to comment
ruiguerreiro Posted June 21, 2016 Author Share Posted June 21, 2016 Yeah, I figured that would be the case What if I have the document in my local Google Drive folder? Could I point Alfred to it? Thanks a lot, Rui Link to comment
deanishe Posted June 22, 2016 Share Posted June 22, 2016 You can set up an Alfred File Filter for any local files (that Spotlight understands). Super easy. The problem with Google Docs is that it is basically online-only. There is no "native" on-disk Google Docs format. All the files in your Google Drive folder are basically tiny JSON files that contain the document name, type and the URL to edit it online. If you can set up a script that keeps your Google Docs synchronised with a local folder of .doc/.xls/.odt/etc. files, you can search them easily. I'm planning to write a Google Spreadsheets-based workflow in the near future. I'll think on this issue and try to keep the code for accessing Google Drive separate from the rest of the workflow, so other people can base their Google Drive workflows on it. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now