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
- Prepare report details
- The workflow collects the device scope, recipient addresses, and report time zone before it begins the query.
- Check the selected scope
- If you choose a custom scope, the workflow requires at least one group name or device name.
- Query matching devices
- The workflow resolves the scope when needed, then queries visible devices in that scope, up to 5,000 when all devices are selected.
- Export and notify
- 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
- Step 1. Choose the device scope.
- Step 2. Add the recipients and time zone.
- Step 3. Connect the required services.
Select all visible devices, or enter at least one group name or device name for a custom scope.
Enter the Gmail recipients and, if needed, choose the fixed UTC offset used for report times.
Provide authorized AirDroid Business, Excel, and Gmail connections so the workflow can query, export, and send the report link.