Better Sheets
Log in
  • Budget Template
  • Calendar Template
  • CRM Template
  • Dashboard Template
  • Finance Template
  • Habit Tracker
  • Monthly Budget Template
  • Project Management Template
  • Time Tracking Template
  • Weight Tracker

Sheet products

  • Software in Sheets
  • Premium Templates
  • Info in Sheets
  • Wild Sheets
Explore Templates

Courses

  • Spreadsheet Automation 101
  • Build Better Dashboards
  • Supercharge Your Sheets
  • Adventures in AI
  • All courses

Apps Script

  • Apps Script Explainer
  • Code Snippets
  • Spreadsheet Automation 101
  • Code Consultations
  • Apps Script directory

Tutorials

  • Automating
  • Better Sheets Updates
  • Build Your Own Tools
  • Data Analysis in Google Sheets
  • Data Management
  • Embed Google Sheets
  • For Beginners
  • Formula Combinations
  • Google Apps Script - Custom Functions in Google Sheets
  • Google Forms
  • All tutorials
All Courses Better Sheets on YouTube

Build from Sheets

  • Sites
  • OnlySheets

URL Generators

  • Sheet to URL
  • CSV URL Generator
  • XLSX URL Generator
  • PDF URL Generator
  • Copy URL Generator

More tools

  • Discover Sheet Tools
  • Create Portals
  • Portal Builder
All tools

Directory

  • Google Sheets formula generator
  • Formula Library

Popular formulas

  • SUMIF
  • COUNTIF
  • VLOOKUP
  • FILTER
  • IMAGE
  • SUMPRODUCT
  • GOOGLEFINANCE

Quick Help

  • QUERY Generator
  • SPARKLINE Generator
  • Conditional Formatting Generator
  • REGEXMATCH Generator
  • REGEXREPLACE Generator
Browse all formulas

Hub

  • Free Hub
  • Questions
  • Explained
  • YouTube Annotated
  • CHAR character table
  • What is sheet art?
  • Progress bars & visual formulas
  • Big Year: A Yearly Calendar Template
  • Blog
  • Better Sheets on YouTube
  • I Love Google Sheets
Browse the Free Hub
Log in Get Instant Access
  1. Apps Script APIs
  2. / GroupsApp

GroupsApp

What it does

Query Google Groups membership, roles, and group email addresses.
Official Google docs

Explore

Related methods

  • .getGroupByEmail()

    Loads a Google Group by its email address.

  • .getGroups()

    Returns the Google Groups the user belongs to.

More Apps Script

  • All Apps Script APIs
  • Apps Script hub
  • Apps Script Explainer

Better Sheets tutorials

No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.

Related blog posts

Written guides about GroupsApp in Google Apps Script.

Browse the blog

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

Read post →

How to Send Google Forms Entries Automatically with Apps Script

Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.

Read post →

Explore Coding in Google Sheets

Did you know you can actually code in Google Sheets?

Read post →
better

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

  • Templates
  • Blog
  • Formulas
  • Apps Script
  • Questions Explained
  • Add AI to your Sheet
  • YouTube
  • TikTok

Academy

  • Learn to Code in Google Sheets
  • Build Better Dashboards
  • Automate Spreadsheets
  • Learn to Sell Spreadsheets

Tools

  • Formula generator
  • Apps Script Explainer
  • Download Google Sheets to PDF
  • Download Google Sheet to CSV
  • Sell Sheets with OnlySheets

Add ons

  • Explore Add-ons
  • Sheet Styles
  • Tiny Sheets
  • Button Styles
  • Build Google Sheets Addons
  • Google Forms Quiz Builder

Better Sheets is a Kamphey Approved Production