Formulas for
The Source Directory

279 sources you can pull into any cell.

Every source below is one =VERVE() call away — pass a name and plain arguments, get a live value. Find one, copy its formula, paste it into a cell in Google Sheets.

279 live sources24 categoriesIn Google SheetsOne key
All 279 sourcesclick any formula to copy

Finance

49
Balance SheetFinance6 cr
=VERVE("balancesheet", "AAPL", "field", "company")
Benchmark RatesFinance2 cr
=VERVE("benchmarkrate", "SOFR", "field", "name")
BIN LookupFinance10 cr
=VERVE("binlookup", "448590", "field", "brand")
=VERVE("incometaxcalculator", 85000, 22, "field", "year")
=VERVE("loanpaymentcalculator", 32000, 8.5, 6, "field", "downpayment")
=VERVE("mortgagecalculator", 570000, 6.8, 30, "field", "downpayment")
=VERVE("salestaxcalculator", 100, "90210", "field", "taxRate")
=VERVE("cashflow", "AAPL", "field", "company")
=VERVE("interestrate", "US", "field", "countryName")
Company EarningsFinance6 cr
=VERVE("earnings", "ADBE", "field", "company")
Company LookupFinance2 cr
=VERVE("companylookup", "AAPL")
Convert CurrencyFinance2 cr
=VERVE("currencyconverter", 1, "USD", "EUR", "field", "convertedValue")
Cost of LivingFinance2 cr
=VERVE("costliving", "California", "field", "from.searchedLocation")
Country GDPNewFinance2 cr
=VERVE("gdp", "US", "field", "countryName")
CPI InflationFinance2 cr
=VERVE("cpiinflation", "field", "yearMonth")
Currency SymbolsFinance2 cr
=VERVE("currencysymbols", "USD")
DividendsFinance6 cr
=VERVE("dividends", "AAPL", "field", "cik")
=VERVE("exchangerate", "USD", "EUR", "field", "exchangeRate")
Financial RatiosFinance6 cr
=VERVE("financialratios", "AAPL", "field", "company")
=VERVE("globalstockmarket", "DE", "field", "countryName")
I-Bond RatesFinance2 cr
=VERVE("savingsbonds", "field", "iBonds.currentRate")
IFSC LookupFinance10 cr
=VERVE("ifsclookup", "SBIN0005943", "field", "bank")
Income StatementFinance6 cr
=VERVE("incomestatement", "AAPL", "field", "company")
=VERVE("incometax", "US", "field", "year")
Inflation RatesFinance2 cr
=VERVE("inflation", "US", "field", "countryName")
Insider TradingFinance6 cr
=VERVE("insidertrading", "AAPL", "field", "cik")
=VERVE("bitcoin", "field", "currency")
=VERVE("ethereum", "field", "currency")
Live Gold PriceFinance2 cr
=VERVE("goldprice", "field", "currency")
=VERVE("palladiumprice", "field", "currency")
=VERVE("platinumprice", "field", "currency")
=VERVE("silverprice", "field", "currency")
=VERVE("stockmarketopentimes", "NYSE", "field", "fullName")
Minimum WageFinance2 cr
=VERVE("minimumwage", "CA", "field", "stateName")
Mortgage RatesFinance2 cr
=VERVE("mortgagerate", "30year", "field", "rateType")
=VERVE("sanctionscreening", "Banco Nacional de Cuba", "field", "query")
=VERVE("population", "US", "field", "countryName")
Purchasing PowerFinance2 cr
=VERVE("purchasingpower", 100, "1990", "field", "originalAmount")
=VERVE("routinglookup", "121000358", "field", "routing_number")
Sales Tax RatesFinance2 cr
=VERVE("salestax", "64082", "field", "state")
SEC FilingsFinance6 cr
=VERVE("secfilings", "AAPL", "field", "cik")
=VERVE("stockexchange", "XNYS")
SWIFT Code LookupFinance10 cr
=VERVE("swiftlookup", "CHASUS33ARP")
Treasury YieldsFinance2 cr
=VERVE("treasuryyields", "field", "date")
=VERVE("unemployment", "USA", "field", "countryName")
US Jobs ReportFinance2 cr
=VERVE("jobsreport", "field", "yearMonth")
US National DebtFinance2 cr
=VERVE("nationaldebt", "field", "date")
US Trade BalanceFinance2 cr
=VERVE("tradebalance", "field", "yearMonth")
VAT RatesNewFinance2 cr
=VERVE("vatrates", "DE", "field", "countryName")

