Bloomerang + Microsoft Excel

Update Bloomerang constituents when rows are updated in Microsoft Excel

Keep your Bloomerang records up-to-date effortlessly. With this workflow, whenever a row is updated in Microsoft Excel, the corresponding Constituent details are immediately updated in Bloomerang. This efficient process ensures consistent data across your platforms and saves you the trouble of manually transferring the changes. Ideal for managing donor, volunteer, or member information, this dynamic automation ensures your Bloomerang database stays current and accurate.

When this happens...
Updated Row
Triggers when a row is added or updated in a worksheet.
TriggerPolling
automatically 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

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
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

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
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

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

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more