Search and Display a Numbers Spreadsheet Row from Alfred

[FredLarson]

I would like to use Alfred to search a Numbers spreadsheet for a row based on a column query. Once a row is found I would like to display the row or rows that matched the search. For example, in the spreadsheet below, If I search for 3B8, the workflow would display: 3B8, Mauritius, 38

 

Numbers Spreadsheet:

 

1S, Spraley, 307

3A, Monaco, 39

3B8, Mauritius, 38

3C, Equatorial Guinea, 69

…

…

 

Any ideas?

 

Fred

[deanishe]

I can give you a prototype that does exactly this but with Excel files. No idea how easy it would be to adapt to Numbers:

 

[FredLarson]

I appreciate you taking the time to do this but I can't follow it. Is there a way to download the workflow you created so that I can study it? Thanks!

[deanishe]

https://github.com/deanishe/i-sheet-you-not

 

Bear in mind this is still a prototype. It works perfectly (I think), but will probably work differently in the future.

[FredLarson]

Thanks! I understand and will check it out.