Google Sheets + NationBuilder

Add new Google Sheets spreadsheet rows (team drive) to create or update people in NationBuilder

Keep your contact lists up to date with this seamless workflow between Google Sheets and NationBuilder. Whenever a new row is added to a specified spreadsheet in Team Drive, a person is created or updated in NationBuilder. This automation saves you time and ensures your NationBuilder contact list stays current with the latest information.

When this happens...
New Spreadsheet Row (Team Drive)
Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerPolling
automatically do this!
Create/Update Person
Creates a new person or organization in NationBuilder. If the person already exists, it will update the existing person.
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

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write

- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- Site ID
- Page ID
- Page Type
- Sideloaded Objects
Trigger
Polling
Try It
- Site ID
- Page Type
Trigger
Polling
Try It
- Tag NameRequired
Trigger
Polling
Try It
- Path IDRequired
Trigger
Polling
Try It
- List IDRequired
- Person IDRequired
Action
Write
- Person IDRequired
- Awarded AmountRequired
Action
Write
- Person ID
- Email
- First NameRequired
- Middle Name
- Last NameRequired
- Private DonationRequired
- Payment Type NameRequired
- Send Donor ReceiptRequired
- AmountRequired
- Donation Tracking Code ID
- Billing Address 1Required
- Billing Address 2
- Billing CityRequired
- Billing StateRequired
- Billing ZIP CodeRequired
- Billing Country CodeRequired
- Billing Latitude
- Billing Longitude
- Note
- Page ID
- Membership Type ID
- Membership Expiration Date
- Grace Period Number of Time Periods
- Grace Period Time Period Type
- Activity Author ID
Action
Write
- Event Page IDRequired
- EmailRequired
- Email Opt-in
- First NameRequired
- Last NameRequired
- AttendeeRequired
- Canceled
- Amount in Cents
- Guests Count
- Prepaid
- Private
- Volunteer
- Phone Number
- Mobile Number
- Mobile Opt-in
- Home Address Line 1
- Home Address Line 2
- Home City
- Home State
- Home ZIP Code
- Home Country Code
Action
Write
- Membership Type IDRequired
- Expires On
- Person IDRequired
- Started AtRequired
- StatusRequired
- Status Reason
- Activity Author ID
- Grace Period Number of Time Periods
- Grace Period Time Period Type
Action
Write
- Person IDRequired
- Author IDRequired
- Note ContentRequired
Action
Write
- Signup IDRequired
- Existing Tag Name
- New Tag Name
Action
Write
- Membership IDRequired
- Membership Type ID
- Expires On
- Started At
- Status
- Status Reason
- Activity Author ID
- Grace Period Number of Time Periods
- Grace Period Time Period Type
- Trigger Autoresponses
Action
Write
- List ID
- List Name
Action
Search
- Email
- External ID
- Signup ID
- Sideloaded Objects
- Additional Fields
Action
Search

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search or write
- Site ID
- Event Page ID
- Include Event Page Details
Trigger
Polling
Try It
- Site ID
- Page ID
- Page Type
- Sideloaded Objects
Trigger
Polling
Try It
- Site ID
- Page ID
- Page Type
- Sideloaded Objects
Trigger
Polling
Try It
- Site ID
- Page ID
- Page Type
- Sideloaded Objects
Trigger
Polling
Try It
- Person IDRequired
- Path IDRequired
- Current Step ID
- Current Step Due Date
- Point Person ID
- Current Step Point Person ID
- Description
- Due Date
- Path Value Amount
Action
Write
- Person IDRequired
- Automation Description
- AutomationRequired
- Campaign URL
- Campaign Source
Action
Write
- Site IDRequired
- Calendar Page ID
- Page NameRequired
- SlugRequired
- StatusRequired
- TitleRequired
- HeadlineRequired
- Excerpt
- Event Description
- Start AtRequired
- End AtRequired
- Time Zone
- Capacity Count
- Venue NameRequired
- Venue Address Line 1
- Venue Address Line 2
- Venue Address Line 3
- Venue City
- Venue State
- Venue ZIP Code
- Venue County
- Venue Country Code
- Contact NameRequired
- Contact EmailRequired
- Contact Phone Number
- Contact Email Private
- Contact Phone Private
- Accept RSVPs
- Additional RSVPs Count
- Allow Guests
- Show Guests
- Gather Volunteers
- Sends Auto Response
- Private Event
- Event Form Address
- Event Form Phone
- Ticket Currency
- Ticket Price (ex. 10)
- Ticket Purchase URL
- Uses Shifts
- Uses Tickets
- Donation Tracking Code ID
- External ID
- Point Person ID
Action
Write
- Person IDRequired
- Sender IDRequired
- Broadcaster ID
- Contact StatusRequired
- Contact MethodRequired
- Note
- Created At
Action
Write
- Petition IDRequired
- Person IDRequired
- Recruiter ID
- Is Private
- Comment
- Trigger Autoresponses
Action
Write
- EmailRequired
- First Name
- Last Name
- TypeRequired
- Unsubscribed At Date
- Phone Number
- Mobile Number
- Note
- Volunteer
- Date of Birth
- Employer
- Occupation
- Sex
- Party
- Home Address Line 1
- Home Address Line 2
- Home City
- Home State
- Home ZIP Code
- Home Country Code
- Home Latitude
- Home Longitude
- Tags
- Bio
- Website
- Additional Fields Description
- Additional Fields
Action
Write
- Person IDRequired
- Tag IDRequired
Action
Write
- Person IDRequired
- Path IDRequired
- Current Step ID
- Path Status
- Current Step Due Date
- Point Person ID
- Current Step Point Person ID
- Description
- Due Date
- Path Value Amount
Action
Write
- How to use with Zapier Looping
- Path IDRequired
Action
Search
- Signup ID
- Tag ID
Action
Search

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About NationBuilder

NationBuilder is designed to power your organizations, movements, and campaigns.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Google Sheets + NationBuilder

Add new Google Sheets spreadsheet rows (team drive) to create or update people in NationBuilder

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Donation

New Page

New Tag Added to Person

Updated Path Journey

Add Person to List

Award Social Capital

Create Donation

Create/Update Event RSVP

Add Membership to Person

Create Private Note

Add Tag to Person

Update Membership

Search List

Search Person

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New Event RSVP

New Person

Updated Donation

Updated Person

Add Person to a Path

Enroll in Automation

Create Event

Create Logged Contact

Create Petition Signature

Create/Update Person

Delete Tag From Person

Update Path Journey

Search Path Participants

Search Person Taggings

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About NationBuilder

Related categories

Similar apps

Zapier Interfaces

Related Zap Templates

Related Zap Templates