Lattice + ADP
Connect Lattice and ADP to Unify People Data Across Your Organization
Automate employee data sync between your performance management and payroll systems to eliminate manual work and keep HR records accurate.
Why integrate Lattice and ADP?
Lattice and ADP are the two systems most people teams can't live without — one running performance, engagement, and growth, the other handling payroll, benefits, and workforce records. When they don't talk to each other, HR teams end up manually reconciling employee data, chasing down compensation changes, and double-checking that new hires got set up correctly in both places. Connecting Lattice and ADP through tray.ai keeps workforce data flowing between them so both systems stay accurate and up to date.
Automate & integrate Lattice & ADP
Use case
Automated New Hire Provisioning
When a new employee record is created in ADP, tray.ai automatically provisions their Lattice profile, assigns them to the correct manager and department, and enrolls them in the appropriate onboarding review cycle. New hires are ready to engage with Lattice on day one without any manual setup from the HR team.
Use case
Compensation Change Sync from Lattice to ADP
After compensation reviews are completed and approved in Lattice, tray.ai automatically pushes the updated salary, bonus, or equity data into ADP's payroll records. No more manually re-entering approved compensation decisions into a separate payroll system, and employees get paid correctly in the next cycle.
Use case
Employee Profile Updates and Department Transfers
When an employee's job title, department, location, or manager changes in ADP, tray.ai syncs those updates to Lattice automatically so performance reviews, OKRs, and org chart data stay accurate. Keeping both systems in sync prevents review cycles from going to the wrong manager and ensures reporting hierarchies reflect how the org actually looks today.
Use case
Offboarding and Termination Workflows
When an employee termination is recorded in ADP, tray.ai triggers an automated offboarding sequence in Lattice — deactivating the employee profile, archiving their performance data, and notifying their manager to complete any pending reviews. Sensitive performance records get handled properly at the time of departure, not weeks later.
Use case
Performance Cycle Enrollment Based on ADP Employment Data
tray.ai can use ADP employment data — hire date, employee type, work location — to automatically enroll employees in the correct Lattice performance review cycles. Full-time versus part-time employees, employees in different regions, or those who just crossed their 90-day anniversary can all be routed into the right review cadence without anyone managing a list manually.
Use case
Manager Change and Reporting Line Updates
When a manager change is recorded in ADP, tray.ai updates the reporting relationship in Lattice so that 1:1 meetings, ongoing feedback, and future review cycles are immediately routed to the new manager. This prevents the frustrating scenario where an employee's performance data sits under a former manager who can no longer access or act on it.
Use case
Headcount and Workforce Analytics Consolidation
By syncing ADP headcount, employment status, and demographic data into Lattice, People Analytics teams can build richer engagement and performance reports that incorporate payroll-level workforce attributes. HR leaders can then correlate compensation bands, tenure, and department data with performance ratings and engagement scores.
Get started with Lattice & ADP integration today
Lattice & ADP Challenges
What challenges are there when working with Lattice & ADP and how will using Tray.ai help?
Challenge
Maintaining a Consistent Employee Identifier Across Both Systems
ADP and Lattice each use their own internal employee ID formats, and without a shared unique identifier, matching records between the two systems during automated syncs can produce duplicate profiles, misrouted data, or failed updates — especially when employee names or emails change.
How Tray.ai Can Help:
tray.ai lets you build an identity-matching layer that maps ADP employee IDs to Lattice user records using a combination of work email, employee number, and name. Custom data transformations normalize identifier formats across both systems, and you can maintain a lookup table within workflows to keep record matching accurate even when individual fields change over time.
Challenge
Handling Compensation Data Sensitivity and Access Controls
Compensation data flowing between Lattice and ADP is among the most sensitive information a company manages. Integrations need to transmit salary, bonus, and equity values securely and only trigger updates when changes are fully approved — not during draft or pending states.
How Tray.ai Can Help:
tray.ai lets you build conditional logic that only triggers compensation sync workflows when Lattice marks a change as fully approved and finalized. All data in transit is encrypted, and tray.ai's role-based access controls ensure that only authorized personnel can view or modify compensation-related workflow configurations, supporting your internal data governance requirements.
Challenge
Managing Complex Organizational Hierarchies and Matrix Reporting
Many organizations have matrixed reporting structures where an employee may have a primary manager in ADP but a different functional manager in Lattice. Syncing org hierarchy changes without accidentally overwriting intentional Lattice-specific configurations is a real integration headache.
How Tray.ai Can Help:
tray.ai's flexible data mapping lets you define which fields are authoritative in ADP versus which are managed independently within Lattice. You can configure sync logic that updates primary reporting relationships from ADP while preserving Lattice-specific manager assignments, so automated syncs don't undo your intentional HR configurations.
Challenge
Dealing with ADP API Rate Limits and Batch Processing
ADP's APIs have rate limits that cause problems when large volumes of employee changes — like those during an annual reorganization or open enrollment — need to be synced to Lattice simultaneously, potentially resulting in failed or incomplete updates.
How Tray.ai Can Help:
tray.ai handles ADP API rate limits natively through built-in retry logic, request throttling, and queue management. During high-volume sync events, tray.ai batches requests appropriately and automatically retries failed calls with exponential backoff, so all employee records eventually sync accurately without manual intervention or workflow re-triggering.
Challenge
Ensuring Data Sync Reliability During ADP Payroll Processing Windows
ADP often locks or restricts certain employee record updates during active payroll processing windows. If tray.ai attempts to push compensation or employee updates during a locked period, integration workflows can fail silently — data appears synced but was never actually written to ADP.
How Tray.ai Can Help:
tray.ai lets you build scheduling logic that accounts for your organization's ADP payroll processing calendar, queuing sensitive updates to run after payroll windows have closed. Combined with error handling and alerting, tray.ai holds any update that can't be immediately applied, retries it at the next available window, and notifies your HR Ops team if manual review is needed.
Start using our pre-built Lattice & ADP templates today
Start from scratch or use one of our pre-built Lattice & ADP templates to quickly solve your most common use cases.
Lattice & ADP Templates
Find pre-built Lattice & ADP solutions for common use cases
Template
New Employee in ADP → Create Lattice Profile
Automatically creates a new employee profile in Lattice whenever a new hire record is finalized in ADP, populating all relevant fields including name, email, manager, department, and start date, and triggering onboarding check-in enrollment.
Steps:
- Trigger: New employee record created or activated in ADP Workforce Now
- Map ADP employee fields (name, job title, department, manager, work email) to Lattice profile schema
- Create new Lattice user profile and enroll employee in configured onboarding review cycle
Connectors Used: ADP, Lattice
Template
Lattice Compensation Approval → Update ADP Payroll Record
When a compensation change is approved through Lattice's compensation review workflow, this template automatically updates the corresponding employee's salary or bonus data in ADP, so payroll reflects the latest approved compensation without manual re-entry.
Steps:
- Trigger: Compensation change approved and finalized in Lattice compensation module
- Extract employee ID, new compensation values, effective date, and change type from Lattice event
- Update the matching ADP employee record with new compensation data tied to the correct effective date
Connectors Used: Lattice, ADP
Template
ADP Employee Update → Sync Changes to Lattice
Monitors ADP for changes to employee job title, department, manager, or location and automatically applies those updates to the corresponding Lattice profile, keeping performance management data aligned with the authoritative HR record in ADP.
Steps:
- Trigger: Employee record updated in ADP (job title, department, manager, or location field change)
- Identify the matching Lattice user by employee ID or work email
- Apply updated field values to the Lattice profile and log the sync event for audit purposes
Connectors Used: ADP, Lattice
Template
ADP Termination → Deactivate Lattice Profile and Notify Manager
When an employee termination is recorded in ADP, this template deactivates the employee's Lattice account, archives their performance and feedback history, and sends an automated notification to their manager prompting them to complete any outstanding reviews.
Steps:
- Trigger: Employee status changed to Terminated in ADP Workforce Now
- Deactivate the corresponding Lattice user profile and archive performance, feedback, and goal data
- Send notification to the employee's manager in Lattice (or via email/Slack) to complete any pending reviews before access is removed
Connectors Used: ADP, Lattice
Template
ADP Hire Date Milestone → Enroll in Lattice Review Cycle
Uses ADP hire date and employee type data to automatically enroll employees in the correct Lattice performance review cycle when they hit key employment milestones, such as 30, 60, or 90 days of tenure or their annual review anniversary.
Steps:
- Scheduled trigger: Daily check of ADP employee records for upcoming hire date milestones
- Filter employees who have reached the configured milestone (e.g., 90-day anniversary) based on ADP hire date
- Enroll qualifying employees in the designated Lattice review cycle with the correct reviewer assignments
Connectors Used: ADP, Lattice
Template
Bidirectional Employee Data Audit and Reconciliation Report
Runs a scheduled comparison between ADP and Lattice employee records to identify discrepancies in fields like manager, department, job title, and employment status, then generates a reconciliation report sent to the HR Operations team for review and remediation.
Steps:
- Scheduled trigger: Weekly pull of all active employee records from both ADP and Lattice
- Compare key fields (manager, department, title, status) across both systems and flag mismatches
- Generate and deliver a formatted discrepancy report to the HR Operations team via email or Slack
Connectors Used: ADP, Lattice