It would be extremely useful to support a conditional Auto-Approval rule based on a Google Sheets allowlist/whitelist.

What I want to achieve

Approve Facebook Group membership requests only when the applicant’s email matches an email contained in a Google Sheet.

Typical use case

Paid/private communities: I maintain a list of allowed members (customers, subscribers, students) in Google Sheets. When someone requests to join the FB group, they enter their email in the membership questions. Groupboss should check if that email exists in the sheet and approve only if it matches.

Proposed workflow

Connect Google Sheets (already supported)

Choose a “Whitelist” tab + a specific column (e.g. Column A = email)

In Auto Approval rules add a condition: “Applicant email exists in Google Sheet”

If match → Auto-approve

If no match → Keep pending (optional: auto-decline)

Requirements / Acceptance criteria

Select Spreadsheet + Tab + Column to match against

Uses the email captured from the membership question (or the “Email provided” field)

Email normalization: trim spaces + lowercase before matching

Exact match (optional: support comma-separated emails in a cell)

Clear result in logs: “Approved because email matched whitelist” / “Not approved (no match)”

Optional enhancements

Support extra rules: expiry date, plan type, allowed until date (columns)

Two modes: Allowlist (approve only if listed) and Blocklist (deny if listed)

Cache whitelist for performance + periodic refresh

This feature would eliminate manual checks and make Groupboss a perfect solution for paid/private groups.