Community + Google Sheets integrations
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
- When this happens...Member ChangedTriggers when a member changes state to "live", "opted out", "blocked", or "deleted".
- automatically do this...Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
- then do this!Create Spreadsheet RowCreate a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Community and Google Sheets
Discover other triggers and actions you can use with Community and Google Sheets
- Message Received
Triggers when we receive a message from a member
Try ItTriggerInstant - Term Response
Triggers when members respond to a term
Try ItTriggerInstant - Community NameRequired
- Member Phone NumberRequired
ActionWrite- 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
ActionWrite
- Member Changed
Triggers when a member changes state to "live", "opted out", "blocked", or "deleted".
Try ItTriggerInstant - Member IDRequired
- Community NameRequired
ActionWrite- Community NameRequired
- ColorRequired
ActionWrite- Member IDRequired
- Community NameRequired
ActionWrite
Related categories
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- "create Google Sheets rows for new messages received in Community"
- Create Community members from new or updated Google Sheets rows
- Update Google Sheets rows when members change in Community
- Add members to Community via phone number for new or updated rows in Google Sheets
- Create new Community members from new rows in Google Sheets






