Anyone know of any FREE API's or some way to pull live election data into Google Sheets?

You might ask this on the politics board? Hopefully someone over there is nerdy enough to know how to do what you are asking.

The NYT uses data from the AP. They claim the following:

Quote:

---

We report vote totals provided by The Associated Press, which collects results from states, counties and townships through a network of websites and more than 4,000 on-the-ground correspondents.

---

It sounds like they scrape county websites for live totals.

It would be a big project to identify all the sites but I suspect there are only a handful of vendors building those sites so it probably wouldn't be too difficult to do the scraping once the pages are identified.

Probably too late for this election but you could use this election to test a few counties in key battleground states.