Skip to content
Community logoCommunity logo
Google Sheets logoGoogle Sheets logo
Community logoCommunity logo
Google Sheets logoGoogle Sheets logo

Community + Google Sheets

Community + Google Sheets

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

  1. When this happens...
    Member Changed
    Member Changed
    Member ChangedTriggers when a member changes state to "live", "opted out", "blocked", or "deleted".
  2. automatically do this...
    Create Spreadsheet
    Create Spreadsheet
    Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
  3. then do this!
    Create Spreadsheet Row
    Create Spreadsheet Row
    Create Spreadsheet RowCreate a new row in a specific spreadsheet.
Start free with email
Start free with email
Google Logo Start free with Google
  • 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

  • Community triggers, actions, and search
    Message Received

    Triggers when we receive a message from a member

    Trigger
    Instant
    Try It
    • Community Name
      Required
    • Member Phone Number
      Required
    Action
    Write
    • Member Phone Number
      Required
    • First Name
    • Surname
    • Email Address
    • Date Of Birth
    • Gender
    • City
    • State Or Province
    • State Or Province Abbreviation
    • Country
    • Country Code
    • Postal Code
    Action
    Write
  • Community triggers, actions, and search
    Member Changed

    Triggers when a member changes state to "live", "opted out", "blocked", or "deleted".

    Trigger
    Instant
    Try It
    • Member ID
      Required
    • Community Name
      Required
    Action
    Write
    • Community Name
      Required
    • Color
      Required
    Action
    Write
    • Member ID
      Required
    • Community Name
      Required
    Action
    Write
community logo
About Community
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
google-sheets logo
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zoho Creator integrationsZoho Creator integrations
Zoho Creator
App Builder, Zoho
Smartsheet integrationsSmartsheet integrations
Smartsheet
Spreadsheets
Quip integrationsQuip integrations
Quip
Documents

Related Zap Templates