Formulas for
The Source Directory

280 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.

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

Finance

50
Balance SheetFinance1 cr
=VERVE("balancesheet", "AAPL", "field", "company")
Benchmark RatesFinance1 cr
=VERVE("benchmarkrate", "SOFR", "field", "name")
BIN LookupFinance5 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 EarningsFinance1 cr
=VERVE("earnings", "ADBE", "field", "company")
Company LookupFinance1 cr
=VERVE("companylookup", "AAPL")
Convert CurrencyFinance1 cr
=VERVE("currencyconverter", 1, "USD", "EUR", "field", "convertedValue")
Cost of LivingFinance1 cr
=VERVE("costliving", "California", "field", "from.searchedLocation")
Country GDPNewFinance1 cr
=VERVE("gdp", "US", "field", "countryName")
CPI InflationFinance1 cr
=VERVE("cpiinflation", "field", "yearMonth")
Currency SymbolsFinance1 cr
=VERVE("currencysymbols", "USD")
DividendsFinance1 cr
=VERVE("dividends", "AAPL", "field", "cik")
=VERVE("exchangerate", "USD", "EUR", "field", "exchangeRate")
Financial RatiosFinance1 cr
=VERVE("financialratios", "AAPL", "field", "company")
=VERVE("globalstockmarket", "DE", "field", "countryName")
I-Bond RatesFinance1 cr
=VERVE("savingsbonds", "field", "iBonds.currentRate")
IFSC LookupFinance5 cr
=VERVE("ifsclookup", "SBIN0005943", "field", "bank")
Income StatementFinance1 cr
=VERVE("incomestatement", "AAPL", "field", "company")
=VERVE("incometax", "US", "field", "year")
Inflation RatesFinance1 cr
=VERVE("inflation", "US", "field", "countryName")
Insider TradingFinance1 cr
=VERVE("insidertrading", "AAPL", "field", "cik")
=VERVE("bitcoin", "field", "currency")
=VERVE("ethereum", "field", "currency")
Live Gold PriceFinance1 cr
=VERVE("goldprice", "field", "currency")
=VERVE("palladiumprice", "field", "currency")
=VERVE("platinumprice", "field", "currency")
=VERVE("silverprice", "field", "currency")
=VERVE("stockmarketopentimes", "NYSE", "field", "fullName")
Minimum WageFinance1 cr
=VERVE("minimumwage", "CA", "field", "stateName")
Mortgage RatesFinance1 cr
=VERVE("mortgagerate", "30year", "field", "rateType")
=VERVE("sanctionscreening", "Banco Nacional de Cuba", "field", "query")
=VERVE("population", "US", "field", "countryName")
Purchasing PowerFinance1 cr
=VERVE("purchasingpower", 100, "1990", "field", "originalAmount")
=VERVE("routinglookup", "121000358", "field", "routing_number")
Sales Tax RatesFinance1 cr
=VERVE("salestax", "64082", "field", "state")
SEC FilingsFinance1 cr
=VERVE("secfilings", "AAPL", "field", "cik")
=VERVE("stockexchange", "XNYS")
=VERVE("stockindex", "sp500", "field", "name")
=VERVE("swiftlookup", "CHASUS33ARP")
Treasury YieldsFinance1 cr
=VERVE("treasuryyields", "field", "date")
=VERVE("unemployment", "USA", "field", "countryName")
US Jobs ReportFinance1 cr
=VERVE("jobsreport", "field", "yearMonth")
US National DebtFinance1 cr
=VERVE("nationaldebt", "field", "date")
US Trade BalanceFinance1 cr
=VERVE("tradebalance", "field", "yearMonth")
VAT RatesNewFinance1 cr
=VERVE("vatrates", "DE", "field", "countryName")

Text Processing

