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

Matt Seitz

Does Smarsheet have the following capabilities?

1. Script Editor mode to create Custom Functions, like the Script Editor in Google Sheets:
   
   https://developers.google.com/apps-script/guides/sheets/functions
2. 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

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.