googlesheets: Manage Google Spreadsheets from R

Interact with Google Sheets from R.

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

Files in this package

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

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

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