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

  1. When this happens...
    CommunityCommunity
    Member Changed

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

    TriggerInstant
  2. automatically do this...
     logo logo
    ActionWrite
  3. then do this!
     logo logo
    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

  • Community triggers, actions, and search

    Message Received

    Triggers when we receive a message from a member

    Trigger
    Instant
    Try It
  • Community triggers, actions, and search

    Term Response

    Triggers when members respond to a term

    Trigger
    Instant
    Try It
    • Community NameRequired

    • Member Phone NumberRequired

    Action
    Write
    • 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

    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 IDRequired

    • Community NameRequired

    Action
    Write
    • Community NameRequired

    • ColorRequired

    Action
    Write
    • Member IDRequired

    • Community NameRequired

    Action
    Write
community logo
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.
Learn more

Related categories

  • Communication
google-sheets logo
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

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets