In this blog post, we will learn how to export mobile devices in Google Workspace. As an IT Admin, you can see the devices that have access to your organizational data. You can fetch info about mobile devices, and their users for different locations through Google mobile device management system. Similarly, they get details about other devices like desktops, laptops, and tablets through Google workspace device management. Additionally, the admin can control devices in Google Workspace with some actions – approve, block, and wipe.

In this blog post, we will describe Export mobile devices in Google Workspace and focus on Foresight’s automation work procedures for this purpose.

Why do you need to export Mobile Devices in Google Workspace?

The Google administrator/ manager collects the details of mobile devices that use organizational data through managed user accounts. Google mobile device management helps to see the devices’ details about device type, device security, users' contact information, and installed apps. All you need to export a list of mobile devices. Mobile devices list can be used for different purposes -

For example, the IT admin can see - 

  1. How many android or IOS devices are registered
  2. How many devices are blocked or approved? The device's user.
  3. The IT admin can see the devices that were last synced 2 months ago. Then, they can block these unresponsive devices via Google Admin Console or using Foresight.

For these above reasons, you should export mobile devices in Google Workspace.

Export mobile devices in Google Workspace with Foresight

Foresight is a SaaS platform helping businesses streamline and automate Google Workspace workflows. It empowers administrators and users to design complex business workflows that cannot be done with native Google cloud services that too without any codes. Though the Google admin console allows you to manage mobile devices and endpoints, it cannot export the list of mobile devices. 

Here is how Foresight will work in this scenario -

  • It can export a list of mobile devices in the form of CSV.
  • Also, it sends an email with a CSV link of exported mobile devices to the IT manager and all this will happen in one workflow.

 Also, Foresight has other automation features that help to increase productivity.

Demo Video

Rule Creation

  1. Log in to Foresight with the Google Admin account. Go to the Rules page and click on the new rule New rule button button in the bottom-right corner.Bulk update employees information in Google Workspace
  2. Select the ManualTrigger.Export Group Members to CSV in Google Workspace
    • Select the List mobile devices action.
  3. Then, you may need to give authorization for Foresight in the Google Workspace account. After a successful permission grant, you will see the Access granted status.
  4. Then, choose the parameters for the Columns field that you want. 
  5. The next fields are related to sorting, leave them as they are. 
  6. In the next field, you can get the devices registered to a specific user via his/her primary email. This is optional. so, leave it empty. 
  7. And Last policy sync field is used to get the devices that are synced in a specific date range. This field is also optional. Leave it empty too.
  8. Click on Add Next Action and select Email action.
  9. Now you have to select the recipient name in the To field. Then you need to fill in the subject and email body. Please note, in the email message body, you need to add Mobile Devices CSV Download Link variable. These variables will start with {{ double opening curly brackets. Finally, click on Review.
  10. Enter the Rule name (All mobile devices list) and click on Create.

Rule Triggering

You can see the rule has been created. Now you have to trigger the rule. So, click on the trigger icon. This process will take a few seconds.

Verifying Results

  1. Some notifications will arrive in the top-right corner. Click on the notification icon and then click on View all. You can also visit the Logs page from the left sidebar. The logs show the rule is manually triggered successfully. You can see the mobile devices exported successfully and can download the devices list from the associated here link.
  2. Also, the manager will receive an email with the CSV download link.


You have learned how to export mobile devices in Google Workspace from this article and its benefits. Moreover, you came to know how Foresight can perform this action with ease within a few minutes. It’s a handy tool to perform this task with a manually created trigger. it also provides lots of automated work processes to complete your actions on Google workspace. Thus it increases productivity and sorts your workload. So start your 14 days with a free trial with Foresight now! You can read other articles related to this topic like -