googlesheets: Manage Google Spreadsheets from R

Interact with Google Sheets from R.

Install the latest version of this package by entering the following in R:
install.packages("googlesheets")
AuthorJennifer Bryan [aut, cre], Joanna Zhao [aut]
Date of publication2016-06-26 12:39:37
MaintainerJennifer Bryan <jenny@stat.ubc.ca>
LicenseMIT + file LICENSE
Version0.2.1
https://github.com/jennybc/googlesheets

View on CRAN

Man pages

cell-specification: Specify cells for reading or writing

construct_url_from_key: Construct a browser URL from a key

construct_ws_feed_from_key: Construct a worksheets feed from a key

drive_user: Retrieve Google Drive user data

example-sheets: Examples of Google Sheets

extract_key_from_url: Extract sheet key from a URL

gd_token: Retrieve and report on the current token

gd_user: Retrieve information about the current Google user

googlesheet: Register a Google Sheet

googlesheets: 'googlesheets' package

google_token: Produce Google token

gs_add_row: Append rows to a spreadsheet

gs_auth: Authorize 'googlesheets'

gs_browse: Visit a Google Sheet in the browser

gs_copy: Copy an existing spreadsheet

gs_deauth: Suspend authorization

gs_delete: Delete a spreadsheet

gs_download: Download a spreadsheet

gs_edit_cells: Edit cells

gs_grepdel: Delete several spreadsheets at once by title

gs_inspect: Visual overview of populated cells

gs_ls: List sheets a la Google Sheets home screen

gs_new: Create a new spreadsheet

gs_perm_add: Add a permission to a spreadsheet

gs_perm_delete: Delete a permission from a spreadsheet

gs_perm_edit: Edit an existing permission

gs_perm_ls: List permissions for a spreadsheet

gs_read: Read data

gs_read_cellfeed: Read data from cells

gs_read_csv: Read data via the 'exportcsv' link

gs_read_listfeed: Read data via the "list feed"

gs_rename: Rename a spreadsheet

gs_reshape_cellfeed: Reshape data from the "cell feed"

gs_simplify_cellfeed: Simplify data from the "cell feed"

gs_upload: Upload a file and convert it to a Google Sheet

gs_webapp_auth_url: Build URL for authentication

gs_webapp_get_token: Exchange authorization code for an access token

gs_ws: Retrieve a worksheet-describing list from a 'googlesheet'

gs_ws_delete: Delete a worksheet from a spreadsheet

gs_ws_ls: List the worksheets in a spreadsheet

gs_ws_modify: Modify a worksheet's title or size

gs_ws_new: Add a new worksheet within a spreadsheet

gs_ws_rename: Rename a worksheet within a spreadsheet

gs_ws_resize: Resize a worksheet

is_legit_token: Check that token appears to be legitimate

print.googlesheet: Print info about a 'googlesheet' object

token_available: Check token availability

Functions

anchored Man page
cell_cols Man page
cell_limits Man page
cell_rows Man page
cell-specification Man page
construct_url_from_key Man page
construct_ws_feed_from_key Man page
drive_user Man page
example-sheets Man page
extract_key_from_url Man page
gd_token Man page
gd_user Man page
googlesheet Man page
googlesheets Man page
googlesheets-package Man page
google_token Man page
gs_add_row Man page
gs_auth Man page
gs_browse Man page
gs_copy Man page
gs_deauth Man page
gs_delete Man page
gs_download Man page
gs_edit_cells Man page
gs_ff Man page
gs_ff_key Man page
gs_ff_url Man page
gs_ff_ws_feed Man page
gs_gap Man page
gs_gap_key Man page
gs_gap_url Man page
gs_gap_ws_feed Man page
gs_grepdel Man page
gs_gs Man page
gs_inspect Man page
gs_key Man page
gs_ls Man page
gs_mini_gap Man page
gs_mini_gap_key Man page
gs_mini_gap_url Man page
gs_mini_gap_ws_feed Man page
gs_new Man page
gs_perm_add Man page
gs_perm_delete Man page
gs_perm_edit Man page
gs_perm_ls Man page
gs_read Man page
gs_read_cellfeed Man page
gs_read_csv Man page
gs_read_listfeed Man page
gs_rename Man page
gs_reshape_cellfeed Man page
gs_simplify_cellfeed Man page
gs_title Man page
gs_token Man page
gs_upload Man page
gs_url Man page
gs_user Man page
gs_vecdel Man page
gs_webapp_auth_url Man page
gs_webapp_get_token Man page
gs_ws Man page
gs_ws_delete Man page
gs_ws_feed Man page
gs_ws_ls Man page
gs_ws_modify Man page
gs_ws_new Man page
gs_ws_rename Man page
gs_ws_resize Man page
include_token_if Man page
is_legit_token Man page
omit_token_if Man page
print.googlesheet Man page
token_available Man page