Text Processing

42
Add Emojis to TextText Processing2 cr
=VERVE("emojidecorator", "I am so excited to go to the lake and swim")
Analyze WordsText Processing2 cr
=VERVE("lexicon", "listen", "field", "isAlphagram")
Calculate Reading TimeText Processing2 cr
=VERVE("readingtime", "This is a sample article with multiple paragraphs. Reading time will be calculated based on word count. The average reading speed is 250 words per minute, which can be customized. This helps content creators provide accurate time estimates to their readers.", "field", "text_length")
Check GrammarText Processing20 cr
=VERVE("grammarcheck", "The the pig snorted when I saw it on the barn gate. I was a little mad becuase it woke up my pupppppy", "field", "modified")
Check PalindromesText Processing2 cr
=VERVE("palindromechecker", "A man a plan a canal Panama", "field", "is_palindrome")
Check SpellingText Processing10 cr
=VERVE("spellchecker", "I neeed to call my friend on telephine today!", "field", "spellPass")
Convert TenseText Processing2 cr
=VERVE("tenseconverter", "I am walking down the street, and I can see a dog", "past", "field", "result")
Convert Titles to Title CaseText Processing2 cr
=VERVE("titlecapitalization", "comprehensive analysis of quarterly financial performance and strategic initiatives for sustainable growth", "title-case", "field", "style")
Correct SpellingText Processing20 cr
=VERVE("didyoumean", "what weather today is")
Count SyllablesText Processing2 cr
=VERVE("syllablecounter", "The quick brown fox jumps over the lazy dog", "field", "total_syllables")
Count VowelsText Processing2 cr
=VERVE("vowelcounter", "The quick brown fox jumps over the lazy dog. This pangram contains every letter of the alphabet at least once.", "field", "vowels")
Detect AnagramsText Processing2 cr
=VERVE("anagramdetector", "listen", "silent", "field", "is_anagram")
Detect GibberishText Processing2 cr
=VERVE("gibberishdetector", "The quick brown fox jumps over the lazy dog", "field", "isGibberish")
Detect LanguageText Processing2 cr
=VERVE("textlanguage", "Ceci est un exemple de texte. Il peut détecter la langue", "field", "language")
Edit DistanceText Processing2 cr
=VERVE("levenshteindistance", "kitten", "sitting", "field", "distance")
Expand AcronymsText Processing10 cr
=VERVE("acronymexpander", "API", "field", "most_common.expansion")
Extract KeywordsText Processing10 cr
=VERVE("keywordextractor", "Machine learning is a subset of artificial intelligence that enables systems to learn from data. Deep learning uses neural networks to process complex patterns in data.", "field", "url")
Extract Markdown LinksText Processing2 cr
=VERVE("markdownlinkextractor", "# Sample Document"&CHAR(10)&""&CHAR(10)&"Check out [this link](https://example.com) and [another one](https://test.com)."&CHAR(10)&""&CHAR(10)&"![Image](https://example.com/image.png)"&CHAR(10)&""&CHAR(10)&"Visit <https://autolink.com> or just https://bare-url.com"&CHAR(10)&""&CHAR(10)&"[Reference link][ref1]"&CHAR(10)&""&CHAR(10)&"[ref1]: https://reference.com", "field", "totalLinks")
Extract Parts of SpeechText Processing2 cr
=VERVE("partsofspeech", "My friend from college hails from a small countryside village located at the heart of the state. During the last summer vacation, I had an opportunity to visit my friend in his village. I packed up my belongings and boarded the bus bound for the village", "verbs", "field", "count")
Filter ProfanityText Processing2 cr
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "field", "isProfane")
Find AntonymsText Processing20 cr
=VERVE("antonym", "happy", "field", "language")
Find Rhyming WordsText Processing2 cr
=VERVE("wordrhymes", "blue", "field", "rhymeCount")
Find Word OppositesText Processing20 cr
=VERVE("wordopposite", "hot")
Leet SpeakText Processing2 cr
=VERVE("leetspeak", "This is a simple piece of text", "encode", "field", "changedCharacters")
Lemmatize TextText Processing2 cr
=VERVE("lemmatizer", "The cats ran from door to door", "field", "found")
Mask Sensitive DataText Processing10 cr
=VERVE("datamasking", "Contact John Doe at [email protected] or call 555-123-4567. His SSN is 123-45-6789.", "field", "masked")
Phonetic CodesText Processing2 cr
=VERVE("phonetic", "smith", "field", "soundex")
Pig LatinText Processing2 cr
=VERVE("piglatin", "The square wooden crate was packed to be shipped. To have is better than to wait and hope.")
Readability ScoreText Processing2 cr
=VERVE("readabilityscore", "Western astrology is founded on the movements and relative positions of celestial bodies such as the Sun, Moon and planets, which are analysed by their movement through signs of the zodiac (twelve spatial divisions of the ecliptic) and by their aspects (based on geometric angles) relative to one another.", "field", "textCounts.syllableCount")
Remove PunctuationText Processing2 cr
=VERVE("removepunctuation", "Hello, world! How are you doing today? I'm great - thanks for asking. This text has lots of punctuation: periods, commas, hyphens & more!", "field", "cleaned")
Reverse TextText Processing2 cr
=VERVE("reversetext", "Hello World", "field", "reversed")
Slugify TextText Processing2 cr
=VERVE("slugify", "Hello World! This is a Test & Example", "field", "original")
Sort Lines of TextText Processing2 cr
=VERVE("linesorter", "[""The quick brown fox jumps over the lazy dog"",""An apple a day keeps the doctor away"",""banana"",""Cherry blossoms bloom in spring"",""date""]", "field", "lineCount")
Style TextText Processing2 cr
=VERVE("textstyler", "This is a very stylish piece of text", "bubbles", "field", "text")
Summarize TextText Processing20 cr
=VERVE("textsummarizer", "A news article can include accounts of eyewitnesses to the happening event. It can contain photographs, accounts, statistics, graphs, recollections, interviews, polls, debates on the topic, etc. Headlines can be used to focus the reader's attention on a particular (or main) part of the article. The writer can also give facts and detailed information following answers to general questions like who, what, when, where, why and how.", "field", "summary")
Text SimilarityText Processing2 cr
=VERVE("textsimilarity", "I'm so excited that tomorrow is going to be sunny! Can't wait!", "We're pretty excited about the weather tomorrow. It's going to be sunny!", "field", "simiarity")
Text to EmojiText Processing2 cr
=VERVE("texttoemoji", "I am so excited to go to the lake and swim")
Translate TextText Processing40 cr
=VERVE("translator", "I'm so excited that tomorrow is going to be sunny! Can't wait!", "es", "field", "sourceLang")
Validate ISBNsText Processing2 cr
=VERVE("isbnvalidator", "978-0-306-40615-7", "field", "valid")
Validate Tax IDsText Processing10 cr
=VERVE("taxidvalidator", "123-45-6789", "field", "valid")
Website ReadabilityText Processing10 cr
=VERVE("websitereadability", "https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/concepts", "field", "fleschReadingEase")
Word PronunciationText Processing2 cr
=VERVE("wordpronunciation", "hello", "field", "pronounciation")

