How it works

1. A schedule starts the workflow every week. 2. Google Sheets - Get Rows reads the target company domains (column Domain). 3. For each domain, an HTTP request calls the Apollo people search API with your API key. 4. Parse JSON turns the answer into fields. 5. For each person found, Google Sheets - Add a Row saves the domain, first and last name, job title and LinkedIn address in the results sheet.