GSheet Membership
GSheet Membership lets you use a private Google Sheet as your membership database.
Solide Wahl
GSheet Membership is a solid plugin choice in 2026, with a few things worth checking first. Was last updated 21 hours ago, and scores 64/100 on our health check.
- Actively developed — last update 21 hours ago
- Getestet mit dem neuesten WordPress (7.1)
- Kleine Benutzerbasis (<10 aktive Installationen)
- Bisher sehr wenige Bewertungen
Wie stapelt es sich?
Side-by-side bei Installationen, Updates, Bewertungen und SupportTägliche Downloads
Download-Spitzen folgen normalerweise einer neuen Version - jede Website, die automatisch aktualisiert wird, gilt als Download.
Ranglisten
Where GSheet Membership stands todayWordPress.org Ranglisten suchen
Live-Position in der Plugin-Suche, Top 100| Stichwort | Position |
|---|---|
| association | >100 |
| branches | #83 |
| Google Sheets | >100 |
| Mitgliedschaft | >100 |
| stripe | >100 |
About GSheet Membership
From the official readme · v4.12.34Beschreibung
Access — the login and page gate
GSheet Membership lets you use a private Google Sheet as your membership database.
- Truly private — the sheet is never shared publicly. Access is granted exclusively to a Google Service Account that you control.
- Login gate — roster members sign in through the member login page. Administrator dashboard authentication stays on WordPress’s native login path and does not require the administrator’s email on a membership roster; member logins return to front-end content rather than the dashboard.
- Membership codes — each row contains an email address and a membership code (e.g. GOLD, SILVER, PLATINUM).
- Per-page restrictions — set required membership code(s) on any page or post via a sidebar panel.
- Flexible access-denied handling — redirect to a custom URL or show a configurable inline message.
- Encrypted roster cache — the entire fetched roster is encrypted as one authenticated payload before it is cached in a non-autoloaded WordPress option. On a cache hit, the whole payload is decrypted for the existing lookups; it is not encrypted or decrypted one member at a time. The OAuth2 access token is cached separately.
- Site Mode — every site runs as Main (a single roster) or Chapter (its own local roster, alongside or instead of the main one) — Chapter mode is enabled by the separate Chapters add-on.
- Expiration handling — warn members as their membership approaches its end, grant a configurable grace period after it lapses, and show a custom message once access is revoked.
- Extra user-info fields — map any additional sheet columns (address, phone, region, or anything else you track) so members can view and verify them on the front end via
[gsma_user_info]. - Custom login page — host the sign-in form on any WordPress page you choose with the
[gsma_login_form]shortcode, instead of WordPress’s default login screen. - Front-end appearance controls — force the login form and status panel to keep their original colors if your theme recolors them, and scale their text size independently of your theme.
- Two code-matching modes — require an exact membership code, or “letters mode,” where a member’s code must simply contain every letter in the required set (e.g. a required code of “AB” matches any member code containing both A and B).
Wie es funktioniert
The plugin authenticates using a Google Service Account — a special non-human Google account your server uses to read and update the sheet. You share the spreadsheet with it; no one else can access the sheet. With OpenSSL available, the saved service-account JSON is encrypted at rest; the roster cache is only written when it can be encrypted. The two use separate keys derived from this WordPress installation’s security salts. They are not exposed in the browser or source code. The entire cached roster is decrypted in server memory when it is read; this does not encrypt old backups made before the upgrade.
Signing in
There’s no separate account-creation step for members. A member already on the roster enters their email on your sign-in page: the first time, a 6-digit verification code is emailed to them and they’re prompted to create a password after entering it; after that, they sign in with the password directly. See the FAQ entry below for the full flow.
Optional Pro add-on
GSheet Membership Pro adds authenticated mailbox sending, Group Email (including Mailchimp campaign delivery), Email-in, File Delivery links and optional PDF watermarks, PayPal checkout, gift purchases, editable membership levels, and admin tools to retry failed sheet writes and refund supported purchases. Pro can also sync roster contacts to Mailchimp and EmailOctopus without sending a campaign; EmailOctopus is a sync option, not a campaign-delivery gateway. The Access and Sales admin screens show read-only previews of relevant Pro features and a direct upgrade button. After purchasing, install and activate the Pro add-on, then complete its license activation; the free plugin’s existing settings stay in place.
Compose’s Sync Roster action syncs its filtered recipients to the connected providers and can supply a selected attachment through a personalized GDLINK1 field. The separate Mailchimp and EmailOctopus settings-card buttons save the card and sync the full roster only to that provider.
Pro and Chapters check the required Free features before loading their modules, so an add-on update arriving first through Freemius can keep working with compatible older Free versions. Unsupported combinations pause with an admin notice, preserve saved settings, and resume automatically after a compatible Free update. New optional functionality can require a newer Free version without pausing an otherwise compatible add-on.
Built for organizations with branches or chapters
Most membership plugins assume one site and one member list. Many real organizations don’t work that way: a national society with local chapters, an alumni association with regional groups, a union with locals. GSheet Membership was designed for exactly that structure:
- One national roster, many chapter rosters — the national organization keeps the master membership sheet; each chapter keeps its own local roster sheet. Both live in ordinary Google Sheets the organization owns.
- Each chapter runs its own WordPress site — with its own pages, branding and admins, while membership checks stay consistent: a chapter site can honour the national roster, its local roster, or both.
- Chapter-local sales and email — in chapter mode, membership sales write to the chapter’s own roster, and group email (Pro add-on) goes to the local chapter list.
- Conditional chapter pricing — when the Chapters add-on is configured, the buyer checks their main-organization membership before checkout. Current main members see chapter-only pricing; expired main members see a combined total based on the main site’s published price plus local chapter dues.
- Separate identity and dues checks — Chapters confirms main and chapter records independently and revalidates selected row tokens at submission. When Pro gifts are enabled, the recipient’s main membership determines dues; the giver’s signed-in identity is not reused as recipient proof. Combined purchase confirmations identify both memberships and the exact total while preserving the configured email template.
- Your organization owns the data — roster sheets stay in your own Google account rather than a hosted membership database. Chapter mode requires the separately licensed Chapters add-on on participating chapter sites.
Chapter mode is provided by the GSheet Membership — Chapters add-on; the free plugin covers everything a single-roster organization needs.
Public pricing data for chapter sites
The free plugin provides the unauthenticated, read-only GET /wp-json/gsma-sales/v1/pricing endpoint so a configured Chapters site can display the main organization’s current combined-price options. The JSON response contains the main site’s configured membership levels, pricing matrix, membership-code matrix, delivery and postage options, currency, and access_match_mode (exact or letters). It does not contain roster or buyer data. Responses advertise a five-minute public cache (Cache-Control: public, max-age=300); the chapter site validates and caches this pricing separately.
On a chapter site, the Chapters add-on checks the buyer’s email against the main roster. If no email match is found, the buyer can check a box to self-report main-organization membership; that statement is not verified and must not be treated as proof of membership. A last-name lookup can help locate a possible roster record, but a buyer’s selection there is also not authentication. Chapter administrators should review these cases using their normal membership procedures.
Combined sales write the chapter membership to the chapter site’s local roster and create a manual remittance worklist entry for the main-organization dues. No payment is transferred or remitted automatically. Chapter administrators must handle the main-organization payment separately and mark the worklist entry resolved after reconciliation. An optional per-sale email can notify a configured main-organization administrator; it is a notification only, not remittance or verification.
Externe Dienste
Optional AI setup assistant (GSheet Connect, Replit and OpenAI)
With consent, https://access-manager-pro.replit.app/api/setup-help/message sends chat and setup metadata to OpenAI through Replit.
Optional help sends questions/recent chat and public card briefs, setting labels/guidance/relationships, version, safe configuration/check statuses and activity/unsaved flags—not setting-field contents. Viewing makes no AI call. Credentials, spreadsheet IDs and roster data are excluded. Never submit confidential information; filtering is imperfect. No service transcripts are saved. Browser-session chat/agreement is isolated by site/login/roster; clearing resets it. Drafts are not saved. Provider policies apply. Counters expire after the following month; blocked hashes persist until restored. Setup works without AI.
Service and data notice: https://access-manager-pro.replit.app
OpenAI Privacy Policy: https://openai.com/policies/privacy-policy/
OpenAI Terms of Use: https://openai.com/policies/terms-of-use/
Replit Privacy Policy: https://replit.com/privacy-policy
This plugin connects to the following third-party services to provide its core functionality:
Google Sheets API and Google OAuth2 (developers.google.com)
Used to read and write membership data to your private Google Sheet, and to authenticate as your Google Service Account. When a page’s access is checked, when a purchase is recorded, or when you save settings and test the connection, the plugin sends: your Service Account’s signed authentication request to https://oauth2.googleapis.com/token, and membership-related row data (emails, membership codes, and — depending on which features you use — names, addresses, and purchase details) to https://sheets.googleapis.com. This only occurs because you have configured a Google Service Account and Spreadsheet ID; no data is sent to Google until you do so.
Google APIs Terms of Service: https://developers.google.com/terms
Google API Services User Data Policy: https://developers.google.com/terms/api-services-user-data-policy
Google Privacy Policy: https://policies.google.com/privacy
Stripe (stripe.com)
Used to process membership purchases via Stripe Checkout. Card details are entered on Stripe’s hosted checkout page, not this site. With the free plugin’s Stripe Connect flow, the hosted GSheet Connect service creates the Checkout Session and relays Stripe’s confirmation to the site; Pro can instead use your own Stripe API keys and a direct Stripe webhook. Stripe is contacted only when the gateway is enabled and connected or configured.
Stripe Terms of Service: https://stripe.com/legal/ssa
Stripe Privacy Policy: https://stripe.com/privacy
GSheet Connect (access-manager-pro.replit.app) — Stripe Connect mode
The plugin’s hosted payment service is used for Stripe Connect sales, including on a Pro site until its own Stripe keys are saved for the active mode. It handles “Connect with Stripe” onboarding, creates the Stripe Checkout Session for each purchase (applying the disclosed platform commission), processes refunds you issue from the dashboard, and relays Stripe’s payment confirmations back to your site. The plugin sends: your connected Stripe account ID, the purchase amount, currency and description, the buyer’s email address, and your site’s webhook address to https://access-manager-pro.replit.app. The service does not keep a membership roster; payment processing itself is performed by Stripe. A site using its own Stripe API keys instead of Connect does not use this service for checkout.
Service overview: https://access-manager-pro.replit.app
PayPal (paypal.com) — requires the GSheet Membership Pro add-on
Used to process membership purchases via PayPal Checkout as an alternative to Stripe. Only active if you install the Pro add-on and configure your PayPal credentials; the free plugin does not send any data to PayPal on its own.
PayPal User Agreement: https://www.paypal.com/us/legalhub/paypal/useragreement-full
PayPal Privacy Statement: https://www.paypal.com/us/legalhub/paypal/privacy-full
Mailchimp (mailchimp.com) — requires the GSheet Membership Pro add-on
Optional campaign delivery and roster-sync method in Pro. With an API key and selected audience, classic sends sync the current membership filter; segments-mode sends sync the full roster and target a segment. The optional Sync Roster action updates the audience without sending a campaign. Pro sends member email addresses, names, and optional personalized link fields from the Google Sheet to https://.api.mailchimp.com to add, update, or archive audience contacts as appropriate; it does not override contacts who unsubscribed or were cleaned. Only active when Pro is installed and Mailchimp is configured; the free plugin sends no data to Mailchimp on its own.
Mailchimp Standard Terms of Use: https://mailchimp.com/legal/terms/
Intuit Mailchimp Privacy Statement: https://www.intuit.com/privacy/statement/
EmailOctopus (emailoctopus.com) — requires the GSheet Membership Pro add-on
An optional roster-sync destination, not a Group Email campaign-sending gateway. If configured, Pro sends member email addresses, names, and optionally a personalized attachment-link field to https://api.emailoctopus.com to update the selected list without sending a campaign. The provider-card Sync Roster action syncs the full local recipient roster; Compose’s Sync Roster action uses the selected membership filter. The free plugin sends no data to EmailOctopus on its own.
EmailOctopus Terms of Service: https://emailoctopus.com/legal/terms
EmailOctopus Privacy Policy: https://emailoctopus.com/legal/privacy
Installation
Guided setup: After activation, open Membership Access → Guided setup. Choose page/login protection, membership sales, or both, then follow the Google connection checks. You can use an existing Google Sheet, let Google Sheets convert an Excel file, or create your own blank sheet. No public roster or maintainer-owned template is required.
The wizard detects existing headers and selects only clear matches. When no headers exist, there is nothing to match. After consent and a fresh Editor-access check, missing roster columns are added after all occupied columns, preserving existing headers, values and formulas. Ambiguous matches need review. You remain the sheet owner; Editor is the service account permission needed to create headers or sell memberships. Avoid editing the tab while columns are being created.
The wizard reads the saved This site is a… setting before presenting spreadsheet choices. On a chapter site, first set up the site’s JSON key and ask the main-site administrator to give the service-account email Viewer access to the existing main roster. Never send the private JSON key. This main connection cannot create sheets or columns; missing main columns must be corrected by the main administrator.
Then continue to Set up your chapter roster, choose its goals, and use the existing-sheet, import or start-from-scratch choices for your own local sheet. Editor access for local sales or new columns applies only to that sheet. The site’s key is reused, while settings and progress remain separate. Main sharing can remain pending while local setup continues, with an explicit incomplete warning. Full settings remain available; opening the wizard or choosing a roster does not change the saved site type.
- Upload the
membership-google-sheetsfolder to/wp-content/plugins/(or upload the ZIP under Plugins → Add New → Upload Plugin). - Activate the plugin through the Plugins screen.
- Follow the Google setup steps below.
- Go to Membership Access (top-level menu in the WordPress admin sidebar) and configure the plugin.
- Click Save & Test Main Roster to verify the service account can read your sheet.
Google setup (~5 minutes)
- Go to https://console.cloud.google.com/ and create or select a project.
- Enable the Google Sheets API (APIs & Services → Library → search “Sheets”).
- Create a Service Account (IAM & Admin → Service Accounts → Create).
- Generate a JSON key for the service account (Keys tab → Add Key → JSON). Download the file.
- Open your Google Sheet → Share → add the service account email (looks like
name@project.iam.gserviceaccount.com) as an Editor (required for creating missing headers, the Sales feature and the Pro add-on’s Group Email). Viewer is enough only for page protection with all needed headers already prepared. You remain the owner; this permission is for the service account. The sheet stays private to everyone else. - In Membership Access (top-level menu in the WordPress admin sidebar), paste the full contents of the JSON key file and enter your Spreadsheet ID.
When you click Save & Test Main Roster, the result identifies the exact service-account email in use and checks authentication, spreadsheet access, available tabs, the selected tab, row reading, and required column mappings in order. If a check fails, the result names the Main roster and gives a specific correction without displaying the private key, access token, raw JSON, or Google response body.
For the Sheet (Tab) Name, leave the field blank to use the spreadsheet’s first tab automatically. If an explicit tab name is missing, the connection result lists the available tab names and tells you to choose one or clear the field.
Restricting pages
- Edit any page or post in WordPress.
- Find the Membership Access panel in the editor sidebar.
- Enter the required membership code(s), comma-separated (e.g.
GOLD, PLATINUM). - Save the page.
Codes are compared according to the Access Control Match Mode setting (exact match by default, or “letters mode” — see Configuration reference below). Leave the field blank for unrestricted access.
Configuration reference
Setting
Description
Service Account JSON
Full contents of the JSON key file downloaded from Google Cloud Console
Spreadsheet ID
The ID from the spreadsheet URL (between /d/ and /edit)
Sheet (Tab) Name
Optional. Leave blank to use the spreadsheet’s first tab automatically.
Email Column
Column letter containing email addresses (default: A)
Membership Code Column
Column letter containing membership codes (default: B)
Header Row Number
Row number of the header; data starts on the next row (default: 1)
Cache Duration (seconds)
How long to keep the encrypted whole-roster cache in WordPress options (default: 300). Set 0 to disable roster caching.
Expiration Mode
Daily (individual dates), Monthly, or Annual (covered-to year).
Warning Window (days)
Days before expiration to start showing members a renewal warning (default: 14)
Grace Period
Continued access after expiration: days in Daily mode; calendar months in Monthly and Annual modes.
Expired-Access Message
Message shown once a membership has expired and the grace period has passed
Login Redirect URL
Where to send unauthenticated visitors trying to access a restricted page
Access-Denied Redirect URL
Where to redirect logged-in users without the required membership
Access-Denied Message
Message to display instead of redirecting (if no redirect URL is set)
Access Control Match Mode
Exact match, or “letters mode,” where the member’s code must contain every letter in the required set
Custom Login Page
The WordPress page containing [gsma_login_form]; leave on Auto-detect to let the plugin find it, or fall back to WordPress’s default login page
Änderungsprotokoll
Corrects chapter-helper access choices and expiration guidance without changing membership rules or AI limits.
4.12.34
- Correct chapter setup-helper guidance to offer only Local roster only or Local roster + main roster. Main-only belongs to Main site mode, not the chapter access setting.
- Explain chapter-first combined profile selection and the checked main-renewal notice, including local-only access, without guessing saved settings. Membership, payment, privacy and AI spending rules are unchanged.
4.12.32
- Make Foreign state / Province, Country and Zone optional in local chapter roster setup. Require these sales mappings only for the main roster on a Main-mode site.
- Keep required/optional labels, Not used selections, missing-header creation and verification consistent without clearing existing mappings or changing checkout behavior.
4.12.31
- Correct helper permissions for ordinary main-site sales versus read-only chapter-main connections, and distinguish email sign-in and emailed verification codes from roster membership classifications.
- Stop treating conditional status and empty-state documentation as saved configuration. Correct the helper’s unchecked chapter-expiration explanation against actual roster selection.
- Clarify that Sandbox payments can still update the configured roster, blank tab selects the first tab, purchase forms need their shortcode, and main-reporting contact prompts remain conditional. Membership and payment behavior are unchanged.
4.12.30
- Correct setup-helper guidance for read-only chapter-main goals and required comparison columns, expired renewal delivery/postage choices, main-reporting contacts, and custom membership durations.
- Prefer relevant related-card guidance for renewal, chapter, contact, level-duration and page-restriction questions without increasing AI limits or sharing entered settings.
4.12.29
- Give optional AI help public setting labels, choices and existing guidance for the current card, plus cross-setting relationships such as mailbox routing and Group Email permissions. Entered values, credentials and roster data remain excluded.
- Explain prepared help in plain language and remember explicit AI-sharing agreement for the current scoped browser-session conversation. Clearing the conversation requires agreement again.
- Keep all current-card field instructions ahead of optional notes without increasing AI prompt or spending limits.
4.12.28
- Add an initially minimized, bottom-right setup helper on Guided setup, Access settings and the five core Sales pages. Help follows the active card and uses maintained, version-matched guidance with current saved configuration and recent checks.
- Preserve bounded recent chat across supported pages within the same administrator browser session, separated by site, login session and roster. Clear conversation removes saved chat; drafts and consent are not stored.
- Keep form contents, credentials and roster data out of automatic diagnostics. Distinguish unsaved edits, stale checks and unverified sales/payment configuration without increasing AI usage limits.
Screenshots
Für Entwickler
Ist das dein Plugin? Zeigen Sie die Zahlen.
Fügen Sie Ihrer Website, Docs oder GitHub Readme ein Live-Badge hinzu. Es wird von selbst aktualisiert - kein Konto erforderlich.
Best GSheet Membership alternatives
All association plugins →Fragen und Antworten
GSheet Membership: quick answers
Gerade Antworten, gezogen von Live WordPress.org Daten.
Quelle: WordPress.org
Is GSheet Membership free?
Yes. GSheet Membership is free to download and use from the official WordPress.org plugin directory.
Is GSheet Membership safe to use in 2026?
GSheet Membership is a solid plugin choice in 2026, with a few things worth checking first. Was last updated 21 hours ago, and scores 64/100 on our health check.
How many websites use GSheet Membership?
GSheet Membership is active on <10 WordPress websites and has been downloaded 1,149 times since it launched in August 2026. It was downloaded 429 times in the last 30 days.
Does GSheet Membership work with WordPress 7.1?
Yes. The developer has tested GSheet Membership up to WordPress 7.1.5, the latest release. It requires WordPress 5.9 or newer.
What PHP version does GSheet Membership need?
GSheet Membership requires PHP 7.4 or higher. Most hosts run PHP 8.x today, so it works on any modern WordPress hosting.
When was GSheet Membership last updated?
The latest version, 4.12.34, was released on November 20, 2026 (21 hours ago).
Who makes GSheet Membership?
GSheet Membership is developed and maintained by gsheetplugins.
What are the best alternatives to GSheet Membership?
The most popular alternatives to GSheet Membership are HelloAsso (4K+ installs), HelloAsso Payments for WooC… (300+ installs) and WP-AMMS (WordPress Plugin:… (20+ installs).
Angetrieben von PageForge
Eine Vorlage und eine Tabelle. Eine echte Seite für jede Suche.
PageForge Verwandelt jede Zeile eines CSV in eine WordPress-Seite mit eigenem Titel, URL, SEO Felder und Schema entworfen. Kostenlos auf WordPress.org.
- CSV und XLSX, plus Google Sheets auf Beruf und Unternehmen
- seinen eigenen Titel, URL, SEO Felder und Schema für jede Seite
- Arbeitet mit dem Blockeditor, Elementor, Divi und Avada
- Kostenlos auf WordPress.org, keine Kreditkarte
