Track the movies I watch and associated metadata.
IFTTT recipe: IMDB page, Pocket w/ tag video-checkin -> google sheet
Other pocket tags:
hbo, netflix, amazon, theater, cable, airplane, hotel…free, $ (rent), $$ (buy)D2 is the html title, extract the date: =value(REGEXEXTRACT(D2,"[0-9]{4}"))H2 is the year, extract the decade: =concatenate(floor(H2/10),"0")C2 is the list of pocket tags, extract spend: =if(K2<datevalue("2016-08-28"),"unknown",if(iferror(find("$$",C2),-1)>=0,"buy", if(iferror(find("$",C2), -1)>=0,"rent", "free")))C2 is the list of pocket tags, extract venue: =if(iferror(search("amazon",C2),-1)>=0,"amazon", if(iferror(search("netflix",C2),-1)>=0,"netflix", if(iferror(search("hbo",C2),-1)>=0,"hbo", if(iferror(search("itunes",C2),-1)>=0,"itunes", if(iferror(search("theatre",C2),-1)>=0,"theatre", if(iferror(search("dvd",C2),-1)>=0,"dvd", if(iferror(search("airplane",C2),-1)>=0,"airplane",if(iferror(search("hotel",C2),-1)>=0,"hotel","other"))))))))
🛠by Tom Hummel