Formulas for
The Source Directory

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

291 live sources25 categoriesIn Google SheetsOne key
All 291 sourcesclick any formula to copy

Finance

52
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, "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", "searchedLocation")
Country GDPNewFinance2 cr
=VERVE("gdp", "US", "field", "countryName")
CPI InflationFinance2 cr
=VERVE("cpiinflation", "field", "yearMonth")
Currency SymbolsFinance1 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")
Gas PricesFinance2 cr
=VERVE("gasprices", "field", "country")
=VERVE("globalstockmarket", "DE", "field", "countryName")
I-Bond RatesFinance2 cr
=VERVE("savingsbonds", "field", "period")
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")
Ticker NewsNewFinance2 cr
=VERVE("tickernews", "AAPL", "field", "name")
=VERVE("tickersymbols", "SHEL", "field", "count")
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 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 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 Processing1 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", "field", "tense")
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 Processing20 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 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 Processing1 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", "field", "partofspeech")
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", "partOfSpeech")
Find Rhyming WordsText Processing2 cr
=VERVE("wordrhymes", "blue", "field", "rhymeCount")
Find Word OppositesText Processing20 cr
=VERVE("wordopposite", "hot")
Leet SpeakText Processing1 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 Processing1 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 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 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 Processing25 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 Conversion1 cr
=VERVE("base64", "Hello World", "field", "action")
Convert Color FormatsData Conversion1 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 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 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 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 Conversion25 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 Generation1 cr
=VERVE("cuidgenerator", "field", "count")
Generate GUIDsData Generation1 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 Generation1 cr
=VERVE("loremipsumgenerator", "field", "words")
Generate PasswordsData Generation1 cr
=VERVE("passwordgenerator")
Generate Random DataData Generation2 cr
=VERVE("randomgenerator", "field", "type")
Generate Random UsersData Generation2 cr
=VERVE("randomusergenerator", "field", "id")
Generate Short CodesData Generation1 cr
=VERVE("shortcodegenerator", "field", "count")
Generate Test CardsData Generation2 cr
=VERVE("cardgenerator", "field", "brand")
Generate Test IdentitiesData Generation2 cr
=VERVE("randomidentitygenerator")
Generate ULIDsData Generation1 cr
=VERVE("ulidgenerator", "field", "count")
Generate UsernamesData Generation2 cr
=VERVE("usernamegenerator", "[email protected]", "field", "count")
Generate UUIDsData Generation1 cr
=VERVE("uuidgenerator", "field", "count")
Random WordsData Generation2 cr
=VERVE("randomwords", "field", "word")

Domain Data

19
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 AgeNewDomain Data10 cr
=VERVE("domainage", "myspace.com", "field", "createdDate")
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://en.wikipedia.org/wiki/HTML_element")
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", "github.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 Lookup1 cr
=VERVE("bible", "Genesis", "KJV", 5, "field", "text")
Country Calling CodesData Lookup1 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 Lookup1 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 Lookup1 cr
=VERVE("unicodelookup", "field", "character")
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", "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 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 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 Data1 cr
=VERVE("portnumberlookup", 443)

Data Validation

10
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")
IBAN ValidatorNewData Validation2 cr
=VERVE("ibanvalidator", "GB29NWBK60161331926819", "field", "isValid")
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")

Weather

9
Air QualityWeather10 cr
=VERVE("airquality", "San Francisco", "field", "pm2_5")
=VERVE("earthquake", "field", "earthquakes_LastUpdated")
=VERVE("weatherforecast", "San Francisco", "field", "tempC")
=VERVE("weatheralerts", "field", "location.state")
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")

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")

Transportation

8
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")
DTC LookupNewTransportation1 cr
=VERVE("dtclookup", "P0301", "field", "found")
Look Up Car ModelsTransportation2 cr
=VERVE("carmodels", "Toyota")
Visa RequirementsNewTransportation5 cr
=VERVE("visarequirements", "US", "JP", "field", "passportName")

Astrology

7
Birth ChartNewAstrology5 cr
=VERVE("birthchart", "1990-06-15", "14:30", 40.7128, -74.006, "field", "birth.localTime")
Chinese ZodiacAstrology1 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")

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 DaysCalendar2 cr
=VERVE("workingdays", "US", "field", "workingDaysCount")
World HolidaysCalendar2 cr
=VERVE("worldholidays", "US", "field", "year")

Data Processing

5
Cloud CounterData Processing1 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 Processing1 cr
=VERVE("morsecode", "This Is A Message", "field", "morse")

Data Scraping

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

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")

Science

4
=VERVE("julianday", "2024-03-15", "field", "gregorian")
=VERVE("meteorites", "Allende")
Periodic TableScience1 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")

data

2
=VERVE("jobpostings", "airbnb", "field", "boardTotal")
Job SearchNewdata20 cr
=VERVE("jobsearch", "software engineer", "field", "page")

Health/Wellness

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

News

1
World NewsNews6 cr
=VERVE("news", "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