Data Conversion

22
Base64 EncodeData Conversion2 cr
=VERVE("base64", "Hello World", "field", "action")
Convert Color FormatsData Conversion2 cr
=VERVE("colorconverter", "FF0000", "field", "rgb")
Convert CSV to JSONData Conversion2 cr
=VERVE("csvtojson", "name,age,city"&CHAR(10)&"John Doe,30,New York"&CHAR(10)&"Jane Smith,25,Los Angeles", "field", "row_count")
Convert JSON to CSVData Conversion2 cr
=VERVE("jsontocsv", "[{""name"":""John Doe"",""age"":30,""city"":""New York""},{""name"":""Jane Smith"",""age"":25,""city"":""Los Angeles""}]", "field", "row_count")
Convert Meeting TimesData Conversion2 cr
=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "originalTime")
Convert Number BasesData Conversion2 cr
=VERVE("numberbaseconverter", "255", "field", "input_value")
Convert UnitsData Conversion2 cr
=VERVE("unitconverter", 100, "lb", "kg", "field", "result.result")
Convert Unix TimestampsData Conversion2 cr
=VERVE("unixtimestamp", "1609459200", "field", "timestamp_format")
Convert Words to NumbersData Conversion2 cr
=VERVE("wordstonumbers", "seven thousand six hundred and twenty", "field", "number")
Convert XML to JSONData Conversion2 cr
=VERVE("xmltojson", "<?xml version=""1.0"" encoding=""UTF-8""?>"&CHAR(10)&"<note>"&CHAR(10)&" <to>Tove</to>"&CHAR(10)&" <from>Jani</from>"&CHAR(10)&" <heading>Reminder</heading>"&CHAR(10)&" <body>Don't forget me this weekend!</body>"&CHAR(10)&"</note>")
Encode ASCII85Data Conversion2 cr
=VERVE("ascii85encoder", "Hello World", "field", "original_text")
Encode HTML EntitiesData Conversion2 cr
=VERVE("htmlentities", "<div class=""test"">Hello & World</div>", "field", "action")
Escape UnicodeData Conversion2 cr
=VERVE("unicodeescape", "Hello World", "field", "action")
Format File SizesData Conversion2 cr
=VERVE("filesizeformatter", 1073741824, "field", "formatted")
Math CalculatorData Conversion2 cr
=VERVE("math", "add", 10, 5, "field", "result")
Numbers to WordsData Conversion2 cr
=VERVE("numbertowords", 975.07, "field", "words")
Placeholder TextData Conversion2 cr
=VERVE("placeholdertext", "field", "style")
Relative TimeData Conversion2 cr
=VERVE("relativetimeformatter", "1609459200", "field", "target_date")
Roman NumeralsData Conversion2 cr
=VERVE("romanconverter", 2024, "field", "roman")
Text to ColorData Conversion2 cr
=VERVE("texttocolor", "turquoise", "field", "hex")
URL Encode & DecodeData Conversion2 cr
=VERVE("urlencode", "Hello World & Goodbye", "field", "action")
Website to TextData Conversion10 cr
=VERVE("websitetotext", "https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/concepts", "field", "description")

