=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
In Google Sheet
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", "[email protected]","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