Docs/Reference/All sources

All sources

The full catalog — every source, what it costs per call, and a reference page with parameters, response fields and a live sample for each one.

View as Markdown

Every source in the catalog is below, grouped by category. Each links to a reference page generated from the published schema, so what you read is what the API actually accepts and returns — there is no hand-maintained copy to drift.

304 sources across 24 categories, all behind one key, one host and one response shape.

What every source has in common

Before the list, the parts that never change:

How you call it=VERVE("<id>", …) — see formulas
AuthThe connection you made in the sidebar. Never a key in a cell.
What comes backOne value when you name a field, or the whole record as a two-column spill
Failures#ERR text in the cell, naming the reason — see errors

So the difference between any two sources is the id, the arguments and the paths you can ask for. Everything else you learn once.

Reading a reference page

Each page follows the same order, and each section answers a specific question:

  • Overview — what it is for, and when it is the wrong tool.
  • Formula — the =VERVE() call, ready to paste.
  • Parameters — name, type, required or optional, constraints, and accepted values where the set is fixed. Premium parameters are marked.
  • Response — a real sample response, not a schema sketch.
  • Response fields — every field with its dot-path, type, an example value and a description. The dot-paths in this table are exactly what the field argument accepts.
  • Errors — what it rejects and why.
  • Use cases — what people actually build with it.

Credit cost

Most sources cost one credit per call. The ones that do more work — rendering, OCR, inference, multi-source lookups — cost more, and their cost is shown on the card below and again at the top of their reference page.

Failed calls are not billed. A credit is taken only when a source actually answers, so a bad parameter, a rejected credential and a blocked call all cost nothing — the request never reaches the source that would charge for it.

The case that is billed and surprises people is a successful call that found nothing. A lookup returning an empty result did the work you asked for, and it costs its credit. An empty answer is an answer — see errors.

Your remaining balance is at the top of the sidebar while you work, so a long fill is never a surprise — see rate limits.

The catalog

Finance 56

