Embedded Files
This script provides a utility for managing Google Group memberships based on data provided in a Google Sheet. The script processes entries to either add or remove members from a specified Google Group.
Key Features:
Key Features:
1. Custom menu in Google Sheets for easy access to the script functionality.
2. Automatically freezes the header row and formats it in bold for clarity.
3. Processes up to 450 entries in a batch before pausing to adhere to Google Apps Script execution quotas.
4. Logs the status of each operation (success or error) in the sheet's "Log" column (Column D).
5. Displays user-friendly alerts for the script's progress and completion.
Start by making a copy of this sheet.
Populate the sheet with group membership data (columns A to C).
Run the script from the "Group Member Handler" menu.
Script Execution Details:
Script Execution Details:
- If an invalid action is encountered, the script will log "Invalid action" in Column D.
- Errors such as "Group does not exist" or "Member does not exist" are handled and logged.
- For large datasets, the script informs the user when execution is complete.
Page updated
Report abuse