Skip to content

Getting started

How to use Web Scraping Kit for Google Sheets

Overview

Web Scraping Kit is a Google Sheets Extension that lets you scrape URLs into markdown & extract information from that, using Firecrawl for scraping and OpenAI for AI extraction. You only need to buy the license once for lifetime usage ($29), no subscription needed.

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

Getting Started

  1. Activate License (Buy $29 once for lifetime use): https://terrydjony.lemonsqueezy.com/buy/fc5e26ee-143a-43eb-a934-c5d3ee097db8
  2. To use =SCRAPE(url), insert Firecrawl API key (sign up using https://firecrawl.dev )
  3. To use =EXTRACT(text, data, type), insert OpenAI API Key