RECENT FUNDING
  1. Recent Funding
  2. API
  3. Recipes
  4. Pull new startup funding rounds into Google Sheets automatically

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