Learn R Programming
⚠️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

Version

Install

install.packages('googlesheets')

Monthly Downloads

46

Version

0.1.0

License

MIT + file LICENSE

Issues

0

Pull Requests

0

Stars

784

Forks

189

Maintainer

Jennifer Bryan

Last Published

July 5th, 2015

Functions in googlesheets (0.1.0)

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