Balance Sheet in Google SheetsGet a Company Balance Sheet by TickerGET6 creditsBank Lookup in SheetsUS Banks and Credit UnionsGET10 creditsBenchmark Rates in Google SheetsGet LIBOR Replacement Benchmark RatesGET2 creditsBIN Lookup in Google SheetsLookup BIN Number InformationGET10 creditsCalculate Income Tax in Google SheetsCalculate Federal and State Income TaxGET2 creditsCalculate Loan Payments in SheetsCalculate loan paymentsPOST2 creditsCalculate Mortgage Payments in SheetsCalculate mortgage paymentsPOST2 creditsCalculate Sales Tax in Google SheetsCalculate sales tax for any US locationGET2 creditsCash Flow Statement in Google SheetsGet a Company Cash Flow Statement by TickerGET6 creditsCentral Bank Rates in Google SheetsGet Central Bank Interest RatesGET2 creditsCompany Earnings in Google SheetsGet All Company Financial Statements in One CallGET6 creditsCompany Lookup in Google SheetsLookup SEC-Registered Public CompaniesGET2 creditsConvert Currency in Google SheetsConvert Currency RatesGET2 creditsCost of Living in Google SheetsCompare Cost of Living by US State and MetroGET2 creditsCountry GDP in Google SheetsGlobal GDP data by countryGET2 creditsCPI Inflation in Google SheetsConsumer Price Index by CategoryGET2 creditsCurrency Rate in Google SheetsGet one currency's live value and historyGET2 creditsCurrency Symbols in Google SheetsGet currency symbolsGETDividends in Google SheetsGet Company Dividend History by TickerGET6 creditsEnergy Prices in Google SheetsGet Daily Oil, Natural Gas and Fuel Spot PricesGET2 creditsExchange Rates in Google SheetsGet exchange rate between two currenciesGET2 creditsFinancial Ratios in Google SheetsGet Key Financial Ratios for a Company by TickerGET6 creditsGas Prices in Google SheetsGet Weekly Gasoline and Diesel Prices for the US, UK and EUGET2 creditsGlobal Market Index in Google SheetsCompare Stock Market Performance by CountryGET2 creditsI-Bond Rates in Google SheetsUS Series I Savings Bond RatesGET2 creditsIFSC Lookup in Google SheetsGet IFSC code informationGET10 creditsIncome Statement in Google SheetsGet a Company Income Statement by TickerGET6 creditsIncome Tax Brackets in Google SheetsGet Federal and State Income Tax Bracket DataGET2 creditsInflation Rates in Google SheetsGet Inflation Rate by Country and YearGET2 creditsInsider Trading in Google SheetsGet Company Insider Transactions by TickerGET6 creditsInstitutional Holdings in Google SheetsGet 13F Holdings by Fund Manager or by StockGET5 creditsLive Bitcoin Price in Google SheetsGet Current Bitcoin PriceGET2 creditsLive Ethereum Price in Google SheetsGet Current Ethereum PriceGET2 creditsLive Gold Price in Google SheetsGet Current Gold PriceGET2 creditsLive Palladium Price in Google SheetsGet Current Palladium PriceGET2 creditsLive Platinum Price in Google SheetsGet Current Platinum PriceGET2 creditsLive Silver Price in Google SheetsGet Current Silver PriceGET2 creditsMarket Open Times in Google SheetsGet stock market open timesGET2 creditsMinimum Wage in Google SheetsFederal and State Minimum Wage RatesGET2 creditsMortgage Rates in Google SheetsGet US Fixed-Rate Mortgage RatesGET2 creditsOFAC Sanctions Screening in Google SheetsScreen a Name Against the OFAC Sanctions ListGET20 creditsPopulation Data in Google SheetsGlobal population statistics by countryGET2 creditsPurchasing Power in Google SheetsInflation-Adjusted Dollar CalculatorGET2 creditsRouting Number Lookup in SheetsLookup Routing Number BankGET10 creditsSales Tax Rates in Google SheetsLookup USA Sales Tax RatesGET2 creditsSEC Filings in Google SheetsGet a Company SEC Filing History by TickerGET6 creditsStock Exchange Lookup in Google SheetsGet Stock Exchange Information by MIC CodeGET2 creditsSWIFT Code Lookup in Google SheetsLookup SWIFT Code InformationGET10 creditsTicker NewsThe latest news for any stock, coin, futures or currency tickerGET2 creditsTicker SymbolsLook up any ticker symbol across 19 stock markets, crypto, futures and currenciesGETTreasury Yields in Google SheetsUS Treasury Securities RatesGET2 creditsUnemployment Rates in Google SheetsGet Unemployment Rate by CountryGET2 creditsUS Jobs Report in Google SheetsUS Employment StatisticsGET2 creditsUS National Debt in Google SheetsUS National Debt TrackerGET2 creditsUS Trade Balance in Google SheetsUS International Trade DataGET2 creditsVAT Rates in Google SheetsLook up VAT rates by countryGET2 credits

Text Processing 42

