World News in Google SheetsWorld News in Google Sheets

OnlineCredit Usage:1 per cell

Formula

News API simplifies the process of scraping news data. Easily extract news titles, descriptions, and more from a single API call.

In a cell
=VERVE("news", A2)
In a cell
=VERVE.CALL("news", A2)

A2 holds the category you're looking up. Drag the formula down and each row resolves on its own.

With literal values

Nothing has to come from a cell — typed values work the same way.

Sheets
=VERVE("news", "technology")

Inputs

Required inputs are positional, in the order below. Everything else is passed as a "name", value pair after them — the same shape as SUMIFS.

InputTypeWhere it goesDescription
categoryRequiredstringargument 2The news category for which you want to get the news. Allowed values: business, entertainment, world, health, science, sports, technology (e.g. technology)
limitinteger"limit", valueMaximum number of articles to return (e.g. 10)

Passing an option

Sheets
=VERVE("news", A2, "limit", "10")

What lands in your sheet

With no "field" pair the formula spills the whole response as two columns — field name on the left, value on the right — starting at the cell you typed in. Make sure the cells below and to the right are empty.

Pulling one value

Add a "field" pair to get a single cell back instead of a table. The field name is the dot-path from the table below.

Returns date
=VERVE("news", A2, "field", "date")
Returns date
=VERVE.CALL("news", A2, "field", "date")

Available fields

Use as "field"TypeExample cell valueDescription
datestring2025-12-16Query date for news articles in YYYY-MM-DD format
categorystringtechnologyNews category retrieved articles are from
articleCountnumber60Total number of articles returned in results
articlesarray[60]list of rowsArray of news article objects with details
articles.0.categorystringtechnologyNews category retrieved articles are from
articles.0.websitestringThe Verge
articles.0.titlestringThe best Android phones
articles.0.pubDatestring2025-12-16T22:18:06Z
articles.0.descriptionstringThe Android ecosystem is all about choice. While iPhone owners have a smaller pool of new devices to pick from when it’s time to upgrade, there’s a wider range of choices on Android. Some Android phones even fold in half! Imagine. On the flip side, all that choice can make for some hard decisions. Here’s where I’d like to help; I’ve tested a whole boatload of recent Android phones, and I think there are some real winners in the current batch. It’s all a matter of what you’re looking for, what you’re comfortable spending, and what your definition of a “reasonably sized phone” is. (I have my own, personally.) As you sift through the options, you’ll almost certainly come across tech’s favorite buzzphrase of the moment: AI. Generally speaking, AI has yet to really impress me on a phone. The Pixel 10 series has some useful features, including Magic Cue, which proactively aims to surface relevant information when you need it, and Galaxy devices can translate a phone call for you in real time. These things are nothing to sneeze at! But none of it feels like the platform shift that the big tech companies keep promising. Best not to put too much stock in any company’s AI claims just yet. The best Android phone overall The best budget Android phone The best maximalist phone The best Android phone that isn’t huge The best lightweight big phone The best phone if you hate waiting for your phone to charge The best foldable phone Other Android phones worth considering What’s coming next If you live in the US, I have some bad news about the Android market, though. For complicated reasons having to do with “capitalism” and “geopolitics,” we don’t get nearly as many of the options as you’ll find in Asia and Europe — brands like Huawei, Xiaomi, Honor, and Oppo just aren’t available here. I’ve limited this guide to the devices I’ve personally tested in depth; thus, it is a fairly US-centric set of recommendations.  With that in mind, it’s also worth acknowledging that most people in the US get their phones “for free” from their wireless carrier. If you can manage it, buying a phone unlocked will give you the most flexibility and freedom if you end up wanting to change carriers in the near future. Phone manufacturers also offer financing and trade-in deals to make payment more manageable. But if you’re happy with your carrier and the free phone on offer is the one you really want, by all means, take the free phone. Just make sure you understand the terms, especially if you need to change plans to cash in on the deal.  However you go about it, you have some fantastic options for your next Android phone. The best Android phone overall Google Pixel 10 Google’s Pixel 10 has a 6.3-inch OLED display, Google Tensor G5 processor, 12GB of RAM, support for Pixelsnap wireless charging, and a triple-lens camera system that includes a new 5x telephoto. Score: 8 ProsCons Qi2 wireless charging with magnets is great AI is actually kind of useful, finally Telephoto camera is a nice addition Main and ultrawide cameras aren’t quite as good as the Pro Battery life is just okay Where to Buy: $799 $599 at Amazon (128GB) $799 $599 at Best Buy (128GB) $799 $599 at Google (128GB) Screen: 6.3-inch, 1080p 120Hz OLED / Processor: Tensor G5 / Cameras: 48-megapixel f/1.7 main with OIS; 13-megapixel f/2.2 ultrawide; 10.8-megapixel 5x telephoto with OIS; 10.5-megapixel selfie / Battery: 4,970mAh / Charging: 30W wired, 15W wireless (Qi2) / Weather-resistance rating: IP68 The Pixel 10 is Google’s latest take on the “just right” Android phone that introduces a few notable upgrades. For $799, you get a sharp 6.3-inch OLED screen, the same Tensor G5 chip found in the pricier Pro version, and Qi2 wireless charging with built-in magnets, no case required. The device is built to handle the day-to-day without a fuss, and the whole thing feels straightforward instead of flashy. This year, the Pixel 10 also adds a dedicated telephoto lens, a first for the non-Pro. Unfortunately, the main and ultrawide cameras are a step down from last year’s model. If you’re not scrutinizing every pixel or chasing low-light portraits, you’ll probably never notice. For regular photos, the Pixel 10 is great; it produces clean shots, solid performance, and enough versatility for the average user. What really sets the Pixel 10 apart, though, is how easy it is to use. AI features like Magic Cue are useful, proactively providing info without getting in the way. For example, it can surface a restaurant’s address or reservation details from your search history or confirmation email as you finalize plans over text. The phone runs cooler than previous versions and handles heavier workloads well, and it shrugs off dust and water. If you want an Android smartphone that doesn’t overcomplicate things, the Pixel 10 is an easy recommendation. Read our full Pixel 10 review. The best budget Android phone Google Pixel 9A Score: 8 ProsCons Robust IP68 rating Seven years of software updates Brighter, bigger screen Missing a couple of AI features AI is occasionally handy, usually weird Where to Buy: $499 $399 at Amazon (128GB) $499 $399 at Best Buy (128GB) $499 $399 at Google (128GB) Screen: 6.3-inch, 1080p OLED, 120Hz / Processor: Tensor G4 / Cameras: 48-megapixel f/1.7 with OIS, 13-megapixel ultrawide, 13-megapixel selfie / Battery: 5,100mAh / Charging: 23W wired, 7.5W wireless / Weather-resistance rating: IP68 The budget-friendly Pixel 9A nails the essentials, offering a bright 6.3-inch OLED display with a 120Hz refresh rate, IP68 water and dust resistance, wireless charging, and Google’s fourth-gen Tensor G4 chipset. It’s dependable and polished, with steady performance and a battery that lasts all day, even with the always-on display enabled. Overall, it delivers fantastic value for $499 — especially given it’s set to receive seven years of OS updates — and stands head and shoulders above the other inexpensive options we’ve recently tested. Google’s entry-level handset does make some compromises to hit its lower price point, though. The 48-megapixel main and 13-megapixel ultrawide cameras are decent for everyday shots, but low-light performance and portrait mode lag behind the latest Pixel 10 phones (and even older Pixel 9 devices). Meanwhile, it runs a more pared-down version of Google’s on-device AI, so you miss out on some features, including the Screenshots app and Call Notes. The core experience is fantastic, though, and the long support window is among the best you’ll find in this price range. If you want a relatively inexpensive phone that feels just a step below today’s flagships, the 9A is an easy pick. Read our full Pixel 9A review. The best maximalist phone Samsung Galaxy S25 Ultra Score: 8 ProsCons Excellent screen Improved ultrawide camera Rounded corners are comfier Expensive Bulky AI is (still) hit or miss Where to Buy: $1419.99 $849.99 at Samsung (512GB) $1659.99 $969.99 at Samsung (1TB) Screen: 6.9-inch 1440p 120Hz OLED / Processor: Qualcomm Snapdragon 8 Elite / Cameras: 200-megapixel main with OIS, 50-megapixel 5x telephoto with OIS, 10-megapixel 3x telephoto with OIS, 50-megapixel ultrawide, 12-megapixel selfie / Battery: 5,000mAh / Charging: 45W wired, 15W wireless (Qi2 Ready) / Weather-resistance rating: IP68 There’s still no phone quite like the Ultra. The Galaxy S25 Ultra is Samsung’s latest answer to the question, “What if your phone had all of the features?” It’s equipped with two telephoto cameras, a built-in stylus, and a big, bright screen. Good luck finding that combination in another phone. Related: this is one of the most expensive slab-style phones you can buy. The newest edition of the Ultra comes with rounded corners and flat edges, making it more comfortable in your hand. But if you’re looking for significant year-over-year improvements to the Ultra formula outside of that, well, you won’t find much. Samsung’s focus has been on software features, which is to say AI features. But AI on Galaxy phones remains a mixed bag — it’s certainly not the paradigm shift Samsung wants us to think the S25 series represents. All of that puts the Ultra in a place of slightly less distinction than previous versions. The biggest updates are software features available to the rest of the S25 series. The Ultra looks and feels more like other Galaxy phones this time around, too. More than ever, it’s hard to understand what Samsung means when it calls this phone “Ultra.” Still, it’s your best choice for a feature-packed Android phone — even if it’s not quite as ultra as it once was. Read our full Galaxy S25 Ultra review. The best Android phone that isn’t huge Samsung Galaxy S25 Score: 8 ProsCons The last reasonably sized Android phone Seven years of OS upgrades Very good camera Samsung software is as cluttered as usual AI is still a mixed bag Where to Buy: $799.99 $650.12 at Amazon (128GB) $799.99 $699.99 at Best Buy (128GB) $799.99 $699.99 at Samsung (128GB) Screen: 6.2-inch 1080p 120Hz OLED / Processor: Qualcomm Snapdragon 8 Elite / Cameras: 50-megapixel main with OIS, 12-megapixel ultrawide, 10-megapixel 3x telephoto with OIS, 12-megapixel selfie / Battery: 4,000mAh / Charging: 25W wired, 15W wireless (Qi2 Ready) / Weather-resistance rating: IP68 Most people like a big phone, and I get that. I do. If you want a big Android phone, you have plenty of options in front of you. But some of us like a smaller phone — something that (kind of) fits in your pocket, or feels more comfortable in your hand. For us, there is but one option on Android: the Samsung Galaxy S25. That’s the regular S25, not the Plus, which is a fine big phone. But the standard S25 is basically the last of its kind: a full-featured phone with a 6.2-inch screen. It’s not small, but it’s not huge, and we’ll have to take what we can get. And it’s a darn good phone that keeps up with the bigger devices in all the important ways: the battery goes all day, it comes with plenty of RAM, and it even has a real telephoto lens — not something you get on a basic, 6.1-inch phone on, say, iOS. The Galaxy S25 isn’t just a good, small-ish phone by default. It’s reliable, durable, and comes with the promise of seven years of OS updates. It’s not my pick for the overall best Android phone because Samsung software can be a bit much, but if you’re comfortable in the Samsung ecosystem and you just want a phone that fits in your dang pocket, then this is the one to go with. Read our full Galaxy S25 review. The best lightweight big phone Samsung Galaxy S25 Edge Score: 8 ProsCons Like a regular phone, but slim Surprisingly lightweight Battery life isn’t as bad as I feared No telephoto camera Battery life not as strong as a standard phone Where to Buy: $1099.99 $799.99 at Best Buy (256GB) $1099.99 at Samsung (256GB) $1099.99 $799.99 at Amazon (256GB) Screen: 6.7-inch 1440p 120Hz LTPO OLED / Processor: Qualcomm Snapdragon 8 Elite / Cameras: 200-megapixel f/1.7 main camera with OIS, 12-megapixel f/2.2 ultrawide, 12-megapixel f/2.2 selfie / Battery: 3,900mAh / Charging: 25W wired, 15W wireless (Qi2 Ready) / Weather-resistance rating: IP68 Big phones have a tendency to, well, look and feel big. The Samsung Galaxy S25 Edge, on the other hand, is different. Thanks to its slim, lightweight design, the device provides a welcome reprieve from the countless chunky, heavy alternatives. It’s thinner and lighter than the Galaxy S25 Plus, making it the big phone you can actually slide into your pocket or evening bag without it protruding out. So, what’s the catch? The S25 Edge’s battery life is fine. Not great, not terrible, but somewhere straight down the middle. To be fair, it held up admirably during a particularly strenuous workday, one complete with hours of screen time, mobile hotspotting, and live blogging, making it to bedtime with battery to spare. It also lacks a dedicated telephoto lens, though it does feature the same 200-megapixel main camera found in the S25 Ultra. Even with those compromises, the S25 Edge is a very capable phone that offers similar performance and durability to other devices in the S25 lineup. You’ll just have to be a little more aware of battery life as the day goes on; however, unless you’re frequently streaming video or playing graphics-intensive games throughout the day, the noticeably thinner, lighter design offers a nice change of pace. Read our full Galaxy S25 Edge review. The best phone if you hate waiting for your phone to charge OnePlus 15 The OnePlus 15 offers some of the best battery performance you’ll find from any flagship phone stateside. There’s a top-shelf processor too, a combination that more than makes up for a lackluster software experience. Score: 8 ProsCons Easily a two-day battery for almost any kind of user Big, sharp screen OxygenOS is looking a little cluttered these days Silicon-carbon battery may limit device longevity Proprietary super-fast wireless charging feels increasingly irrelevant Where to Buy: $899.99 at OnePlus $899.99 at Amazon Screen: 6.78-inch 1272p 165Hz LTPO OLED / Processor: Snapdragon 8 Elite Gen 5 / Cameras: 50-megapixel f/1.8 main with OIS, 50-megapixel f/2.8 3.5x telephoto with OIS, 50-megapixel f/2.0 ultrawide, 32-megapixel selfie / Battery: 7,300mAh / Charging: 80W wired, 50W wireless / Weather-resistance rating: IP68 and IP69K The OnePlus 15 takes the “never worry about charging” ethos of its predecessor and cranks it up a notch. Its massive 7,300mAh silicon-carbon battery comfortably delivers two days of real-world use — and that’s with every power-draining feature enabled, including the always-on display. You don’t have to baby it to get the best possible battery life, either. If you do need a quick top-off, the included 80W wired charger and patented USB-C cable can provide you with a full day of battery life in just 20-ish minutes of charging. It’s not available in the US yet, but it is available for preorder, with shipments expected to begin in January 2026. As for other specs, the 15 features a sharp 1.5K, 165Hz display and Qualcomm’s Snapdragon Elite Gen 5 chip, meaning there’s more to the handset than just battery life. That said, there are some tradeoffs given the newer technology. The chemistry of silicon-carbon batteries may degrade faster than that of lithium-ion batteries, though OnePlus claims the battery will retain over 80 percent of its overall health for the first four years. The 15 also lacks built-in Qi2 magnets, unlike the Pixel 10, so you may have to fiddle with the alignment on your wireless charger to get it just right. If absurd battery headroom is what you’re after, though, the 15 offers it in spades. Read our full OnePlus 15 review. The best foldable phone Google Pixel Pro 10 Fold Score: 8 ProsCons Full dust resistance! On a foldable! Qi2 support with built-in magnets Heavy and chunky Cameras aren’t as good as the other 10 Pro phones’ Pricier than a regular phone Where to Buy: $1799 $1499 at Amazon (256GB) $1799 $1499 at Best Buy (256GB) $1799 $1499 at Google (256GB) Screen: 8-inch, 2076p, 120Hz OLED inner screen; 6.4-inch, 1080p, 120Hz OLED cover screen / Processor: Google Tensor G5 / Cameras: 48-megapixel f/1.7 main with OIS; 10.8-megapixel 5x telephoto with OIS; 10.5-megapixel ultrawide; 10-megapixel selfie (cover screen); 10-megapixel inner selfie camera / Battery: 5,015mAh / Charging: 30W wired, 15W wireless (Qi2) / Weather-resistance rating: IP68 The Pixel 10 Pro Fold’s brings better durability to a category that’s historically fragile. With an IP68 rating, the it’s the first foldable to offer full dust and water resistance. In real-world use, that means the device can take a tumble at the beach and remain relatively unscathed. Plus, you get the convenience of Qi2 support with built-in magnets for snap-on charging and accessories, including Google’s excellent magnetic ring stand. Performance is smooth, too, and the slightly wider outer display feels more like a standard slab-style phone. Battery life is also solid for a folding phone, lasting a full day with minimal use of the inner screen; however, spending more time multitasking on the larger display means the battery may be in the red by bedtime. While the 10 Pro Fold’s cameras are good, they lag behind Google’s other 10 Pro models. The foldable is also over 40g heavier than Samsung’s lightweight Galaxy Z Fold 7. If you’ve been avoiding foldables because of durability concerns, the 10 Pro Fold’s improved hinge design means exposure to dust and grains of sand doesn’t equal certain doom. Read our full Pixel 10 Pro Fold review. Other Android phones worth considering There are many more great Android devices that weren’t covered here, and a few are worth calling out that didn’t quite make the cut for a recommendation. The Nothing Phone 3 is billed by the brand as its “first true flagship phone,” with a $799 starting price that competes directly with the iPhone 17, Galaxy S25, and Pixel 10. It boasts a 6.67-inch OLED display, a generous 5,150mAh capacity battery, and a Snapdragon 8S Gen 4 chipset, which is on the lower end of the flagship spectrum. It also looks different from previous Nothing devices. Instead of the iconic light strips on the back that glow and flash, the Nothing 3 features a small dot-matrix LED display that can show pictures and icons. Read our review. The Galaxy Z Flip 7 is Samsung’s other new foldable device. Unlike previous Flip series devices, the company’s latest flip phone ditches the file folder-shaped look for a 4.1-inch, edge-to-edge display that wraps around the cameras. The larger screen is a joy to use, making it much easier to quickly respond to texts and manage full apps. While the design is a big upgrade, the device still offers no protection against fine particles like dust or sand, raising concerns about how the device will hold up over time. Read our review. The Pixel 10 Pro is Google’s most refined flagship yet, and a great showcase for the Android ecosystem. It features a premium design and big hardware upgrades over its predecessor, like a Tensor G5 chip and Qi2 wireless charging with built-in magnets. It also offers genuinely useful AI features, and the camera’s portrait mode is much improved over its predecessor. However, while the 10 Pro’s battery capacity is a bit larger this time around (4,870mAh versus 4,700mAh), the battery life is just okay. We’re also feeling uneasy about generative AI being inside the camera app. Read our review. The Galaxy Z Fold 7 is a thin, lightweight foldable that feels like a regular phone when folded shut. It has a spacious inner display that’s great for multitasking and gaming, and its battery can last all day with moderate use. That said, the device has a starting price of $2,000 — $200 more than the Pixel 10 Pro Fold — though we’ve seen it drop as low as $1,599. It also has an IP48 rating, meaning it’s fully water-resistant but not completely immune to tiny specks of dust. Read our review. What’s coming next Samsung recently announced the Z TriFold after teasing it earlier this summer. As of now, the device has a tentative launch planned for the first quarter of 2026 here in the US. The foldable features not one, but two hinges, which open to reveal an inner screen that measures 10 inches diagonally, with a resolution of 2160 x 1584 and a 120Hz adaptive refresh rate that can drop all the way to 1GHz. The 1080p outer display, meanwhile, measures 6.5 inches and features a 21:9 aspect ratio, while the device itself is 12.9mm thick when folded shut. It also has a ceramic-glass, fiber-reinforced polymer back panel that’s designed to resist cracking, along with an IP48 rating, meaning it’s fully water-resistant but not dust-tight. In addition to the OnePlus 15, the brand is gearing up to reveal more info regarding the OnePlus 15R on December 17th. Details are scarce, but we know the device will feature a massive 7,400mAh battery. We’re also expecting it to offer a pared-down experience compared to the 15, including a less powerful processor. Depending on how much it costs — the OnePlus 13R launched at $599.99 — the 15R could give the Pixel 9A some serious competition, especially for those who value battery life above all else. While an official launch is likely still months away, we’re already starting to hear murmurs about Google’s Pixel 10A. The device is expected to look similar to the Pixel 9A, according to leaked CAD renders, and carry over some features from the Pixel 10. That means we could see the entry-level 10A launch with Google’s powerful Tensor G5 processor, offering the same great performance as the brand’s best device. Update, December 16th: Updated pricing / availability, added the OnePlus 15 and Pixel 9A as new picks, and added bullets to the “What’s coming next” section. Brandon Russell also contributed to this post.
articles.0.linkstringhttps://www.theverge.com/23674658/best-android-phone

Filling a whole column

Hand the first argument a range instead of a cell and the add-in makes one batched call for the lot, then spills the answers down. That is faster than dragging the formula and costs the same credits — one per row looked up.

Rows 2–100 in one call
=VERVE("news", A2:A100, "field", "date")
Rows 2–100 in one call
=VERVE.CALL("news", A2:A100, "field", "date")

A2:A100 is the column of category values. The result spills down alongside it, one row per input, blanks skipped.

When a cell doesn't fill

A failed lookup returns readable text starting with #ERR rather than a spreadsheet error, because Excel cannot show a custom message on a real error — you would get a bare #VALUE! with no reason. The trade-off is that IFERROR() won't catch it; test with LEFT(cell, 4) = "#ERR" instead.

Cell readsWhat happened
#ERR Not connectedNo API key saved. Open the side panel and connect your account.
#ERR Replace <name> with a cell or valueThe preview formula was copied as-is. Swap the placeholder for a cell reference.
#ERR No "x" in newsAn option name that this source doesn't take. The message lists the ones it does.
#ERR No data point "…"The "field" path isn't in the response. Check the dot-path against the table above.
#PREMIUM(field)The field exists but your plan doesn't include it.
#ERR Out of creditsThe month's credits are spent. Usage resets on your billing date.

