Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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
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
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?
I am looking forward to a package that can link smartsheet and R.
Cheers,
At least for reading data from Smartsheet into R I use the jdbc driver from cdata. It's not free though.
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")
Any progress on something like this?
I found this package on GitHub, but have not tried using it yet:
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.
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!
Hi Builders, You’ve been asking versions of the same question in this community: when do I use Smart Assist, when an automation, when MCP, and when plain API code? 🤔 So we’re starting a new series, the Smartsheet Builders Series: Building with Smartsheet MCP and Agents, and the first post tackles exactly that. 📖 Smart…
Tell us the one Smartsheet API that would save you the most manual work or workarounds. One word is enough. If you’d like, add what you’re trying to do and how you handle it today. Your answers go straight into deciding what we build next.
Restructuring sheets with tighter dropdowns and clearer naming is key. Why? Because ambiguous column names and free-text status fields that a person reads as fine can produce inconsistent agent behaviour. It’s worth unpacking, because the reason is not that the agent is worse at reading than you are. It is that you bring…