Data Generation

22
Generate AcronymsData Generation2 cr
=VERVE("acronymgenerator", "Application Programming Interface")
Generate Baby NamesData Generation2 cr
=VERVE("babynamegenerator", "male")
Generate Bingo CardsData Generation2 cr
=VERVE("bingocardgenerator", "field", "size")
Generate Boggle BoardsData Generation2 cr
=VERVE("boggleboardgenerator", "field", "size")
Generate Color PalettesData Generation2 cr
=VERVE("colorpalette", "FF5733", "field", "source")
Generate CommentsData Generation2 cr
=VERVE("commentgenerator", "text", "field", "count")
Generate Company NamesData Generation2 cr
=VERVE("companynamegenerator", "systems", "field", "count")
Generate CUIDsData Generation2 cr
=VERVE("cuidgenerator", "field", "count")
Generate GUIDsData Generation2 cr
=VERVE("guidgenerator", "field", "count")
Generate HashtagsData Generation2 cr
=VERVE("hashtaggenerator", "Adventure awaits 🌍✈️ Who's ready to embark on a journey of a lifetime? Whether you're exploring exotic landscapes, immersing yourself in vibrant cultures, or simply indulging in delicious cuisines, there's something magical about travel that fills the soul with joy and wonder. Let's wander together and create unforgettable memories! 🌟")
Generate InitialismsData Generation2 cr
=VERVE("initialismgenerator", "Application Programming Interface", "field", "initialism")
Generate Lorem IpsumData Generation2 cr
=VERVE("loremipsumgenerator", "field", "words")
Generate PasswordsData Generation2 cr
=VERVE("passwordgenerator", 10, 12, "strong")
Generate Random DataData Generation2 cr
=VERVE("randomgenerator", "number", "field", "count")
Generate Random UsersData Generation2 cr
=VERVE("randomusergenerator", "field", "id")
Generate Short CodesData Generation2 cr
=VERVE("shortcodegenerator", "field", "count")
Generate Test CardsData Generation2 cr
=VERVE("cardgenerator", "visa", "field", "count")
Generate Test IdentitiesData Generation2 cr
=VERVE("randomidentitygenerator")
Generate ULIDsData Generation2 cr
=VERVE("ulidgenerator", "field", "count")
Generate UsernamesData Generation2 cr
=VERVE("usernamegenerator", "[email protected]", "field", "count")
Generate UUIDsData Generation2 cr
=VERVE("uuidgenerator", "field", "count")
Random WordsData Generation2 cr
=VERVE("randomwords", "field", "word")

Domain Data