42
Add Emojis to TextText Processing1 cr
=VERVE("emojidecorator", "I am so excited to go to the lake and swim")
Analyze WordsText Processing1 cr
=VERVE("lexicon", "listen", "field", "isAlphagram")
Calculate Reading TimeText Processing1 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 Processing10 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 Processing1 cr
=VERVE("palindromechecker", "A man a plan a canal Panama", "field", "is_palindrome")
Check SpellingText Processing5 cr
=VERVE("spellchecker", "I neeed to call my friend on telephine today!", "field", "spellPass")
Convert TenseText Processing1 cr
=VERVE("tenseconverter", "I am walking down the street, and I can see a dog", "past", "field", "result")
Convert Titles to Title CaseText Processing1 cr
=VERVE("titlecapitalization", "comprehensive analysis of quarterly financial performance and strategic initiatives for sustainable growth", "title-case", "field", "style")
Correct SpellingText Processing10 cr
=VERVE("didyoumean", "what weather today is")
Count SyllablesText Processing1 cr
=VERVE("syllablecounter", "The quick brown fox jumps over the lazy dog", "field", "total_syllables")
Count VowelsText Processing1 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 Processing1 cr
=VERVE("anagramdetector", "listen", "silent", "field", "is_anagram")
Detect GibberishText Processing1 cr
=VERVE("gibberishdetector", "The quick brown fox jumps over the lazy dog", "field", "isGibberish")
Detect LanguageText Processing1 cr
=VERVE("textlanguage", "Ceci est un exemple de texte. Il peut détecter la langue", "field", "language")
Edit DistanceText Processing1 cr
=VERVE("levenshteindistance", "kitten", "sitting", "field", "distance")
Expand AcronymsText Processing5 cr
=VERVE("acronymexpander", "API", "field", "most_common.expansion")
Extract KeywordsText Processing5 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 Processing1 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 Processing1 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 Processing1 cr
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "field", "isProfane")
Find AntonymsText Processing10 cr
=VERVE("antonym", "happy", "field", "language")
Find Rhyming WordsText Processing1 cr
=VERVE("wordrhymes", "blue", "field", "rhymeCount")
Find Word OppositesText Processing10 cr
=VERVE("wordopposite", "hot")
Leet SpeakText Processing1 cr
=VERVE("leetspeak", "This is a simple piece of text", "encode", "field", "changedCharacters")
Lemmatize TextText Processing1 cr
=VERVE("lemmatizer", "The cats ran from door to door", "field", "found")
Mask Sensitive DataText Processing1 cr
=VERVE("datamasking", "Contact John Doe at [email protected] or call 555-123-4567. His SSN is 123-45-6789.", "field", "masked")
Phonetic CodesText Processing1 cr
=VERVE("phonetic", "smith", "field", "soundex")
Pig LatinText Processing1 cr
=VERVE("piglatin", "The square wooden crate was packed to be shipped. To have is better than to wait and hope.")
Readability ScoreText Processing1 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 Processing1 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 Processing1 cr
=VERVE("reversetext", "Hello World", "field", "reversed")
Slugify TextText Processing1 cr
=VERVE("slugify", "Hello World! This is a Test & Example", "field", "original")
Sort Lines of TextText Processing1 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 Processing1 cr
=VERVE("textstyler", "This is a very stylish piece of text", "bubbles", "field", "text")
Summarize TextText Processing10 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 Processing1 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 Processing1 cr
=VERVE("texttoemoji", "I am so excited to go to the lake and swim")
Translate TextText Processing20 cr
=VERVE("translator", "I'm so excited that tomorrow is going to be sunny! Can't wait!", "es", "field", "sourceLang")
Validate ISBNsText Processing1 cr
=VERVE("isbnvalidator", "978-0-306-40615-7", "field", "valid")
Validate Tax IDsText Processing1 cr
=VERVE("taxidvalidator", "123-45-6789", "field", "valid")
Website ReadabilityText Processing5 cr
=VERVE("websitereadability", "https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/concepts", "field", "fleschReadingEase")
Word PronunciationText Processing1 cr
=VERVE("wordpronunciation", "hello", "field", "pronounciation")

Data Conversion

