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

1
  1. Validate the request
  2. The workflow checks the recipient email, app name, group list, and selected time zone before any device lookup.
2
  1. Resolve the device scope
  2. It converts group names into group IDs, retrieves devices from those groups, and removes duplicate device IDs.
3
  1. Scan each device
  2. The workflow checks the target app on each device and counts installed versions, not installed devices, and read failures.
4
  1. Build and send the report
  2. 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

  1. Step 1. Prepare the connected services
  2. Set up AirDroid Business, Microsoft Excel, Microsoft OneDrive, and Outlook credentials before you run the template.

  3. Step 2. Enter the report inputs
  4. Provide the app name, the target group names, one recipient email address, and the time zone for report timestamps.

  5. Step 3. Review the run result
  6. Check the returned Success value, RunResult, WorkbookUrl, and ErrorMessage when the run does not complete.

FAQs

What happens if a group name does not match?
The run stops with a group not found result. Group names must match the console names exactly.
Does the workflow change any devices or apps?
No. It only reads app data, creates the report workbook, and sends the link by email.
What if the report workbook link cannot be created?
The workflow returns a failed export result and sends a failure notification email when that link is unavailable.
What does the success result include?
A successful run returns the workbook URL and aggregate counts for the scanned devices.
Was This Page Helpful?

More Workflows for Inspiration

🔧
Account Activity Log Query and Export
Exports account activity logs from the chosen days, then emails a OneDrive workbook link.
Learn more >
🔧
Device Unenroll and Transfer Log Query
Query recent device unenrollment and group transfer logs, then send an Excel report link by email.
Learn more >
🔧
Auto-add Tags to Alerting Devices
When an alert fires, this workflow tags the target device for faster filtering and follow-up.
Learn more >