Quick overview
This workflow runs on the first day of each month to search SourceGeek for candidates matching a defined query, adds only new matches to an existing SourceGeek talent pool sheet, and posts a monthly summary with counts and a link to the updated sheet in Slack.
How it works
- Runs on a schedule at 08:00 on the first day of every month.
- Sets the SourceGeek pool sheet ID and the candidate search query used for this refresh.
- Searches SourceGeek for matching candidates using a fast lead search and returns up to 20 results.
- Adds the search results to the specified SourceGeek sheet, skipping candidates that are already in the pool and returning new/duplicate counts and the sheet URL.
- Posts a message to a Slack channel summarizing how many candidates were added and how many were duplicates, with a link to the SourceGeek sheet.
Setup
- Install the community node n8n-nodes-sourcegeek and add a SourceGeek API credential using an API key from SourceGeek.
- Add a Slack credential/connection that can post messages to your target channel.
- Replace the placeholder SourceGeek pool sheet ID and adjust the SourceGeek search query to match the role and location you recruit for.
- Update the Slack channel (currently set to #recruiting) where the monthly summary should be posted.