Web Scraping in Google Sheets
35 scraper functions for Amazon, Google, Instagram, LinkedIn, TikTok, YouTube, and more — plus classic page scraping with VISIT and CSS selectors. Type a formula, get a table. No code, no browser extensions, no separate accounts.
| title | price | rating | reviews |
|---|---|---|---|
| Sony WF-1000XM5 | $248.00 | 4.4 | 12,847 |
| Apple AirPods Pro 2 | $189.99 | 4.7 | 98,210 |
| Anker Soundcore P40i | $59.99 | 4.5 | 31,062 |
| JBL Tune Flex 2 | $79.95 | 4.3 | 8,455 |
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 — just like =SERP() already does.
=GSEARCH("best crm for startups")Background jobs — 22 formulas
Social platforms and business data take longer. These formulas show a loading placeholder while the job runs, then write the results into the same cells automatically — keep working while they finish.
=INSTAGRAM({"nasa","natgeo"})Search, Maps, News, Trends, Shopping, Flights, Hotels, and Play Store — 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
=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")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")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)Simple, predictable cost
Scraping runs on integration credits, included in every plan: 1,000/month on Solo, 5,000/month on Team, and 20,000/month on Business. The Free tier includes a one-time 10 credits to try it out — no credit card needed. A scrape costs the same whether you run it as a formula or ask the AI Chat Agent to do it.
See plans and credit allowancesPrefer to just ask?
The AI Chat Agent scrapes every one of these sources from plain English — no formula required. Describe what you want and it lands in your sheet.
Put the web in your spreadsheet
Trusted by 3,900+ users. Install free and run your first scrape in under a minute.
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 profiles or hashtags=REDDIT()Reddit posts for searches or communities=TWITTERSEARCH()Posts on X matching your search terms=FACEBOOKPOSTS()Recent posts from Facebook pages=FACEBOOKADS()Active ads any page is running, from the Facebook Ad Library=INSTAGRAM({"natgeo","nasa"})