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

Bridge Workflow Export
I have just recently found use cases where I needed Bridge. I created a sheet with unpivotted data. I have a love/hate relationship with the tool for now. I really like flexibility and power, what I don't like is how difficult it is to troubleshoot and in some ways manage the workflows. Seems to be some sensitive points…
Unable to connect to Smart sheet API using the Python sdk
raise HttpError(rex, "SSL handshake error, old CA bundle or old OpenSSL?") from rex smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]…
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…