ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
EuroScrape · New US companies in my state, every day (template)
2
How to use (5 minutes): 1) File → Make a copy. 2) Extensions → Apps Script: the script "importNewCompanies" is already there, without any token. 3) Project Settings → Script properties → add APIFY_TOKEN (free Apify account: Console → Settings → API & Integrations).
3
4) Edit INPUT at the top of the script: your states (e.g. ['CT'] or ['NY','CO']), daysBack, maxItems. 5) Run importNewCompanies once and authorise. 6) Triggers → Add Trigger → importNewCompanies, time-driven, day timer, an hour in the morning.
4
The sheet "New companies" then gets one new row per company every day, never the same company twice: registration date, name, legal form, city, state, postcode, activity, address, company number, official register link. Companies only, no names of people.
5
Actor: https://apify.com/euroscrape/us-new-companies · $3 per 1,000 companies + $0.003 per run · the first 20 companies of every run are free. Full guide: https://euroscrape.com/guides/google-sheets-new-us-companies
6
Source: open-data registers of six states (New York, Colorado, Connecticut, Texas, Oregon, Pennsylvania) and four cities (Chicago, Seattle, Los Angeles, San Francisco). Unofficial tool. Built by EuroScrape, updated 10 Nov 2026.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100