SheetMagicSheetMagic

Scrape the web with a formula.

eBay sold prices, YouTube transcripts, LinkedIn company pages, Zillow comps, Airbnb rates, Amazon listings. One formula each, and the table spills into your sheet. 43 platform scrapers across 10 platforms, plus VISIT and CSS selectors for any other page. No code, no browser extension, no separate scraping account.

Install free for Google SheetsEvery source and its rate

Free includes 100 scraping credits, no card, no expiry. Every scraper works on every plan.

Platform scrapers

43formulas

Return instantly

13formulas

Google, Amazon and YouTube spill a table the moment you press enter.

Run in the background

30formulas

Social and business sources take up to about a minute and show a placeholder first.

Per row returned

1 to 84credits

Every rate is published. Cheap sources stay cheap.

What people scrape with it.

The data you used to copy by hand, refreshed by dragging a formula down.

  • E-commerce sellers

    Track competitor prices and Amazon rankings every morning.

    AMAZONSEARCH spills the top results for a keyword. AMAZONOFFERS shows every seller undercutting you. GSHOPPING catches the rest of the market.

    =AMAZONSEARCH("wireless earbuds", "US", "10001")

  • Outbound sales teams

    Turn a list of company URLs into a qualified lead sheet.

    LINKEDINCOMPANY pulls industry, headcount and HQ. CONTACTINFO finds emails and phones on the site. VALIDATEEMAIL cleans the list before it hits your sequencer.

    =LINKEDINCOMPANY(A2:A200)

  • Real estate investors

    Run comps on a whole neighborhood without opening a listing.

    ZILLOWSEARCH lists every property in a Zillow search URL. ZILLOWHOME adds Zestimate and last sold price. AIRBNB shows what short-term rentals nearby charge for your dates.

    =ZILLOWHOME(A2:A50)

  • Marketing agencies

    Monitor client and competitor social accounts in one tab.

    INSTAGRAM and FACEBOOKPOSTS pull the latest posts. FACEBOOKADS and GOOGLEADS show every ad a brand is running. SIMILARWEB estimates their traffic.

    =FACEBOOKADS({"Nike"})

  • Recruiters

    Scan the job market and research candidates from a sheet.

    JOBSEARCH covers Indeed, LinkedIn, Glassdoor and ZipRecruiter in one call. LINKEDINPROFILE pulls public profile data for a list of URLs.

    =JOBSEARCH("Product Manager", "Remote")

  • Resellers and collectors

    Price inventory against what actually sold, not what is listed.

    EBAYSOLD returns recently sold listings and prices. TCGPRICE pulls TCGplayer market prices for any card. TRUSTPILOT and TRIPADVISOR cover reputation.

    =EBAYSOLD("iPhone 13 Pro")

All 43, by platform.

Every one returns publicly available data, and costs the same credits as running the same scrape through the Chat Agent.

Limits, stated: TikTok profiles are blocked upstream, hashtags work. ZILLOWSEARCH needs a full search URL. AIRBNB quotes the dates you pass. Spilled tables need empty cells below and to the right.

Google11functions
Amazon3functions
YouTube2functions
Social Media7functions
LinkedIn3functions
Jobs & Leads5functions
Commerce & Reviews3functions
Reviews & Reputation3functions
Real Estate3functions
Research & Web3functions

Google

11formulas

Search, Maps, News, Trends, Shopping, Flights, Hotels, Play Store, and Ads Transparency, straight into your sheet.

  • =GSEARCH()

    Organic Google results as a table: title, URL, snippet

    instant
  • =GNEWS()

    Google News articles for any query

    instant
  • =GMAPS()

    Google Maps places: name, rating, address, phone

    instant
  • =GMAPSREVIEWS()

    Reviews for any Google Maps place

    background
  • =GTRENDS()

    Google Trends interest-over-time for a search term

    instant
  • =GTRENDING()

    What is trending right now in any country

    instant
  • =GSHOPPING()

    Google Shopping listings with prices and merchants

    instant
  • =GPLAYREVIEWS()

    App reviews from the Google Play Store

    instant
  • =GFLIGHTS()

    Flight options for a route and date

    instant
  • =GHOTELS()

    Hotel search for a location and date range

    instant
  • =GOOGLEADS()

    Every ad a company runs, from the Google Ads Transparency Center

    background
