Microsoft Excel + Keap

Create or update Keap contacts from new rows in your Microsoft Excel table

When a new row is added in your Microsoft Excel table, streamline the process with this workflow that instantly creates or updates a contact in Keap. This way, you're saving time on manual data entry and ensuring information is efficiently managed in your customer relationship management tool. Stay organized without the extra effort and keep your contacts up-to-date.

When this happens...
New Row in Table
Triggers when a new row is added to a table in a spreadsheet.
TriggerPolling
automatically do this!
Create or Update Contact
Creates a new contact or updates an existing contact.
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

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
New Affiliate
For Ulimate users, triggers when a new affiliate is added.
Trigger
Polling
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
- Contact Tag Sync Interval
- Tag
Trigger
Instant
Try It
New Refund
Triggers when a new refund is created.
Trigger
Polling
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 Address
- 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

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
New Action Sequence
Triggers when a new Action Sequence is added.
Trigger
Polling
Try It
- Appointment Trigger Requirement
- 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
Polling
Try It
- Task events this trigger will listen to:Required
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created. This will trigger the moment the invoice is created, before any details are added.
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 Assigned Task
Triggers when a new task is created. Please note: only tasks assigned to the authenticated user may be retrieved through this trigger. Use the New Task Event trigger to retrieve all tasks.
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
- Email or Phone Required
- 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 Fields Required
- 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 Fields Required
- 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 Fields Required
- 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
- Email or Phone Required
- 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 Fields Required
- 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 Fields Required
- 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 Fields Required
- 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

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more