The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

smartsheetr

R-CMD-check

smartsheetr is an extensible smartsheet API client. It utilizes the API to push/pull data frames as smartsheet documents.

Installation

You can install the released version of smartsheetr from CRAN with:

install.packages("smartsheetr")

You can install the development version of smartsheetr from GitHub with:

# install.packages("devtools")
devtools::install_github("cole-johanson/smartsheetr")

You will also need to generate a smartsheet API key and then add it as a global environment variable:

Sys.setenv("SMARTSHEET_API_TOKEN" = <your token>)

Example

Upload a sample data frame, and read it back into R:

ss_mtcars_resp = smartsheetr::ss_write_sheet("mtcars", mtcars)
ss_mtcars_sheetid = smartsheetr::ss_sheetid(ss_mtcars_resp)
smartsheetr::ss_list_sheets() |> dplyr::filter(name == 'mtcars')
#>                 id   name accessLevel
#> 1 4018535999164292 mtcars       OWNER
#>                                                                    permalink
#> 1 https://app.smartsheet.com/sheets/47v6g7p3hGCg9CV4gQRJrF3fmPGwxjhQJ8r92rP1
#>              createdAt           modifiedAt
#> 1 2023-10-25T21:39:59Z 2023-10-25T21:39:59Z
smartsheetr::ss_read_sheet(ss_mtcars_sheetid)
#> # A tibble: 32 × 11
#>      mpg   cyl  disp    hp  drat    wt  qsec    vs    am  gear  carb
#>    <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
#>  1  21       6  160    110  3.9   2.62  16.5     0     1     4     4
#>  2  21       6  160    110  3.9   2.88  17.0     0     1     4     4
#>  3  22.8     4  108     93  3.85  2.32  18.6     1     1     4     1
#>  4  21.4     6  258    110  3.08  3.22  19.4     1     0     3     1
#>  5  18.7     8  360    175  3.15  3.44  17.0     0     0     3     2
#>  6  18.1     6  225    105  2.76  3.46  20.2     1     0     3     1
#>  7  14.3     8  360    245  3.21  3.57  15.8     0     0     3     4
#>  8  24.4     4  147.    62  3.69  3.19  20       1     0     4     2
#>  9  22.8     4  141.    95  3.92  3.15  22.9     1     0     4     2
#> 10  19.2     6  168.   123  3.92  3.44  18.3     1     0     4     4
#> # ℹ 22 more rows

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.