Automate employee directory updates from HRIS to Google Sheets

• Automatically update employee directories to reflect changes in real-time.
• Reduce manual data entry errors by automating data synchronization.
• Notify team members of updates in employee information via Slack.

Triggers every six hours using a cron job. Fetches employee directory data from BambooHR. Normalizes the fetched data for consistency. Writes the normalized data to Google Sheets. Sends a notification to Slack with the update details.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure the BambooHR credentials with your API token.
3. 3
   Set the Google Sheets document ID and range for data insertion.
4. 4
   Adjust the Slack channel settings for notifications.
5. 5
   Activate the workflow to start automatic updates.