Welcome!

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

Form automation - API
I'm looking to develop a solution for copying forms from one sheet to another, based on matching fields in the forms. I am having difficulty, however in getting forms to appear as an attribute or an associated object to a sheet. What is the correct way to use the API for listing/discovering the forms associated with a…
Getting a 403 Forbidden message when copying a folder endpoint
Hi I am getting a 403 forbidden status when trying to use the endpoint to copy one folder to another. This has worked previously and I can access other endpoints of the API.
Batch add/update time entries?
We are trying to update all users’ timesheets programmatically, which will involve tens of thousands of records in total. According to the Resource Management API documentation, time entries can only be updated one at a time. Is there a way to batch update multiple records at once? If I’m not mistaken, the API rate limit…