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
Community is a platform for SMS with Enterprise-grade power and everyday easy of use. Grow your list, send personalized messages, and enrich your Zero Party Data with ease and trust.
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






