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

Matt Seitz · 06/25/19

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

KevinFansler · 06/27/19

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 · 06/27/19

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 · 06/27/19

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.

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

Comments

Categories