=GSEARCH("best coffee makers")

Amazon

3formulas

Product research, price tracking, and seller-offer comparison from ASINs or keywords.

  • =AMAZONSEARCH()

    Search Amazon and spill matching products as a table

    instant
  • =AMAZONPRODUCT()

    Full product details for one ASIN: title, price, rating, reviews

    instant
  • =AMAZONOFFERS()

    Third-party seller offers for an ASIN, for price comparison

    instant
=AMAZONSEARCH("shoes", "US", "10001")

YouTube

2formulas

Video search results and full transcripts without leaving your spreadsheet.

  • =YTSEARCH()

    YouTube search results: title, channel, views, URL

    instant
  • =YTTRANSCRIPT()

    Full transcript of any YouTube video

    background
=YTSEARCH("cooking tutorials")

Social Media

7formulas

Instagram, TikTok, Reddit, X, and Facebook posts and ads, monitored from a formula.

  • =INSTAGRAM()

    Recent posts for a list of Instagram usernames or hashtags

    background
  • =TIKTOK()

    Recent videos for TikTok hashtags: views, likes, shares, comments, author

    background
  • =REDDIT()

    Reddit posts for searches or communities

    background
  • =TWITTERSEARCH()

    Posts on X matching your search terms

    background
  • =FACEBOOKPOSTS()

    Recent posts from Facebook pages

    background
  • =FACEBOOKCOMMENTS()

    Comments under specific Facebook posts, with commenter and like counts

    background
  • =FACEBOOKADS()

    Active ads any page is running, from the Facebook Ad Library

    background
=INSTAGRAM({"natgeo","nasa"})

LinkedIn

3formulas

Company pages, public profiles, and post search for B2B research.

  • =LINKEDINCOMPANY()

    Company page data: industry, staff count, HQ, specialties

    background
  • =LINKEDINPROFILE()

    Public profile data for a list of LinkedIn profile URLs

    background
  • =LINKEDINPOSTS()

    LinkedIn posts matching your keywords

    background
=LINKEDINCOMPANY({"https://linkedin.com/company/google"})

Jobs & Leads

5formulas

Job boards, lead discovery, contact extraction, and email validation for outbound work.

  • =INDEEDJOBS()

    Indeed job listings for a position and location

    background
  • =JOBSEARCH()

    Jobs across Indeed, LinkedIn, Glassdoor, and ZipRecruiter at once

    background
  • =FINDLEADS()

    B2B leads by job title, location, domain, or industry

    background
  • =CONTACTINFO()

    Crawl a site and extract emails, phones, and social links

    background
  • =VALIDATEEMAIL()

    Check whether email addresses are deliverable

    background
=INDEEDJOBS("Software Engineer", "Austin, TX")

Commerce & Reviews

3formulas

Sold-price research, collectible prices, and hotel review mining.

  • =EBAYSOLD()

    Recently sold eBay listings, what items actually sold for

    background
  • =TCGPRICE()

    Trading-card market prices from TCGplayer

    background
  • =BOOKINGREVIEWS()

    Guest reviews for any Booking.com property

    background
=EBAYSOLD("iPhone 13 Pro")

Reviews & Reputation

3formulas

App Store, TripAdvisor, and Trustpilot reviews for reputation tracking and voice-of-customer research.

  • =APPSTOREREVIEWS()

    Apple App Store (iOS) reviews: rating, title, text, app version

    background
  • =TRIPADVISOR()

    TripAdvisor hotel, restaurant, and attraction reviews, with the owner replies

    background
  • =TRUSTPILOT()

    Trustpilot business reviews plus the company TrustScore on every row

    background
