Google Sheets + NationBuilder

Manage new or updated Google Sheets rows by creating or updating memberships in NationBuilder

Keep your NationBuilder memberships closely aligned with your Google Sheets data using this efficient workflow. With each new or updated row in Google Sheets, corresponding memberships in NationBuilder will be updated or created. This way, you ensure accurate membership information at all times, saving time and reducing potential errors. Just set up this automation, and let it manage your memberships for you!

When this happens...
New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Add Membership to Person
Adds a new membership type to a person in NationBuilder.
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

- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont Change Sheet Structure
- 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
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write

- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
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
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
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
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
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
- Event Page ID
- Include Event Page Details
- Include Signup Details
Trigger
Polling
Try It
- Site ID
- Page ID
- Page Type
- Sideloaded Objects
Trigger
Polling
Try It
- Site ID
- Event ID
- Page ID
- Event Name
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
- Succeeded At
- 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
- Site ID
- Event ID
- Page ID
- Event Name
Action
Search
- How to use with Zapier Looping
- Path IDRequired
Action
Search
- Signup ID
- Tag ID
Action
Search

- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Dont Change Sheet Structure
- 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
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
- Site ID
- Calendar Page
- Include Page Details
Trigger
Polling
Try It
- Site ID
- Page Type
Trigger
Polling
Try It
- Tag NameRequired
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
- Phone Number
- Mobile Number
- Email Opt-In
- Unsubscribed At Date
- Mobile Opt-In
- 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
- List ID
- List Name
Action
Search
- Email
- External ID
- Signup ID
- Sideloaded Objects
- Additional Fields
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

Manage new or updated Google Sheets rows by creating or updating memberships in NationBuilder

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

New Donation

New Event RSVP

New Person

Search Events

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 Events

Search Path Participants

Search Person Taggings

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

New Event

New Page

New Tag Added to 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 List

Search Person

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About NationBuilder

Related categories

Similar apps

Zapier Interfaces

Related Zap Templates