google-spreadsheets-key-parser

parse a google spreadsheets url and get the spreadsheet key

var parser = require('google-spreadsheets-key-parser')

var parsed = parser('https://docs.google.com/spreadsheets/d/1jHY4wO4b0kuX4rVnJgZGwfQUzoxado52k1hzxdUY-AM/edit?pli=1#gid=0')

// returns: 
// { key: '1jHY4wO4b0kuX4rVnJgZGwfQUzoxado52k1hzxdUY-AM',
//  isNewSheets: true }

works for new and old sheets. isNewSheets will be true if it's new sheets, false if it's old sheets

CLI

You can also use it as a CLI app by installing it globally:

$ npm install --global google-spreadsheets-key-parser

Usage

$ google-spreadsheets-key-parser --help
 
Usage
  $ google-spreadsheets-key-parser <url>