Intelligex Logo
Intelligex Logo
Get A Consultation

Human Resources & People Ops

Building One Internal Request Hub with Airtable and Make

13 August 2026|

An 85-person manufacturer replaced scattered emails, chats, and spreadsheets with a central request hub. Google Forms captures structured submissions, Make routes and monitors work, Airtable records ownership and status, and Gmail delivers confirmations, reminders, approval requests, and escalations.

Automating Shift Scheduling and Open-Shift Coverage

11 August 2026|

A fictional manufacturer replaced message-based scheduling and disconnected spreadsheets with structured availability, approval, conflict, and open-shift workflows. Airtable became the operational record, while Zapier connected Google Drive and Gmail for folders, notifications, reminders, and exception monitoring.

Safety Incident Reporting and Corrective Action Automation

5 August 2026|

A manufacturer replaced calls, messages, and spreadsheet tracking with a controlled Microsoft 365 workflow. Microsoft Forms captures safety events, Power Automate routes alerts and approvals, Microsoft Lists manages investigations and corrective actions, and SharePoint retains supporting evidence.

Tracking Policy Distribution and Employee Acknowledgment

4 August 2026|

A fictional professional services firm replaced policy-update emails and a spreadsheet with SharePoint records, Microsoft Forms acknowledgment, Power Automate workflows, and Outlook notices. The design preserves version history, assigns the correct audience, follows up on overdue responses, and retains reviewable evidence.

Automating Access Requests with Dual Approval and Expiry

31 July 2026|

A fictional consultancy replaced informal software and data-access requests with a controlled workflow connecting Microsoft Forms, Microsoft Lists, Power Automate, and Microsoft Entra ID. The system validates identities, obtains manager and data-owner approval, creates provisioning tasks, records evidence, and schedules reviews or removal.

Automating Mobile Expense Claims from Receipt to Payment

19 July 2026|

A 58-person consulting firm replaced emailed receipts and reimbursement spreadsheets with a mobile claim form, controlled approval workflow, centralized receipt storage, QuickBooks synchronization, automated reminders, and an auditable payment-status process.

Building Workforce Capacity Planning in Google Workspace

16 July 2026|

A fictional project services firm replaced disconnected staffing and project spreadsheets with a 13-week capacity planning system. Google Forms, Google Sheets, Google Apps Script, Gmail, and Google Drive provide validated updates, scenario reporting, review tasks, reminders, escalation, and hiring indicators.

Securing Payroll Change Requests with Approval Controls

16 July 2026|

A fictional 105-person manufacturer replaced emailed salary, banking, tax, benefit, and deduction requests with a controlled Airtable workflow. Zapier coordinates validation, restricted Google Drive folders, Gmail notices, approvals, cutoff reminders, and audit records while payroll staff retain final authority over every payroll-system change.

Building a Searchable Skills and Certification Matrix

16 July 2026|

An 80-person technical services firm replaced disconnected spreadsheets, resumes, and messages with a controlled skills matrix. Microsoft Forms, Lists, Power Automate, and Teams support profile updates, manager verification, certification evidence, expiry reminders, resource searches, and operational reporting.

Secure Employee Document Collection with Google Workspace

16 July 2026|

A distributed employer replaced email attachments and manually maintained checklists with a controlled Google Workspace workflow. Google Forms collects files, Google Drive applies storage conventions, Google Sheets tracks requirements, and Apps Script sends reminders, escalates overdue tasks, and records processing history.

Go to Top