SheetMagicSheetMagic

Web Scraping in Google Sheets

eBay sold prices. YouTube transcripts. LinkedIn company pages. Zillow comps. Amazon listings. Instagram posts. One formula each, and the table spills into your sheet. 42 scrapers for 20+ sites, plus VISIT and CSS selectors for any other page. No code, no browser extension, no separate scraping account.

Try SheetMagic FreeSee plans

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

docs.google.com/spreadsheets
A1=AMAZONSEARCH("wireless earbuds", "US", "10001")
titlepriceratingreviews
Sony WF-1000XM5$248.004.49,214
Apple AirPods Pro 2$189.994.798,210
Anker Soundcore P40i$59.994.531,062
JBL Tune Flex 2$79.954.38,455

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. ZILLOWHOME adds Zestimate and last sold price. GMAPS fills in what is nearby.

=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")

Two kinds of formulas

Fast sources return instantly. Slower sources run as background jobs. Either way, the results land in your sheet.

Instant tables, 13 formulas

Google, Amazon, and YouTube search respond fast, so these formulas spill a full table the moment you hit enter: titles, prices, ratings, URLs.

=GSEARCH("best crm for startups")

Background jobs, 29 formulas

Social platforms and business data take up to about a minute. These formulas show a loading placeholder while the job runs, then write the results into the same cells. Keep working while they finish.

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

All 42 scraper functions

Grouped by the site they scrape. All of them return publicly available data, and every one costs the same integration credits as running the same scrape through the AI Chat Agent.

Google

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
  • =GNEWS()Google News articles for any query
  • =GMAPS()Google Maps places: name, rating, address, phone
  • =GMAPSREVIEWS()Reviews for any Google Maps place
  • =GTRENDS()Google Trends interest-over-time for a search term
  • =GTRENDING()What is trending right now in any country
  • =GSHOPPING()Google Shopping listings with prices and merchants
  • =GPLAYREVIEWS()App reviews from the Google Play Store
  • =GFLIGHTS()Flight options for a route and date
  • =GHOTELS()Hotel search for a location and date range
  • =GOOGLEADS()Every ad a company runs, from the Google Ads Transparency Center
=GSEARCH("best coffee makers")

Amazon

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

  • =AMAZONSEARCH()Search Amazon and spill matching products as a table
  • =AMAZONPRODUCT()Full product details for one ASIN: title, price, rating, reviews
  • =AMAZONOFFERS()Third-party seller offers for an ASIN, for price comparison
=AMAZONSEARCH("shoes", "US", "10001")

YouTube

Video search results and full transcripts without leaving your spreadsheet.

  • =YTSEARCH()YouTube search results: title, channel, views, URL
  • =YTTRANSCRIPT()Full transcript of any YouTube video
=YTSEARCH("cooking tutorials")

Social Media

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

  • =INSTAGRAM()Recent posts for a list of Instagram usernames or hashtags
  • =TIKTOK()Recent videos for TikTok hashtags: views, likes, shares, comments, author
  • =REDDIT()Reddit posts for searches or communities
  • =TWITTERSEARCH()Posts on X matching your search terms
  • =FACEBOOKPOSTS()Recent posts from Facebook pages
  • =FACEBOOKCOMMENTS()Comments under specific Facebook posts, with commenter and like counts
  • =FACEBOOKADS()Active ads any page is running, from the Facebook Ad Library
=INSTAGRAM({"natgeo","nasa"})

LinkedIn

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

  • =LINKEDINCOMPANY()Company page data: industry, staff count, HQ, specialties
  • =LINKEDINPROFILE()Public profile data for a list of LinkedIn profile URLs
  • =LINKEDINPOSTS()LinkedIn posts matching your keywords
=LINKEDINCOMPANY({"https://linkedin.com/company/google"})

