Checks fresh roster data before refusing a login for a missing email. Pro 1.15.10 and Chapters 1.18.8 remain unchanged.<\/p>","4.10.13":"
Adds a 60-second login-code resend delay with reassurance messages. Suppressed requests do not count toward the send limit. Chapters 1.18.8 and Pro 1.15.10 remain compatible.<\/p>","4.10.12":"
Fixes an incorrect "selected membership record has changed" refusal for unchanged chapter members. Keep Chapters 1.18.8 and Pro 1.15.10 installed. Previously failed paid purchases and existing duplicate rows still require reconciliation.<\/p>","4.10.11":"
Improves roster-read timeout recovery. Install Chapters 1.18.8 for same-payment chapter recovery and Pro 1.15.10 for the unsafe-retry safeguard. Existing duplicate rows require manual reconciliation.<\/p>","4.10.10":"
Adds safe existing-member destination support for Chapters 1.18.7; purchases complete independently of optional new-email approval.<\/p>","4.10.9":"
Refreshes feature and compatibility documentation; Free runtime behavior is unchanged.<\/p>","3.1.0":"
The plugin folder and text domain changed to membership-google-sheets. Deactivate and delete the old copy after installing this one; settings and data are preserved automatically.<\/p>"},"ratings":[],"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3658640,"resolution":"128x128","location":"assets","locale":"","width":128,"height":128},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3658640,"resolution":"256x256","location":"assets","locale":"","width":256,"height":256}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3658609,"resolution":"1544x500","location":"assets","locale":"","width":1544,"height":500},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3658609,"resolution":"772x250","location":"assets","locale":"","width":772,"height":250}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["4.10.16","4.10.8","4.5.8","4.5.9","4.6.1","4.6.10","4.6.11","4.6.12","4.6.6","4.6.7","4.6.8","4.6.9","4.8.1","4.9.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3658609,"resolution":"1","location":"assets","locale":"","width":1099,"height":850},"screenshot-10.png":{"filename":"screenshot-10.png","revision":3658609,"resolution":"10","location":"assets","locale":"","width":1099,"height":850},"screenshot-11.png":{"filename":"screenshot-11.png","revision":3658609,"resolution":"11","location":"assets","locale":"","width":2122,"height":728},"screenshot-12.png":{"filename":"screenshot-12.png","revision":3658609,"resolution":"12","location":"assets","locale":"","width":1988,"height":1358},"screenshot-13.png":{"filename":"screenshot-13.png","revision":3658609,"resolution":"13","location":"assets","locale":"","width":1986,"height":1060},"screenshot-14.png":{"filename":"screenshot-14.png","revision":3658609,"resolution":"14","location":"assets","locale":"","width":1762,"height":1322},"screenshot-15.png":{"filename":"screenshot-15.png","revision":3658609,"resolution":"15","location":"assets","locale":"","width":1099,"height":850},"screenshot-16.jpg":{"filename":"screenshot-16.jpg","revision":3658609,"resolution":"16","location":"assets","locale":"","width":1063,"height":1220},"screenshot-17.png":{"filename":"screenshot-17.png","revision":3658609,"resolution":"17","location":"assets","locale":"","width":1302,"height":656},"screenshot-18.png":{"filename":"screenshot-18.png","revision":3658609,"resolution":"18","location":"assets","locale":"","width":1099,"height":850},"screenshot-19.png":{"filename":"screenshot-19.png","revision":3658609,"resolution":"19","location":"assets","locale":"","width":1099,"height":850},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3658609,"resolution":"2","location":"assets","locale":"","width":1099,"height":850},"screenshot-20.png":{"filename":"screenshot-20.png","revision":3658609,"resolution":"20","location":"assets","locale":"","width":1099,"height":380},"screenshot-21.png":{"filename":"screenshot-21.png","revision":3658609,"resolution":"21","location":"assets","locale":"","width":1099,"height":850},"screenshot-22.png":{"filename":"screenshot-22.png","revision":3658609,"resolution":"22","location":"assets","locale":"","width":1099,"height":850},"screenshot-23.png":{"filename":"screenshot-23.png","revision":3658609,"resolution":"23","location":"assets","locale":"","width":1099,"height":643},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3658609,"resolution":"3","location":"assets","locale":"","width":2542,"height":658},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3713670,"resolution":"4","location":"assets","locale":"","width":1614,"height":1516},"screenshot-5.png":{"filename":"screenshot-5.png","revision":3658609,"resolution":"5","location":"assets","locale":"","width":1099,"height":850},"screenshot-6.png":{"filename":"screenshot-6.png","revision":3658609,"resolution":"6","location":"assets","locale":"","width":1099,"height":850},"screenshot-7.png":{"filename":"screenshot-7.png","revision":3658609,"resolution":"7","location":"assets","locale":"","width":1626,"height":978},"screenshot-8.png":{"filename":"screenshot-8.png","revision":3658609,"resolution":"8","location":"assets","locale":"","width":1099,"height":850},"screenshot-9.png":{"filename":"screenshot-9.png","revision":3658609,"resolution":"9","location":"assets","locale":"","width":1099,"height":385}},"screenshots":{"1":"Site Mode and Google Service Account \u2014 connect a private Google Sheet as the membership roster.","2":"Main Roster \u2014 the organisation's spreadsheet ID and column mapping (email, membership code, name, cache duration).","3":"A private Google Sheet roster \u2014 email and membership-code columns support access checks; additional columns can supply expiration dates, member details, and purchase information.","4":"Membership Expiration \u2014 Main Roster: choose Daily, Monthly, or Annual expiration updates, then set the warning window, mode-specific grace period, and expired-access message. Chapter sites can set separate local-roster rules.","5":"Extra User-Info Fields \u2014 map additional sheet columns (address, phone, region) for members to view and verify on the front end.","6":"The Membership Access panel in the page editor sidebar \u2014 set the membership codes required to view this page.","7":"The login gate turning away a visitor whose email is not on the roster.","8":"Login Flow \u2014 pick the page that hosts your custom sign-in form.","9":"Front-end Appearance \u2014 force the login form and status panel to keep their original colors and resize their text.","10":"Access Control Behaviour \u2014 exact vs. letters-mode code matching, and the message shown when access is denied.","11":"Signing in \u2014 a member enters their email to get started.","12":"First-time sign-in \u2014 a 6-digit verification code is emailed and entered here.","13":"After the code, a first-time member is prompted to create a password.","14":"Membership status confirmed after sign-in \u2014 shown here right after a purchase, but the same confirmation appears for any member signing in.","15":"Sales settings \u2014 the Pricing Matrix with Delivery, Duration and Postage pricing; GSheet Membership<\/strong> lets you use a private<\/strong> Google Sheet as your membership database.<\/p>\n\n The plugin authenticates using a Google Service Account<\/strong> \u2014 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.<\/p>\n\n 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.<\/p>\n\n GSheet Membership Pro<\/strong> 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.<\/p>\n\n Compose's Sync Roster<\/strong> action syncs its filtered recipients to the connected providers and can supply a selected attachment through a personalized 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.<\/p>\n\n 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:<\/p>\n\n Chapter mode is provided by the GSheet Membership \u2014 Chapters<\/strong> add-on; the free plugin covers everything a single-roster organization needs.<\/p>\n\n The free plugin provides the unauthenticated, read-only 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.<\/p>\n\n 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.<\/p>\n\n This plugin connects to the following third-party services to provide its core functionality:<\/p>\n\n Google Sheets API and Google OAuth2<\/strong> (developers.google.com)\nUsed 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 \u2014 depending on which features you use \u2014 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.\nGoogle APIs Terms of Service: https:\/\/developers.google.com\/terms\nGoogle API Services User Data Policy: https:\/\/developers.google.com\/terms\/api-services-user-data-policy\nGoogle Privacy Policy: https:\/\/policies.google.com\/privacy<\/p>\n\n Stripe<\/strong> (stripe.com)\nUsed 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.\nStripe Terms of Service: https:\/\/stripe.com\/legal\/ssa\nStripe Privacy Policy: https:\/\/stripe.com\/privacy<\/p>\n\n GSheet Connect<\/strong> (access-manager-pro.replit.app) \u2014 Stripe Connect mode\nThe 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.\nService overview: https:\/\/access-manager-pro.replit.app<\/p>\n\n PayPal<\/strong> (paypal.com) \u2014 requires the GSheet Membership Pro add-on\nUsed 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.\nPayPal User Agreement: https:\/\/www.paypal.com\/us\/legalhub\/paypal\/useragreement-full\nPayPal Privacy Statement: https:\/\/www.paypal.com\/us\/legalhub\/paypal\/privacy-full<\/p>\n\n Mailchimp<\/strong> (mailchimp.com) \u2014 requires the GSheet Membership Pro add-on\nOptional 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.\nMailchimp Standard Terms of Use: https:\/\/mailchimp.com\/legal\/terms\/\nIntuit Mailchimp Privacy Statement: https:\/\/www.intuit.com\/privacy\/statement\/<\/p>\n\n EmailOctopus<\/strong> (emailoctopus.com) \u2014 requires the GSheet Membership Pro add-on\nAn 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.\nEmailOctopus Terms of Service: https:\/\/emailoctopus.com\/legal\/terms\nEmailOctopus Privacy Policy: https:\/\/emailoctopus.com\/legal\/privacy<\/p>\n\n\n When you click Save & Test Main Roster<\/strong>, 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.<\/p>\n\n 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.<\/p>\n\n Codes are compared according to the Access Control Match Mode setting (exact match by default, or \"letters mode\" \u2014 see Configuration reference below). Leave the field blank for unrestricted access.<\/p>\n\n In Recent Purchases, choose Reconcile and then \"Abandon a sandbox test purchase\". Verify the original transaction in the payment provider's test or sandbox environment, confirm that no real funds were charged, and confirm that any test roster changes have been removed or reversed without deleting a legitimate membership. Record a short note and mark it reconciled. This permanently prevents another fulfillment attempt for that payment without claiming a refund or a completed membership, and does not approve an email addition. Known live transactions cannot use this shortcut: a real-money purchase made for testing still needs a completed full refund or the correct fulfilled membership. Original errors and email-status notes remain available in expandable details instead of an active failure warning.<\/p><\/dd>\n0<\/code> offers a free membership and a blank cell is unavailable.","16":"The membership purchase picker a buyer sees, with live price updates.","17":"The confirmation email a buyer receives after purchase.","18":"The Membership Code Matrix \u2014 the stored code for every level and delivery-method combination.","19":"Payments with Pro active \u2014 Stripe Connect account details and the optional PayPal gateway; free-only sites use Stripe Connect without PayPal.","20":"Recent Purchases \u2014 purchase outcomes and available actions; sheet-write retry needs Pro, while refundable Stripe Connect sales can be refunded on free sites.","21":"General Settings \u2014 currency, thank-you page, expiration-column override and the new-member bonus cutoff used in Annual mode.","22":"Membership Level Names \u2014 map raw membership codes to the human-readable names members see.","23":"Email Verification (OTP) \u2014 code expiry and sender details for the verification email."}},"plugin_section":[],"plugin_tags":[8874,215942,25296,1932,5349],"plugin_category":[45,58],"plugin_contributors":[276608],"plugin_business_model":[],"class_list":["post-346528","plugin","type-plugin","status-publish","hentry","plugin_tags-association","plugin_tags-branches","plugin_tags-google-sheets","plugin_tags-membership","plugin_tags-stripe","plugin_category-ecommerce","plugin_category-user-management","plugin_contributors-gsheetplugins","plugin_committers-gsheetplugins"],"banners":{"banner":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/banner-772x250.png?rev=3658609","banner_2x":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/banner-1544x500.png?rev=3658609","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/icon-128x128.png?rev=3658640","icon_2x":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/icon-256x256.png?rev=3658640","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-1.png?rev=3658609","caption":"Site Mode and Google Service Account \u2014 connect a private Google Sheet as the membership roster."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-2.png?rev=3658609","caption":"Main Roster \u2014 the organisation's spreadsheet ID and column mapping (email, membership code, name, cache duration)."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-3.png?rev=3658609","caption":"A private Google Sheet roster \u2014 email and membership-code columns support access checks; additional columns can supply expiration dates, member details, and purchase information."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-4.png?rev=3713670","caption":"Membership Expiration \u2014 Main Roster: choose Daily, Monthly, or Annual expiration updates, then set the warning window, mode-specific grace period, and expired-access message. Chapter sites can set separate local-roster rules."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-5.png?rev=3658609","caption":"Extra User-Info Fields \u2014 map additional sheet columns (address, phone, region) for members to view and verify on the front end."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-6.png?rev=3658609","caption":"The Membership Access panel in the page editor sidebar \u2014 set the membership codes required to view this page."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-7.png?rev=3658609","caption":"The login gate turning away a visitor whose email is not on the roster."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-8.png?rev=3658609","caption":"Login Flow \u2014 pick the page that hosts your custom sign-in form."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-9.png?rev=3658609","caption":"Front-end Appearance \u2014 force the login form and status panel to keep their original colors and resize their text."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-10.png?rev=3658609","caption":"Access Control Behaviour \u2014 exact vs. letters-mode code matching, and the message shown when access is denied."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-11.png?rev=3658609","caption":"Signing in \u2014 a member enters their email to get started."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-12.png?rev=3658609","caption":"First-time sign-in \u2014 a 6-digit verification code is emailed and entered here."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-13.png?rev=3658609","caption":"After the code, a first-time member is prompted to create a password."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-14.png?rev=3658609","caption":"Membership status confirmed after sign-in \u2014 shown here right after a purchase, but the same confirmation appears for any member signing in."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-15.png?rev=3658609","caption":"Sales settings \u2014 the Pricing Matrix with Delivery, Duration and Postage pricing; 0<\/code> offers a free membership and a blank cell is unavailable."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-16.jpg?rev=3658609","caption":"The membership purchase picker a buyer sees, with live price updates."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-17.png?rev=3658609","caption":"The confirmation email a buyer receives after purchase."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-18.png?rev=3658609","caption":"The Membership Code Matrix \u2014 the stored code for every level and delivery-method combination."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-19.png?rev=3658609","caption":"Payments with Pro active \u2014 Stripe Connect account details and the optional PayPal gateway; free-only sites use Stripe Connect without PayPal."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-20.png?rev=3658609","caption":"Recent Purchases \u2014 purchase outcomes and available actions; sheet-write retry needs Pro, while refundable Stripe Connect sales can be refunded on free sites."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-21.png?rev=3658609","caption":"General Settings \u2014 currency, thank-you page, expiration-column override and the new-member bonus cutoff used in Annual mode."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-22.png?rev=3658609","caption":"Membership Level Names \u2014 map raw membership codes to the human-readable names members see."},{"src":"https:\/\/ps.w.org\/membership-google-sheets\/assets\/screenshot-23.png?rev=3658609","caption":"Email Verification (OTP) \u2014 code expiry and sender details for the verification email."}],"raw_content":"\nAccess \u2014 the login and page gate<\/h4>\n\n
\n
[gsma_user_info]<\/code>.<\/li>\n[gsma_login_form]<\/code> shortcode, instead of WordPress's default login screen.<\/li>\nHow it works<\/h4>\n\n
Signing in<\/h4>\n\n
Optional Pro add-on<\/h4>\n\n
GDLINK1<\/code> field. The separate Mailchimp and EmailOctopus settings-card buttons save the card and sync the full roster only to that provider.<\/p>\n\nBuilt for organizations with branches or chapters<\/h3>\n\n
\n
Public pricing data for chapter sites<\/h4>\n\n
GET \/wp-json\/gsma-sales\/v1\/pricing<\/code> 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<\/code> (exact<\/code> or letters<\/code>). It does not contain roster or buyer data. Responses advertise a five-minute public cache (Cache-Control: public, max-age=300<\/code>); the chapter site validates and caches this pricing separately.<\/p>\n\nExternal services<\/h3>\n\n
\n
membership-google-sheets<\/code> folder to \/wp-content\/plugins\/<\/code> (or upload the ZIP under Plugins \u2192 Add New \u2192 Upload Plugin<\/strong>).<\/li>\nGoogle setup (~5 minutes)<\/h4>\n\n
\n
name@project.iam.gserviceaccount.com<\/code>) as an Editor<\/strong> (required for the Sales feature and the Pro add-on's Group Email; Viewer is enough if you only use page protection). The sheet stays private to everyone else.<\/li>\nRestricting pages<\/h4>\n\n
\n
GOLD, PLATINUM<\/code>).<\/li>\nConfiguration reference<\/h4>\n\n\n\n\n Setting\n Description\n\n\n\n\n Service Account JSON\n Full contents of the JSON key file downloaded from Google Cloud Console\n\n\n Spreadsheet ID\n The ID from the spreadsheet URL (between
\/d\/<\/code> and \/edit<\/code>)\n\n\n Sheet (Tab) Name\n Optional. Leave blank to use the spreadsheet's first tab automatically.\n\n\n Email Column\n Column letter containing email addresses (default: A)\n\n\n Membership Code Column\n Column letter containing membership codes (default: B)\n\n\n Header Row Number\n Row number of the header; data starts on the next row (default: 1)\n\n\n Cache Duration (seconds)\n How long to keep the encrypted whole-roster cache in WordPress options (default: 300). Set 0 to disable roster caching.\n\n\n Expiration Mode\n Daily (individual dates), Monthly, or Annual (covered-to year).\n\n\n Warning Window (days)\n Days before expiration to start showing members a renewal warning (default: 14)\n\n\n Grace Period\n Continued access after expiration: days in Daily mode; calendar months in Monthly and Annual modes.\n\n\n Expired-Access Message\n Message shown once a membership has expired and the grace period has passed\n\n\n Login Redirect URL\n Where to send unauthenticated visitors trying to access a restricted page\n\n\n Access-Denied Redirect URL\n Where to redirect logged-in users without the required membership\n\n\n Access-Denied Message\n Message to display instead of redirecting (if no redirect URL is set)\n\n\n Access Control Match Mode\n Exact match, or \"letters mode,\" where the member's code must contain every letter in the required set\n\n\n Custom Login Page\n The WordPress page containing [gsma_login_form]<\/code>; leave on Auto-detect to let the plugin find it, or fall back to WordPress's default login page\n\n\n\n
How do I close a failed sandbox test purchase?<\/h3><\/dt>\n