Links

Smartsheets

Connect to Smartsheets

1. Go to the Resources page and click the
button.
2. Select Smartsheets.
3. Enter your account credentials and click Connect.
  • Access Token: Follow the instructions below to generate API Key.
  1. 1.
    Go to Account (top-right icon)
  2. 2.
    Navigate to Apps & Integrations > API Access
  3. 3.
    Generate a new access token
  4. 4.
    Copy the access token
  • Sheet ID: Spreadsheet ID. Find it by opening the spreadsheet then navigating to File > Properties
  • Start Date: Retrieve data after this date. The date should be ISO 8601 date and time in the format of 2000-01-01T13:00:00.
4. Choose tables to import and click Finish Setup.
5. You will see a
icon next to your resource. It may take a few minutes to several hours depending on the data size and the number of your tables. Once your data is ready, you will receive a notification email.