Google Sheets Copy data from Google Sheets in a view only mode This morning, I came across a Google Sheet in view only mode. I needed the data in an excel for further analysis. Here is a trick that worked. Simple, go to URL and
Spider Pro Improve Productivity. Extract YouTube Transcripts using Spider Pro I've been working on trying to get a blog post related to Spider Pro, which is as they say is *one of the easiest ways to scrape the internet, simply start clicking and collect the data you need*.
Meteor Working with REST APIs on Meteor I have an IP address that changes everyday. One of my electron app has the IP hardcoded, and I need to manually update the IP everyday to get this working. Doing this over
Terminal Switching between windows on a remote nested tmux session Figured this out a while. I tmux first to server 1 and then ssh into server 2. I often need to switch between windows in the remote session. Finally, figure out that the
Spinning Streaming from Macbook to Amazon Fire Stick Good fun this weekend! I've been trying to stream my Pelton classes to my Fire Stick that is attached to the TV. I have a ton of Peloton classes on my hard-drive and
Hacks Amazon Fire TV Stick with Beats Wireless Headphones Discovered this last night and am pretty kicked about it. I never thought this would be possible. I wanted to watch Tron in the living room without disturbing family in the house. I
Hacks Reset PRAM and SMC on Macbook Pro Life can get weird and somethings seem to work by the "Shut-it OFF" and "Shut-it ON" way :-) Here is the way to do it for PRAM and SMC. It works on my
Hacks Solved : Displayport of Macbook 2011 (Early) not working OK! I hate ridiculous solutions, but this actually seems to work! My displayport of Macbook Pro 2011 edition stopped working ... suddenly! I tried a lot of restarts, plug-ins and plug-outs .... and the usual
iPhone Accessing Iphone 7s photos on Ubuntu 16.04 I have tons of photos on my iPhone 7s and was looking to download them onto my MacBook Pro. I swapped the harddisk in my Macbook Pro (2011 edition!) with an SSD and
Hacks Redirect IP Address to localhost I had some of my code (terrible as usual) pointing to an IP Address. I had downloaded my code to a local machine and wanted to use the same code to function of
FFMPEG Creating an audiobook from a list of mp3 files I recently got my hands on an audiobook with a collection of mp3 files. I like to listen on an iPhone and creating a playlist wasn't working the way I intended. So, I
Hacks Solved! Display setting of Dell ST2420L monitor going black after few seconds! This is weird. I dug up my closet and pulled out my old Dell ST2420L and plugged it in. It was turning off after a few seconds! Sucks! After an hour of changing
Tools Clearly Extension on Google Chrome I'm addicted to the Clearly extension that was previously released by Evernote and is no longer available!! Here is the way to install the last one available: * Download extension from Clearly 10.6.
rstats Data Pasta is a must have to working with R and the Web Just came across this package called MilesMcBain/datapasta from r-bloggers! Here is a quick demo of why it is a boon for working with RStudio! No repetitive tasks of parsing and munging for
Pebble Creating my first Pebble Watchface Going to try out creating a pebble watchface as mentioned here [https://developer.pebble.com/tutorials/js-watchface-tutorial/part1/]. Installation Install pebble SDK using Homebrew with: brew install pebble/pebble-sdk/pebble-sdk Development I first
Hacks Creating A Native Signature From A Picture To Sign Documents A fun exercise today. I had to sign a document .. self-attestation actually and I hate manual stuff and paper. I wanted to hack a way to get a near real experience of signing
Mac Resurrecting my Apple TV 3rd Gen I've been a facing a weird lag when I use my Apple TV as an extended monitor. Till recently, it was fine because I decided to use my Apple TV to watch on
Music MusicBrainz Picard - Awesome id3 tagger for all your music! Totally blown away by MusicBrainz Picard! This id3 tagger is just awesome! The explanation will take some time .. but here is a demo that shows how awesome it is! (shower some patience on
Hacks Decrypting Gaana's undocumented API This weekend has been fun! I do a lot of hacks around Gaana.com! But, now I needed to get Metadata of the tracks I listen to. Here is a quick explanation on
Hacks The (Raspberry) pi has landed this weekend was quite exciting I recently got hold of a raspberry pi. Honestly, installing raspberry pi is not as straightforward as I had imagined. There were couple of challenges which had tried
Automation Hammerspoon – Powerful automation of OS X with Lua This is pretty cool! HN featured a post on the front page today about Hammerspoon. I skimmed through the page and looked pretty neat. I liked two examples ... run spotify and find your
Terminal m-cli - Add some more power to your OSX command line I love working on the Mac terminal. I just came across the rgcr/m-cli: Swiss Army Knife for Mac OS X. It is basically a set of cool administrative commands made accessible through
Raspberry Pi Raspberry Pi Zero has landed I just got my hands on a Raspberry Pi Zero. The size of it is just amazing. I'll experiment with it the next couple of days and try to write some interesting posts!
Hacks Making your external harddrive from Mac readable on ubuntu I recently replaced my old harddisk in the Mabbook with an SSD. I decided to put the old hard disk into a USB casing and start using an external drive. I formatted the
Hacks A completely customizable browser - Electron Browser It sometimes happens that I do not need the complete functionality available in a typical browser and would like to hack on top of it to suit and customize it to fit my