How the Integration Works
Export your GitDealFlow watchlist as CSV. Import into Google Sheets. Use Google Finance and =IMPORTHTML for additional data layers.
Set up a weekly automated pipeline using Google Apps Script to pull the latest GitDealFlow data.
Build conditional formatting rules to highlight startups with momentum scores above your investment threshold.
The Google Sheets integration turns a static watchlist into a living deal-flow dashboard. Sheets is where most angel groups, scout programs, and seed funds already keep their pipeline, adding GitDealFlow data means the momentum signal, the pipeline status, and the team's notes live in one place that everyone can edit. No new software to learn, no export ritual to remember.
Setup Steps
- Pull the data: the free CSV endpoint at
https://signals.gitdealflow.com/api/signals.csvreturns the latest signal list for direct import via File → Import or =IMPORTDATA(). - Build your tracker: one tab for the pipeline (company, sector, momentum score, status, owner, next step), one tab for raw signals.
- Automate the refresh: a small Apps Script trigger re-imports the CSV weekly, so the dashboard updates itself every Sunday.
- Layer on context: join with =IMPORTHTML or manual columns for website, sector news, and your own notes.
- Make it visual: conditional formatting highlights momentum scores above your threshold, and a second rule flags declining scores for review.
Who Benefits
Angel syndicates get a shared dashboard where every member sees the same scores and statuses. Scout programs use it to track lead quality over time and prove sourcing value to the fund. Seed funds fold the momentum data into their existing CRM-like sheets, so sourcing and diligence stay in the same workflow. Because the underlying data is public GitHub activity, the numbers are verifiable by anyone on the team, no black box.
Frequently Asked Questions
Is there a pre-built Google Sheets template?
Yes. Download our free deal flow tracker template with pre-configured formulas scoring and formatting.
How often does the data refresh?
The signal dataset is updated weekly. An Apps Script trigger can re-import the CSV on the same cadence, keeping your dashboard current automatically.
Is there a JSON option instead of CSV?
Yes, the same data is available at /api/signals.json, and there is a full OpenAPI spec at /api/openapi.json for building custom integrations.
Can I track my own portfolio companies?
Yes, add your portfolio to the tracker and use momentum columns to watch for velocity changes that warrant a follow-on conversation.