Before the formula works

The add-in reads the API key you saved once in the side panel — the key never goes in the formula, so a shared sheet doesn't leak it and a collaborator without access simply sees the last calculated values.

  1. Install the add-in for Google Sheets or Excel.
  2. Open the side panel and sign in, or paste a key from your dashboard.
  3. Type the formula above into any cell.

Other ways to use World News in Google Sheets

Set up World News in Google Sheets on VerveSheets, or reach the same source a different way. Your VerveSheets account and credits work on all of them — one key, one balance.

Call it as a REST APIOne HTTPS endpoint and an X-API-Key header, with SDKs for Node, Python and .NET.APIVerveReference →
Give it to an AI agentConnect over MCP and your agent calls it as a native tool — Claude, Cursor, ChatGPT.VerveKitReference →
Ground an agent on itA cited, machine-checkable fact your model can't produce on its own.VerveContextReference →

Frequently asked questions

Does World News in Google Sheets work in both Google Sheets and Excel?

Yes — the same source, the same arguments. Sheets calls it =VERVE("news", …) and Excel calls it =VERVE.CALL("news", …); that function name is the only difference.

Do the cells recalculate on their own?

They recalculate when the sheet does — on edit, on open, or on a manual recalc. Each recalculation is a fresh call and spends credits, so for a large static column it's worth copying the results and pasting them as values.

How many credits does a filled column cost?

1 credit per row looked up, whether you drag the formula or pass a range. The range form is one HTTP call instead of many, but the credit count is the same.

Can I share the sheet without sharing my key?

Yes. The key is stored against your account, not in the file. Collaborators see the values already in the cells; formulas only recalculate for someone who has connected their own account.

Why is a cell showing #ERR instead of an error?

So you can read the reason. Excel can't display a custom message on a real spreadsheet error, so the add-in returns the explanation as text on both platforms instead.

What's Next?

Continue your journey with these recommended resources

Was this page helpful?