googlesheets: Manage Google Spreadsheets from R

Share:

Interact with Google Sheets from R.

Author
Jennifer Bryan [aut, cre], Joanna Zhao [aut]
Date of publication
2016-06-26 12:39:37
Maintainer
Jennifer Bryan <jenny@stat.ubc.ca>
License
MIT + file LICENSE
Version
0.2.1
URLs

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