Community + Google Sheets
Create Google Sheets rows for new member changes in Community
Whenever the state of a member changes in Community—such as live, opted out, blocked, or deleted—a corresponding Google Sheets row will be added automatically. We recommend formatting the Google Sheets spreadsheet with the following headers: MEMBER_ID, LEADER_ID, SUBSCRIPTION_STATE, FIRST_NAME, LAST_NAME, EMAIL, DATE_OF_BIRTH, GENDER, CITY, STATE, STATE_CODE, COUNTRY, COUNTRY_CODE, DEVICE_TYPE, FIRST_ACTIVATED_AT
Whenever the state of a member changes in Community—such as live, opted out, blocked, or deleted—a corresponding Google Sheets row will be added automatically. We recommend formatting the Google Sheets spreadsheet with the following headers: MEMBER_ID, LEADER_ID, SUBSCRIPTION_STATE, FIRST_NAME, LAST_NAME, EMAIL, DATE_OF_BIRTH, GENDER, CITY, STATE, STATE_CODE, COUNTRY, COUNTRY_CODE, DEVICE_TYPE, FIRST_ACTIVATED_AT
- When this happens...Member Changed
Triggers when a member changes state to "live", "opted out", "blocked", or "deleted".
- automatically do this...Create Spreadsheet
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
- then do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
Message Received
Triggers when we receive a message from a member
Try ItMember IDRequired
Community NameRequired
Community NameRequired
ColorRequired
Member IDRequired
Community NameRequired
Member Changed
Triggers when a member changes state to "live", "opted out", "blocked", or "deleted".
Try ItCommunity NameRequired
Member Phone NumberRequired
Member Phone NumberRequired
First Name
Surname
Email Address
Date Of Birth
Gender
City
State Or Province
State Or Province Abbreviation
Country
Country Code
Postal Code
Community NameRequired
Member Phone NumberRequired
