Turn Google Spreadsheet Data into GitHub Flavored Markdown Table

index.js

// It logs out the table data in GHfM format, you can just
// pipe it to `pbcopy` and then paste it in your markdown file

#!/usr/bin/env node

var request = require('request')
var URL = 'https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Ao5u1U6KYND7dGN5QngweVJUWE16bTRob0d2a3dCbnc&single=true&gid=0&output=csv'

request( URL, function (error, response, body) {
  if (error) console.log(error)
  if (!error && response.statusCode == 200) {
    var array = body.split('\n')
    var headers = array.shift()
    makeMdTable(headers, array)
  }
})

function makeMdTable(headers, bodyArray) {  
  var headerCount = (headers.split(',').length) + 1
  var comma = /\,/g
  var tableHeaders = '|' + headers.replace(comma, '|') + '|'
  var tableBody = addNLandBar(bodyArray)
  var underHeaders = makeHeaderUnders(headerCount)
  var nl = '\n'
  var mdTable = tableHeaders + nl + underHeaders + nl + tableBody
  console.log(mdTable)
}

function makeHeaderUnders(headerCount) {
  var underHeaders = ""
  for (i = 1; i <= headerCount; i++) {
    if (i === 1) underHeaders += "| ------ |"
    else underHeaders += " ------ |"
  }
  return underHeaders
}

function addNLandBar(array) {
  var edit = []
  var comma = /\,/g
  array.forEach(function (item) {
    item = '|' + item.replace(comma, '|') + '|'
    item += "\n"
    edit.push(item)
  })
  return edit.toString().replace(comma, '')
}

pennies.md