18
Check DNS PropagationDomain Data30 cr
=VERVE("dnspropagation", "google.com", "field", "recordType")
=VERVE("domainavailability", "myspace.com", "field", "available")
Check SSL CertificatesDomain Data10 cr
=VERVE("sslchecker", "ebay.com", "field", "subject.C")
DNS LookupDomain Data6 cr
=VERVE("dnslookup", "myspace.com", "field", "summary.hasIPv6")
DNSSEC CheckDomain Data10 cr
=VERVE("dnsseccheck", "cloudflare.com", "field", "dnssecEnabled")
Domain ExpirationDomain Data10 cr
=VERVE("domainexpiration", "myspace.com", "field", "daysToExpiration")
Find SubdomainsNewDomain Data100 cr
=VERVE("subdomainfinder", "google.com", "field", "rootDomain.domain")
Get Page TitlesDomain Data10 cr
=VERVE("urltitle", "https://blog.apiverve.com/chuck-norris-api-how-to")
MX LookupDomain Data10 cr
=VERVE("mxlookup", "yahoo.com")
=VERVE("fullyqualifieddomain", "199.30.24.0", "field", "baseDomain")
Reverse DNS LookupDomain Data10 cr
=VERVE("reversednslookup", "8.8.8.8", "field", "hostname")
Unshorten URLsDomain Data10 cr
=VERVE("urlunshortener", "https://bit.ly/3k3j4", "field", "source")
URL Location LookupDomain Data10 cr
=VERVE("urllookup", "https://www.merriam-webster.com/dictionary/documentation", "field", "country")
Validate BIMI RecordsNewDomain Data10 cr
=VERVE("bimivalidator", "ebay.com", "field", "host")
Validate DKIMNewDomain Data10 cr
=VERVE("dkimvalidator", "google.com", "field", "selector")
Validate DMARCNewDomain Data10 cr
=VERVE("dmarcvalidator", "paypal.com", "field", "host")
Validate SPF RecordsNewDomain Data10 cr
=VERVE("spfvalidator", "myspace.com", "field", "host")
WHOIS LookupDomain Data8 cr
=VERVE("whoislookup", "myspace.com", "field", "domainName")

Data Lookup

17
ASN LookupData Lookup4 cr
=VERVE("asnlookup", "AS15169", "field", "simple")
Bible VersesData Lookup2 cr
=VERVE("bible", "Genesis", "KJV", 5, "field", "text")
Country Calling CodesData Lookup2 cr
=VERVE("callingcode", "FR", "field", "officialName")
Current TimeData Lookup2 cr
=VERVE("worldtime", "San Francisco")
Detect GenderData Lookup2 cr
=VERVE("genderdetector", "John Mcdonald", "field", "country")
Dog Breed LookupData Lookup2 cr
=VERVE("dogbreeds", "beagle", "field", "foundCount")
Emoji LookupData Lookup2 cr
=VERVE("emoji", "🥳")
Find SynonymsData Lookup2 cr
=VERVE("thesaurus", "big", "field", "similarCount")
Gravatar LookupData Lookup2 cr
=VERVE("gravatarlookup", "[email protected]", "field", "profileUrl")
IP DemographicsData Lookup10 cr
=VERVE("ipdemographics", "173.172.81.20", "field", "location.zip")
License LookupData Lookup2 cr
=VERVE("openlicenses", "MIT", "field", "domain_content")
Lottery NumbersData Lookup2 cr
=VERVE("lottery", "powerball", "field", "lotteryType")
Nobel Prize LookupData Lookup2 cr
=VERVE("nobelprizes")
Timezone LookupData Lookup2 cr
=VERVE("timezonelookup", "Harare", "field", "timezone")
Unicode LookupData Lookup2 cr
=VERVE("unicodelookup", "👋", "field", "codepoint")
Word DefinitionsData Lookup2 cr
=VERVE("dictionary", "apple", "field", "definitionCount")
ZIP DemographicsData Lookup10 cr
=VERVE("zipdemographics", "90210", "field", "name")

Networking

