Bloomerang + Google Sheets + Filter by Zapier

Update Bloomerang constituents with new updates in Google Sheets rows

This integration automatically updates an existing constituent in Bloomerang whenever a row in Google Sheets is added or updated, saving you the hassle of manual contact management.

When this happens...
TriggerPolling
automatically do this...
Only continue if...
Set up rules to specify when this Zap can continue running.
ActionFilter
then do this...
Find Constituent
Find a Constituent by name and a least one of address, phone, or email.
ActionSearch
then do this!
Update Constituent
Updates an existing constituent.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Only continue if...Required
Action
Filter
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

- ConstituentRequired
- DateRequired
- SubjectRequired
- PurposeRequired
- ChannelRequired
- Initiated by Constituent?
- Note
Action
Write
- ConstituentRequired
- Status
- Title
- Organization Name
- First Name
- Middle
- Last Name
- Suffix
- Informal Name
- Formal Name
- Envelope Name
- Recognition Name
- Gender
- Birthdate
- Employer
- Job Title
- Facebook Page
- Twitter Handle
- LinkedIn Page
- Website
- Email Interest Type
- Email Interest Update Reason
- 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
Action
Write

- TypeRequired
- Include Constituent’s cumulative giving history?
- Include Constituent’s Household information?
- 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
Search or write

- Type
Trigger
Polling
Try It
- Channel
- Purpose
- Include Constituent’s cumulative giving history?
- Include Constituent’s Household information?
Trigger
Polling
Try It
- Type
- Minimum Amount
- Maximum Amount
Trigger
Polling
Try It
- Type
- Include Constituent’s cumulative giving history?
- Include Constituent’s Household information?
Trigger
Polling
Try It
- ConstituentRequired
- DateRequired
- MethodRequired
- Designation Notes
- Check Number
- Check Date
- Credit Card Type
- Credit Card Last Four Digits
- Credit Card Expiration Month
- Credit Card Expiration Year
- Eft Account Type
- Eft Last Four Digits
- Eft Routing Number
- In Kind Description
- In Kind Type
- In Kind Market Value
Action
Write
- Constituent
- ChannelRequired
- UserRequired
- Due DateRequired
- SubjectRequired
- Purpose
- Note
- Send Notifications?
Action
Write
- TypeRequired
- Include Constituent’s cumulative giving history?
- Include Constituent’s Household information?
Action
Search

About Bloomerang

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

Related categories

Fundraising

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

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Learn more

Related categories

Related Zap Templates

Create donation records in Bloomerang from new updates to rows in Google Sheets

Bloomerang + Google Sheets + Filter by Zapier

Update Bloomerang constituents with new updates in Google Sheets rows

Supported triggers and actions

Only continue if...

New Transaction Payment

New Task

Updated Constituent

Create Constituent

Create Interaction

Update Constituent

Find or Create Constituent

New Constituent

New Interaction

New Transaction

New or Updated Constituent

Create Donation

Create Task

Find Constituent

About Bloomerang

Related categories

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Filter by Zapier

Related categories

Related Zap Templates

Related Zap Templates