Refresh Data for Stale Records

In the '[Account List]' Google Sheet, find all rows where the '[Status]' column is '[Refresh]'. Use Apollo to get the latest employee count for the company domain and update the '[Employee Count]' column. Then, change the '[Status]' to '[Refreshed]'.

Apps used

ApolloGoogle Sheets