How it works

1. A schedule starts the run every day at 09:00. 2. An HTTP request sends a search to the funding data API asking for organizations of type investor. 3. Parse JSON turns the response text into fields. 4. For each investor returned, a row is added to your Google Sheet with name, location, investment stage and description.