How to use OpenAI's ChatGPT for SEO

How to use OpenAI in Rows

Connecting the OpenAI integration in Rows

You can find the OpenAI integration by browsing the integrations gallery and searching for "OpenAI".

To connect the integration and use the power of AI inside Rows all you need is an API Key. You can get your API key by going to the View API Keys option on your OpenAI account. If you don't have an account yet, sign-up here. All free accounts have API access.

Now simply copy the API key, go to the OpenAI integration page, press Connect, paste it and click Connect. Your Rows workspace is now connected to your OpenAI account and you're ready to go.

Using the OpenAI functions

The OpenAI integration comes with five proprietary functions that automate prompts to address specific types of tasks:

• ASK_OPENAI(), which aims at leveraging the power of GPT to solve general tasks.
• CREATE_LIST_OPENAI(), which is designed specifically to create tables and list of dummy data, for testing purposes.
• CLASSIFY_OPENAI(), which is designed specifically to classify texts into a given set of tags.
• TRANSLATE_OPENAI(), which translates texts from/into a wide range of languages.
• APPLY_TASK_OPENAI(), which is designed specifically to clean up or apply logic rules to data.

You can use them via the Autocomplete in the editor,

or via the Actions wizard:

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

Prompt

The prompt is the instruction to give to the model in our most generic function ASK_OPENAI(). This is where you'll enter the "ask" you want the AI to answer. You can use the prompt to solve a task by explicitly writing it in prose. Example:

1=ASK_OPENAI("Generate 100-word paragraph about the latest iPhone release")

Temperature (optional)

The temperature is common to all functions and is used to fine tune the sampling temperature, varying between 0 and 1. Use 1 for creative applications, and 0 for well-defined straight answers.

If you're doing tasks that require a factual answer (e.g. country populations, capitalize text), then 0 (the default) is a better fit. If you're using the AI for tasks where there aren't definite answers - such as generating text, summarizing text, or translating - then experiment with a higher temperature, which allows the engine to better capture text nuances and idiomatic expressions.

Max_tokens (optional)

This max_tokens represents the maximum number of tokens to generate in the completion. It's present in all OpenAI functions. You can think of tokens as pieces of words. Here are a few helpful rules of thumb examples from the OpenAI Help center:

• 1 token ~= 4 chars in English
• 1 token ~= 3/4 words
• 100 tokens ~= 75 words
• 1-2 sentences ~= 30 tokens
• 1 paragraph ~= 100 tokens
• 1,500 words ~= 2048 tokens

You can use any number starting with 0. The default value is 200. Most models have a context length of 2048 tokens, except for the newest models which support a maximum of 4096. For tasks that require more text output - text generation/summarization/translation - pick a higher value (e.g. 250).

Model (optional)

The AI model to use to generate the answer. It can be chosen in both functions, and by default, it uses "gpt-3.5-turbo". Below you find a list of all of the available GPT-3.5 models:

Number of items (optional)

The number of items is available only in the CREATE_LIST_OPENAI() function, and represents the expected number of items in the list.

1=CREATE_LIST_OPENAI("Full names and email address",5,,500)

Tags and multi-tag (optional)

The tags and multi-tag properties are available only in the CLASSIFY_OPENAI() function. The first is mandatory and represents the categories you want your text to be classified into.

For example, if you need to classify a list of product reviews in column A, into positive, neutral, negative and very negative, you just need to input those tags separated by a coma, as follows:

1=CLASSIFY_OPENAI(A2, "positive, neutral, negative, very negative")

The second is optional and can be "true" (default) or "false". If true, the function can use more than one tag to classify your text. If false, it will only use one tag. Use false when you need a mutually exclusive strict categorization.

Language

The language is available only in the TRANSLATE_OPENAI() function, and indicates the destination language for your translation tasks. Use the function as follows:

1=TRANSLATE_OPENAI(B1,"hebrew")

Task and text

The task and text are available only in the APPLY_TASK_OPENAI() function, and are used to specify the logic rule to some text.

For example, if you need to capitalize a string of text, use the function as follows:

1=APPLY_TASK_OPENAI("Capitalize all letters", "i HavE a doG")

Examples of OpenAI functions for SEO

There are several ways to use OpenAI to automate SEO tasks inside a spreadsheet:

• Generate keywords: Generate keyword ideas based on a topic.
• Generate blog post titles: Create a list of ideas for blog post titles based on the topic of the post.
• Generate the outline of a blog post: Create the rough outline for a blog post based on its title.
• Generate meta descriptions: Generate the meta description for a blog post based on its title.
• Translate keywords: Translate a list of keywords to several languages to capture traffic in multiple geographies.

Let's go through each of them.

Generate keywords

Goal: Generate keyword ideas based on a topic. Create separate lists for Informational., Transactional, Navigational and Commercial keywords.

Example:

1=ASK_OPENAI(CONCATENATE("Generate a list of 10 Informational keywords based on the topic of: ",A2))

Add new columns to the spreadsheet for different keyword types.

Details: Assumes that A2 contains the topic.

💡 To have the list of keywords in a new table, use the CREATE_LIST_OPENAI() function from the Actions menu. Input the prompt 'Generate a list of Informational keywords based on the topic of Vegan dog food'.

Then specify the number of items you expect, here 10. Set a temperature of 1, to allow for creative responses, and max_tokens of 500.

Set a temperature of 1, to allow for creative responses, and max_tokens of 500. Once the function has been configured, click on Next step and your table will appear below.

Generate blog post titles

Goal: Create a list of ideas for blog post titles based on the topic of the post.

Example:

Use the CREATE_LIST_OPENAI() function from the Actions menu. Input the prompt 'Generate a list of blog post titles ideas based on the topic of Vegan dog food'.

Then specify the number of items you expect, here 10. Set a temperature of 1, to allow for creative responses, and max_tokens of 500.

Once the function has been configured, click on Next step and your table will appear below.

Generate the outline of a blog post

Goal: Create the rough outline for a blog post based on its title.

Example:

1=ASK_OPENAI(CONCATENATE("Generate the outline of a blogpost titled: ",A2))

Details: Assumes that A2 contains the title of the post.

Experiment with generating several outlines for the same topic. The model is likely to respond with different variations and give you more inspiration before putting your pencil down and starting writing.

Note: Generating blog outlines work well for cases where the content of the blog post does not need specific details about a company or product. For cases such as writing case studies or feature launch blog posts, try adding more content in the prompt and giving it a bullet point summary of the details you want to cover in the post.

Generate meta descriptions

Goal: Generate the meta description for a blog post based on its title.

Example:

1=ASK_OPENAI(CONCATENATE("Generate a meta description for a post titled: ",A2))

Details: Assumes that A2 contains the title of the post.

Translate keywords

Goal: Translate a list of keywords to several languages to capture traffic in multiple geographies.

Example:

1=TRANSLATE_OPENAI(A2,"Spanish",1,200)

Add new columns with the languages you want to translate to. In this example, we added additional columns for Japanese and Arabic.

Details:

• Assumes that A2 contains the keyword.
• Set a temperature of 1, to account for language nuances and idiomatic expressions
• Set max_tokens high enough to translate longer sentences.