35 New Scraper Functions for Google Sheets
Amazon, Google Search, Instagram, LinkedIn, and more, all as plain formulas now. Same credit cost as the AI Chat sidebar, zero setup.
If you have used the AI Chat sidebar to pull data from Amazon, Instagram, or Google Maps, you already know SheetMagic can reach into places a normal formula cannot. You just had to open the sidebar and describe what you wanted in plain English.
Now you do not have to. That same data is available as 35 new formulas you can type directly into a cell.
=AMAZONSEARCH("wireless earbuds", "US", "10001")Searches Amazon and spills a full table of matching products into your sheet. No sidebar, no prompt, just a formula.
Drag it down a column of keywords and you have a product research table. Put it next to a list of ASINs and you have a pricing tracker. These are regular formulas now. They fit into whatever workflow you already use for the rest of your sheet.
Two kinds of formulas, because two kinds of data need it
The 35 new functions split into two groups, and it matters which group a formula belongs to.
Instant tables: 13 formulas that return data right away
The first group covers Google and Amazon. These sources respond fast, so the formula returns a full table the moment you hit enter. No waiting, no placeholder text. The results spill across rows and columns just like =SERP() already does.
=GSEARCH("best crm for startups")Returns organic Google search results as a table, with title, URL, and snippet columns.
=GFLIGHTS("JFK", "LHR", "2026-08-01")Searches flights for a route and date. Add a return date and cabin class if you want a round trip in a specific class.
=GHOTELS("Paris hotels", "2026-08-01", "2026-08-05")Searches hotels for a location and date range. Sort by lowest price, highest rating, or most reviewed.
Here is the full list of the 13 instant-table formulas: AMAZONSEARCH, AMAZONPRODUCT, AMAZONOFFERS, GSEARCH, GNEWS, GMAPS, GTRENDS, GTRENDING, GPLAYREVIEWS, GSHOPPING, GFLIGHTS, GHOTELS, and YTSEARCH.
Every one of these formulas takes optional arguments after the required ones. =GSEARCH(A2) works with just a query. Add a country code, language, or pagination offset only when you actually need to narrow the results.
Background jobs: 22 formulas for sites that take longer
The second group covers social platforms and business data: Instagram, TikTok, LinkedIn, Reddit, job boards, and more. These sources take longer to respond, sometimes a minute or two, so the formula works a bit differently.
Type the formula and it immediately shows ⏳ Scraping... in the cell. Keep working on the rest of your sheet. When the job finishes, the real results get written into that same cell's range automatically. This is the exact same pattern =VISIT() already uses, so if you have ever used VISIT, you already know how this behaves.
=INSTAGRAM({"nasa","natgeo"})Scrapes recent posts for a list of Instagram usernames. Shows a loading placeholder, then the results appear in the cell once the job completes.
=LINKEDINCOMPANY({"https://linkedin.com/company/openai"})Pulls company page data (industry, staff count, headquarters, specialties) for a list of LinkedIn company URLs.
=JOBSEARCH("product manager", "US", "New York", , TRUE)Searches job listings across Indeed, LinkedIn, Glassdoor, and ZipRecruiter at once. The last TRUE restricts results to remote roles.
Here is the full list of the 22 background-job formulas: INSTAGRAM, TIKTOK, REDDIT, TWITTERSEARCH, FACEBOOKPOSTS, FACEBOOKADS, LINKEDINCOMPANY, LINKEDINPROFILE, LINKEDINPOSTS, INDEEDJOBS, JOBSEARCH, FINDLEADS, GMAPSREVIEWS, BOOKINGREVIEWS, TCGPRICE, EBAYSOLD, SIMILARWEB, WIKIPEDIA, YTTRANSCRIPT, CRAWL, CONTACTINFO, and VALIDATEEMAIL.
Because these formulas write their own results into the cell, avoid wrapping them in another formula (like =UPPER(INSTAGRAM(...))). Put the scraper formula in its own cell and reference that cell from anything else you build on top of it.
A few real examples
Track a product's price and reviews on Amazon. Put ASINs in column A, then pull the product details and the current seller offers next to them.
=AMAZONPRODUCT(A2, "US", "10001")Returns full product details for one ASIN: title, price, rating, review count, and more.
=AMAZONOFFERS(A2, "US", "10001")Lists third-party seller offers for the same ASIN, so you can compare prices across sellers.
Research eBay sold prices before you list something. Instead of guessing what an item is worth, pull recent completed sales.
=EBAYSOLD("nintendo switch oled")Returns recently sold and completed eBay listings for the keyword, so you can see what items actually sold for.
Check what a competitor's site says about itself without opening a browser. Crawl their site and pull emails, phone numbers, and social links in one pass.
=CONTACTINFO({"https://example.com"})Crawls a website and extracts emails, phone numbers, and social links it finds along the way.
Same credit cost as the AI Chat assistant
This is the part we wanted to get right before shipping any of this. These 35 formulas do not cost anything extra compared to running the same scrape through the AI Chat sidebar. Whatever a given scrape already costs in integration credits when the assistant runs it for you, it costs exactly the same as a formula.
Nothing about your integration credit usage changes by switching from the sidebar to a formula. You are just choosing a faster path to the same data, with the same cost. Free tier accounts get 10 integration credits (one-time trial) to try these out, no credit card needed.
The advantage of the formula is not price. It is that a formula fits into the rest of your sheet. Drag it down a column, reference it from =AITEXT(), combine it with filters and pivot tables, or build a dashboard that refreshes when your input data changes. A chat message can't do any of that on its own.
Where to find the full list
All 35 names, their arguments, and example formulas live in the Function Reference inside the add-on. Open Extensions > SheetMagic > Function Reference from the Google Sheets menu and search or scroll to find any of them.
If you are new to SheetMagic and want to see how formulas and the AI Chat sidebar fit together, start with the getting started guide. If you already scrape data with =SERP(), =VISIT(), or =GETSELECTOR(), these 35 formulas slot into the same workflow. The web scraping guide covers how they all work together.
Install SheetMagic free from the Google Workspace Marketplace and try one of the new formulas in your next sheet.
Wrap-up
Spreadsheets shouldn't limit what you can do. SheetMagic brings AI and web scraping to your workflow — whether you're generating content, scraping data, or automating repetitive tasks.
If that sounds like the kind of tooling you want to use — try SheetMagic or watch our tutorials.