=Memberstack

The =Memberstack formula allows you to add & edit your Memberstack member fields or current plan

=Memberstack: How-to Video

1. Set Your Memberstack API Key

At https://Overfit.AI

Sign In at Overfit.AI To Update Your Memberstack API Key

Memberstack Username/Password only required for changing Memberstack user plans.

In Google Sheet

Use the =API_Memberstack Formula to Set Your Memberstack API Key

This is an optional alternative method of authenticating your Memberstack API Key and cridentials directly within your Google Sheet.

=API_Memberstack(key, email, password, website_num, reset)

Key	Description
key	Your Memberstack API Key - required app.memberstack.io/developers (Power-ups > Custom Integrations > New API Key)
email	Your Memberstack login email - required only for updating member plans
password	Your Memberstack login password - required only for updating member plans
website_num	Website number on your account from oldest to newest (bottom to top when first logged in) - required only for updating member plans if you have multiple websites "1" - The first Memberstack website you created (default)

=API_Memberstack Example

=API_Memberstack("YOUR-MEMBERSTACK-KEY-HERE", "[e-mail]","PASSWORD123", "3")

Find your Memberstack API Key at App.Memberstack.io/Developers

(Power-ups > Custom Integrations > New API Key)

Your Memberstack API key will be stored securely as a Document Property of any Google Sheet you have authenticated with your Overfit.AI API Key. Anyone you allow to access this Google Sheet will be able to access your Memberstack Members and use your Overfit.AI Tasks.

2. Use the =Memberstack Formula in Google Sheets to View & Edit Member Data

Refer to the official Memberstack API Documentation for more details.

=Memberstack(field, member_id, value)

=Memberstack Formula Example

=Memberstack("firstname", "112233...", "Elon")

I have a member with the ID of "112233..." and want to update their First Name field with the value "Elon" .

Variable	Default	Description
field	null	Membership field null = Returns all fields "all" = Returns all field options "can-edit" = Returns all field options that can be edited
member_id	null	A specific member's ID. null = Returns all members
value	null	The member's new field value null = No field values will be updated