|ID|PLACE NAME|PHOTO-URL|VENUE|IMAGE|NOUN|LAT|LONG|HEXCOLOR|CITY|STATE|YEAR| | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | ------ | |0|Oakland Zoo|http://farm4.staticflickr.com/3744/12293538223_84b099d982_b.jpg|Oakland Zoo|elephant|animal|37.7502645413531|-122.14675065|#FFE7E7|Oakland|California|2013| |1|Winchester Mystery House|http://farm8.staticflickr.com/7290/12293689915_90cb98dd17_b.jpg|Winchester Mystery House|mansion|place|37.3183373|-121.9510439|#F7CE86|San Jose|California|2012| |2|Winchester Mystery House|http://farm3.staticflickr.com/2828/12294120174_82433e8a83_b.jpg|Winchester Mystery House|Sarah Winchester|person|37.3183373|-121.9510439|#F78585|San Jose|California|2012| |3|Amerian Museum of Natural History|http://farm8.staticflickr.com/7306/12293703216_ee89b9b52f_b.jpg|Amerian Museum of Natural History|mammoth|animal|40.7809389|-73.9730135|#FFE7E7|Washington DC|Washington DC|2011| |4|Six Flags Over Georgia|http://farm8.staticflickr.com/7366/12293855633_70397eda19_b.jpg|Six Flags Over Georgia|Viper|"animal| ride"|33.767303|-84.551204|#F7CE86|Atlanta|Georgia|2000| |5|World Trade Center|http://farm8.staticflickr.com/7409/12294255026_3642dd1592_b.jpg||skyline|place|40.7143528|-74.0059731|#F7CE86|New York City|New York|2008| |6|The St. Pete Pier|http://farm4.staticflickr.com/3813/12293366065_f058bf6eeb_b.jpg|The St. Pete Pier|pier building|place|27.773566|-82.622326|#F7CE86|St. Petersburg|Florida|1998| |7|Miss Katie's Restaurant|http://farm8.staticflickr.com/7385/12293809234_01aaca03d1_b.jpg||logo|graphic|33.8081608|-84.170196|#F78585|Stone Mountain|Georgia|1993| |8|Rhode Island|http://farm4.staticflickr.com/3755/12293371245_3498c140b2_b.jpg||ship|thing|41.8239891|-71.4128343|#FFE7E7|Providence|Rhode Island|2008| |9|"River Street| Savannah"|http://farm4.staticflickr.com/3807/12293941226_cc9654eef9_b.jpg||skyline|place|32.0814473472438|-81.0903453826904|#F78585|Savannah |Georgia|2004| |10|Natchez New Orleans|http://farm6.staticflickr.com/5525/12293375285_73758ea496_b.jpg||ship|thing|29.9510658|-90.0715323|#FFE7E7|New Orleans|Lousianna|2007| |11|Margarittaville|http://farm6.staticflickr.com/5544/12293378845_6dec31f704_b.jpg||drink|thing|29.9510658|-90.0715323|#FFE7E7|New Orleans|Lousianna|2007| |12|Woodman's|http://farm6.staticflickr.com/5486/12293849703_15ab1371e6_b.jpg|Woodman's|clam|animal|42.630151|-70.774552|#F78585|Essex|Massachusetts|2008| |13|Summit Pikes Peak|http://farm8.staticflickr.com/7317/12293700255_084f24d58e_b.jpg|Summit Pikes Peak|logo|graphic|38.840556|-105.044167|#F78585|Pikes Peak|Colorado|2002| |14|Polar Caves Park|http://farm8.staticflickr.com/7325/12294266496_0f712c3707_b.jpg|Polar Caves Park|polar bear|animal|43.7940757|-71.8508395|#F78585|Rumney|New Hampshire|2010| |15|Rainforest Cafe|http://farm3.staticflickr.com/2829/12293696055_99c586eb01_b.jpg|OpryMills|butterfly|animal|36.2051067|-86.6938833|#F7CE86|Nashville|Tennessee|1999| |16|National Museum of American History|http://farm8.staticflickr.com/7336/12293707065_34fa748f16_b.jpg|National Museum of American History|house|place|38.8911993|-77.0300391|#F78585|Washington DC|Washington DC|2011| |17|Boston Celtics|http://farm6.staticflickr.com/5505/12293954736_5dd9f656c4_b.jpg|TD Garden|mascot|person|42.3660275025778|-71.0615873336792|#FFE7E7|Boston|Massachusetts|2010| |18|Cafe du Monde|http://farm4.staticflickr.com/3701/12294274166_b38e331a9b_b.jpg|Cafe Du Monde|coffee and bengiet|food|29.9510658|-90.0715323|#FFE7E7|New Orleans|Lousianna|2012| |19|Six Flags Over Georgia|http://farm8.staticflickr.com/7325/12293799214_ae6eb9d9d6_b.jpg|Six Flags Over Georgia|Wylie Cyotte|animal|33.767303|-84.551204|#FFE7E7|Atlanta|Georgia|2003| |20|Mardis Gras|http://farm4.staticflickr.com/3786/12293544303_a4a6aaeacf_b.jpg||masks|thing|29.9510658|-90.0715323|#FFE7E7|New Orleans|Lousianna|2004| |21|Buzz Lightyear|http://farm3.staticflickr.com/2894/12293704356_e87b4a2234_b.jpg|Six Flags Over Georgia|Buzz Lightyear|person|28.3702563165193|-81.5497970581055|#F78585|Walt Disney World|Florida|2001| |22|Independence Hall|http://farm6.staticflickr.com/5522/12293804254_01fbe35a22_b.jpg|Independence Hall|Indepence Hall|place|39.952335|-75.163789|#FFE7E7|Philadelphia|Pennsylvania|2008| |23|Golden Gate Bridge|http://farm4.staticflickr.com/3749/12293546973_1e98ab77dc_b.jpg||Golden Gate Bridge|thing|37.809783953011|-122.47740983963|#FFE7E7|San Francisco|California|2011| |24|Pirates of the Caribean|http://farm8.staticflickr.com/7301/12294131034_3d995c0523_b.jpg|"Magic Kingdom| Walt Disney World"|Goofey|person|28.3702563165193|-81.5497970581055|#FFE7E7|Walt Disney World|Florida|2001| |25|Boston Skyline|http://farm6.staticflickr.com/5472/12293957336_ccd178f282_b.jpg|TD Garden|skyline|place|42.3660275025778|-71.0615873336792|#FFE7E7|Boston|Massachusetts|2009| |26|Johnny Bravo|http://farm8.staticflickr.com/7301/12294131034_3d995c0523_b.jpg|Six Flags Over Georgia|Johnny Bravo|person|33.767303|-84.551204|#FFE7E7|Atlanta|Georgia|2003| |27|Busch Gardens|http://farm4.staticflickr.com/3765/12294275536_aedc69999e_b.jpg|Busch Gardens|clydesdale|animal|28.033158|-82.420593|#F78585|Tampa|Florida|2002| |28|California Academy of Sciences|http://farm4.staticflickr.com/3822/12293384895_e2b5ae1dff_b.jpg|California Academy of Sciences|aligator|animal|37.769979|-122.466288|#FFE7E7|San Francisco|California|2012| |29|Santa Monica Pier|http://farm4.staticflickr.com/3817/12293940136_bbcc9b806a_b.jpg|Pacific Park|rollercoaster|thing|34.009471|-118.497322|#F78585|Santa Monica|California|2013| |30|Monterey Aquarium|http://farm8.staticflickr.com/7290/12293376585_10c3a7a26c_b.jpg|Monterey Aquarium|animal|animal|36.618032|-121.902054|#FFE7E7|Monterey|California|2013| |31|Hearst Castle|http://farm8.staticflickr.com/7408/12294270926_e970929af8_b.jpg|Hearst Castle|architecture|architecture|35.685312|-121.16894|#F78585|San Simeon|California|2013| |32|Mo's Seafood|http://farm8.staticflickr.com/7416/12293701856_774397f3ac_b.jpg|Mo's|clam|animal|43.967335|-124.104244|#F78585|Florence|Oregon|2013| |33|Ca Hwy 101|http://farm4.staticflickr.com/3799/12293700136_50a6605d43_b.jpg|"Trees of Mystery| Paul Bunyan"|tree|thing|41.584849|-124.086106|#F78585|Klamath|California|2013| |34|Museum of Aviation|http://farm8.staticflickr.com/7361/12293703065_a31ce73392_b.jpg|Museum of Aviation|fighter jet|thing|32.591118|-83.586957|#FFE7E7|Warner Robins|Georgia|2013| |35|Old Sacramento|http://farm4.staticflickr.com/3774/12294126114_0affdf1ea9_b.jpg|"Old Sacramento| Ca"|miner|person|38.583513|-121.503834|#FFE7E7|Sacramento|California|2013| |36|"Tower of London| seal"|http://farm3.staticflickr.com/2819/12293854163_e4a32426d0_b.jpg|"The Fusilier Museum| Tower of Lon"|seal|thing|51.508094|-0.076114|#F78585|London|United Kingdom|2013| |37|Matterhorn|http://farm4.staticflickr.com/3716/12293684265_35f45a0dab_b.jpg|"Zermat| Switzerland"|mountain|place|45.976503|7.65805|#F78585|Zermat|Switzerland|2013|