There are many occasions when the Google WorkSpace administrator of an organization needs to export group members to a CSV file to know who the users in the particular group are. This action may be required as part of a permissions review, security audit, or import and export of members into another system. 

This can be explained with the help of an example. Let’s say the engineering department manager needs the list of new interns in the organization. This is one instance when you need to export group members to CSV.

How to export Group members to CSV

You can export the members of a group to CSV by either using the

  • Google WorkSpace Admin
  • With the help of a third-party Google WorkSpace assistance app like Foresight. 

Of course, we will explain the procedure for exporting Group members to CSV. But first, we will be telling you a bit about exporting with the help of Google WorkSpace Admin.

Exporting Group members to CSV with the help of Google WorkSpace Admin

  1. First of all, you need to sign in to Google Groups.
  2. After that, you need to click on the group name whose members you need to export to CSV.
  3. On the left side of the Group page, click on Members.
  4. On the top of the list, click Export list.

Bulk export group members to CSV

You can bulk export group members of CSV using Google Groups. But for groups with members over 5000, you need to run a bit of code. But as we have already mentioned that we wish to do this without any code, so we will not be using this method.  Also, this action can be performed with the help of several third-party tools only. Some of them require a bit of coding expertise as well. So, we will be leaving all these and focusing on the easiest way out – Foresight.  

How does Foresight help?

Foresight is a SaaS platform to help businesses streamline and automate Google Workspace workflows without learning to code. It empowers administrators and users to design complex business workflows that cannot be done with native Google cloud services and work smarter. It helps automate the workflow in Google WorkSpace. It allows you to export group members to CSV. Many triggers and actions in Foresight help you to complete a task automatically without using even a single line of code. You can also Bulk move Google Chrome devices to another organizational unit using Foresight.

How to export Group members to CSV with Foresight

Step 1: Rule creation

  1. Log in to your Foresight account with your Google Admin account. Go to the Rules page and click on the New Rule New rule button button.
  2. Select Manual Trigger, then select List Group Members action.
  3. Grant Foresight the necessary permissions by clicking the Sign in with Google button, after permission is granted, you will see a green label "Access granted".
  4. Then select the Group Email of whose members you want to export.
  5. In the Columns field, leave the default columns as they are.
  6. In the Include Indirect Members field, you have to leave the setting as False. That’s because indirect members are the members of a nested group. If you are confused about any field. Look at the question mark icon at the right-hand side of the field. By hovering your mouse over it, you can get information about the field.
  7. Scroll up and click on Add Next action. Select Email action.
  8. You might again need to give Foresight the necessary permissions again.
  9. Enter the email of the manager to whom you want to send the email. Enter a subject in the message body. In the message body, enter the Group members CSV download link. Type in the double curly brackets {{ and then select the Group members CSV download link. After completing the message body, click Review.
  10. Enter the Rule name and then click on Create.

Step 2: Rule Triggering

  1. As you can see, the rule is created; now click on the Play icon to trigger the rule.

Step 3: Rule Verification

  1. The rule has been triggered. A notification will appear on the top right-hand corner. Click on the notification icon, then click on Show All or go to the Logs page to see the result. Click on the link to download the CSV. You will get the list of the group members and all their data.
  2. The manager also receives an email with the CSV file.

Wrapping up

That’s not all, you can also Bulk add members to Google Group using Foresight or Bulk remove members from Google Group. For more information, visit the xFanatical website.