How to use OpenAI's ChatGPT for SEO

Learn how to use OpenAI inside the spreadsheet to generate keywords, meta descriptions and other SEO activities.

OpenAI Template

There's a near-infinite amount of tasks you can solve using OpenAI. Use this template showcase to get started with +10 pre-built examples.

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.

Product image

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.

Connect OpenAI

Inside the Data Actions panel, search for "Openai" and select one of the following actions.

openai actions

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.

Using the OpenAI actions

The OpenAI integration comes with fourteen proprietary actions that automate prompts to address specific types of tasks.

You can use them via the Autocomplete in the editor,

generic autocomplete openai

or via the Actions wizard:

general openai editor

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 meta descriptions: Generate the meta description for a blog post based on its title.
  • 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.
  • 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.

Example:

1=KEYWORDS_OPENAI(A2,5,"transactional")

Add new columns to the spreadsheet for different keyword types.

Details: Assumes that A2 contains the topic.

generate keywords

💡Change the type parameter to 'Informational' or 'Navigational' to generate keywords oriented to find more information or website promoting your product (e.g. additional features, original website, etc)

1=KEYWORDS_OPENAI(A2,5,"informational")

Generate keywords misspellings

Goal: Generate common misspellings based on a list of keywords.

Example:

1=KEYWORDS_MISSPELLING_OPENAI(A2)

Details:

  • Assumes that A2 contains the original keywords.

keywords misspelling

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.

Translate keywords

Generate meta descriptions

Goal: Generate the meta description for a page based on its title and keywords.

Example:

1=META_DESCRIPTION_OPENAI(A2,B2)

Details:

  • Assumes that A2 contains the title of the post.
  • Assumes that B2 contains the keywords to employ

generate meta desc

Generate blog post titles

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

Example:

1=AD_CONTENT_OPENAI(A2,"Blogpost title",3)

Details:

  • Assumes that A2 contains the topic of the post.
  • Use the 'type' argument to specify the type of content you want to generate: here a blog post title
  • Use the 'number' argument to specify how many alternatives you need, here 3

Blogpost title

Generate the outline of a blog post

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

Example:

1=AD_CONTENT_OPENAI(A2,"Outline for blogpost",1,,,,,400)

Details:

  • Assumes that A2 contains the title of the post.
  • Use the 'type' argument to specify the type of content you want to generate: here the outline for a blog post
  • Use the 'number' argument to specify how many alternatives you need, here 1
  • Set max_tokens to 400 to make sure the response is complete

Blog post outline