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.

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

    Update one or more 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

  • 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
    Polling
    Try It
    • Channel

    • Purpose

    • Constituent

    • User

    Trigger
    Polling
    Try It
    • Type

    • Include Constituent’s cumulative giving history?

    • Include Constituent’s Household information?

    Trigger
    Polling
    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
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

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