Bloomerang + Microsoft Excel

Bloomerang + Microsoft Excel integrations

Track new Bloomerang transaction payments by adding rows in Microsoft Excel

Streamline your financial management processes with this handy workflow. Each time a new transaction payment occurs in Bloomerang, a row will be added in your designated Microsoft Excel sheet. This automation saves you the effort of manual entry and keeps your spreadsheet up-to-date, ensuring efficient management and tracking of your transactions.

When this happens...
New Transaction PaymentTriggers 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.
TriggerPolling
automatically do this!
Add RowAdds a new row to the end of a worksheet.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Bloomerang and Microsoft Excel

Discover other triggers and actions you can use with Bloomerang and Microsoft Excel

- 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
- Constituent
  Required
- Date
  Required
- Method
  Required
- 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
- Channel
  Required
- User
  Required
- Due Date
  Required
- Subject
  Required
- Purpose
- Note
- Send Notifications?
Action
Write
- Type
  Required
- Include Constituent’s cumulative giving history?
- Include Constituent’s Household information?
Action
Search

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- 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
- Type
  Required
- 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
- Constituent
  Required
- Date
  Required
- Subject
  Required
- Purpose
  Required
- Channel
  Required
- Initiated by Constituent?
- Note
Action
Write
- Constituent
  Required
- 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
- Type
  Required
- 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
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
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 moreLearn moreHelpHelp

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 moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

Related Zap Templates

Add new Bloomerang constituents to Microsoft Excel rows effortlessly for streamlined tracking