=APPSTOREREVIEWS({"389801252"})

Real Estate

3formulas

Zillow listings and property detail plus Airbnb stays worldwide, for comps, rental surveys, and short-term rental research.

  • =ZILLOWSEARCH()

    US listings from a Zillow search URL (copy it from your browser after searching): address, price, beds, baths, sqft

    background
  • =ZILLOWHOME()

    Full detail for one property, including Zestimate and last sold price

    background
  • =AIRBNB()

    Airbnb stays for any city or neighborhood: price for your dates, rating, host, guests, bedrooms

    background
=ZILLOWSEARCH("https://www.zillow.com/austin-tx/?searchQueryState=%7B%22isMapVisible%22%3Atrue%7D")

Research & Web

3formulas

Site traffic estimates, Wikipedia data, and whole-site crawling.

  • =SIMILARWEB()

    Traffic and engagement estimates for any domain

    background
  • =WIKIPEDIA()

    Structured Wikipedia article data for search terms or URLs

    background
  • =CRAWL()

    Crawl a site from a start URL and collect page content

    background
=SIMILARWEB({"nike.com"})

Any other page.

Not every site has a dedicated function. For everything else: whole pages, specific elements, images and page metadata, 1 credit per call on most sites. Search results with SERP and BULKSERP, and DOMAINCHECK lookups, are free.

Scrape

  • =VISIT()

    Get entire page content from any URL (up to 50K chars), including JavaScript-rendered pages

  • =GETSELECTOR()

    Extract elements matching any CSS selector

  • =GETIMG()

    Extract all image URLs from a page

  • =SERP()

    Up to 20 search results per query, title, snippet, URL, powered by DuckDuckGo, free on every plan

  • =BULKSERP()

    Search results in horizontal format, ideal for many keywords at once, free on every plan

  • =DOMAINCHECK()

    Check domain availability instantly via RDAP across 20+ TLDs, free on every plan

Page data

  • =PAGEDATA()

    Bulk-extract metadata (title, description, headings) from a range of URLs

  • =GETMETATITLE()

    Get the meta title of any page

  • =GETMETADESCRIPTION()

    Get the meta description of any page

  • =GETH1()

    Get the main H1 heading of any page

  • =GETH2()

    Get all H2 headings of any page

  • =GETHEADINGS()

    Get all headings (H1–H6) of any page

  • =GETP()

    Get all paragraph text from any page

Guides: web scraping in Sheets, CSS selectors, SERP tracking.

What a month of scraping costs.

Scraping runs on integration credits. Solo includes 10,000 a month for $20, or 30% less on yearly billing. Team and Business scale that to 50,000 and 135,000. Bring your own AI key on any paid plan and monthly credits rise 50%.

IMPORTXML is free but breaks on JavaScript-rendered pages and rate limits, and cannot touch Amazon, LinkedIn or Instagram. Scraping platforms hand you a CSV to import. SheetMagic writes the rows into the cell you typed the formula in.

Compare plans

Google and YouTube lookups on Solo

3,333a month

3 credits each. Search, Maps, Shopping, News, Trends, Flights, Hotels, Play reviews, YouTube search.

Amazon lookups on Solo

10,000a month

1 credit each. Search, product detail, seller offers.

Page scrapes on Solo

10,000a month

1 credit each on most sites; a rendered page is 2, a bot-protected one up to 9.

Background platform scrapers are priced per row returned, 1 to 84 credits, so a 20-row pull costs a fraction of a 500-row one. Free starts you with 100 credits: about 33 Google lookups or 100 page scrapes.

On a paid plan, skip the formula.

Solo, Team and Business include the AI Chat Agent. Type “pull the transcripts of these 20 YouTube videos and summarise each in two sentences” and it runs the scrape, writes the rows and adds the AI column. Same credits as the formula.

Install freeMeet the Chat Agent