How to connect Gmail + Google Sheets + NationBuilder
Zapier lets you send info between Gmail and Google Sheets and NationBuilder automatically—no code required. With 8,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Gmail + Google Sheets + NationBuilder
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Gmail, Google Sheets, and NationBuilder. And don’t forget that you can add more apps and actions to create complex workflows.
Label or mailbox
Search keywords
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Starred Email
Triggers when you receive a new email and star it within two days.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLabelRequired
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email message to be DeletedRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To
Send message to Google Contacts Group/Label
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ThreadRequired
Label(s) to removeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSite ID
Page ID
Page Type
Sideloaded Objects
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSite ID
Event Page ID
Include Event Page Details
Include Signup Details
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSite ID
Page ID
Page Type
Sideloaded Objects
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSite ID
Event ID
Page ID
Event Name
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planList IDRequired
Person IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person IDRequired
Awarded AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person IDRequired
Author IDRequired
Note ContentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Signup IDRequired
Existing Tag Name
New Tag Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site ID
Event ID
Page ID
Event Name
ActionThis is an event a Zap performs.SearchFind existing data in your appHow to use with Zapier Looping
Path IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSignup ID
Tag ID
ActionThis is an event a Zap performs.SearchFind existing data in your app
New Label
Triggers when you add a new label.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planMessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient Instructions
To
Cc
Bcc
SubjectRequired
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of labelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MessageRequired
Label(s) to removeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Reply To
Subject
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
To
Send message to Google Contacts Group/Label
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSite ID
Calendar Page
Include Page Details
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSite ID
Page ID
Page Type
Sideloaded Objects
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSite ID
Page ID
Page Type
Sideloaded Objects
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPerson IDRequired
Path IDRequired
Current Step ID
Current Step Due Date
Point Person ID
Current Step Point Person ID
Description
Due Date
Path Value Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person IDRequired
Automation Description
AutomationRequired
Campaign URL
Campaign Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person IDRequired
Sender IDRequired
Broadcaster ID
Contact StatusRequired
Contact MethodRequired
Note
Created At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Petition IDRequired
Person IDRequired
Recruiter ID
Is Private
Comment
Trigger Autoresponses
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person IDRequired
Tag IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List ID
List Name
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail
External ID
Signup ID
Sideloaded Objects
Additional Fields
ActionThis is an event a Zap performs.SearchFind existing data in your app
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Gmail + Google Sheets + NationBuilder Integrations Work
- Step 1: Authenticate Gmail, Google Sheets, and NationBuilder.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.