Skip to content
GPTSheetsPlus

Guide

Use Cases

With AI functions & URL Scraping, you can unlock many use cases, such as:

  1. Company research alt text
  • Use SCRAPE() in column C to get the content of the URL
  • Use EXTRACT_INFO() in column D to extract relevant information from column C, such as “deal size” in number format
  1. Product research alt text
  • Use PPLX() in column C to get the latest information of a product’s pricing in a certain market
  • Use EXTRACT_INFO() in column D to extract relevant information from column C, such as “pricing” in number format
  1. Getting a document link alt text
  • Use PPLX() in column C to get info on a link to a startup’s pitch deck
  • Use EXTRACT_INFO() in column D to extract relevant information from the text retrieved in column C, such as “pitch deck link” as hyperlink

Formulas

Here are formulas you can use in GPTSheetsPlus

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).

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).

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).

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.