AutomationAI

Text to JSON

Package a text input into a JSON output.

The Text to JSON feature packages a text input into a JSON (JavaScript Object Notation) output. This format is the most common way to store and work with data through APIs. You can also add instructions to guide the feature into creating the exact output you need for your workflow.

New to JSON? Check out our guide to APIs and JSON.

Adding the Text to JSON feature

1

Open the table where you want to use the Text to JSON column.

2

Add a new basic text column for the Input. The input can be any column that contains text, so if you’ve used another action or computed column to create a text result, you can also use that text result as the Input source.

  • New columns added with the plus button will always appear on the right. If you’d like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose Add column right. You can also click and drag columns to rearrange them.
3

Add a Text to JSON column to store the result. Search for ‘Text to JSON’ or navigate to AI → Text to JSON.

4

For Instructions, enter custom text to create more specificity for your prompt.

5

For Input, use the Input column created previously.

6

Note: If the action will be triggered in the Workflow Editor, then add a basic number Result column where the result will be stored.

7

Click on Done.

Frequently Asked Questions

The Text to JSON feature requires a paid plan. Browse our plans to find the right fit for you.

The Text to JSON feature will use one update every time it is triggered.