Add Emojis to Text in SheetsDecorate text with emojisPOST2 creditsAnalyze Words in Google SheetsAnalyze wordsGET2 creditsCalculate Reading Time in Google SheetsCalculate estimated reading time for textPOSTCheck Grammar in Google SheetsCheck grammar and spellingPOST20 creditsCheck Palindromes in Google SheetsCheck if text is a palindromeGETCheck Spelling in Google SheetsCheck spellingPOST10 creditsConvert Tense in Google SheetsConvert text to past, present or future tensePOST2 creditsConvert Titles to Title Case in SheetsConvert Titles to Various CasesPOSTCorrect Spelling in Google SheetsCorrect spelling mistakesGET20 creditsCount Syllables in Google SheetsCount syllables in words and textPOSTCount Vowels in Google SheetsCount vowels and consonants in textPOSTDetect Anagrams in Google SheetsDetect if two texts are anagramsGETDetect Gibberish in Google SheetsDetect gibberish text using n-gramsPOST2 creditsEdit Distance in Google SheetsCalculate edit distance between stringsPOSTExpand Acronyms in Google SheetsExpand acronyms to their full meaningsGET10 creditsExtract Keywords in Google SheetsExtract keywords from textPOST10 creditsExtract Markdown Links in SheetsExtract all links from markdown documentsPOST2 creditsExtract Parts of Speech in SheetsExtract nouns, verbs, adjectives, adverbs, etc.POST2 creditsFilter Profanity in Google SheetsFilter profane wordsPOST2 creditsFind Antonyms in Google SheetsGet antonyms of a wordGET20 creditsFind Rhyming Words in Google SheetsGet word rhymesGET2 creditsFind Word Opposites in SheetsGet opposites of a wordGET20 creditsLanguage Name & ISO Code in Google SheetsDetect language from textPOST2 creditsLeet Speak in Google SheetsEncode and decode Leet SpeakPOSTLemmatize Text in Google SheetsLemmatize textPOST2 creditsMask Sensitive Data in Google SheetsDetect and mask sensitive dataPOST10 creditsPhonetic Codes in Google SheetsSoundex and Metaphone EncodingGET2 creditsPig Latin in Google SheetsEncode Pig LatinPOSTReadability Score in Google SheetsCalculate readability scorePOST2 creditsRemove Punctuation in Google SheetsRemove punctuation from textPOSTReverse Text in Google SheetsReverse text by characters, words, or linesPOSTSlugify Text in Google SheetsConvert text to URL-friendly slugsPOSTSort Lines of Text in Google SheetsSort lines of text alphabeticallyPOSTStyle Text in Google SheetsStyle text in various waysPOSTSummarize Text in Google SheetsSummarize textPOST20 creditsText Similarity in Google SheetsCheck text similarityPOST2 creditsText to Emoji in Google SheetsConvert text to emojiPOST2 creditsTranslate Text in Google SheetsTranslate textPOST40 creditsValidate ISBNs in Google SheetsValidate and parse ISBN numbersGET2 creditsValidate Tax IDs in Google SheetsValidate US Tax IDs (SSN, EIN, ITIN)GET10 creditsWebsite Readability in Google SheetsAnalyze Website ReadabilityPOST25 creditsWord Pronunciation in Google SheetsGet word pronunciationGET2 credits

Data Generation 22

Data Conversion 22

Base64 Encode in a CellEncode and decode Base64 stringsGETConvert Color Formats in Google SheetsConvert color formatsGETConvert CSV to JSON in a CellConvert CSV data to JSON formatPOSTConvert JSON to CSV in a CellConvert JSON data to CSV formatPOSTConvert Meeting Times in Google SheetsConvert meeting times across timezonesGETConvert Number Bases in Google SheetsConvert numbers between different basesGETConvert Units in Google SheetsConvert unitsGETConvert Unix Timestamps in SheetsConvert between Unix timestamps and human-readable datesGETConvert Words to Numbers in Google SheetsConvert words to numbersGETConvert XML to JSON in SheetsConvert XML to JSONPOSTEncode ASCII85 in Google SheetsEncode/decode ASCII85 (Base85) dataGETEncode HTML Entities in SheetsEncode and decode HTML entitiesPOSTEscape Unicode in Google SheetsEscape and unescape Unicode charactersPOSTFormat File Sizes in Google SheetsConvert bytes to human-readable file sizesGETMath Calculator in Google SheetsMathematical operations and number utilitiesPOSTNumbers to Words in Google SheetsConvert numbers to wordsGETPlaceholder Text in Google SheetsGenerate placeholder text in multiple stylesGETRelative Time in Google SheetsConvert dates to relative time (e.g., '2 hours ago')GETRoman Numerals in Google SheetsConvert between numbers and Roman numeralsGETText to Color in Google SheetsConvert Color from Natual LanguageGETURL Encode & Decode in SheetsEncode and decode URL stringsPOSTWebsite to Text in Google SheetsConvert website to textPOST25 credits

Data Lookup 19

Domain Data 19

Networking 14

Geography 14

Transportation 13

Reference Data 13

Data Validation 10

Weather 9

Math/Calculations 8

Astrology 7

Calendar 5

Data Scraping 5

Data Processing 5

AI/Computer Vision 4

Science 4

Health/Wellness 3

Food 3

Lifestyle 3

Parsers 3

News 1

Next

Pick anything above and its reference page has a working call you can paste. If you have not made one yet, quickstart is the fastest route there.

For many rows at once, pass a range rather than copying a formula down — one call instead of one per row. See formulas.

Terms used across these pages are defined in the glossary.

Was this page helpful?

Last updated