BuildShip Logo
BuildShip Community

Analyse Data and Score

Compare data from two Google Sheets, analyze and find a match score. This template can be applied to various use cases. We will demonstrate how an accelerator uses it to find potential partnership between its network of companies.

59

Report this template

Select the reason for reporting

Describe the issue in detail

Share template

Link to template

https://templates.buildship.com/template/NeyTxUTpRAea/

Inputs

Remix the template to run it with your own values.

Output

Read me

📖 Read Me

Compare two Google Sheets data, analyse and find match score. This template can be applied to a variety of usecases.

Overview

We will demonstrate how an accelerator utilizes data from its partner companies to match incoming applications or portfolio companies with potential partnership opportunities within its network. In this example we will use a sample dataset from this sheet.

  • Sheet 1 contains the master dataset you want to match with. In this example, it's the complete list of partnership network companies.
  • Sheet 2 contains the dataset for which you want to find matches. In this example, these are the companies seeking opportunities to connect with the network.
  • Sheet 3 contains the output with the match scores, along with compiled emails for each of the companies from Sheet 2.

Prerequisites

  • Have an OpenAI account and create an API key and AI Assistant

✍️ How to Use

Step 1: In the Google Sheets node, connect to your Google account using the fingerprint icon.

Step 2: Change the dataset to the Google Sheets data you want to use for this template.

Step 3: Update the OpenAI Assistant node with your OpenAI key by using the key icon, and replace the Assistant ID with your own, which you can create on OpenAI. here