Overview
This template checks specified AirDroid Business groups for devices currently in Lost Mode, builds an online Excel report, and shares the link by email. It fits a repeatable operating step for teams that need a current device list and a consistent handoff to recipients.
The Problem This Workflow Solves
Teams that monitor managed devices need a current view of devices marked as Lost Mode in specific groups. They also need the group scope checked, the time context shown in the chosen time zone, and a report link sent to the right recipients. If the group names are wrong or the search is too broad, the run must stop with a clear reason.
- Faster review. The report gathers matching devices into one list instead of checking groups one by one.
- Clearer handoff. The workflow emails the report link to selected recipients after the list is prepared.
- Defined scope. The workflow validates exact group names before it searches for devices.
- Easy verification. The workbook shows device details, current status, and last online time in one place.
Who This Is For
- Device operations teams. They need a current Lost Mode list for selected groups.
- Security or incident responders. They need a shared report link for follow-up on affected devices.
- Teams running scheduled checks. They can reuse the template for repeated report generation with saved defaults.
What Sets This Workflow Apart
- Exact group matching. The workflow stops when a group name is missing or matches more than one path.
- Single-page limit. The device query ends when the result set exceeds 100 devices.
- Duplicate handling. The report keeps one row per device ID before it writes the workbook.
- Time zone control. The workflow formats the run time and last online time in the selected display zone.
How It Works
- Validate the inputs
- The workflow checks group names, the report time zone, and recipient emails before it continues.
- Resolve the target groups
- It resolves each exact group name, then stops if any name is missing or ambiguous.
- Search for Lost Mode devices
- The workflow searches the selected groups for devices currently in Lost Mode and accepts only one page of results.
- Build the workbook
- It deduplicates devices, formats the report rows, and creates a new Excel workbook.
- Create the share link and send email
- The workflow creates an anonymous read-only link, then sends the report email to each validated recipient.
- Return the results
- It returns the status, report link, Lost Mode device count, email delivery counts, and any failure message.
What You'll Need
- AirDroid Business group names
- You must enter at least one exact group name and no more than 50, separated by English commas.
- Report display time zone
- You must select one supported time zone so the run time and last online time display correctly.
- Recipient email addresses
- You must enter at least one recipient and no more than 50, separated by English commas.
- Authorized service connections
- You need working credentials for AirDroid Business, Microsoft Excel, Microsoft OneDrive, and Gmail.
How to Use
- Step 1. Connect the required services
- Step 2. Enter the report settings
- Step 3. Save defaults for repeat runs
- Step 4. Run and share the report
Bind the AirDroid Business, Excel, OneDrive, and Gmail credentials used by the workflow.
Fill in the group names, select the report time zone, and enter the recipient email addresses.
If you plan scheduled runs, set default values and make the custom inputs optional.
Start the workflow and review the returned report link, device count, and email delivery status.