Jobs & Leads

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

  • =INDEEDJOBS()Indeed job listings for a position and location
  • =JOBSEARCH()Jobs across Indeed, LinkedIn, Glassdoor, and ZipRecruiter at once
  • =FINDLEADS()B2B leads by job title, location, domain, or industry
  • =CONTACTINFO()Crawl a site and extract emails, phones, and social links
  • =VALIDATEEMAIL()Check whether email addresses are deliverable
=INDEEDJOBS("Software Engineer", "Austin, TX")

Commerce & Reviews

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

  • =EBAYSOLD()Recently sold eBay listings, what items actually sold for
  • =TCGPRICE()Trading-card market prices from TCGplayer
  • =BOOKINGREVIEWS()Guest reviews for any Booking.com property
=EBAYSOLD("iPhone 13 Pro")

Reviews & Reputation

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
  • =TRIPADVISOR()TripAdvisor hotel, restaurant, and attraction reviews, with the owner replies
  • =TRUSTPILOT()Trustpilot business reviews plus the company TrustScore on every row
=APPSTOREREVIEWS({"389801252"})

Real Estate

US listings and full property detail from Zillow, for comps, rental surveys, and market research.

  • =ZILLOWSEARCH()US listings from a Zillow search URL (copy it from your browser after searching): address, price, beds, baths, sqft
  • =ZILLOWHOME()Full detail for one property, including Zestimate and last sold price
=ZILLOWSEARCH("https://www.zillow.com/austin-tx/?searchQueryState=%7B%22isMapVisible%22%3Atrue%7D")

Research & Web

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

  • =SIMILARWEB()Traffic and engagement estimates for any domain
  • =WIKIPEDIA()Structured Wikipedia article data for search terms or URLs
  • =CRAWL()Crawl a site from a start URL and collect page content
=SIMILARWEB({"nike.com"})

The classics: scrape any page

Not every site has a dedicated function. For everything else, scrape any URL directly: whole pages, specific elements, images, and search results.

See the full web scraping guide, learn how CSS selectors work, or dig into SERP tracking.

=VISIT()

Get entire page content from any URL (up to 50K chars)

=VISIT("https://example.com")

=GETSELECTOR()

Scrape exactly the element you want with a CSS selector

=GETSELECTOR(A1, ".price")

=PAGEDATA()

Bulk-extract titles, descriptions, and headings from URLs

=PAGEDATA(A1:A100)

=GETIMG()

Extract every image URL from a page

=GETIMG("https://example.com")

=SERP()

Top search results for any keyword, powered by DuckDuckGo

=SERP("best coffee shops in NYC", 20)

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. Turn on BYOK on any paid plan and your monthly credits go up 50%.

Google and YouTube lookups

3,300 a month on Solo

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

Amazon lookups

10,000 a month on Solo

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

Page scrapes

10,000 a month on Solo

1 credit each. VISIT, GETSELECTOR, PAGEDATA and the rest. Heavily protected sites can cost more.

Background platform scrapers (Instagram, LinkedIn, Zillow, eBay and the rest) are priced per row returned, 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, with no card and no expiry.

Compared to the alternatives: IMPORTXML is free but breaks on JavaScript-rendered pages and rate limits, and cannot touch Amazon, LinkedIn or Instagram at all. Scraping platforms like Apify or PhantomBuster work, then hand you a CSV to import. SheetMagic writes the rows into the cell you typed the formula in.

Compare plans

On a paid plan, skip the formula

Solo, Team and Business include the AI Chat Agent. Type “pull the last 50 YouTube comments on this video and tag each one by sentiment” and it runs the scrape, writes the rows and adds the AI column. Same credits as the formula.

Meet the AI Chat Agent
Rated 4.8/5 on the Google Workspace Marketplace. 6,400+ users.

Start free. Upgrade when your 100 credits run out.

Install from the Marketplace, type your first scraper formula, and watch the table spill. Solo is $20 a month when you want 10,000 credits every month.

Try SheetMagic FreeRead the launch post