22
Base64 EncodeData Conversion1 cr
=VERVE("base64", "Hello World", "field", "action")
Convert Color FormatsData Conversion1 cr
=VERVE("colorconverter", "FF0000", "field", "rgb")
Convert CSV to JSONData Conversion1 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 Conversion1 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 Conversion1 cr
=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London", "field", "originalTime")
Convert Number BasesData Conversion1 cr
=VERVE("numberbaseconverter", "255", "field", "input_value")
Convert UnitsData Conversion1 cr
=VERVE("unitconverter", 100, "lb", "kg", "field", "result.result")
Convert Unix TimestampsData Conversion1 cr
=VERVE("unixtimestamp", "1609459200", "field", "timestamp_format")
Convert Words to NumbersData Conversion1 cr
=VERVE("wordstonumbers", "seven thousand six hundred and twenty", "field", "number")
Convert XML to JSONData Conversion1 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 Conversion1 cr
=VERVE("ascii85encoder", "Hello World", "field", "original_text")
Encode HTML EntitiesData Conversion1 cr
=VERVE("htmlentities", "<div class=""test"">Hello & World</div>", "field", "action")
Escape UnicodeData Conversion1 cr
=VERVE("unicodeescape", "Hello World", "field", "action")
Format File SizesData Conversion1 cr
=VERVE("filesizeformatter", 1073741824, "field", "formatted")
Math CalculatorData Conversion1 cr
=VERVE("math", "add", 10, 5, "field", "result")
Numbers to WordsData Conversion1 cr
=VERVE("numbertowords", 975.07, "field", "words")
Placeholder TextData Conversion1 cr
=VERVE("placeholdertext", "field", "style")
Relative TimeData Conversion1 cr
=VERVE("relativetimeformatter", "1609459200", "field", "target_date")
Roman NumeralsData Conversion1 cr
=VERVE("romanconverter", 2024, "field", "roman")
Text to ColorData Conversion1 cr
=VERVE("texttocolor", "turquoise", "field", "hex")
URL Encode & DecodeData Conversion1 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 Generation1 cr
=VERVE("acronymgenerator", "Application Programming Interface")
Generate Baby NamesData Generation1 cr
=VERVE("babynamegenerator", "male")
Generate Bingo CardsData Generation1 cr
=VERVE("bingocardgenerator", "field", "size")
Generate Boggle BoardsData Generation1 cr
=VERVE("boggleboardgenerator", "field", "size")
Generate Color PalettesData Generation1 cr
=VERVE("colorpalette", "FF5733", "field", "source")
Generate CommentsData Generation1 cr
=VERVE("commentgenerator", "text", "field", "count")
Generate Company NamesData Generation1 cr
=VERVE("companynamegenerator", "systems", "field", "count")
Generate CUIDsData Generation1 cr
=VERVE("cuidgenerator", "field", "count")
Generate GUIDsData Generation1 cr
=VERVE("guidgenerator", "field", "count")
Generate HashtagsData Generation1 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 Generation1 cr
=VERVE("initialismgenerator", "Application Programming Interface", "field", "initialism")
Generate Lorem IpsumData Generation1 cr
=VERVE("loremipsumgenerator", "field", "words")
Generate PasswordsData Generation1 cr
=VERVE("passwordgenerator", 10, 12, "strong")
Generate Random DataData Generation1 cr
=VERVE("randomgenerator", "number", "field", "count")
Generate Random UsersData Generation1 cr
=VERVE("randomusergenerator", "field", "id")
Generate Short CodesData Generation1 cr
=VERVE("shortcodegenerator", "field", "count")
Generate Test CardsData Generation1 cr
=VERVE("cardgenerator", "visa", "field", "count")
Generate Test IdentitiesData Generation1 cr
=VERVE("randomidentitygenerator")
Generate ULIDsData Generation1 cr
=VERVE("ulidgenerator", "field", "count")
Generate UsernamesData Generation1 cr
=VERVE("usernamegenerator", "[email protected]", "field", "count")
Generate UUIDsData Generation1 cr
=VERVE("uuidgenerator", "field", "count")
Random WordsData Generation1 cr
=VERVE("randomwords", "field", "word")

Domain Data

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

Data Lookup

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

Networking

14
=VERVE("phishingcheck", "centruldepiele.ro", "field", "isPhishing")
Check TLS SupportNewNetworking1 cr
=VERVE("tlscheck", "amazon.com", "field", "tlsVersions.TLSv1")
Check URL SafetyNewNetworking1 cr
=VERVE("contentfilter", "https://www.pornhub.com/video/123", "field", "domain")
Detect BotsNewNetworking1 cr
=VERVE("botdetector", "Googlebot/2.1 (+http://www.google.com/bot.html)", "field", "userAgent")
Detect Tor NodesNewNetworking1 cr
=VERVE("tordetect", "185.189.183.143", "field", "ipAddress")
Detect VPNsNetworking1 cr
=VERVE("vpndetector", "103.62.49.210", "field", "is_vpn")
IP Blacklist CheckNetworking5 cr
=VERVE("ipblacklistlookup", "185.220.101.1", "field", "ipAddress")
IP LookupNetworking5 cr
=VERVE("iplookup", "173.172.81.20", "field", "country")
=VERVE("bluetoothlookup", "76", "field", "companyIdHex")
Look Up NameserversNetworking5 cr
=VERVE("nameservers", "google.com", "field", "nameserverCount")
MAC Address LookupNetworking1 cr
=VERVE("macaddresslookup", "00-B0-D0-63-C2-26", "field", "isValid")
Ping HostsNetworking1 cr
=VERVE("pinger", "google.com", "field", "alive")
TLD LookupNewNetworking1 cr
=VERVE("tldlookup", "com", "field", "found")
USB Vendor LookupNetworking1 cr
=VERVE("usbvendorlookup", "05AC", "field", "productId")

