The @unitedstates project makes data on currently serving members of Congress available in a variety of formats.
The getLegislatorData.gs Google Apps Script is a Google Sheet-bound script that uses the URL Fetch Service to retrieve this data, add hyperlinks to social media accounts, split up the address column, and set the resulting values in the Sheet. The URL Fetch Service is subject to quotas and limitations.
You can find more data and info on the @unitedstates project at GitHub.
{
"oauthScopes": [
"https://www.googleapis.com/auth/spreadsheets.currentonly",
"https://www.googleapis.com/auth/script.external_request"
]
}
Jordan Bradford - GitHub: jrdnbradford
This script is licensed under the GPLv3 license.