How to use OpenAI's ChatGPT for content redaction

About Rows

Rows is the easiest way to import, transform, and share data in a spreadsheet. It combines a spreadsheet editor, +50 integrations with the tools you use every day, a powerful AI Analyst✨, and a sharing experience to instantly turn any spreadsheet into a web app, a form, or a dashboard.

Connect the OpenAI integration

To connect the integration, open a new spreadsheet, and select the OpenAI integration on the welcome side panel. Alternatively, you can search for the integration inside the Data actions panel.

Rows offers three proprietary functions specifically designed for content redaction tasks: SUMMARIZE_OPENAI, REWRITE_OPENAI, and TRANSLATE_OPENAI.

Let's start with the first: inside the actions panel, search for "Summarize" and select the action.

Finally, Connect the integration to get started.

The Free plan includes 20 free uses of the OpenAI integration. Users on the Plus or Pro plans have unlimited access to OpenAI and can use their API key to access any OpenAI model, including fined-tuned models. By default, the OpenAI integrations use the "gpt-3.5-turbo" model.

Use the Summarize action

Once the integration is connected, you can start using OpenAI in Rows to summarize any piece of text.

Alternatively, you can use the Summarize function directly in the spreadsheet. Type =SUMMARIZE to see the autocomplete.

All OpenAI functions need to be configured through mandatory and optional parameters, depending on their purpose. Let's go through them.

Text

The Summarize function requires 'text' as the first parameter. This is simply the text you want to summarize.

As shown in the above screens, you can write the text directly inside the 'text' field in the action wizard, or reference any cell in the table by pointing to it on the editor, as follows:

Style

The second argument includes the 'style' you want to adopt to summarize the text. You can refer directly to the desired output, such as 'bullet point' or 'one-liner'.

The remaining parameters are all optional and commonly used for advanced use cases. Learn more about them in the Summarize function documentation.

Use the Rewrite action

The REWRITE_OPENAI function has been designed specifically to rewrite pieces of text. You can use it to make your texts sound better or adopt a specific writing style. It works with two arguments.

Text

The 'text' you want to rewrite. As for the Summarize function, you can write the text directly inside the 'text' field in the action wizard, or reference any cell in the table by pointing to it on the editor.

Instructions

The instructions you want the function to follow to rewrite the text. For example: 'use Gen-Z slang', 'use Shakespearean style', or 'make it sound more professional'.

The remaining parameters are all optional and commonly used for advanced use cases. Learn more about them in the Rewrite function documentation.

Use the Translate action

The TRANSLATE_OPENAI function has been designed specifically to translate pieces of text from and into any language. It works with two arguments.

Text

The 'text' you want to translate.

Language

The destination 'language', is the language you want to translate your text into.

The remaining parameters are all optional and commonly used for advanced use cases. Learn more about them in the Translate function documentation.

Examples

There are several ways to use OpenAI for content redaction:

• Summarize product reviews into bullet points Take a list of product reviews and summarize them into bullet points, to spot key action points
• Summarize sales replies into one liner Summarize sales replies into one-liner, and speed up prospects screening
• Rewrite text Rewrite any piece of text according to user-defined instructions
• Translate customer reviews Translate customer reviews from any language

Summarize product reviews from customers

Goal:

Summarize the product review into two bullet points.

Example:

1=SUMMARIZE_OPENAI(A2,"two bullet points")

Details:

• The function assumes that A2 contains the product review to be summarized
• Add the style of the summary as the second parameter, e.g. "two bullet points", or "one-liner"

Summarize sales replies

Goal:

Summarize sales replies from customers to immediately spot the highlights behind a deal negotiation.

Example:

1=SUMMARIZE_OPENAI(A2,"one-liner")

Details:

• The function assumes that A2 contains the email to be summarized
• Add the style of the summary as the second parameter, e.g. "two bullet points", or "one-liner"

Rewrite a text

Goal:

Rewrite a text to make it sound more native or change its style.

Example:

1=REWRITE_OPENAI(A2,"add emoji")

Details:

• The function assumes that A2 contains the text to be rewritten
• Add the instructions for the rewrite as the second parameter, e.g. "add emoji", or "speak like Shakespeare"

Translate product reviews from customers

Goal

Translate product reviews done by customers in third-party platforms - e.g. App Store, Trustpilot - to English.

Example

1=TRANSLATE_OPENAI(A2,"english",1)

Details:

• The function assumes that A2 contains the product review text
• Sets a temperature of 1, to help the engine recognize nuances and idiomatic expressions