Google Sheets + NationBuilder

Create persons in NationBuilder from new Google Sheets rows

With this Google Sheets-NationBuilder integration, you'll have new Sheet entries added as people in your nation, keeping all supporter data in the one place. Once it's active, Zapier will send every new Google Sheet row to NationBuilder, automatically updating or creating a person.

When this happens...
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create/Update Person
Creates a person in your nation if they don't exist. Updates an existing person if they do exist.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant
New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Trigger
Instant

New Worksheet
Triggered when you create a new worksheet in a spreadsheet.
Trigger
Scheduled
Create Spreadsheet Column
Create a new column in a specific spreadsheet.
Action
Write

Create Spreadsheet Row
Create a new row in a specific spreadsheet.
Action
Write

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
NationBuilder
Triggers when a certain person in your nation makes a new contact.
Scheduled
Trigger
NationBuilder
Triggers when a new donation is created.
Scheduled
Trigger
NationBuilder
Triggers when a new event is created.
Scheduled
Trigger
NationBuilder
Triggers when a new person is created.
Scheduled
Trigger
NationBuilder
Triggers when a person in your nation is updated.
Scheduled
Trigger
NationBuilder
Adds a person to a specified list.
Scheduled
Action
NationBuilder
Awards (or deducts) political capital to a person in your nation.
Scheduled
Action
NationBuilder
Creates a contact entry against a person.
Scheduled
Action
NationBuilder
Creates a donation.
Scheduled
Action
NationBuilder
Creates an event in your nation, on a site of your choice.
Scheduled
Action
NationBuilder
Creates an event RSVP
Scheduled
Action
NationBuilder
Creates a membership for a person.
Scheduled
Action
NationBuilder
Creates a person in your nation if they don't exist. Updates an existing person if they do exist.
Scheduled
Action
NationBuilder
Add a new petition signature to a person
Scheduled
Action
NationBuilder
Removes a tag from a person in your nation.
Scheduled
Action
NationBuilder
Add a private note to a user's profile
Scheduled
Action
NationBuilder
Searches for a logged contact in the People database.
Scheduled
Action
NationBuilder
Finds a person in your nation.
Scheduled
Action
NationBuilder
This action can be used to look up a donor based off of the donor ID (signup ID or person ID).
Scheduled
Action
NationBuilder
Finds a person using a person ID.
Scheduled
Action
NationBuilder
Finds a person in your nation.
Scheduled
Action