Usage metrics

Hi Smartsheet community,

I am trying to create an app that fetches usage statistics/metrics for a given smartsheet account (like number of sheets or items created, edited, opened, etc), but couldn't find any API which could do the same. Webhooks is one way (not exactly), but that also we can create per sheet (not all the sheets/items under one account). Is there something available which can serve the purpose?

Find more posts tagged with

API and Developers

Product Development

Comments

Mike L.

You can get some minor metrics from power BI web app (just load the Smartsheet app) includes #worksheets/reports/sheet/templates. Some of the data might be useful but it is not nearly the level of detail you're looking for.

amitk

There are some APIs to get the list of sheets under a my account, however that requires a READ_SHEETS access. This pretty much allows me read the contents of the sheet. What I am looking for is the stats part of usage, sort of AUDIT_SHEETS type of access which can tell me if any change happened to the sheet (opened/edited/deleted). Another possibility is having a AUDIT_USER access which gives me access (any probably some APIs for the same) to see if any sheet is created, edited, opened or deleted under a account from last X amount of time. This will serve my purpose exactly.

amitk

thanks for the reply Mike. This wont exactly serve my purpose though.

Sign in to join the conversation!

Quick Links

Trending discussions

Does a view-only user need a license to use the API?
Hello everyone, I will need to use Smartsheet API to ingest data from Smartsheet to an object storage. To do that, my client will create a view only account for me. If I understand correctly, to use the API the account needs to be licensed, so we will need to pay for this "service account". That is correct?
Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
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…