Skip to content
WebScraperKit

Guide

Use Cases

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

  1. Company research
  • Use SCRAPE() in column C to get the content of the URL

alt text

  • Use EXTRACT() in column D to extract relevant information from column C, such as “deal size” in number format

alt text

Formulas

Here are formulas you can use in GPTSheetsPlus

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

EXTRACT

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

Example:

=EXTRACT(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).

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)

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

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.