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.

279 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 with "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 pass to "field". 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 "field" 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 49

Balance Sheet in Google SheetsGet a Company Balance Sheet by TickerGET6 creditsBenchmark Rates in Google SheetsGet LIBOR Replacement Benchmark RatesGET2 creditsBIN Lookup in Google SheetsLookup BIN Number InformationGET10 creditsCalculate Income Tax in Google SheetsCalculate Federal 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 RegionGET2 creditsCountry GDP in Google SheetsGlobal GDP data by countryGET2 creditsCPI Inflation in Google SheetsConsumer Price Index by CategoryGET2 creditsCurrency Symbols in Google SheetsGet currency symbolsGET2 creditsDividends in Google SheetsGet Company Dividend History by TickerGET6 creditsExchange Rates in Google SheetsGet exchange rate between two currenciesGET2 creditsFinancial Ratios in Google SheetsGet Key Financial Ratios for a Company by TickerGET6 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 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 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 creditsTreasury 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 textPOST2 creditsCheck Grammar in Google SheetsCheck grammar and spellingPOST20 creditsCheck Palindromes in Google SheetsCheck if text is a palindromeGET2 creditsCheck Spelling in Google SheetsCheck spellingPOST10 creditsConvert Tense in Google SheetsConvert text to past or future tensePOST2 creditsConvert Titles to Title Case in SheetsConvert Titles to Various CasesPOST2 creditsCorrect Spelling in Google SheetsCorrect spelling mistakesGET20 creditsCount Syllables in Google SheetsCount syllables in words and textPOST2 creditsCount Vowels in Google SheetsCount vowels and consonants in textPOST2 creditsDetect Anagrams in Google SheetsDetect if two texts are anagramsGET2 creditsDetect Gibberish in Google SheetsDetect gibberish text using n-gramsPOST2 creditsDetect Language in Google SheetsDetect language from textPOST2 creditsEdit Distance in Google SheetsCalculate edit distance between stringsPOST2 creditsExpand 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 creditsLeet Speak in Google SheetsEncode and decode Leet SpeakPOST2 creditsLemmatize 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 LatinPOST2 creditsReadability Score in Google SheetsCalculate readability scorePOST2 creditsRemove Punctuation in Google SheetsRemove punctuation from textPOST2 creditsReverse Text in Google SheetsReverse text by characters, words, or linesPOST2 creditsSlugify Text in Google SheetsConvert text to URL-friendly slugsPOST2 creditsSort Lines of Text in Google SheetsSort lines of text alphabeticallyPOST2 creditsStyle Text in Google SheetsStyle text in various waysPOST2 creditsSummarize 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 ReadabilityPOST10 creditsWord Pronunciation in Google SheetsGet word pronunciationGET2 credits

Data Generation 22

Generate Acronyms in Google SheetsGenerate acronyms from phrasesGET2 creditsGenerate Baby Names in Google SheetsGenerate baby namesGET2 creditsGenerate Bingo Cards in SheetsGenerate bingo cards with HTML and imagesGET2 creditsGenerate Boggle Boards in SheetsGenerate Boggle game boards with HTML and imagesGET2 creditsGenerate Color Palettes in SheetsGenerate color palettesGET2 creditsGenerate Comments in Google SheetsGenerate comments for social mediaGET2 creditsGenerate Company Names in SheetsGenerate company namesGET2 creditsGenerate CUIDs in Google SheetsGenerate collision-resistant unique identifiersGET2 creditsGenerate GUIDs in Google SheetsGenerate globally unique identifiersGET2 creditsGenerate Hashtags in Google SheetsGenerate hashtagsPOST2 creditsGenerate Initialisms in SheetsGenerate initialisms from phrasesPOST2 creditsGenerate Lorem Ipsum in Google SheetsGenerate lorem ipsum textGET2 creditsGenerate Passwords in Google SheetsGenerate passwordsGET2 creditsGenerate Random Data in SheetsGenerate random dataGET2 creditsGenerate Random Users in SheetsGenerate random user dataGET2 creditsGenerate Short Codes in SheetsGenerate short alphanumeric codesGET2 creditsGenerate Test Cards in Google SheetsGenerate test card numbersGET2 creditsGenerate Test Identities in SheetsGenerate random identitiesGET2 creditsGenerate ULIDs in Google SheetsGenerate sortable unique identifiersGET2 creditsGenerate Usernames in Google SheetsGenerate usernamesGET2 creditsGenerate UUIDs in Google SheetsGenerate universally unique identifiersGET2 creditsRandom Words in Google SheetsGet random wordsGET2 credits

Data Conversion 22

Base64 Encode in a CellEncode and decode Base64 stringsGET2 creditsConvert Color Formats in Google SheetsConvert color formatsGET2 creditsConvert CSV to JSON in a CellConvert CSV data to JSON formatPOST2 creditsConvert JSON to CSV in a CellConvert JSON data to CSV formatPOST2 creditsConvert Meeting Times in Google SheetsConvert meeting times across timezonesGET2 creditsConvert Number Bases in Google SheetsConvert numbers between different basesGET2 creditsConvert Units in Google SheetsConvert unitsGET2 creditsConvert Unix Timestamps in SheetsConvert between Unix timestamps and human-readable datesGET2 creditsConvert Words to Numbers in Google SheetsConvert words to numbersGET2 creditsConvert XML to JSON in SheetsConvert XML to JSONPOST2 creditsEncode ASCII85 in Google SheetsEncode/decode ASCII85 (Base85) dataGET2 creditsEncode HTML Entities in SheetsEncode and decode HTML entitiesPOST2 creditsEscape Unicode in Google SheetsEscape and unescape Unicode charactersPOST2 creditsFormat File Sizes in Google SheetsConvert bytes to human-readable file sizesGET2 creditsMath Calculator in Google SheetsMathematical operations and number utilitiesPOST2 creditsNumbers to Words in Google SheetsConvert numbers to wordsGET2 creditsPlaceholder Text in Google SheetsGenerate placeholder text in multiple stylesGET2 creditsRelative Time in Google SheetsConvert dates to relative time (e.g., '2 hours ago')GET2 creditsRoman Numerals in Google SheetsConvert between numbers and Roman numeralsGET2 creditsText to Color in Google SheetsConvert Color from Natual LanguageGET2 creditsURL Encode & Decode in SheetsEncode and decode URL stringsPOST2 creditsWebsite to Text in Google SheetsConvert website to textPOST10 credits

Domain Data 18

Data Lookup 17

Networking 14

Geography 13

Reference Data 11

Data Validation 9

Weather 8

Math/Calculations 8

Transportation 6

Astrology 6

Calendar 5

Data Processing 5

AI/Computer Vision 4

Data Scraping 4

Science 4

Food 3

Lifestyle 3

Parsers 3

Health/Wellness 2

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