Contents

Cancel

Recommended Articles

  1. unify-apps

    Indexing

    Unify AI

    Transform raw content into searchable knowledge through AI-powered indexing and vector embeddings

  2. unify-apps

    IMAP

    Unify Integrations

    Integrate your app with IMAP to enable seamless email synchronization, real-time access, and enhanced communication workflows.

  3. unify-apps

    Preview Your Work

    Unify Automations

    Effortlessly review & monitor your automation’s performance

  4. unify-apps

    QuickBooks

    Unify Integrations

    Integrate your app with QuickBooks to streamline accounting, automate invoicing, and manage finances effortlessly

  5. unify-apps

    FTP/FTPS

    Unify Integrations

    Connect your app with FTP/FTPS to automate secure file transfers and streamline data exchange across systems.

  6. unify-apps

    Snowflake

    Unify Automations

    Connect to Snowflake for fast, scalable cloud data warehousing and analytics

  7. unify-apps

    Button

    Unify Applications

    Create interactive elements with ease using buttons

  8. unify-apps

    BambooHR

    Unify Automations

    Integrate your app with BambooHR to streamline HR management, automate employee data processing, and enhance onboarding workflows

  9. unify-apps

    Build your first automation

    Unify Automations

    Learn how to build your automation step by step

  10. unify-apps

    User Management

    Unify Applications

    Efficiently manage user roles and permissions

  11. unify-apps

    Microsoft Teams

    Unify Automations

    Connect your app with Microsoft Teams to enhance communication, automate workflows, and foster collaboration across your organization

  12. unify-apps

    Jira

    Unify Automations

    Use Jira to plan, track, and manage your agile and software development projects

  13. unify-apps

    Pre Processing

    Unify AI

    Optimize query processing through intelligent rephrasing, retrieval, and ranking to deliver accurate AI responses

  14. unify-apps

    Google Calendar

    Unify Integrations

    Integrate your app with Google Calendar to streamline scheduling, automate event management, and improve team coordination

  15. unify-apps

    SAP HANA

    Unify Integrations

    Connect your app with SAP HANA to leverage in-memory computing for real-time data processing and advanced analytics at scale.

#
Unify Integrations
Logo
Smartsheet

Smartsheet

Logo

4 mins READ

Smartsheet is a cloud-based platform for work management and collaboration, enabling users to track projects, automate workflows, and visualise tasks in customizable sheets and dashboards. It combines spreadsheet functionality with powerful project management tools to streamline team coordination and productivity.

Connecting your application to Smartsheet enables integration for project management and collaboration features.

Authentication

Before you begin, make sure you have the following information:

  • Connection Name: Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings. It could be something descriptive like "MyAppSmartsheetIntegration"

  • Authentication Type:Select the type of authentication for connecting to your Smartsheet account:

    • Auth Token

    • OAuth

Token Based Authentication

  1. Log in to the Smartsheet Account.

  2. Click on the user icon at the bottom left corner.

    Image
    Image

  3. Select the Apps & integrations.

    Image
    Image

  4. In Personal Settings, navigate to API Access to verify the existing token. You can also refer to Apps for managing and viewing your tokens.

    Image
    Image

  5. In API Access choose Generate new access token .

  6. Once the Generate New Access Token option is selected, the user will be prompted to enter a name for the access token.

  7. Afterward, you will receive a popup displaying the access token. Copy this token and treat it with high confidentiality, as it allows access to your smartsheet account.

    Image
    Image

OAuth Based Authentication 

  1. Create a New OAuth Application: After selecting Create New App, enter the necessary details for your application:

    • App Name

    • App Description

    • App URL

    • App Contact/Support Information

    • App Redirect URL (for OAuth authentication)

    • Optionally, select the checkbox to Publish App if you want to make the app available publicly.

      Image
      Image
  2. Retrieve Client ID and Client Secret: Once the application is created, Smartsheet will provide a Client ID and Client Secret for your OAuth application. Keep these credentials secure, as they are required to authenticate users through OAuth.

    Image
    Image

Actions

Action

Description

Create a new row

Create a new row in smartsheet

Get report

Gets a report from smartsheet

Get row

Gets a row from smartsheet

Get sheet summary

Gets a sheet summary in smartsheet

List folders

List folders in smartsheet

List public templates

Lists public templates in smartsheet

List reports

List reports from smartsheet

List home contents

Lists home contents in smartsheet

List users

List users in smartsheet

Search sheet

Searches a sheet for the specified text in smartsheet

Update row in sheet

Update a row in a sheet in smartsheet

Triggers

Trigger

Description

On a new row

Triggers on a new row in smartsheet

On new or updated report in sheet

Triggers on a new or updated report row in smartsheet

On new or updated row in sheet

Triggers on a new or updated row in a sheet in smartsheet