Files

inst
inst/shiny-examples
inst/shiny-examples/10_read-write-private-sheet
inst/shiny-examples/10_read-write-private-sheet/ui.R inst/shiny-examples/10_read-write-private-sheet/server.R
inst/shiny-examples/10_read-write-private-sheet/shiny_app_token.rds
inst/shiny-examples/10_read-write-private-sheet/global.R
inst/shiny-examples/README.md
inst/shiny-examples/04_embedded-google-form
inst/shiny-examples/04_embedded-google-form/ui.R inst/shiny-examples/04_embedded-google-form/server.R
inst/shiny-examples/04_embedded-google-form/README.md
inst/shiny-examples/04_embedded-google-form/README.html
inst/shiny-examples/02_user-picks-worksheet
inst/shiny-examples/02_user-picks-worksheet/ui.R inst/shiny-examples/02_user-picks-worksheet/server.R
inst/shiny-examples/01_read-public-sheet
inst/shiny-examples/01_read-public-sheet/ui.R inst/shiny-examples/01_read-public-sheet/server.R
inst/shiny-examples/README.html
inst/shiny-examples/03_craigslist-lost-and-found
inst/shiny-examples/03_craigslist-lost-and-found/ui.R inst/shiny-examples/03_craigslist-lost-and-found/server.R
inst/shiny-examples/03_craigslist-lost-and-found/README.md
inst/shiny-examples/03_craigslist-lost-and-found/README.html
inst/shiny-examples/20_gs-explorer
inst/shiny-examples/20_gs-explorer/ui.R inst/shiny-examples/20_gs-explorer/server.R
inst/shiny-examples/20_gs-explorer/README.Rmd
inst/shiny-examples/20_gs-explorer/README.md
inst/mini-gap
inst/mini-gap/mini-gap.xlsx
inst/mini-gap/mini-gap.tsv
inst/mini-gap/mini-gap.txt
inst/mini-gap/mini-gap.ods
inst/mini-gap/mini-gap.csv
inst/doc
inst/doc/formulas-and-formatted-numbers.R
inst/doc/managing-auth-tokens.Rmd
inst/doc/basic-usage.R
inst/doc/basic-usage.Rmd
inst/doc/formulas-and-formatted-numbers.html
inst/doc/basic-usage.html
inst/doc/managing-auth-tokens.R
inst/doc/formulas-and-formatted-numbers.Rmd
inst/doc/managing-auth-tokens.html
tests
tests/testthat.R
tests/testthat
tests/testthat/test-cell-edit.R tests/testthat/helper00_test-policies.R tests/testthat/test-utils.R tests/testthat/test-gs-register.R tests/testthat/test-yy-consume-data-public-tricky.R tests/testthat/test-gs-upload.R tests/testthat/helper02_unique-slug.R tests/testthat/test-gs-permissions.R tests/testthat/test-gs-yy-download.R tests/testthat/test-yy-consume-data-public-selective.R tests/testthat/test-zz-clean-up.R tests/testthat/test-consume-data-private.R tests/testthat/test-interactive.R tests/testthat/test-gs-ls.R tests/testthat/test-inspect.R tests/testthat/helper03_check-if-old-sheet-still-old.R tests/testthat/test-ws-edits.R
tests/testthat/for_reference
tests/testthat/for_reference/ff_cellfeed.rds
tests/testthat/for_reference/ff.rds
tests/testthat/for_reference/iris_pvt.rds
tests/testthat/for_reference/gap_africa_simplify_R1C1.rds
tests/testthat/for_reference/gap_oceania_listfeed_query.rds
tests/testthat/for_reference/gap_africa_simplify_A1.rds
tests/testthat/for_reference/gap_googlesheet.rds
tests/testthat/for_reference/iris_pvt_googlesheet.rds
tests/testthat/for_reference/pts_special_chars.rds
tests/testthat/test-gs-create-delete-copy-rename.R tests/testthat/helper04_activate-test-token.R tests/testthat/test-auth.R tests/testthat/test-cell-specification.R tests/testthat/test-yy-consume-data-public-whole-sheets.R tests/testthat/helper01_setup-sheets.R tests/testthat/test-yy-axe-oauth-token.R
NAMESPACE
NEWS.md
R
R/gs_ls.R R/gs_register.R R/utils.R R/gd_permissions.R R/googlesheet.R R/gs_read_listfeed.R R/gs_rename.R R/gs_inspect.R R/googlesheet-print.R R/gs_new.R R/gs_download.R R/gd_drive_user.R R/gs_upload.R R/gs_edit_cells.R R/gs_read.R R/gs_copy.R R/gs_old-sheets.R R/gs_browse.R R/gs_reshape_cellfeed.R R/googlesheets.R R/gs_delete.R R/gs_read_cellfeed.R R/gs_add_row.R R/gs_read_csv.R R/gs_example-sheet-setup.R R/gs_webapp.R R/gs_simplify_cellfeed.R R/httr-helpers.R R/gd_metadata.R R/gs_ws.R R/gs_cell-specification.R R/zzz.R R/gd_token-print.R R/gs_auth.R
vignettes
vignettes/managing-auth-tokens.Rmd
vignettes/img
vignettes/img/simple-ingest.png
vignettes/img/gs-test-formula-formatting-screenshot.png
vignettes/img/refresh-tokens-refresh.png
vignettes/img/google-oauth-flow-no-token-found.png
vignettes/img/not-so-simple-ingest.png
vignettes/img/README.md
vignettes/img/gs-test-formula-formatting-screenshot-smaller.png
vignettes/img/google-oauth-flow-plus-httr-oauth-cache.png
vignettes/img/refresh-tokens-fall-off-the-end.png
vignettes/img/google-oauth-flow.png
vignettes/img/user-login-consent-3in-wide.png
vignettes/img/google-oauth-flow-explicit-token-load.png
vignettes/img/google-oauth-flow-plus-load-from-cache.png
vignettes/img/google-oauth-flow-explicit-token-storage.png
vignettes/basic-usage.Rmd
vignettes/formulas-and-formatted-numbers.Rmd
README.md
MD5
build
build/vignette.rds
DESCRIPTION
man
man/extract_key_from_url.Rd man/example-sheets.Rd man/token_available.Rd man/gs_ws_modify.Rd man/gs_ws_resize.Rd man/gs_read_csv.Rd man/print.googlesheet.Rd man/is_legit_token.Rd man/drive_user.Rd man/gs_browse.Rd man/gd_token.Rd man/gs_perm_add.Rd man/gs_perm_delete.Rd man/construct_url_from_key.Rd man/gs_webapp_get_token.Rd man/gs_edit_cells.Rd man/gd_user.Rd man/gs_simplify_cellfeed.Rd man/cell-specification.Rd man/googlesheet.Rd man/gs_deauth.Rd man/gs_auth.Rd man/googlesheets.Rd man/gs_delete.Rd man/gs_ws_delete.Rd man/gs_upload.Rd man/gs_ws_ls.Rd man/gs_read_cellfeed.Rd man/gs_download.Rd man/gs_inspect.Rd man/gs_ws_rename.Rd man/construct_ws_feed_from_key.Rd man/gs_add_row.Rd man/gs_read_listfeed.Rd man/gs_ws.Rd man/gs_read.Rd man/gs_perm_ls.Rd man/gs_grepdel.Rd man/gs_rename.Rd man/gs_reshape_cellfeed.Rd man/google_token.Rd man/gs_copy.Rd man/gs_ws_new.Rd man/gs_new.Rd man/gs_webapp_auth_url.Rd man/gs_perm_edit.Rd man/gs_ls.Rd
LICENSE

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.