Pull new startup funding rounds into Google Sheets automatically
In your sheet, open Extensions → Apps Script, paste this, add your key under Project Settings → Script properties as RF_KEY, and run updateFundingRounds once. Then add a daily time-driven trigger (Triggers → Add trigger) to keep it fresh.
Every request needs an API key: get one free with just an email (50 calls a day; Free shows data at least 14 days old). Pay as you go or Pro for the newest rounds and stealth startups.
function updateFundingRounds() {
const key = PropertiesService.getScriptProperties().getProperty('RF_KEY');
const since = Utilities.formatDate(new Date(Date.now() - 30 * 864e5), 'UTC', 'yyyy-MM-dd');
const res = UrlFetchApp.fetch('https://recentfunding.com/api/v1/rounds?limit=500&since=' + since, {
headers: { Authorization: 'Bearer ' + key },
});
const rounds = JSON.parse(res.getContentText()).rounds;
const book = SpreadsheetApp.getActiveSpreadsheet();
const sheet = book.getSheetByName('Rounds') || book.insertSheet('Rounds');
sheet.clearContents();
const rows = [['Announced', 'Company', 'Stage', 'Amount (USD)', 'Investors', 'Source']];
rounds.forEach(r => rows.push([r.announced_at.slice(0, 10), r.name, r.stage, Number(r.amount_usd), (r.investors || []).join(', '), r.source_url]));
sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}
Each run replaces the sheet with the current list. Add &stage=seed or &crypto=true to the URL to narrow it.
Endpoints used
- List recent funding rounds
GET /api/v1/rounds