Loading

Bloomerang + Google Sheets

Update Google Sheets rows with new or updated Bloomerang constituents

Keep your Google Sheets updated with the latest constituent information from Bloomerang seamlessly. With this workflow, whenever a new or updated constituent is recorded in Bloomerang, the corresponding spreadsheet row in Google Sheets will be updated automatically. No more manual data entry or worrying about outdated records, allowing you to focus on nurturing relationships with constituents.

Keep your Google Sheets updated with the latest constituent information from Bloomerang seamlessly. With this workflow, whenever a new or updated constituent is recorded in Bloomerang, the corresponding spreadsheet row in Google Sheets will be updated automatically. No more manual data entry or worrying about outdated records, allowing you to focus on nurturing relationships with constituents.

  1. When this happens...
    BloomerangBloomerang
    New or Updated Constituent

    Triggers when a constituent is created or updated.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row(s)

    Update one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Type

    Trigger
    Scheduled
    Try It
    • Channel

    • Purpose

    • Include Constituent’s cumulative giving history?

    • Include Constituent’s Household information?

    Trigger
    Scheduled
    Try It
    • Type

    • Minimum Amount

    • Maximum Amount

    Trigger
    Scheduled
    Try It
    • Type

    • Include Constituent’s cumulative giving history?

    • Include Constituent’s Household information?

    Trigger
    Scheduled
    Try It
  • Bloomerang triggers, actions, and search

    New Transaction Payment

    Triggers for each donation, pledge payment, and recurring donation when a new transaction is created. Use this to trigger for each payment in a split payment.

    Trigger
    Scheduled
    Try It
    • Channel

    • Purpose

    • Constituent

    • User

    Trigger
    Scheduled
    Try It
    • Type

    • Include Constituent’s cumulative giving history?

    • Include Constituent’s Household information?

    Trigger
    Scheduled
    Try It
    • TypeRequired

    • Suffix

    • Informal Name

    • Formal Name

    • Envelope Name

    • Recognition Name

    • Gender

    • Birthdate

    • Employer

    • Job Title

    • Facebook Page

    • Twitter Handle

    • LinkedIn Page

    • Website

    • Preferred Communication Channel

    • Communication Restrictions

    • Email Interest Type

    • Custom Email Interests

    • Primary Address Type

    • Primary Address Street

    • Primary Address City

    • Primary Address State

    • Primary Address Postal Code

    • Primary Address Country

    • Primary Email Type

    • Primary Email

    • Primary Phone Type

    • Primary Phone

    • Primary Phone Extension

    • Household

    Action
    Write
bloomerang logo
bloomerang logo

About Bloomerang

Bloomerang is a simple, cloud-based donor database solution that pools together the latest in best practices for donor engagement and retention.
Learn more

Related categories

  • Fundraising
google-sheets logo

Related categories

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