Ontraport + Google Sheets + Keap Integrations

How to connect Ontraport + Google Sheets + Keap

Zapier lets you send info between Ontraport and Google Sheets and Keap automatically—no code required. With 6,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

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

Do even more with Ontraport + Google Sheets + Keap

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 Ontraport, Google Sheets, and Keap. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

New Contact
Triggers when a new contact is added to Ontraport.
Trigger
Scheduled
Try It
- Product IdRequired
Trigger
Instant
Try It
- Product IdRequired
Trigger
Instant
Try It
- Email
- Last Name
- First Name
- Address
- City
- State
- Zip Code
- Address Line 2
- Country
- Office Phone
- SMS Number
- Birthday
- Title
- Fax
- Website
- Company
- First Campaign
- First Content
- First Lead Source
- First Medium
- First Term
- Last Campaign
- Last Content
- Last Lead Source
- Last Medium
- Last Term
- Facebook
- Instagram
- Twitter
- Linkedin
- Profile Image
- Sequence
- Tag
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It

- Drive
Trigger
Scheduled
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
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write
New Affiliate
For Ulimate users, triggers when a new affiliate is added.
Trigger
Scheduled
Try It
- Company events this trigger will listen to:Required
Trigger
Instant
Try It
- Invoice events this trigger will listen to:Required
Trigger
Instant
Try It
- Opportunity events this trigger will listen to:Required
- RandomRequired
Trigger
Instant
Try It
- Subscription events this trigger will listen to:Required
Trigger
Instant
Try It
- Tag events this trigger will listen to:Required
- Tag (for use with "Tag Applied to Contact" event only)
Trigger
Instant
Try It
New Credit Card Charge - Merchant Only
Triggers when a new credit card charge is made. (Merchant Only).
Trigger
Instant
Try It
New Manual Payment – (Cash, Check)
Triggers when a New Manual Payment is added. (Cash or Check).
Trigger
Instant
Try It
- Tag
Trigger
Instant
Try It
Updated Contact
Triggers when an existing contact is updated.
Trigger
Instant
Try It
- Product NameRequired
- Active
- Product Description
- Product Price
- Product Short Description
- SKU
- Subscription Only
Action
Write
- Contact IDRequired
- Lead Affiliate Id
- Order DateRequired
- Product IdRequired
- Product QuantityRequired
- Price Override
- Order TitleRequired
- Order TypeRequired
- Promo Codes
- Sales Affiliate Id
- Company
- Country Code (e.g., USA)
- First Name
- Is Invoice to Company
- Last Name
- Address Line 1
- Address Line 2
- Locality
- Middle Name
- Phone
- Region (e.g., US-CA)
- Zip Code
- Zip Four
Action
Write
- Contact Id
- Due DateRequired
- TitleRequired
- User Id
- Description
Action
Write
- ContactRequired
- TagsRequired
Action
Write
- ContactRequired
- TagsRequired
Action
Write
- Check for Duplicates UsingRequired
- Email Address 1
- Opt In
- Last Name
- First Name
- Tag IDs
- Anniversary Date (format: YYYY-MM-DD)
- Birth Date (format: YYYY-MM-DD)
- Company Name
- Company ID
- Contact Type
- Job Title
- Lead Source ID
- Middle Name
- Origin IP Address
- Owner ID
- Preferred Locale
- Preferred Name
- Prefix
- Source Type
- Spouse Name
- Suffix
- Time Zone
- Website
- Keap Source ID
- UTM Campaign
- UTM Content
- UTM Medium
- UTM Source
- UTM Term
- Billing Address Country Code (e.g., USA)
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address Postal Code
- Billing Address Region (e.g., US-CA)
- Billing Address Zip Code
- Billing Address Zip Four
- Shipping Address Country Code (e.g., USA)
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Postal Code
- Shipping Address Region (e.g., US-CA)
- Shipping Address Zip Code
- Shipping Address Zip Four
- Other Address Country Code (e.g., USA)
- Other Address Line 1
- Other Address Line 2
- Other Address City
- Other Address Postal Code
- Other Address Region (e.g., US-CA)
- Other Address Zip Code
- Other Address Zip Four
- Email Address 2
- Email Address 3
- Phone 1 Number
- Phone 1 Type
- Phone 1 Extension
- Phone 2 Number
- Phone 2 Type
- Phone 2 Extension
- Phone 3 Number
- Phone 3 Type
- Phone 3 Extension
- Phone 4 Number
- Phone 4 Type
- Phone 4 Extension
- Phone 5 Number
- Phone 5 Type
- Phone 5 Extension
- Fax 1 Number
- Fax 1 Type
- Fax 2 Number
- Fax 2 Type
- Facebook Account
- LinkedIn Account
- Twitter Account
- Instagram Account
- Snapchat Account
- YouTube Account
- Pinterest Account
Action
Write
- Company NameRequired
Action
Search
- FieldRequired
- ValueRequired
- Check for Duplicates UsingRequired
- Email Address 1
- Opt In
- Last Name
- First Name
- Tag IDs
- Anniversary Date (format: YYYY-MM-DD)
- Birth Date (format: YYYY-MM-DD)
- Company Name
- Company ID
- Contact Type
- Job Title
- Lead Source ID
- Middle Name
- Origin IP Address
- Owner ID
- Preferred Locale
- Preferred Name
- Prefix
- Source Type
- Spouse Name
- Suffix
- Time Zone
- Website
- Keap Source ID
- UTM Campaign
- UTM Content
- UTM Medium
- UTM Source
- UTM Term
- Billing Address Country Code (e.g., USA)
- Billing Address Line 1
- Billing Address Line 2
- Billing Address City
- Billing Address Postal Code
- Billing Address Region (e.g., US-CA)
- Billing Address Zip Code
- Billing Address Zip Four
- Shipping Address Country Code (e.g., USA)
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Postal Code
- Shipping Address Region (e.g., US-CA)
- Shipping Address Zip Code
- Shipping Address Zip Four
- Other Address Country Code (e.g., USA)
- Other Address Line 1
- Other Address Line 2
- Other Address City
- Other Address Postal Code
- Other Address Region (e.g., US-CA)
- Other Address Zip Code
- Other Address Zip Four
- Email Address 2
- Email Address 3
- Phone 1 Number
- Phone 1 Type
- Phone 1 Extension
- Phone 2 Number
- Phone 2 Type
- Phone 2 Extension
- Phone 3 Number
- Phone 3 Type
- Phone 3 Extension
- Phone 4 Number
- Phone 4 Type
- Phone 4 Extension
- Phone 5 Number
- Phone 5 Type
- Phone 5 Extension
- Fax 1 Number
- Fax 1 Type
- Fax 2 Number
- Fax 2 Type
- Facebook Account
- LinkedIn Account
- Twitter Account
- Instagram Account
- Snapchat Account
- YouTube Account
- Pinterest Account
Action
Search or write

