gistfile1.txt

# install.packages("googlesheets")
suppressMessages(library(dplyr))
library(googlesheets)
library(dplyr)

gs_url("https://docs.google.com/spreadsheets/d/1IbDM8z5XicMIXgr93FPwjgwoTTKMuyLfzU6cQrGZzH8/pub?gid=0",lookup = FALSE)

## Sheet-identifying info appears to be a browser URL.
## googlesheets will attempt to extract sheet key from the URL.
## Putative key: 1IbDM8z5XicMIXgr93FPwjgwoTTKMuyLfzU6cQrGZzH8
## Authentication will not be used.
## Worksheets feed constructed with public visibility

##                   Spreadsheet title: indicator gapminder population
##                  Spreadsheet author: gapdata
##   Date of googlesheets registration: 2015-10-05 16:54:10 GMT
##     Date of last spreadsheet update: 2012-09-07 13:50:39 GMT
##                          visibility: public
##                         permissions: rw
##                             version: new
## 
## Contains 5 worksheets:
## (Title): (Nominal worksheet extent as rows x columns)
## Data: 261 x 233
## About: 43 x 6
## Footnotes: 20 x 6
## Settings: 20 x 6
## v: 20 x 6
## 
## Key: 1IbDM8z5XicMIXgr93FPwjgwoTTKMuyLfzU6cQrGZzH8
## Browser URL: https://docs.google.com/spreadsheets/d/1IbDM8z5XicMIXgr93FPwjgwoTTKMuyLfzU6cQrGZzH8/