> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt

# Linking Smartsheet as a source

Canonical URL: https://posthog.com/docs/data-pipelines/sources/smartsheet

> **Cloud region:** This page uses US Cloud hosts. For an EU Cloud project, use `https://eu.posthog.com` instead of `https://app.posthog.com` (app host for links).

## On this page

- [Adding a data source](#adding-a-data-source)
- [Available tables](#available-tables)
- [Configuration](#configuration)
- [Supported tables](#supported-tables)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

`npx @posthog/wizard warehouse`

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

![](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)Let AI connect your sources for you

Enter your Smartsheet API access token to pull your Smartsheet data into the PostHog data warehouse.

## Adding a data source

1.  Go to the [sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section in PostHog.
2.  Click **\+ New source** and then click **Link** next to Smartsheet.
3.  Generate a personal access token under **Personal Settings → API Access** in your [Smartsheet account](https://app.smartsheet.com). The token inherits your account's read access. The `users` and `events` tables require a system administrator account, and `events` also requires the Event Reporting add-on.
4.  Back in PostHog, paste the token in the `Access token` field and click **Next**.
5.  Select the tables you want to sync, set the sync method and frequency, then click **Import**.

Once the syncs are complete, you can start using Smartsheet data in PostHog.

## Available tables

| Table | Description | Sync method |
| --- | --- | --- |
| `sheets` | Sheets in your account | Full refresh |
| `reports` | Reports in your account | Full refresh |
| `workspaces` | Workspaces in your account | Full refresh |
| `users` | Users in your account (requires a system administrator account) | Full refresh |
| `contacts` | Contacts in your account | Full refresh |
| `templates` | Templates in your account | Full refresh |
| `sheet_rows` | Row data with cells for each sheet (join cell `columnId` to `sheet_columns`) | Incremental |
| `sheet_columns` | Column definitions for each sheet | Full refresh |
| `events` | Organization activity stream (requires system administrator and Event Reporting add-on) | Incremental |
| `groups` | Groups in your organization | Full refresh |
| `group_members` | Members of each group | Full refresh |

**Incremental** tables sync only new or updated records on each run. **Full refresh** tables reload all data on each sync.

## Configuration

| Option | Type | Required |
| --- | --- | --- |
| `Access token` | password | Yes |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `sheets` | Metadata for a sheet the account can access (the grid where rows and columns of data live). | Full refresh | — | — |
| `reports` | Metadata for a report — a filtered, cross-sheet view of rows the account can access. | Full refresh | — | — |
| `workspaces` | Metadata for a workspace — a container that groups sheets, reports, and dashboards. | Full refresh | — | — |
| `users` | A user in the Smartsheet organization (requires a system administrator account). | Full refresh | — | — |
| `contacts` | A contact in the account's personal contact list, usable when assigning rows. | Full refresh | — | — |
| `templates` | Metadata for a template the account can use to create new sheets. | Full refresh | — | — |
| `report_columns` | A column in a report — one per report the account can access, fanned out across every report. | Full refresh | — | — |
| `report_scope` | The scope of a report — its source sheets and source workspaces, fanned out across every report. | Full refresh | — | — |
| `sheet_rows` | A row of a sheet, with its cells — fanned out across every sheet the account can access. | Incremental, Full refresh | modifiedAt | — |
| `sheet_columns` | A column of a sheet — fanned out across every sheet the account can access. Resolves the columnId of each cell in sheet\_rows. | Full refresh | — | — |
| `events` | An event in the organization's activity stream — an action a user or system took on a Smartsheet object. | Incremental, Full refresh | eventTimestamp | — |
| `groups` | A group in the organization account. | Full refresh | — | — |
| `group_members` | A member of a group — fanned out across every group in the organization account. | Full refresh | — | — |