14
Check Phishing URLsNewNetworking10 cr
=VERVE("phishingcheck", "centruldepiele.ro", "field", "isPhishing")
Check TLS SupportNewNetworking2 cr
=VERVE("tlscheck", "amazon.com", "field", "tlsVersions.TLSv1")
Check URL SafetyNewNetworking2 cr
=VERVE("contentfilter", "https://www.pornhub.com/video/123", "field", "domain")
Detect BotsNewNetworking10 cr
=VERVE("botdetector", "Googlebot/2.1 (+http://www.google.com/bot.html)", "field", "userAgent")
Detect Tor NodesNewNetworking10 cr
=VERVE("tordetect", "185.189.183.143", "field", "ipAddress")
Detect VPNsNetworking10 cr
=VERVE("vpndetector", "103.62.49.210", "field", "is_vpn")
IP Blacklist CheckNetworking10 cr
=VERVE("ipblacklistlookup", "185.220.101.1", "field", "ipAddress")
IP LookupNetworking10 cr
=VERVE("iplookup", "173.172.81.20", "field", "country")
=VERVE("bluetoothlookup", "76", "field", "companyIdHex")
Look Up NameserversNetworking10 cr
=VERVE("nameservers", "google.com", "field", "nameserverCount")
MAC Address LookupNetworking2 cr
=VERVE("macaddresslookup", "00-B0-D0-63-C2-26", "field", "isValid")
Ping HostsNetworking2 cr
=VERVE("pinger", "google.com", "field", "alive")
TLD LookupNewNetworking2 cr
=VERVE("tldlookup", "com", "field", "found")
USB Vendor LookupNetworking2 cr
=VERVE("usbvendorlookup", "05AC", "field", "productId")

Geography

13
Calculate DistanceGeography2 cr
=VERVE("distancecalculator", 36.7783, -119.4179, 34.0522, -118.2437, "field", "distanceMiles")
=VERVE("coordinatesaresea", 37.7749, -122.4194, "field", "latitude")
Country BordersGeography2 cr
=VERVE("countryborders", "CA", "field", "cca2")
Country BoundariesGeography10 cr
=VERVE("countryboundaries", "CA")
Country FlagsGeography2 cr
=VERVE("countryflags", "ZW", "png", "circle", "field", "countryCode")
Country LanguagesGeography2 cr
=VERVE("countrylanguages", "ZW", "field", "name")
Country LookupGeography2 cr
=VERVE("countrylookup", "USA")
Look Up City DataGeography2 cr
=VERVE("citieslookup", "San Francisco")
Reverse GeocodeGeography6 cr
=VERVE("reversegeocode", 40.714224, -73.961452, "field", "zipcode")
State BoundariesGeography10 cr
=VERVE("stateboundaries", "CA")
US County DataGeography10 cr
=VERVE("countydata", "MO", "Jackson", "field", "name")
USDA Hardiness ZoneGeography2 cr
=VERVE("hardinesszone", "97201", "field", "zipCode")
Zip Code LookupGeography2 cr
=VERVE("zipcodes", "64082", "field", "zipcode")

Reference Data

