Script Editor, Deploy as Web App, like Google Sheets?

Does Smarsheet have the following capabilities?

Script Editor mode to create Custom Functions, like the Script Editor in Google Sheets:

https://developers.google.com/apps-script/guides/sheets/functions
Deploy as Web App: https://developers.google.com/apps-script/guides/web

I'm looking to do something similar to the project described here: https://community.broadcom.com/enterprisesoftware/blogs/davidledeaux/2019/05/29/parsing-webhooks

Find more posts tagged with

API and Developers

Comments

KevinFansler

I'll start with the larger question. Yes, you can build integrations using a combination of Smartsheet API and webhooks. Here are some specific pointers to help you get started:

Integration: https://smartsheet-platform.github.io/api-docs/#third-party-app-development

Webhooks: https://smartsheet-platform.github.io/api-docs/#webhooks

You can also work with formulas: https://smartsheet-platform.github.io/api-docs/#cross-sheet-references

KevinFansler

We also have SDKs if you prefer to use a familiar language to do this (C#, Java, Node.js, Python, or Ruby) or you can work with cURL and a cURL Editor. Each of those SDKs also has a simple sample app to help you get started.

https://smartsheet-platform.github.io/api-docs/#sdks-and-sample-code

Matt Seitz

Thanks, but that's not what I'm looking for.

What I like about the Google Sheets-Rally connector I mentioned is that I don't have to set up my own server to host the connector code. Everything is done within Google Sheets and Rally.

Sign in to join the conversation!

Quick Links

Trending discussions

Webhook not getting event callback
Hi all, I have been using webhooks in my nodejs application for awhile and sometime I think my webhook is not receiving the event callback. In my sheet I have a column A, (not editable directly) which is a formula that's calculated using column B. When an user updates column B, column A gets updated which triggers the…
Potential reasons why my trigger is not resulting an event during run log (Bridge)
I've completed the authentication process, created a trigger and made sure that the trigger has the right source sheet and event type but I am noticing that I can't get any data from the trigger. My goal is to get the row information when new row is added in my sheet so I can copy some of the data over to another sheet.…
Trying to create a new sheet in a Workspace is throwing an unexpected exception C# SDK
I am trying to create a new Sheet in a specific Workspace using the Smartsheet SDK for C# and I keep getting an unexpected exception The statement above compiles just fine. The Workspace ID (wkspID in the code) is correct. I can create the Sheet just fine locally but the sheet does not have an ID until it is created in…