Sync Smartsheet rows with Field Nation work orders bidirectionally — dispatch field work from your sheet and receive real-time updates without manual entry.
The Field Nation Smartsheet connector links your Smartsheet workspace to Field Nation, keeping work orders and sheet rows synchronized between both platforms. When a row is ready for dispatch, the connector creates a work order in Field Nation automatically. When work progresses — status changes, messages posted, files uploaded — those updates flow back to your Smartsheet row in near real time.
Bidirectional sync
Smartsheet row changes create or update Field Nation work orders. Field Nation events push data back to your sheet rows.
What syncs
Work orders, row field values, messages/discussions, and attachments — mapped to any column type in your sheet.
Authentication
Smartsheet API Access Token. No OAuth flow required — generate directly from your Smartsheet account settings.
Webhook-driven inbound
Smartsheet webhooks notify Field Nation when rows change. Webhooks are created via the Smartsheet API (no UI option).
The connector sits between Field Nation and Smartsheet. Inbound sync is triggered by Smartsheet webhooks — when a row changes, the webhook fires and Field Nation fetches the row data. Outbound sync is event-driven — when a work order is created or updated in Field Nation, the connector writes changes back to the linked Smartsheet row.
Inbound (Smartsheet → Field Nation): A Smartsheet webhook fires when a row is added or updated. The connector receives the Sheet ID and Row ID, fetches the full row data from the Smartsheet API, applies your field mappings, and creates or updates the corresponding Field Nation work order.
Outbound (Field Nation → Smartsheet): When a Field Nation work order event fires (status change, message posted, attachment uploaded), the connector translates the work order data using your outbound mappings and writes it back to the linked Smartsheet row.
Scenario: Your team manages field service tasks in Smartsheet. When a row is ready for dispatch, you want a Field Nation work order created automatically without re-entering data.
Scenario: Your team needs real-time visibility into field work status directly inside Smartsheet without switching between platforms.
No manual updates required — all driven by Field Nation work order events.
Scenario: Your operations team wants end-to-end automation — rows in Smartsheet dispatch field work, and every new Field Nation work order also creates a corresponding row.
Enable Outbound Create in connector settings. With this on:
<SHEET_ID>-<ROW_ID> for all future sync events.This mode is best suited for teams where both platforms are active and need full parity.
| Data type | Inbound (SS → FN) | Outbound (FN → SS) | Notes |
|---|---|---|---|
| Work order / Row | Create, Update | Create, Update | Core sync — field mappings applied |
| Messages / Discussions | ✓ (comments → FN messages) | ✓ (FN messages → row discussions) | Controlled by messages service flag |
| Attachments | ✓ (row attachments → FN files) | ✓ (FN files → row attachments) | Controlled by attachments_import / attachments_export flags |
| Status | ✓ (column value → status) | ✓ (status → column value) | Via field mapping with array map action |
| Auto-dispatch | ✓ | — | Optional — auto-assigns provider on inbound create |
Attachment sync has a 29.9 MB file size limit for direct upload. Files larger than 29.9 MB are attached as URL links instead of embedded files. This is a Smartsheet API restriction.
The connector supports all standard Smartsheet column types. Each type is handled with appropriate serialization:
| Smartsheet column type | Mapped data type | Behavior |
|---|---|---|
| Text/Number | string | number | Direct value pass-through |
| Contact List | select | Mapped by email address |
| Multi Contact List | select | Comma-separated emails |
| Date | string | ISO date string |
| DateTime | string | ISO datetime string |
| Picklist (Dropdown) | select | Single value from options |
| Multi Picklist | select | Comma-separated values, stored as MULTI_PICKLIST object |
| Checkbox | boolean | Boolean — true/false |
| Duration | string | number | Numeric duration value |
| Predecessor | number | Row dependency reference |
Column limit: The connector supports sheets with up to 400 columns. Sheets exceeding this limit will fail during field refresh. This covers the vast majority of real-world sheets — Smartsheet's own maximum is 400 columns per sheet.
Generate an API Access Token, identify your Template Sheet ID, and (optionally) your Workspace ID. No OAuth flow — token generation takes under 2 minutes.
Log in to Field Nation as a Company Admin, navigate to Integrations → Field Services → Smartsheet, and enter your credentials. The connector validates the token and sheet access on save.
Click Refresh Fields to discover your sheet's columns. Then map Smartsheet columns to Field Nation work order fields for both inbound and outbound directions.
Create a webhook via the Smartsheet API that sends row change events to your Field Nation trigger URL. Enable the webhook to activate inbound sync.
Create or update a row in Smartsheet to verify inbound flow. Create a work order in Field Nation to verify outbound flow.
Complete the checks below before starting the Configuration steps.
Progress is saved in your browser. Run this checklist once per environment (sandbox then production).
Last updated on