11
Birthstone LookupReference Data2 cr
=VERVE("birthstones", "5")
Color BrightnessReference Data2 cr
=VERVE("colorbrightness", "FF5733", "field", "rgb.r")
Convert Ring SizesReference Data2 cr
=VERVE("ringsizeconverter", "7", "us", "field", "input_diameter_mm")
Convert Shoe SizesReference Data2 cr
=VERVE("shoesizeconverter", "9", "us", "field", "input_size")
HTTP Status LookupReference Data2 cr
=VERVE("httpstatuslookup", 404, "field", "name")
Mayan CalendarReference Data2 cr
=VERVE("mayancalendar", "2024-12-21", "field", "gregorian")
MIME Type LookupReference Data2 cr
=VERVE("mimetypelookup", "pdf", "field", "mime_type")
Name Hex ColorsReference Data2 cr
=VERVE("colornamefinder", "FF5733", "field", "input_hex")
Parse CAA RecordsReference Data2 cr
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue ""letsencrypt.org""", "field", "raw_record")
Parse SRV RecordsReference Data2 cr
=VERVE("srvparser", "_http._tcp.example.com. 86400 IN SRV 10 60 80 server.example.com.", "field", "raw_record")
Port Number LookupReference Data2 cr
=VERVE("portnumberlookup", 443)

Data Validation

9
Check Disposable EmailsData Validation6 cr
=VERVE("emaildisposablechecker", "[email protected]", "field", "isDisposable")
Check Disposable PhonesNewData Validation6 cr
=VERVE("disposablephone", "+12085813945", "field", "isDisposable")
Check Password StrengthData Validation2 cr
=VERVE("passwordstrength", "Password123", "field", "strength")
Check UsernamesData Validation2 cr
=VERVE("usernameprofanity", "b00bs", "field", "isProfane")
Detect SpamData Validation10 cr
=VERVE("spamdetector", "Can you please spare some change?! Desperate!!! Send cash", "field", "likelySpam")
Validate Card NumbersData Validation2 cr
=VERVE("cardvalidator", "4900264223817524", "field", "card.niceType")
Validate EmailsData Validation20 cr
=VERVE("emailvalidator", "[email protected]", "field", "domain")
Validate Phone NumbersData Validation10 cr
=VERVE("phonenumbervalidator", "816-555-1017", "us", "field", "detectedCountry")
Validate SEOData Validation10 cr
=VERVE("seovalidator", "https://apiverve.com", "field", "passed")

Math/Calculations

8
Compare ColorsMath/Calculations2 cr
=VERVE("colorsimilarity", "FF5733", "FF6B47", "field", "color1.hex")
Convert UTM CoordinatesMath/Calculations2 cr
=VERVE("utmconverter", 40.7128, -74.006, "field", "conversion")
Daylight HoursMath/Calculations2 cr
=VERVE("daylightduration", 40.7128, -74.006, "field", "date")
Fibonacci SequenceMath/Calculations2 cr
=VERVE("fibonaccigenerator", 10, "field", "start_from")
Permutations & CombinationsMath/Calculations2 cr
=VERVE("permutationcombination", 10, 3, "field", "permutation")
Roman Numeral MathMath/Calculations2 cr
=VERVE("romannumeralmath", "XIV", "VI", "field", "roman1_value")
Tip CalculatorMath/Calculations2 cr
=VERVE("tipcalculator", 100, "field", "bill_amount")
Truth TablesMath/Calculations2 cr
=VERVE("truthtable", "A AND B OR C", "field", "normalized")

Weather

8
Air QualityWeather10 cr
=VERVE("airquality", "San Francisco", "field", "pm2_5")
=VERVE("earthquake", "field", "earthquakes_LastUpdated")
Live WeatherWeather10 cr
=VERVE("weatherforecast", "San Francisco", "field", "tempC")
Marine WeatherWeather10 cr
=VERVE("marineweather", 29.48003, -37.62424, "field", "location.lat")
=VERVE("moonrisemoonset", 37.7749, -122.4194, "field", "coordinates.latitude")
Season DatesWeather2 cr
=VERVE("weatherseasons", "field", "year")
Solar PotentialWeather2 cr
=VERVE("solarpotential", 37.7749, -122.4194, "field", "coordinates.latitude")
Sunrise & SunsetWeather2 cr
=VERVE("sunrisesunset", 36.72016, -4.42034, "field", "sunrise")

Astrology

6
Chinese ZodiacAstrology2 cr
=VERVE("chinesezodiac", "1990-01-15", "field", "zodiacYear")
Daily HoroscopeAstrology2 cr
=VERVE("horoscope", "aries", "field", "horoscope")
Moon PhasesAstrology2 cr
=VERVE("moonphases", "field", "phase")
Moon PositionAstrology2 cr
=VERVE("moonposition", 37.7749, -122.4194, "field", "date")
Planet PositionsNewAstrology2 cr
=VERVE("planetpositions", 37.7749, -122.4194, "Moon", "field", "isBelowHorizon")
Sun PositionAstrology2 cr
=VERVE("sunposition", 37.7749, -122.4194, "field", "date")

Transportation

6
Airline LookupTransportation2 cr
=VERVE("airlinelookup", "AA", "field", "name")
Airport DistanceNewTransportation2 cr
=VERVE("airportdistance", "JFK", "LAX", "field", "distanceMiles")
Airport LookupTransportation2 cr
=VERVE("airports", "MCI", "field", "icao")
Convert Airport CodesNewTransportation2 cr
=VERVE("airportcodeconverter", "MCI", "field", "input")
Decode VINsTransportation10 cr
=VERVE("vindecoder", "1HGCM82633A004352", "field", "valid")
Look Up Car ModelsTransportation2 cr
=VERVE("carmodels", "Toyota")

Calendar

5
Calculate AgeCalendar2 cr
=VERVE("agecalculator", "1990-08-02", "field", "age_breakdown.years")
Date DifferencesCalendar2 cr
=VERVE("datecalculator", "2022-01-01", "2024-08-31", "field", "minutes")
=VERVE("liturgicalcalendar")
Working DaysCalendar2 cr
=VERVE("workingdays", "US", "field", "workingDaysCount")
World HolidaysCalendar2 cr
=VERVE("worldholidays", "US", "field", "year")

Data Processing

5
Cloud CounterData Processing2 cr
=VERVE("counter", "test_counter", "field", "created")
Convert HTML to TextData Processing2 cr
=VERVE("htmltotext", "<!doctype html> <html> <head> <title>This is the title of the webpage!</title> </head> <body> <p>This is an example paragraph. Anything in the <strong>body</strong> tag will appear on the page, just like this <strong>p</strong> tag and its contents.</p> </body> </html>", "field", "text")
Explain SQLNewData Processing10 cr
=VERVE("sqlexplainer", "SELECT u.name, COUNT(o.id) as order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.created_at > '2024-01-01' GROUP BY u.id HAVING COUNT(o.id) > 5 ORDER BY order_count DESC", "field", "explanation")
Extract Page MetadataData Processing2 cr
=VERVE("metadataextractor", "https://apiverve.com", "field", "requestUrl")
Morse CodeNewData Processing2 cr
=VERVE("morsecode", "This Is A Message", "field", "morse")

AI/Computer Vision

4
Analyze SentimentAI/Computer Vision10 cr
=VERVE("sentimentanalysis", "I'm so excited that tomorrow is going to be sunny! Can't wait!", "field", "comparative")
Detect Code LanguageAI/Computer Vision20 cr
=VERVE("codedetector", "a = 5"&CHAR(10)&"b = 6"&CHAR(10)&"c = 7"&CHAR(10)&""&CHAR(10)&"# calculate the semi-perimeter"&CHAR(10)&"s = (a + b + c) / 2"&CHAR(10)&""&CHAR(10)&"# calculate the area"&CHAR(10)&"area = (s*(s-a)*(s-b)*(s-c)) ** 0.5"&CHAR(10)&"print('The area of the triangle is %0.2f' %area)", "field", "current")
Detect LanguageAI/Computer Vision2 cr
=VERVE("languagedetector", "esta es una frase en español. esta API puede detectar fácilmente el idioma", "field", "primaryLanguage")
Generate Article IdeasAI/Computer Vision20 cr
=VERVE("articleideas", "software and technology", "field", "topicIdeas")

Data Scraping

4
Extract ContactsData Scraping10 cr
=VERVE("contactextractor", "https://en.wikipedia.org/wiki/Email_address", -1, "field", "emailCount")
Scrape Page LinksData Scraping10 cr
=VERVE("linkscraper", "https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/concepts.html", 20, "field", "linkCount")
Scrape SEO DataData Scraping10 cr
=VERVE("seoscraper", "https://apiverve.com", "field", "requestUrl")
Scrape Website ImagesData Scraping10 cr
=VERVE("webimagescraper", "https://en.wikipedia.org/wiki/Solar_System", "field", "imageCount")

Science

4
=VERVE("julianday", "2024-03-15", "field", "gregorian")
=VERVE("meteorites", "Allende")
Periodic TableScience2 cr
=VERVE("periodictable", "hydrogen")
Star LookupScience2 cr
=VERVE("starslookup", "Sirius", "field", "starName")

Food

3
=VERVE("cocktail", "martini", "field", "count")
=VERVE("recipe", "chicken fajitas", "field", "description")
=VERVE("nutrition", "banana", "field", "fdcId")

Lifestyle

3
Calculate OvulationLifestyle2 cr
=VERVE("ovulationcalculator", "2024-01-01", "field", "cycle_length")
=VERVE("menstrualcycle", "2024-01-01", "field", "last_period_date")
Pregnancy Due DatesLifestyle2 cr
=VERVE("duedatecalculator", "2025-06-01", "field", "calculation_method")

Parsers

3
Parse AddressesParsers2 cr
=VERVE("streetaddressparser", "1600 Amphitheatre Parkway, Mountain View, CA 90210", "field", "parsed.streetNumber")
Parse NamesParsers2 cr
=VERVE("humannameparser", "MR. MARTINO PETROS DE FLORENCE (TINO) Jr.", "field", "parsed.title")
RSS Feeds to JSONParsers10 cr
=VERVE("rsstojson", "https://www.nasa.gov/rss/dyn/breaking_news.rss", "field", "source")

Health/Wellness

2
Calculate BMIHealth/Wellness2 cr
=VERVE("bmicalculator", 180, 70, "imperial", "field", "bmi")
Exercise LookupHealth/Wellness2 cr
=VERVE("exercises", "chest")

News

1
World NewsNews6 cr
=VERVE("news", "technology", "field", "date")

Found the source you need? Add the extension, paste the formula, and your cell fills itself.

One key, every source

The same key powers every source in this directory, across Google Sheets and Excel. First calls free.

See pricing