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.
Phil Nguyen · 6 min read
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.
Update (September 2026): two things below have changed since launch. SheetMagic now has 43 scraper functions, 30 of them Apify sources. And since 15 July 2026 every scraper formula behaves the same way: it shows a ⏳ Scraping... placeholder first and writes its results back when the job finishes. Nothing returns a table the moment you hit enter any more. The Google and Amazon group described below is still the faster of the two, but it is no longer instant.
Formula
=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.
Fast sources: 13 formulas for Google and Amazon
The first group covers Google and Amazon. These sources respond quickly, so the wait is short. Type the formula, see the ⏳ Scraping... placeholder, and the results are written back as a table a moment later.
Formula
=GSEARCH("best crm for startups")Returns organic Google search results as a table, with title, URL, and snippet columns.
Formula
=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.
Formula
=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 fast-source formulas: AMAZONSEARCH, AMAZONPRODUCT, AMAZONOFFERS, GSEARCH, GNEWS, GMAPS, GTRENDS, GTRENDING, GPLAYREVIEWS, GSHOPPING, GFLIGHTS, GHOTELS, and YTSEARCH.
Tip
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.
Slower sources: 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.
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 back automatically. This is the exact same pattern =VISIT() already uses, so if you have ever used VISIT, you already know how this behaves.
Formula
=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.
Formula
=LINKEDINCOMPANY({"https://linkedin.com/company/openai"})Pulls company page data (industry, staff count, headquarters, specialties) for a list of LinkedIn company URLs.
Formula
=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 slower-source formulas: INSTAGRAM, TIKTOK, REDDIT, TWITTERSEARCH, FACEBOOKPOSTS, FACEBOOKADS, LINKEDINCOMPANY, LINKEDINPROFILE, LINKEDINPOSTS, INDEEDJOBS, JOBSEARCH, FINDLEADS, GMAPSREVIEWS, BOOKINGREVIEWS, TCGPRICE, EBAYSOLD, SIMILARWEB, WIKIPEDIA, YTTRANSCRIPT, CRAWL, CONTACTINFO, and VALIDATEEMAIL.
Caveat
Because these formulas write their own results back into the sheet, avoid wrapping them in another formula (like =UPPER(INSTAGRAM(...))). Put the scraper formula in its own cell and reference the results 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.
Formula
=AMAZONPRODUCT(A2, "US", "10001")Returns full product details for one ASIN: title, price, rating, review count, and more.
Formula
=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.
Formula
=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.
Formula
=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.
Note
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 100 integration credits (one-time, no expiry) 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.
Every formula in this article runs on the free allowance. Install from the Google Workspace Marketplace, no card, no expiry.
Install free for Google SheetsAbout the author
Phil NguyenPhil builds SheetMagic, the Google Sheets add-on that brings AI and web scraping into the spreadsheet, used by 6,300+ people. He writes these guides from the formulas he runs on his own sheets.