New: 35 Scraper Formulas End Copy-Paste in Google Sheets
Amazon, eBay, Google Search, Instagram, LinkedIn and more are now plain formulas, so price checks and research lists fill themselves instead of eating your afternoon. Same credit cost as the AI Chat sidebar, zero setup.
Phil Nguyen · 8 min read · Updated
SheetMagic launched with 35 new scraper formulas, so the data you used to copy off Amazon, eBay, Google, Instagram and LinkedIn by hand lands in your sheet from one cell. The payoff is time back on research you repeat every week, and fewer prices set by guesswork.
Think of a reseller who checks eBay sold prices before listing each item. Search, scroll, note five or six prices, average them in their head: say 10 minutes an item, as an example. At 15 items a week that is 2.5 hours, and a guess that lands $30 under what similar items sold for is $30 gone on that one sale.
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 that same data is available as formulas you can type directly into a cell.
Update (October 2026): a few things below have changed since launch. SheetMagic now has 43 scraper formulas: the 13 Google and Amazon ones plus 30 slower sources (8 added after launch, including FACEBOOKCOMMENTS, TRUSTPILOT, ZILLOWSEARCH and AIRBNB). Every scraper formula now behaves the same way: it shows a ⏳ Scraping... placeholder first, and when the job finishes the rows go to a new tab named after the tool (for example "Amazon Results" for AMAZONSEARCH), with a Source column showing which input each row came from. Results never land in or below the formula cell. Keep Formula is on by default and keeps your formula as text in the cell; with it off, the cell changes to a status such as "✅ 20 results → Amazon Results". The Google and Amazon group is still the faster of the two, but it is no longer instant.
Formula
=AMAZONSEARCH("wireless earbuds", "US", "10001")Searches Amazon and writes a table of matching products to a new results tab. 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 to a new results tab 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 rows are written to a new results tab automatically. The placeholder works like the one =VISIT() shows, so if you have used VISIT, the wait will feel familiar.
Formula
=INSTAGRAM({"nasa","natgeo"})Scrapes recent posts for a list of Instagram usernames. Shows a loading placeholder, then writes the posts to a new results tab 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 point anything you build on top of it at the rows in its results tab.
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.
What can you do with the results?
A table in your sheet is only useful if it changes what you do next. Four ways these formulas pay for the credits they use:
- Price from real sales, not a guess.
=EBAYSOLD("nintendo switch oled", "EBAY-US", "endedRecently", 20)returns the last 20 sold listings. Each listing costs 14 scraping credits, so that check is 280 credits and replaces the 10 minutes of scrolling in the example above. Sort by price and you can see where your listing sits before you post it. - Catch a competitor discount the week it happens. Keep your rivals' ASINs in a column with
=AMAZONPRODUCT()next to them and run it again each week. Each run writes a fresh results tab, so a price drop shows up next to last week's number, not as a slow month you notice later. - Build an outreach list without opening 50 tabs.
=CONTACTINFO()on a column of prospect websites pulls the emails, phones and social links into rows. If finding the contact page takes 3 minutes a site by hand (an example figure), 50 sites is 2.5 hours you skip. - Hand the rows straight to AI. Reference any cell in the results tab from
=AITEXT()to summarize reviews, score leads, or draft a first line for an email, in the same sheet.
Same credit cost as the AI Chat assistant
This is the part we wanted to get right before shipping any of this. These formulas do not cost anything extra compared to running the same scrape through the AI Chat sidebar. Whatever a given scrape already costs in scraping credits when the assistant runs it for you, it costs exactly the same as a formula.
Note
Nothing about your scraping 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 scraping 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 of inputs, point =AITEXT() at the rows it returns, and build filters and pivot tables on the results tab. A chat message can't do that on its own.
Where to find the full list
Every scraper formula's name, 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 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.
Text and scraping formulas run 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.