Geography

13
Calculate DistanceGeography1 cr
=VERVE("distancecalculator", 36.7783, -119.4179, 34.0522, -118.2437, "field", "distanceMiles")
=VERVE("coordinatesaresea", 37.7749, -122.4194, "field", "latitude")
Country BordersGeography1 cr
=VERVE("countryborders", "CA", "field", "cca2")
Country BoundariesGeography5 cr
=VERVE("countryboundaries", "CA")
Country FlagsGeography1 cr
=VERVE("countryflags", "ZW", "png", "circle", "field", "countryCode")
Country LanguagesGeography1 cr
=VERVE("countrylanguages", "ZW", "field", "name")
Country LookupGeography1 cr
=VERVE("countrylookup", "USA")
Look Up City DataGeography1 cr
=VERVE("citieslookup", "San Francisco")
Reverse GeocodeGeography1 cr
=VERVE("reversegeocode", 40.714224, -73.961452, "field", "zipcode")
State BoundariesGeography5 cr
=VERVE("stateboundaries", "CA")
US County DataGeography5 cr
=VERVE("countydata", "MO", "Jackson", "field", "name")
USDA Hardiness ZoneGeography1 cr
=VERVE("hardinesszone", "97201", "field", "zipCode")
Zip Code LookupGeography1 cr
=VERVE("zipcodes", "64082", "field", "zipcode")

Reference Data

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

Data Validation

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

Math/Calculations

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

Weather

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

Astrology

6
Chinese ZodiacAstrology1 cr
=VERVE("chinesezodiac", "1990-01-15", "field", "zodiacYear")
Daily HoroscopeAstrology1 cr
=VERVE("horoscope", "aries", "field", "horoscope")
Moon PhasesAstrology1 cr
=VERVE("moonphases", "field", "phase")
Moon PositionAstrology1 cr
=VERVE("moonposition", 37.7749, -122.4194, "field", "date")
Planet PositionsNewAstrology1 cr
=VERVE("planetpositions", 37.7749, -122.4194, "Moon", "field", "isBelowHorizon")
Sun PositionAstrology1 cr
=VERVE("sunposition", 37.7749, -122.4194, "field", "date")

Transportation

6
Airline LookupTransportation1 cr
=VERVE("airlinelookup", "AA", "field", "name")
Airport DistanceNewTransportation1 cr
=VERVE("airportdistance", "JFK", "LAX", "field", "distanceMiles")
Airport LookupTransportation1 cr
=VERVE("airports", "MCI", "field", "icao")
Convert Airport CodesNewTransportation1 cr
=VERVE("airportcodeconverter", "MCI", "field", "input")
Decode VINsTransportation5 cr
=VERVE("vindecoder", "1HGCM82633A004352", "field", "valid")
Look Up Car ModelsTransportation1 cr
=VERVE("carmodels", "Toyota")

Calendar

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

Data Processing

5
Cloud CounterData Processing1 cr
=VERVE("counter", "test_counter", "field", "created")
Convert HTML to TextData Processing1 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 Processing5 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 Processing1 cr
=VERVE("metadataextractor", "https://apiverve.com", "field", "requestUrl")
Morse CodeNewData Processing1 cr
=VERVE("morsecode", "This Is A Message", "field", "morse")

AI/Computer Vision

4
Analyze SentimentAI/Computer Vision5 cr
=VERVE("sentimentanalysis", "I'm so excited that tomorrow is going to be sunny! Can't wait!", "field", "comparative")
Detect Code LanguageAI/Computer Vision10 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 Vision1 cr
=VERVE("languagedetector", "esta es una frase en español. esta API puede detectar fácilmente el idioma", "field", "primaryLanguage")
Generate Article IdeasAI/Computer Vision10 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 Scraping5 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 TableScience1 cr
=VERVE("periodictable", "hydrogen")
Star LookupScience1 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 OvulationLifestyle1 cr
=VERVE("ovulationcalculator", "2024-01-01", "field", "cycle_length")
=VERVE("menstrualcycle", "2024-01-01", "field", "last_period_date")
Pregnancy Due DatesLifestyle1 cr
=VERVE("duedatecalculator", "2025-06-01", "field", "calculation_method")

Parsers

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

Health/Wellness

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

News

1
World NewsNews1 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