Overfit.AI
Search…
=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

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

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

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.
1
=API_Memberstack(key, email, password, website_num, reset)
Copied!
Key
Description
key
Your Memberstack API Key - required
(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.
1
=Memberstack(field, member_id, value)
Copied!
=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
Last modified 5mo ago