by petrus · v0.0.1
Manage employee roster with finance department mappings. Query employees, import from Feishu/Deel CSV exports, and view department mappings. Uses Google Sheets as backend.
This community listing does not yet include every recommended support, privacy, pricing, and permission disclosure. Review the available package permissions before installing.
Available inside your emploidai workspace after installation.
Available inside your emploidai workspace after installation.
Manage employee roster data with finance department mappings, using Google Sheets as backend storage.
This plugin helps finance teams maintain an employee roster with department categorization. It stores employee records in Google Sheets and provides tools for querying, importing, and mapping departments.
Search for employees by name or email with fuzzy matching.
Parameters:
query (required): Employee name or email to search for (partial match supported)Returns: Matching employee records with finance department assignment, job title, employment type, and status.
Batch import employee data from CSV exports. Supports smart column mapping for common HR system export formats, deduplication by employee ID and email, and preserves manually edited fields (finance_department, notes).
Parameters:
csv_content (required): CSV text content with header rowsource (required): Source system identifier (feishu or deel)dry_run (optional): Preview changes without writing (default: false)Returns: Summary of records added, updated, skipped, and any errors.
View or filter the mapping table from source departments to finance departments.
Parameters:
source_department (optional): Filter by department name (fuzzy match)Returns: List of department mappings with source system info.
Two methods supported (configure one):
OAuth2 — Users authorize via Google login. Requires OAuth Client ID and Client Secret from Google Cloud Console.
Service Account — For automated/headless use. Requires a GCP Service Account JSON key. Share the spreadsheet with the service account email.
Create a Google Spreadsheet — The plugin auto-initializes three sheets on first use:
Roster — Employee records (name, email, department, job title, etc.)Department_Mapping — Source department to finance department mappingsSync_Log — Import audit trailEnable Google Sheets API in Google Cloud Console
Configure credentials — Set up OAuth Client or Service Account (see Authentication above)
Install the plugin in Dify and enter:
https://docs.google.com/spreadsheets/d/{ID}/edit)# Search for an employee
Tool: Query Employee Roster
query: "jane.doe@company.com"
# Preview a CSV import
Tool: Import Roster from CSV
csv_content: "<CSV text>"
source: "deel"
dry_run: true
# Look up department mappings
Tool: Get Department Mapping
source_department: "Engineering"