Overview

This workflow gathers a snapshot of visible AirDroid Business devices, exports the selected list fields to an Excel workbook, and sends the report link by Gmail. It supports either all visible devices or a defined group or device scope, so teams can reuse the same report path for routine inventory checks.

The Problem This Workflow Solves

Teams responsible for device records often need a current device list, but the scope may vary between all visible devices and a smaller named set. They also need a report they can share, along with enough status information to confirm what was exported and whether the email was delivered.

  • Clearer scope checks. The workflow verifies whether the request covers all devices or a named subset before it queries anything.
  • Shared report link. The workflow sends the workbook link through Gmail to the addresses you provide.
  • Consistent report fields. The workbook uses the same nine device fields each run, which makes review easier.
  • Visible run status. The run returns export and delivery status details that help confirm what happened.

Who This Is For

  • Device management teams. They can export the current device list for inventory, verification, or routine records.
  • Teams working with named device scopes. They can limit the query to selected groups or devices before exporting.
  • Recipients who need the report link. They receive the workbook link through Gmail after the report is created.

What Sets This Workflow Apart

  • Scope validation. The workflow stops early when a custom query is missing both group names and device names.
  • Fixed field set. It exports the same nine columns, including last online time, tags, and notes.
  • Time zone consistency. It uses one selected UTC offset for workbook timestamps, the file name, and the email display time.
  • Run-level status output. It returns separate results for scope resolution, query, export, and Gmail delivery.

How It Works

1
  1. Prepare report details
  2. The workflow collects the device scope, recipient addresses, and report time zone before it begins the query.
2
  1. Check the selected scope
  2. If you choose a custom scope, the workflow requires at least one group name or device name.
3
  1. Query matching devices
  2. The workflow resolves the scope when needed, then queries visible devices in that scope, up to 5,000 when all devices are selected.
4
  1. Export and notify
  2. The workflow writes the device list to Excel, creates a shareable report link, and sends that link through Gmail.

What You'll Need

  • AirDroid Business access and scope
    • You need authorized access to query visible devices, or named groups and devices for a custom scope.
  • Excel workbook connection
    • You need an authorized Excel connection to write the workbook that stores the device list.
  • Gmail recipient details
    • You need one or more recipient email addresses, separated by semicolons or commas.
  • Report time zone
    • You can optionally select a fixed UTC offset for timestamps, file names, and email time display.

How to Use

  1. Step 1. Choose the device scope.
  2. Select all visible devices, or enter at least one group name or device name for a custom scope.

  3. Step 2. Add the recipients and time zone.
  4. Enter the Gmail recipients and, if needed, choose the fixed UTC offset used for report times.

  5. Step 3. Connect the required services.
  6. Provide authorized AirDroid Business, Excel, and Gmail connections so the workflow can query, export, and send the report link.

FAQs

What happens if custom scope names are missing?
The run stops with an invalid scope result. You must provide at least one group name or device name.
How many devices can an all-device query return?
All-device queries return up to 5,000 devices visible to the current AirDroid Business credentials.
What does the report contain?
It includes last online time, online status, device name, group, model, system version, serial number, tags, and notes.
What if Gmail delivery fails after the workbook is created?
The run returns a Gmail delivery failed status and still provides the generated report link when available.
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 >