Interpret Workflow: Generate Program from Custom Sheets

Snaptrude now supports a powerful new AI-assisted workflow called Interpret, which allows you to auto-generate a structured Program Data Sheet directly from your custom sheets—all within Program Mode.

With a simple command and a cell selection, the AI assistant intelligently extracts space names, areas, counts, departments, and other metadata from your input and converts it into usable program data in seconds.

What is Interpret?

Interpret is a smart command within Program Mode that reads your selected table data and converts it into structured space and department data, which is then added to your Program Data Sheet.

Whether your data lives across multiple tabs, contains complex metadata, or has multi-building hierarchies, Interpret helps streamline the process—no manual entry needed.

How to Use the Interpret Command

1. Prepare Your Data

Open the Program Mode.
Copy paste your custom program sheet that contains space-related information onto a new sheet in the Program mode
Ensure your table includes column headers for better accuracy (e.g., Space Name, Area, Count, Department, etc.)

2. Select the Data

Manually select the relevant range of cells you want the AI to interpret.

Note: Interpret will only work on the currently selected cells at the time you run the command.

3. Trigger the Command

In the AI prompt chatbox, type @Interpret, or click on the suggestion when it appears.
Add an optional structured prompt for improved accuracy (see examples below).
Hit the arrow key — the assistant will start processing the program then.

Sample Prompts:

You can run @Interpret with or without a structured prompt. However, structured prompts provide better control and accuracy. Here are some examples:

Use Case	Sample Prompt
Basic interpretation with headers	`@Interpret`
Specify column mappings	`@Interpret Create spaces using “Title A” as space label, “Title C” as area, “Title D” as count.`
Include custom metadata	`@Interpret Create spaces using “Title A” as space label, “Title C” as area, “Title D” as count. Add “Category” and “Code” as metadata.`
Combine columns for labels	`@Interpret Create spaces using combination of “Title A” + “Title B” as space label, “Title C” as area, “Title D” as count.`
Create only department objects	`@Interpret Create spaces using “Title A” as space label and department name, “Title B” as area, “Title C” as count.`

4. See the Output

While the command runs, a 'Reading program', 'Processing program' and 'Creating program' message appears.
Once complete, you’ll see a 'Complete' message along with an explanation of how the data was interpreted.
The resulting spaces and departments are added to your Program Data Sheet.

Pro-tip: After generating the program, you can continue using @Interpret to update or expand the data. For example, if you want to edit spaces within a specific department, open the copied sheet, select the relevant columns or rows, and run @Interpret again with your updated instructions.

Best Practices

Always select the data range before triggering @Interpret.
Include header rows in your selection — improves accuracy.
Use clear, structured prompts for complex sheets.
Avoid vague prompts or selecting the entire sheet (Ctrl+A) — this may fail or reduce accuracy.

Key Features

Works within Program Mode on any custom sheet.
Supports multiple tabs — new spaces are appended to the Program Data Sheet.
Imports extra columns as metadata automatically.
Handles complex structures like multi-specialty departments and flipped row-column formats.
Repeatable — you can use @Interpret multiple times across sheets.

Additional Notes:

Tested on sheets with up to 250 rows / 1400+ cells
Typical processing time: under 2–3 minutes
Better accuracy with well-labeled columns and structured prompts

Known Limitations

Limitation	Details
Max space count	Can interpret up to 1500 spaces in one go
Select All not supported	Avoid `Ctrl+A` or selecting the whole sheet
No re-prompting support yet	Re-running prompt will create duplicates
No preview or cell review	Once run, selection can’t be modified

Import Program Data

Direct Program Entry

About Program Mode

AI Program Creator Guide

Creating a New Program