Node.js sample application that loads a sheet, updates selected cells, and saves the results
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.gitignore
LICENSE
README.md
Sample Sheet.xlsx Initial commit Apr 4, 2017
config.json
node-read-write-sheet.js

README.md

node-read-write-sheet

Node.js sample application that loads a sheet, updates selected cells, and saves the results

This is a minimal Smartsheet sample that demonstrates how to

  • Load a sheet
  • Loop through the rows
  • Check for rows that meet a criteria
  • Update cell values
  • Write the results back to the original sheet

This sample scans a sheet for rows where the value of the "Status" column is "Complete" and sets the "Remaining" column to zero. This is implemented in the evaluate_row_and_build_updates() method which you should modify to meet your needs.

Setup

  • Install the smartsheet library with npm install smartsheet at the command line

  • Update the config.json file with these two settings:

    • An API access token, obtained from the Smartsheet Account button, under Personal settings
  • Run the application using your preferred IDE or at the command line with node node-read-write-sheet.js

The rows marked "Complete" will have the "Remaining" value set to 0. (Note that you will have to refresh in the desktop application to see the changes)

See also