Google Sheets + NeonCRM

Add new NeonCRM donations to a Google Sheet

Prefer using Google Sheets to perform your mail merging for donor letters? Then automate that list by pushing each new gift put into NeonCRM into Google Sheets and remove the need to download a report and upload it.

When this happens...
New Donation
Triggers when a new donation is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Account
Triggers when a new account is created.
Trigger
Instant
New Activity
Triggers when a new activity is created.
Trigger
Instant
New Donation
Triggers when a new donation is created.
Trigger
Instant
Create Individual Account
Creates a new individual account.
Action
Write
Create Activity
Add an activity to an account.
Action
Write
Create Donation
Creates a new donation.
Action
Write
Create Organization Account
Creates a new organization account.
Action
Write
Update Individual Account
Updates an individual account.
Action
Write
NeonCRM
Updates an organization account.
Scheduled
Action
NeonCRM
Links an individual account to an organization account.
Scheduled
Action
NeonCRM
Finds an existing account.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action