Bloomerang + Google Sheets
Find or create constituents in Bloomerang with new updates to Google Sheets rows
With this integration, you'll be able to automatically locate a constituent in Bloomerang whenever a row is added or updated in a Google Sheets spreadsheet. If the constituent is not found, you'll seamlessly create a new one. Keep your contacts up to date while you manage your data.
With this integration, you'll be able to automatically locate a constituent in Bloomerang whenever a row is added or updated in a Google Sheets spreadsheet. If the constituent is not found, you'll seamlessly create a new one. Keep your contacts up to date while you manage your data.
- When this happens!
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
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
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
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Save new Gmail emails matching certain traits to a Google Spreadsheet
- Add new Facebook Lead Ads leads to rows on Google Sheets
- Send emails via Gmail when Google Sheets rows are updated
- Create Google Sheets rows for new Google Ads leads
- Generate Google Calendar events from new Google Sheets rows
- Send Slack messages whenever Google Sheets rows are updated
- Generate rows in Google Sheets for new Unbounce submissions
- Create new Google Sheets row from a new Google Calendar event
- Create Google Sheets row(s) for new TikTok Lead Generation leads
- Add new Acuity Scheduling appointments to a Google Sheets spreadsheet
- Create Trello cards from new rows on Google Sheets
- Create rows in Google Sheets for new Gravity Forms submissions
- Create Google Sheets rows from new scheduled Calendly events
- Send Webflow form data to Google Sheets
- Add subscribers to Mailchimp for new Google Sheets rows
- Add new paid Shopify orders to Google Sheets rows
- Collect new Typeform responses as rows on Google Sheets
- Add info to a Google Sheet from new Webhook POST requests
- Add new Stripe sales as rows on Google Sheets
- Save new Ecwid orders to Google Sheets rows
- Add Slack messages to a Google Sheets spreadsheet
- Add new ClickFunnels Classic contacts to Google Sheets
- Add new Strava activities to Google Sheets rows
- Add new Wufoo entries to a Google Sheets spreadsheet
- Add new Wave invoices to Google Sheets rows
- Store new parsed emails in Google Sheets rows
- Save new Perspective leads to Google Sheets as rows
- Add new emails in Gmail to Google Sheets rows
- Add new labeled Gmail emails to rows in Google Sheets
- Save new WooCommerce orders to Google Sheets rows
- Add rows to Google Sheets with every day's weather forecast
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Save new WPForms entries to a Google Sheets spreadsheet
- Add new Gmail emails matching searches to Google Sheets rows
- Add updated Google Contacts to Google Sheets spreadsheets
- Save new Eventbrite attendees to Google Sheets spreadsheets
- Create Google Sheets rows for new Zapier Interfaces form submissions.
- Add new Cognito Forms entries to a Google Sheets spreadsheet
- Save new Ticket Tailor orders to Google Sheets rows
- Add new Barks to Google Sheets rows
- Create Google Sheet rows for new form submissions in Leadpages
- Save new HubSpot form submissions to Google Sheets rows
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Log new Leadpages submissions on Google Sheets
- Copy data from new Google Sheets rows to a Google Doc template
- Save new JotForm responses as Google Sheets rows
- Create Google Sheet spreadsheet rows for new Adalo records
- Push new URLs to rows in Google Sheets
- Add cards to Pipefy for new rows on Google Sheets
- Save new Trello card activity as Google Sheets rows
- Create Google Sheet rows for new eBay orders
- Log new Google Calendar events in Google Sheets rows
- Create Google Contacts from new Google Sheets rows
- Add rows to Google Sheets spreadsheets from Ninja Forms form submissions
- Add new Airtable records in views to Google Sheets
- Add WooCommerce orders to Google Sheets rows
- Save new Square transactions to Google Sheets rows
- Add new Toggl time entries to a Google Sheets spreadsheet
- Add new Paperform submission as a new row in Google Sheets
- Create Google Calendar events from new Google Sheets rows
- Log RSS feed updates as new rows in Google Sheets
- Add new Strava club activities as rows to Google Sheets
- Create items on a monday.com board for new rows on Google Sheets
- Send Gmail emails for new Google Sheet spreadsheet rows
- Add new ShipStation orders to Google Sheets rows
- Generate Google Sheets rows for new items in Notion databases
- Send regularly scheduled Slack messages with information from Google Sheets
- Save new Facebook page posts to Google Sheets
- Add new Google Drive files in a folder as rows in Google Sheets
- Create rows in Google Sheets spreadsheets with new Trello cards
- Save new Netlify form submissions to rows in Google Sheets
- Create new Google Docs from text with new rows in Google Sheets
- Create rows in Google Sheets with new OnceHub bookings
- Add new ClickFunnels Classic purchases to Google Sheets
- Log Google Ads offline conversions from new rows in Google Sheets
- Add subscribers to Flodesk from new Google Sheets spreadsheet rows
- Create Google Sheets rows from new Facebook Page messages
- Add rows to Google Sheets spreadsheets from new visitors reaching the Zapier Integration block in Landbot
- Add new Shopify paid orders to Google Sheets rows
- Add items to Notion databases from new rows in Google Sheets
- Create new rows in Google Sheets from Google My Business reviews
- Create Trello cards from new or updated Google Sheets rows
- Create a row in Google Sheets from Slack messages with new reactions
- Add new Pipedrive deals to Google Sheets rows
- Create HubSpot contacts for new Google Sheets rows
- Create new rows in Google Sheets spreadsheets from VideoAsk responses
- Add new Asana tasks to Google Sheets rows
- Add Google Sheets rows for new Google Forms responses
- Create Google Sheets rows from newly extracted data by Browse AI
- Add rows to Google Sheets spreadsheets for new PayPal sales
- Share new Google Sheets rows on Slack
- Add GoCanvas entries to Google Sheets rows
- Add new Kajabi form submissions to Google Sheets rows
- Save new Google Sheets rows to Airtable
- Add new SurveyMonkey responses to new Google Sheets rows
- Create Brevo subscribers from new rows on Google Sheets
- Keep track of your HoneyBook payments in Google Sheets
- Add contacts to Google Ads customer lists from new Google Sheets rows
- Log new Thinkific orders to a Google Sheet
- Add new rows to Google Sheets with daily RescueTime summary reports
Related Zap Templates
- Save new Gmail emails matching certain traits to a Google Spreadsheet
- Create Google Sheets rows for new Google Ads leads
- Generate rows in Google Sheets for new Unbounce submissions
- Add new Acuity Scheduling appointments to a Google Sheets spreadsheet
- Create Google Sheets rows from new scheduled Calendly events
- Add new paid Shopify orders to Google Sheets rows
- Add new Stripe sales as rows on Google Sheets
- Add new ClickFunnels Classic contacts to Google Sheets
- Add new Wave invoices to Google Sheets rows
- Add new emails in Gmail to Google Sheets rows
- Add rows to Google Sheets with every day's weather forecast
- Add new Gmail emails matching searches to Google Sheets rows
- Create Google Sheets rows for new Zapier Interfaces form submissions.
- Add new Barks to Google Sheets rows
- Create Trello cards and Google Sheets rows for new starred emails on Gmail
- Save new JotForm responses as Google Sheets rows
- Add cards to Pipefy for new rows on Google Sheets
- Log new Google Calendar events in Google Sheets rows
- Add new Airtable records in views to Google Sheets
- Add new Toggl time entries to a Google Sheets spreadsheet
- Log RSS feed updates as new rows in Google Sheets
- Send Gmail emails for new Google Sheet spreadsheet rows
- Send regularly scheduled Slack messages with information from Google Sheets
- Create rows in Google Sheets spreadsheets with new Trello cards
- Create rows in Google Sheets with new OnceHub bookings
- Add subscribers to Flodesk from new Google Sheets spreadsheet rows
- Add new Shopify paid orders to Google Sheets rows
- Create Trello cards from new or updated Google Sheets rows
- Create HubSpot contacts for new Google Sheets rows
- Add Google Sheets rows for new Google Forms responses
- Share new Google Sheets rows on Slack
- Save new Google Sheets rows to Airtable
- Keep track of your HoneyBook payments in Google Sheets
- Add new rows to Google Sheets with daily RescueTime summary reports
- Add new Facebook Lead Ads leads to rows on Google Sheets
- Generate Google Calendar events from new Google Sheets rows
- Create new Google Sheets row from a new Google Calendar event
- Create Trello cards from new rows on Google Sheets
- Send Webflow form data to Google Sheets
- Collect new Typeform responses as rows on Google Sheets
- Save new Ecwid orders to Google Sheets rows
- Add new Strava activities to Google Sheets rows
- Store new parsed emails in Google Sheets rows
- Add new labeled Gmail emails to rows in Google Sheets
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Add updated Google Contacts to Google Sheets spreadsheets
- Add new Cognito Forms entries to a Google Sheets spreadsheet
- Create Google Sheet rows for new form submissions in Leadpages
- Log new Leadpages submissions on Google Sheets
- Create Google Sheet spreadsheet rows for new Adalo records
- Save new Trello card activity as Google Sheets rows
- Create Google Contacts from new Google Sheets rows
- Add WooCommerce orders to Google Sheets rows
- Add new Paperform submission as a new row in Google Sheets
- Add new Strava club activities as rows to Google Sheets
- Add new ShipStation orders to Google Sheets rows
- Save new Facebook page posts to Google Sheets
- Save new Netlify form submissions to rows in Google Sheets
- Add new ClickFunnels Classic purchases to Google Sheets
- Create Google Sheets rows from new Facebook Page messages
- Add items to Notion databases from new rows in Google Sheets
- Create a row in Google Sheets from Slack messages with new reactions
- Create new rows in Google Sheets spreadsheets from VideoAsk responses
- Create Google Sheets rows from newly extracted data by Browse AI
- Add GoCanvas entries to Google Sheets rows
- Add new SurveyMonkey responses to new Google Sheets rows
- Add contacts to Google Ads customer lists from new Google Sheets rows
- Send emails via Gmail when Google Sheets rows are updated
- Send Slack messages whenever Google Sheets rows are updated
- Create Google Sheets row(s) for new TikTok Lead Generation leads
- Create rows in Google Sheets for new Gravity Forms submissions
- Add subscribers to Mailchimp for new Google Sheets rows
- Add info to a Google Sheet from new Webhook POST requests
- Add Slack messages to a Google Sheets spreadsheet
- Add new Wufoo entries to a Google Sheets spreadsheet
- Save new Perspective leads to Google Sheets as rows
- Save new WooCommerce orders to Google Sheets rows
- Save new WPForms entries to a Google Sheets spreadsheet
- Save new Eventbrite attendees to Google Sheets spreadsheets
- Save new Ticket Tailor orders to Google Sheets rows
- Save new HubSpot form submissions to Google Sheets rows
- Copy data from new Google Sheets rows to a Google Doc template
- Push new URLs to rows in Google Sheets
- Create Google Sheet rows for new eBay orders
- Add rows to Google Sheets spreadsheets from Ninja Forms form submissions
- Save new Square transactions to Google Sheets rows
- Create Google Calendar events from new Google Sheets rows
- Create items on a monday.com board for new rows on Google Sheets
- Generate Google Sheets rows for new items in Notion databases
- Add new Google Drive files in a folder as rows in Google Sheets
- Create new Google Docs from text with new rows in Google Sheets
- Log Google Ads offline conversions from new rows in Google Sheets
- Add rows to Google Sheets spreadsheets from new visitors reaching the Zapier Integration block in Landbot
- Create new rows in Google Sheets from Google My Business reviews
- Add new Pipedrive deals to Google Sheets rows
- Add new Asana tasks to Google Sheets rows
- Add rows to Google Sheets spreadsheets for new PayPal sales
- Add new Kajabi form submissions to Google Sheets rows
- Create Brevo subscribers from new rows on Google Sheets
- Log new Thinkific orders to a Google Sheet