Tag Info

New answers tagged


I had a similar problem. sheetSpider does not appear to be available anymore. I tried writing my own script and it kinda worked but it was slow and didn't update reliably when the source data changed. I eventually solved my problem with a pivot table (Data->Pivot table report...). Just select the range, then add all the columns you want to see as Rows ...


IFTTT looks like it can meet your needs. Specifically, this recipe: Add receipts & orders to Receipt Spreadsheet. (There are also other similar recipes.) This recipe is triggered by a new email message with particular words in the subject, and adds a row to a specific spreadsheet. You'd just need to customize it to your specifications.


You can add a Google Script inside the spreadsheet that looks something like this: function save() { var ss = SpreadsheetApp.getActiveSheet(); var threads = GmailApp.search("subject:X"); for (var t in threads) ss.appendRow([threads[t].getFirstMessageSubject()]); }


Create a sort key, for example by combining actual values and your custom list orders, such as with lookup tables and concatenation, eg: =VLOOKUP(C2,H:I,2,0)&"|"&D2&"|"&VLOOKUP(A2,F:G,2,0)&"|"&B2 then sort on that column.

Top 50 recent answers are included