Overview

Smartsheet is an alternative to google sheet. So, you can get sheet data as JSON format without any coding or server setup.

Getting started

We are assuming that you already signup on nocodeapi.com. If not then first make an account there and activate Smartsheet API from Marketplace.

To make Smartsheet Hook API we need:

  • API Access token - Go to Personal Apps & integration -> API Access -> Generate new access token

Click on Create Smartsheet API button then put required values into form and click on Create button. 🎉 Done!

Endpoints

There are following endpoints for Smartsheet API:

  • List Sheets - Gets a list of all sheets that the user has access to in alphabetical order by name
  • Sheet Data - Returns the sheet, including rows, and optionally populated with discussion and attachment objects.

Video Tutorial

If you love video tutorial then we also have video tutorial for you.