Help & Support
Send Feedback
Patternchain
Browse critical information on hundreds of thousands of startups to identify your next customer, competitor, or investment.
patternchain.com
No users
Works with
Install
Overview
Patternchain runs on a proprietary lifelong machine learning platform, autonomously mining hundreds of media sources and analyzing thousands of startups daily. 

All acquired knowledge feeds into Patternchain database, accessible through API endpoints documented at https://patternchain.com/docs

Patternchain Add-on provides subscribed users with seven ready-to-use functions to be called from Google Sheets:

=RaisedOver(funding, hasContact)

funding - Returns only funded startups over entered amount (in millions).
hasContact - Returns only startups where Patternchain has contact information on.

Example 1: =RaisedOver("1.5","yes") -> Returns all growing startups with contact information with over 1.5 million in investment 
Example 2: =RaisedOver("2") -> Returns all growing startups with over 2 million in investment, regardless of contact information presence

=SentimentScore(score, hasContact)

score - Returns only growing startups where Social and Regular Media Sentiment is over entered score.
hasContact - Returns only startups where Patternchain has contact information on.

Example: =SentimentScore("0.5") -> Returns all growing startups with sentiment score over 0.5. (See our docs to understand meaning).

=FoundedAfter(year, hasContact)

year - Returns only growing startups founded in OR after entered year.
hasContact - Returns only startups where Patternchain has contact information on.

Example 1: =FoundedAfter("2012","yes") -> Returns all growing startups with contact information founded in OR after 2012 
Example 2: =FoundedAfter("2016") -> Returns all growing startups founded in OR after 2016, regardless of contact information presence

=StartupCity(city, hasContact)

city - Returns only growing startups where HQ is located in defined city.
hasContact - Returns only startups where Patternchain has contact information on.

Example: =StartupCity("New") -> Returns all growing startups where city's name has the word 'New' in it.

=StartupVertical(vertical, hasContact)

vertical - Returns only growing startups under defined vertical.
hasContact - Returns only startups where Patternchain has contact information on.

Example: =StartupVertical("Tech","yes") -> Returns all growing startups with contact information where vertical has the word 'Tech' in it.

=ScaleIndex(index, hasContact)

index - Returns only growing startups with scalability level over defined index.
hasContact - Returns only startups where Patternchain has contact information on.

Example: =ScaleIndex("0.1") -> Returns all growing startups with scalability index over 0.1 (See our docs to understand meaning)
Reviews
No comments
Additional information
Version
2
Updated
May 17, 2017
Search
Clear search
Close search
Google apps
Main menu