nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

R package for Smartsheet

ceparman

HI,

Does anyone know of an R package for interacting with Smartsheet? Are there folks using R with Smartsheet?

I am considering a project using R and I might start building out a package.

Thanks

Craig

info@ngsanalytics.com

www.ngsanalytics.com

Find more posts tagged with

API and Developers

Product Development

Comments

Corinne Flanagan

Hi Craig!

I'm not aware of any specific instances of R package and Smartsheet integrations.

If you haven't already explored our Developer Portal, that resource is located here: https://developers.smartsheet.com

Github is another available resource that might be useful: https://github.com/

Thanks for posting in the Community!

Corinne

Jonas

Hi Craig,

It would be wonderful news if you do. It's very unfortunate that there is no ease of connecting with Smartsheet using R.

Hi Corinne,

Are there plans to create such an integration?

Thanks

shens7

Hi Craig,

I am looking forward to a package that can link smartsheet and R.

Cheers,

Beecher Adams

At least for reading data from Smartsheet into R I use the jdbc driver from cdata. It's not free though.

https://www.cdata.com/drivers/smartsheet/

This is some sample code:

library(RJDBC)

drv <- JDBC("cdata.jdbc.smartsheet.SmartsheetDriver","C:/Program Files/CData/CData JDBC Driver for Smartsheet 2016/lib/cdata.jdbc.smartsheet.jar")

conn <- dbConnect(drv, "jdbc:smartsheet:OAuthAccessToken=*** ;CallbackURL=http://localhost:33333;LogFile=C:\\SmartSheet.txt;Verb osit y=3")

df <- dbGetQuery(conn, "select * from Sheet_Name_xyz")

Dennis Knipfer

Any progress on something like this?

Andey Nunes

I found this package on GitHub, but have not tried using it yet:

https://github.com/elias-jhsph/rsmartsheet/blob/master/R/Smartsheet-R-sdk.R

docs: https://rdrr.io/github/elias-jhsph/rsmartsheet/

I am actively using R for analytics and looking forward to having a more reliable tool for accessing smartsheets with RMarkdown docs.

colej1390

I have created a small but extensible smartsheet API client library for R: https://github.com/cole-johanson/smartsheetr

I will be actively maintaining this, so please submit feedback/issues using https://github.com/cole-johanson/smartsheetr/issues. Thanks!

Sign in to join the conversation!

Quick Links

Trending discussions

500 Internal Server Error when accessing WorkApps
Hello- my co-worker is getting the Opps something went wrong error. Also know as a 500 internal server error when accessing workapps. Can you please help?
Reports API: Full CRUD Support Now Available
You can now create, read, update, and delete reports programmatically via the Smartsheet API. Reports are no longer UI-only — they're a first-class API resource, just like sheets. What's new The Reports API now supports the full object lifecycle: Create reports from API calls — no more manual setup in the UI Read report…
New Learning Series: "Mastering Smartsheet API" — Part 1 is live
Hey dev friends, We just kicked off a new hands-on learning series for the Smartsheet API Developer Ecosystem: Mastering Smartsheet API. From your first API call to production integrations and the new MCP Server for AI agents — this series covers the full path. Part 1, "Zero to API: Your First Successful Smartsheet…