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

Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Smartsheet API Bug: Copy Sheet with include=forms Fails (Regression)
Hello Support Team, We are experiencing an issue with the Smartsheet Copy Sheet API when attempting to include forms. Endpoint: POST https://api.smartsheet.com/2.0/sheets/1097094865571716/copy?include=forms Request Body: { "destinationType": "folder", "destinationId": 608151415351172, "newName": "new_sheet_included_Forms"…
Issue with Searching a sheet with more than 10k rows
Hello, I am using the Smartsheet Search rows module in make : I am querying a sheet with 18k rows If i search for data in the first 10k rows it find is. if its after that, it doesnt find it. please help Kind Regards, Wesley.