Skip to content
GPTSheetsPlus

Getting started

How to use GPTSheet Plus

Overview

GPTSheet Plus is a Google Sheets add-on that allows you to leverage the power of AI directly within your spreadsheets. With a few simple functions, you can extract information, summarize text, list items, and more using GPT, Perplexity, and Firecrawl APIs.

Getting Started

Activation and API Keys

Before you can use GPTSheet Plus functions, you need to activate your license and insert the necessary API keys.

  1. Activate License

    • Go to GPTSheetsPlus in the menu.
    • Click Activate License (Only $49 for Lifetime!).
    • Enter your license key. If you don’t have one, visit our store to purchase.

  2. Insert API Keys

    • Go to GPTSheetsPlus in the menu.
    • Click Insert GPT API Key to enter your OpenAI API key.
    • Click Insert Perplexity API Key to enter your Perplexity API key.
    • Click Insert Firecrawl API Key to enter your Firecrawl API key.

Video Guide

You can take a look at our setup guide on Youtube

Functions

GPT

The GPT function generates a response from the OpenAI GPT 4 API based on a given prompt and an optional system prompt.

Usage:

=GPT("your prompt here", "your system prompt here (optional)")

  • prompt: Your prompt.
  • system prompt: System prompt (optional)

EXTRACT_INFO

The EXTRACT_INFO(text, what_to_extract, format: optional) function extracts specific information from a given text.

Example:

=EXTRACT_INFO(A1, "year", "number")

  • A1: Cell containing the text.
  • ”year”: We’d like to extract the “year” from all the text (the text contains a year that we’d like to extract).
  • “number”: The format of the extracted information, which is in the form of “number” for “year” (optional).

SUMMARIZE_BULLET

The SUMMARIZE_BULLET function summarizes a given text into bullet points.

Example:

=SUMMARIZE_BULLET(A1)

  • A1: Cell containing the text.

SUMMARIZE_BULLETS

The SUMMARIZE_BULLETS function summarizes a given text into bullet points.

Usage:

=SUMMARIZE_BULLETS(A1)

  • A1: Cell containing the text.

LIST_STUFF

The LIST_STUFF function generates a list of items or ideas based on a given noun and number.

Usage:

=LIST_STUFF("actors", 5)

  • ”actors”: The noun to generate the list for.
  • 5: The number of items to list (optional, default is 10).

PPLX

The PPLX function generates a response from the Perplexity API based on a given prompt and an optional system prompt.

Usage:

=PPLX("your prompt here", "your system prompt here")

Firecrawl

The Firecrawl function scrapes content from a given URL and converts it to markdown.

Usage:

=Firecrawl("https://example.com", 5)

  • ”https://example.com”: The URL to scrape content from.
  • 5: The wait time for the page to load (optional, default is 0).

SCRAPE

The SCRAPE function scrapes content from a given URL and converts it to markdown.

Usage:

=SCRAPE("https://example.com", 5)

  • ”https://example.com”: The URL to scrape content from.
  • 5: The wait time for the page to load (optional, default is 0).

Troubleshooting

  • License Activation: Ensure your license key is valid and correctly entered.
  • API Key Not Found: Make sure you have entered the correct API key in the respective menu options.
  • Function Errors: Check the inputs and format of the function you are using. Ensure all required parameters are provided.

For further assistance, visit our support page or contact us at [email protected]. I’m in GMT+7 timezone, so please wait for some time if it’s still night time in my time.