- FormRequired
Trigger
Instant
Try It
- TagRequired
- Object TypeRequired
Trigger
Instant
Try It
- TagRequired
- Object TypeRequired
Trigger
Instant
Try It
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
New Action Sequence
Triggers when a new Action Sequence is added.
Trigger
Scheduled
Try It
- Appointment events this trigger will listen to:Required
Trigger
Instant
Try It
New Contact
Triggers when a new contact is created.
Trigger
Instant
Try It
- Note events this trigger will listen to:Required
Trigger
Instant
Try It
- Product events this trigger will listen to:Required
Trigger
Instant
Try It
New Subscription Plan
Triggers when a new Subscription Plan is added.
Trigger
Scheduled
Try It
- Task events this trigger will listen to:Required
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
New Payment (All Payment Type)
Triggers when any payment is made regardless of the payment type. Credit Card Payments, Cash Payments, and Check Payments.
Trigger
Instant
Try It
New Task
Triggers when a new task is created.
Trigger
Instant
Try It
Opportunity Stage Moved
Triggers when an opportunity stage is moved.
Trigger
Instant
Try It
- Company NameRequired
- Country Code (e.g., "USA")
- Address Line 1
- Address Line 2
- Locality
- Region (e.g., "US-CA")
- Zip Code
- Zip Four
- Phone Number
- Phone Ext
- Notes
- Email Address
- Fax Number
- Website
Action
Write
- Contact IdRequired
- BodyRequired
- Title
- Type
- User Id
Action
Write
- Invoice IDRequired
- Product
- Product QuanityRequired
- Price Override
Action
Write
- UserRequired
- ContactsRequired
- SubjectRequired
- HTML Content
- Plain Text Content
- Email Address Field
- Attachments
Action
Write
- Company IDRequired
- Company Name
- Email AddressRequired
- Website
- Notes
- Opt-In
- Address Country Code
- Address Street (Line 1)
- Address Street (Line 2)
- Address City
- Address State
- Address Zip Code
- Address Zip Four
- Phone Number
- Phone Extension
- Phone Type
- Phone Number
- Phone Extension
- Phone Type
Action
Write
- FieldRequired
- ValueRequired
Action
Search
- Invoice IDRequired
Action
Search
- Company NameRequired
- Country Code (e.g., "USA")
- Address Line 1
- Address Line 2
- Locality
- Region (e.g., "US-CA")
- Zip Code
- Zip Four
- Phone Number
- Phone Ext
- Notes
- Email Address
- Fax Number
- Website
Action
Search or write

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How Ontraport + Google Sheets + Keap Integrations Work

Step 1: Authenticate Ontraport, Google Sheets, and Keap.
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.