Zero Touch – Replace Employees Access Card (Verkada & Zapier)

Written by:

Overview:

I designed and implemented a Zapier workflow to automate the process of updating employee badge IDs in Verkada, triggered by changes in a Google Sheet.

Key Features:

• Trigger: Workflow is initiated when a row is updated in a Google Sheet (e.g., an employee’s badge is changed).

• Authentication: Zapier securely connects with the Verkada API using API key authorization.

• Search Function: The Zap searches Verkada for the employee’s current (old) badge ID based on the data from the sheet.

• Automation Logic: Once the old badge is located, the Zap deletes it and adds the new badge ID to the employee’s profile in Verkada.

• Error Handling: Built-in checks ensure badge updates only occur when necessary, and error handling is included for edge cases.

Impact: This automation significantly reduced manual work for the IT and security teams, ensured badge records were consistently up-to-date, and improved onboarding/offboarding accuracy.