RDocumentation
Moon
Learn R
Search all packages and functions
⚠️
There's a newer version (0.3.0) of this package.
Take me there.
googlesheets (version 0.1.0)
Manage Google Spreadsheets from R
Description
Interact with Google Sheets from R.
Copy Link
Copy
Link to current version
Version
Version
0.3.0
0.2.2
0.2.1
0.2.0
0.1.0
Down Chevron
Install
install.packages('googlesheets')
Monthly Downloads
93
Version
0.1.0
License
MIT + file LICENSE
Issues
0
Pull Requests
0
Stars
781
Forks
192
Repository
https://github.com/jennybc/googlesheets
Maintainer
Jennifer Bryan
Last Published
July 5th, 2015
Functions in googlesheets (0.1.0)
Search functions
gdrive_POST
Make POST request to Google Drive API
construct_ws_feed_from_key
Construct a worksheets feed from a key
gs_grepdel
Delete several spreadsheets at once by title
googlesheet
Register a Google Sheet
gs_edit_cells
Edit cells
gs_download
Download a spreadsheet
gs_ls
List sheets a la Google Sheets home screen
gs_webapp_auth_url
Build URL for authentication
gs_new
Create a new spreadsheet
gdrive_GET
Make GET request to Google Drive API
gs_upload
Upload a file and convert it to a Google Sheet
get_google_token
Retrieve Google token from environment
extract_key_from_url
Extract sheet key from a URL
gs_inspect
Visual overview of populated cells
gs_copy
Copy an existing spreadsheet
cell-specification
Specify cells for reading or writing
gs_auth_suspend
Suspend authorization
gs_read_listfeed
Read data via the "list feed"
gs_perm_delete
Delete a permission from a spreadsheet
gs_delete
Delete a spreadsheet
print.googlesheet
Print info about a
googlesheet
object
construct_url_from_key
Construct a browser URL from a key
google_user
Retrieve Google user data
gs_read
Read data
gdrive_PUT
Make PUT request to Google Drive API
gs_perm_add
Add a permission to a spreadsheet
gs_add_row
Append a row to a spreadsheet
gs_auth
Authorize
googlesheets
gs_ws
Retrieve a worksheet-describing list from a
googlesheet
gs_read_csv
Read data via the
exportcsv
link
is_legit_token
Check that token appears to be legitimate
gs_ws_modify
Modify a worksheet's title or size
gs_perm_ls
List permissions for a spreadsheet
gs_webapp_get_token
Exchange authorization code for an access token
gs_ws_delete
Delete a worksheet from a spreadsheet
gs_ws_ls
List the worksheets in a spreadsheet
gs_ws_rename
Rename a worksheet within a spreadsheet
gs_ws_resize
Resize a worksheet
gs_simplify_cellfeed
Simplify data from the cell feed
googlesheets
googlesheets
package
gs_ws_new
Add a new worksheet within a spreadsheet
gsheets_POST
Create POST request
gsheets_GET
Create GET request
gs_read_cellfeed
Read data from cells
gs_perm_edit
Edit an existing permission
gs_reshape_cellfeed
Reshape data from the "cell feed"
gsheets_DELETE
Create DELETE request
example-sheets
Examples of Google Sheets
gsheets_PUT
Create PUT request
gs_user
Retrieve information about authorized user
token_exists
Check if authorization currently in force