Overview

This template collects AirDroid Business account activity logs for a selected time window, writes them to an Excel workbook in OneDrive, and shares the workbook by email. It supports repeatable reporting for operations and audit-style review, while keeping the report time, file name, and email content aligned to the chosen time zone.

The Problem This Workflow Solves

Teams responsible for account oversight often need a current log of AirDroid Business activity, a readable workbook, and a link they can send to others. They also need to know whether the requested period is valid, whether the export stayed within limits, and whether sharing or delivery succeeded.

  • Faster handoff. The workflow sends a workbook link to validated recipients after export succeeds.
  • Clearer review. The report groups log details into a workbook that reviewers can open directly.
  • Defined limits. The run checks the requested range before export and flags the 2,500 record limit.
  • Visible failures. The result fields show where the run stopped, which helps narrow follow-up action.

Who This Is For

  • Operations teams. They can request recent activity logs for routine oversight or scheduled reporting.
  • Audit and review workflows. They can distribute a workbook link for record checks and handoffs.
  • Teams sharing report links. They can send a read-only workbook link to multiple recipients by email.

What Sets This Workflow Apart

  • Early input checks. The workflow rejects invalid days and email addresses before it queries or exports data.
  • Time zone alignment. It uses the selected report time zone for the file name, email time, and returned timestamp.
  • Limit-aware reporting. It still exports acquired data and prompts for a shorter range when the record cap is reached.
  • Share link verification. The workflow checks that OneDrive returns a usable anonymous link before sending email.

How It Works

1
  1. Validate the request
  2. The workflow checks the day range, recipient list, and report time zone before any log query starts.
2
  1. Build the report window
  2. It calculates the start and end dates, then prepares the run context for the selected time window.
3
  1. Query account activity logs
  2. The workflow pages through AirDroid Business activity logs and stops early if a query error occurs.
4
  1. Create the workbook and link
  2. It writes the log rows to Excel in OneDrive, then creates an anonymous read-only sharing link.
5
  1. Send the report by email
  2. The workflow sends the workbook link through Gmail and returns success or failure details.

What You'll Need

  • AirDroid Business access
    • An authorized credential must be able to query account activity logs in the requested time window.
  • Excel and OneDrive connections
    • Authorized Microsoft credentials must write the workbook and create the anonymous read-only sharing link.
  • Gmail recipients and report settings
    • Enter valid comma-separated email addresses, choose 1 to 90 days, and optionally select a report time zone.

How to Use

  1. Step 1. Connect the required services
  2. Provide authorized AirDroid Business, Excel, OneDrive, and Gmail credentials before you run the template.

  3. Step 2. Enter the report settings
  4. Set the number of days, add the recipient email addresses, and choose the report time zone if needed.

  5. Step 3. Review the delivery result
  6. Check the returned report link, email status, and error message after the run finishes.

FAQs

What happens if I choose more than 90 days?
The run stops during input validation. Days must be a whole number from 1 to 90.
What if the log query returns too many records?
The workflow exports the data it already collected, then notes that the time range should be shortened.
Can I still use the link if Gmail fails?
Yes. If OneDrive created the link, the run can return it even when Gmail delivery fails.
What does the time zone setting affect?
It affects the workbook name, the report time in the email, and the returned triggered time.
Was This Page Helpful?

More Workflows for Inspiration

🔧
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 >
📊
Device list report export and notification
Export the current device list to Excel and email the report link after scope checks.
Learn more >