Patternchain - Google Sheets add-on

Download platform_app

Browse critical information on hundreds of thousands of startups to identify your next customer, competitor, or investment.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)