Overview
This template checks the app version distribution for a named business app across selected device groups. It builds an online Excel workbook, creates a share link, and emails that link to one recipient. The result supports a repeatable reporting step in device-management operations without changing the app or the devices.
The Problem This Workflow Solves
Teams responsible for monitored devices often need a current view of one business app across several groups. They must confirm which versions are installed, note devices where the app is missing, and handle failed reads or export issues before sharing the report with others.
- Version visibility. The report groups devices by version, so the team can review the distribution in one place.
- Missing app check. The output separates not installed devices, which makes the scope easier to interpret.
- Shareable record. The workflow creates an online spreadsheet and sends its access link by email.
- Clear failure handling. The run returns a reason when input, group resolution, export, or mail delivery fails.
Who This Is For
- Device operations teams. They need a grouped version snapshot for business apps on managed devices.
- Teams responsible for pilot groups. They compare app versions across stores, warehouses, or other selected groups.
- People sharing operational reports. They send a timestamped spreadsheet link to one recipient after each run.
What Sets This Workflow Apart
- Input checks. The workflow validates the app name, group names, recipient email, and time zone before device queries start.
- Scoped device resolution. It resolves group names, merges the devices, and removes duplicates before scanning begins.
- Run-level summary. It labels the run as Success, Partial Success, or Failed based on the collected results.
- Linked delivery. It creates the workbook first, then creates a share link, and only then sends the email.
How It Works
- Validate the request
- The workflow checks the recipient email, app name, group list, and selected time zone before any device lookup.
- Resolve the device scope
- It converts group names into group IDs, retrieves devices from those groups, and removes duplicate device IDs.
- Scan each device
- The workflow checks the target app on each device and counts installed versions, not installed devices, and read failures.
- Build and send the report
- It writes the summary into an online Excel workbook, creates a share link, and emails that link to the recipient.
What You'll Need
- AirDroid Business access and device-group scope
- You need authorized access to resolve group names and query devices within the selected groups.
- Microsoft Excel, OneDrive, and Outlook connections
- You need credentials for workbook creation, sharing link generation, and email delivery through the connected accounts.
- Run inputs
- You must enter the app name, one or more exact group names, one valid recipient email, and a content time zone.
How to Use
- Step 1. Prepare the connected services
- Step 2. Enter the report inputs
- Step 3. Review the run result
Set up AirDroid Business, Microsoft Excel, Microsoft OneDrive, and Outlook credentials before you run the template.
Provide the app name, the target group names, one recipient email address, and the time zone for report timestamps.
Check the returned Success value, RunResult, WorkbookUrl, and ErrorMessage when the run does not complete.