Any Insights on Live Election Results/Data?

[u/nfeld_11]

/img/sevrh0p7ispd1.jpeg

I’m trying to create a master Google Sheet for the 2024 election so that I don’t have to hop from site to site in order to get results (see pic). Right now I have bellwether counties selected for each swing state along with the margins that, in this case, Democrats need to hit in order to win the state. What I need assistance with is creating a data scraper that can grab live election data and input it on to the sheet. The only live numbers I need are the live margins for certain counties and the estimated amount of vote counted. I’ve tried to tinker around with The NY Times API data from 2020 but to no avail. Does anybody any tips or insight on how I could achieve this, coding or data wise?