A Google Sheet that fills itself with new US companies
A new company needs a bank account, insurance, a website, payroll and an accountant in its first weeks. If you sell any of these, the list of companies registered yesterday in your state is the most useful sheet you can open in the morning.
This guide gives you a script to paste into Google Sheets. Each day it calls the US New Companies Actor on Apify and appends the companies it has not written before. The Actor is an unofficial tool that reads the open-data registers of six states (New York, Colorado, Connecticut, Texas, Oregon, Pennsylvania) and four cities (Chicago, Seattle, Los Angeles, San Francisco). It returns companies only, never the names of people.
How many companies is that? The daily count page shows it for three states: on Monday 9 November 2026, New York registered 895 new entities, Colorado 625 and Connecticut 159 (counted on 10 November in each state’s open-data portal; the last days still rise as late filings arrive).
To look at the list before setting anything up: the free new US companies this week tool shows the companies of a state, a city or a keyword in your browser, with a CSV.
What you need
- A Google account and an empty Google Sheet.
- An Apify account. A free account includes monthly credit, enough for small daily runs.
- Your Apify API token: in Apify Console, open Settings, then API & Integrations.
Shortcut: start from the ready-made sheet. Make a copy of the EuroScrape template: the script below is already inside the copy, without any token. Then go straight to Step 2. You can also look at the template first, read-only.
Step 1: paste the script
In your sheet, open Extensions, then Apps Script. Delete what is in the editor and paste this:
// New US companies into Google Sheets, with the EuroScrape "US New Companies" Actor on Apify.
// Change INPUT to pick your states, your window and your keywords.
var ACTOR = 'euroscrape~us-new-companies';
var INPUT = { daysBack: 3, states: ['CT'], maxItems: 500, monitorName: 'google-sheet' };
var COLUMNS = ['registeredOn', 'name', 'legalForm', 'city', 'stateCode', 'postcode',
'activity', 'address', 'companyNumber', 'sourceUrl'];
var SHEET_NAME = 'New companies';
function importNewCompanies() {
var token = PropertiesService.getScriptProperties().getProperty('APIFY_TOKEN');
if (!token) {
throw new Error('Add your Apify token in Project Settings > Script properties, as APIFY_TOKEN.');
}
var url = 'https://api.apify.com/v2/acts/' + ACTOR + '/run-sync-get-dataset-items';
var response = UrlFetchApp.fetch(url, {
method: 'post',
contentType: 'application/json',
headers: { Authorization: 'Bearer ' + token },
payload: JSON.stringify(INPUT),
muteHttpExceptions: true
});
var code = response.getResponseCode();
if (code < 200 || code >= 300) {
throw new Error('Apify answered ' + code + ': ' + response.getContentText().slice(0, 300));
}
var companies = JSON.parse(response.getContentText()).filter(function (item) {
return item.type === 'company';
});
var book = SpreadsheetApp.getActiveSpreadsheet();
var sheet = book.getSheetByName(SHEET_NAME) || book.insertSheet(SHEET_NAME);
if (sheet.getLastRow() === 0) {
sheet.appendRow(COLUMNS);
sheet.setFrozenRows(1);
}
// Never write the same company twice, even when you run the script by hand.
var idColumn = COLUMNS.indexOf('companyNumber') + 1;
var known = {};
if (sheet.getLastRow() > 1) {
sheet.getRange(2, idColumn, sheet.getLastRow() - 1, 1).getValues().forEach(function (row) {
known[row[0]] = true;
});
}
var rows = companies.filter(function (company) {
return !known[company.companyNumber];
}).map(function (company) {
return COLUMNS.map(function (key) { return cell(company[key]); });
});
if (rows.length) {
sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, COLUMNS.length).setValues(rows);
}
Logger.log(rows.length + ' new companies added.');
}
// Text coming from a register is written as text, never as a formula.
function cell(value) {
if (value === null || value === undefined) return '';
if (typeof value === 'string' && /^[=+@-]/.test(value)) return "'" + value;
return value;
}
Step 2: add your token, outside the code
In the Apps Script editor, open Project Settings (the gear), scroll to Script properties, and add a property named APIFY_TOKEN with your token as its value.
The script reads the token from there and sends it in a request header. It is never written in the code, in a cell or in a web address, so you can share the sheet or copy the script without sharing your token.
Step 3: run it once
Back in the editor, choose importNewCompanies and click Run. Google asks you to authorise the script to edit this spreadsheet and to call an external service: that service is api.apify.com. A tab named “New companies” appears with one row per company.
Step 4: run it every day
Open Triggers (the clock), click Add Trigger, choose importNewCompanies, Time-driven, Day timer, and an hour in the morning. That is all.
Because the input has a monitorName, the Actor remembers what it has already delivered under that name: each run returns only companies it has not returned before, so you are not charged twice for the same company. With daysBack: 3, a missed day is caught up by the next run.
Choose your state and your niche
Change the INPUT line. A few real inputs:
// Colorado, the last 3 days
var INPUT = { daysBack: 3, states: ['CO'], maxItems: 1000, monitorName: 'google-sheet-co' };
// Dental, coffee and roofing companies in Connecticut and Chicago
var INPUT = { daysBack: 14, states: ['CT', 'CHI'], keywords: ['dental', 'coffee', 'roofing'],
excludeKeywords: ['holdings'], monitorName: 'google-sheet-niche' };
// Texas and Oregon publish with a delay: look further back
var INPUT = { daysBack: 30, states: ['TX', 'OR'], maxItems: 500, monitorName: 'google-sheet-tx-or' };
| Code | Register | How fresh |
|---|---|---|
NY, CO, CT |
New York, Colorado, Connecticut | the day after filing |
TX |
Texas | about ten days after the charter date |
OR |
Oregon | weekly |
PA |
Pennsylvania | about monthly |
CHI, SEA, LA, SF |
Chicago, Seattle, Los Angeles, San Francisco (business licenses) | a few days |
Use a different monitorName for each sheet, so that one sheet does not consume the new companies of another.
The columns
registeredOn is the official filing date, not a crawl date. legalForm is the form as the register publishes it (LLC, corporation, nonprofit). activity is the NAICS text and code where the register publishes one (Connecticut and the four cities). address, city and postcode come from the register. In New York, about two companies in three are registered at the address of a registered-agent service: for those the Actor returns no address rather than a wrong one. sourceUrl opens the company’s row in the official portal, so every line can be checked.
A real row, from the Connecticut register (filed 7 November 2026, street number masked here):
{
"type": "company",
"companyNumber": "CT-3546983",
"name": "Gaynor Digital LLC",
"legalForm": "Limited liability company (LLC)",
"entityType": "llc",
"registeredOn": "2026-11-07",
"activity": "Custom Computer Programming Services (NAICS 541511)",
"address": "•• Daniels Farm Rd, Trumbull, CT 06611",
"city": "Trumbull",
"postcode": "06611",
"stateCode": "CT"
}
To add a column, add its field name to COLUMNS: entityType, tradeName, area (county or neighbourhood), stateName and source are available. The example page has a full output file.
What it costs
$3 per 1,000 companies, plus $0.003 per run. The first 20 companies of every run are free, and so are the summary rows. Prices read from the actor’s pricing file on 10 November 2026.
- Connecticut alone, about 160 to 215 new entities on a weekday in early November 2026: roughly $0.40 to $0.60 a day.
- New York, Colorado and Connecticut together, 1,679 entities on 9 November 2026: about $5 for that day.
- A niche with keywords, a few dozen companies a day: a few cents, and nothing but the $0.003 start fee on days with 20 companies or fewer.
If you want a hard ceiling, lower maxItems: the Actor never delivers more companies than that in one run. There is no subscription.
The same sheet for other countries
The script works with any Actor that returns one row per company. Change ACTOR, INPUT and COLUMNS, and remove the type === 'company' filter when the Actor has no summary row:
- Spain, from the official BORME gazette:
euroscrape~spain-companies, see Spanish company data. - Switzerland, from the official SOGC gazette:
euroscrape~switzerland-companies, see Swiss company data. - United Kingdom:
euroscrape~uk-companies, see Companies House API or scraper.
FAQ
Do I need to code?
No. You paste the script once and edit one line, the INPUT, to choose your states.
Why not download the state’s file myself? You can: the portals are open and free, and for one state and one download that is the right choice. The script is for when you want the same columns for several registers, only the new companies, every morning, without opening anything.
Does it give emails or phone numbers? No. State registers do not publish them, and the Actor adds none. You get the company, its form, its date, its address when published, and a link to the official record.
The script stops with a time-out. What now?
The call waits for the run to finish, and Apify keeps such a call open for up to five minutes. Runs are short (1,500 companies from the ten sources took 7 seconds in a test), but if you ask for a very large window, lower maxItems or daysBack.
Is this an official Google or state product? No. It is a script for your own sheet, calling an unofficial Actor that reads official open data. Related reading: new business filings from the Secretary of State registers.
Data sources: the open-data portals of the states and cities listed above. Not affiliated with Google, any Secretary of State or any city.
Open the US New Companies Actor on Apify
Other US lead lists: Form D filings list and construction leads from building permits.
Run these numbers yourself. Every EuroScrape Actor runs on Apify, pay per result; a free Apify account ($5 of monthly credit) covers your first tests. Open the Store page →
EuroScrape Data Letter
Five numbers a week from official registers and public prices, each one reproducible with an Actor. Free, one e-mail on Thursdays.
Archive and unsubscribe: buttondown.com/Euroscrape.