---
title: "Extract a list of Google Group members into a Sheet with Google Apps Script"
author: "Phil Bainbridge"
date: 2021-04-14T14:01:22+00:00
modified: 2021-04-14T14:01:26+00:00
canonical_url: https://pulse.appsscript.info/p/2021/04/extract-a-list-of-google-group-members-into-a-sheet-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2021/04/extract-a-list-of-google-group-members-into-a-sheet-with-google-apps-script.md
categories:
  - "Groups"
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2021/04/groups-who-can-view-members-1.png
description: "Extract a list of members of a Google Group (email address and role) into a Google Sheet. You simply enter the email address of the Google Group that you belong to and then run the Function."
---

# Extract a list of Google Group members into a Sheet with Google Apps Script

![Extract a list of Google Group members into a Sheet with Google Apps Script](https://pulse.appsscript.info/files/2021/04/groups-who-can-view-members-1.png)

> Image: Google
> Extract a list of members of a Google Group (email address and role) into a Google Sheet. You simply enter the email address of the Google Group that you belong to and then run the Function.

Source: *[The Gift of Script: Extract a list of Google Group members into a Sheet*](https://www.pbainbridge.co.uk/2021/04/extract-list-of-google-group-members.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/04/extract-a-list-of-google-group-members-into-a-sheet-with-google-apps-script/](https://pulse.appsscript.info/p/2021/04/extract-a-list-of-google-group-members-into-a-sheet-with-google-apps-script/)*