Insights Data

Connect a spreadsheet, a SQLite file or an integration such as Google Sheets, and let the AI turn it into a data source.

A data source is a database that your pages read from. Insights › Data lists them all. Some are managed by Threaded. The rest are files and integrations you connect.

#Who can use it

  • Owners, Editors and View All members see Data. Operators don’t.
  • Only Editors and Owners can connect, upload or run a source.

#Sources managed by Threaded

The list starts with sources Threaded keeps up to date for you:

  • Threaded Data: your organization’s platform data.
  • Threaded Forms: your forms and their responses.

They show Managed by Threaded. Click Create to build one the first time, or Rebuild to refresh it.

#Connect a source

Click Add data source. Choose one of two options.

#Upload a file

Drop a spreadsheet (.xlsx or .csv, up to 25 MB) or a SQLite file (.db or .sqlite).

  • Spreadsheet: Threaded uploads and inspects it, then opens the AI panel with the file attached. The AI builds a data source from it and asks you questions if it needs to. Spreadsheet imports need the AI assistant.
  • SQLite file: enter a Title and Description and click Create. No AI is needed.

#Connect an integration

Use this to pull data from another system with a saved credential.

  1. Choose a provider, such as Google Sheets, and click Next.
  2. Choose a saved credential or add a new one. Credentials are saved to the credential vault, not to the chat.
  3. Under Configure data source, enter a Title, a Description and the provider’s settings. For Google Sheets, that’s the Spreadsheet ID (you can paste the sheet’s URL) and, optionally, Tab names.
  4. Click Create. The AI panel opens and the AI finishes connecting the source.

Connecting an integration needs the Integrations add-on and the AI assistant. Owners manage credentials in Admin › Integrations.

#A data source’s page

Click a source to open it.

  • Preview opens the data in your browser. Pick a table from Schema, or write SQL and click Run.
  • Download saves the data.
  • Upload new version replaces a file source’s data.
  • Run integration pulls fresh data from an integration. It is turned off until the AI has finished connecting the source. An integration source can also run on a Schedule.
  • Linked reports lists the pages that use this source.
  • Version history lists each upload of a file source.

To refresh a source, upload a new version, run its integration, or rebuild a managed source. There is no separate refresh button.

A source can also be built from other sources, such as a metrics table computed from a raw export. See Derived Data Sources.

Run’s work orders and records aren’t in Threaded Data yet. To report on them, read them from the API. See What Run Exposes.