In this article we aims to provide a comprehensive guide on how to export all suspended users in Google Workspace. The management of user accounts in Google Workspace is a crucial aspect of maintaining a well-organized and secure digital environment.

However, there may be instances where certain user accounts become suspended for various reasons, such as security concerns or inactive usage. In such cases, it becomes necessary for administrators to efficiently handle and export all suspended users in Google Workspace.

Why do you need to Export Suspended Users in Google Workspace?

As we have mentioned, you might need to suspend an employee's google account temporarily or permanently. To save up the costs, the Google workspace accounts need to be suspended as well and it also helps to prevent any leakage of important business information. Organizations, especially the HR department, must keep track of the employees who are leaving (or whose accounts are getting suspended) for operational purposes.

As a result, the company suspends the Google Workspace account in order to reduce expenditures and improve operational efficiency. Although retrieving account information manually is a tedious task, automating it can be more efficient.

Benefits of Exporting All Suspended Users in Google Workspace

  • Enhanced Security and Compliance: Exporting all suspended user accounts in Google Workspace allows administrators to maintain a comprehensive record of all user activities and data. T
  • Simplified User Management: Exporting suspended user accounts provides administrators with a streamlined approach to user management. By exporting the suspended accounts, administrators can easily review and analyze the reasons behind the suspensions.
  • Efficient Audit Trail: Exporting suspended user accounts creates a detailed audit trail of all actions performed on these accounts. This comprehensive record helps administrators to track and monitor any changes made to the suspended accounts, providing transparency and accountability.

How to Export Suspended Google Workspace accounts through automation?

The Foresight automation tool simplifies the process of managing suspended users in Google Workspace. The tool simplifies the process of exporting all suspended users by providing an efficient and seamless approach. Foresight's advanced features and user-friendly interface make exporting suspended users' data easy, ensuring a smooth transition and comprehensive data management.

As a result of automating this process, Foresight allows administrators to focus on other crucial aspects of Google Workspace user management.

Video Demo 

Instructions for setting up the Foresight Automation Process

Here is a detailed guide explaining the Foresight rule setup process –

  1. First, log in to Foresight using your Google Workspace Account.
  2. Go to the Rules Page and click on the Rule Foresight Automation 2-2.png+ Button.
  3. Select the Manual Trigger.
  4. Then, select the List users action.
  5. First, you need to grant Foresight permission if you see Sign in with Google or Access expired.
  6. After that, add Email, First Name, Last Name, and Is Suspended in the Columns field. Then, select true in the User suspended field. Leave the rest of the fields as default.

7. Click Add Next Action. Select Upload data to Drive action. This is our updated action for this use case.

8. Then, select the Users CSV Download Link in the CSV file URL field. Also, select the Google Drive folder path in the Google Drive folder field. Your CSV file will be exported here.

9. Click Add Next Action. Select the Email action. After that, you should give an email ID in the To field and create a subject line for the email.

10. Create an email body. Click Add variable (v) to add the Users CSV Download Link. Click Review.

11 Give a Rule Name (Suspend Users List) and click Create.

Rule Trigger

Click the play button to trigger the rule.

Verifying the Result

  1. From the Logs page, you will see that the rule has been executed successfully. Download the CSV from the here link. We have created a list of 30 suspended users.

2. Also, check the CSV file uploaded to Google Drive. 

3. Again, you can get the CSV file by clicking the email link.


Foresight provides a useful solution for exporting all suspended users in Google Workspace. With Foresight's automation tool, administrators can streamline their workflow and enhance their foresight when managing suspended users. This exported file can be used for auditing purposes, record-keeping, or any other requirement that may arise within your organization. Take advantage of this feature in Google Workspace to maintain a well-organized and efficient user management system.

By following the steps outlined in this blog post, you can easily filter and export a CSV file containing the necessary information about your suspended users using Foresight Automation Tool.

Now, try to perform this automation action with Foresight.

Initially, you can choose the 14-day free trial and later upgrade it. Learn more topics related to this one, like How to Export Google Workspace Licenses, etc.