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.
