How to connect Clio + Google Sheets + Keap Max Classic
Zapier lets you send info between Clio and Google Sheets and Keap Max Classic automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Clio + Google Sheets + Keap Max Classic
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 Clio, Google Sheets, and Keap Max Classic. And don’t forget that you can add more apps and actions to create complex workflows.
New Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Bill State Updated
Triggers when the state of a bill has changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Communication
Triggers when a new communication is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Document
Triggers when a new document is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Task
Triggers when a new task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Matter IDRequired
Task Template ListRequired
Notify AssigneesRequired
Due At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SummaryRequired
Description
Location
Starts at:Required
Ends at:Required
All Day Event
Send Email Notification
CalendarRequired
Contact Attendee
Matter
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
MatterRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note SubjectRequired
Note DetailRequired
MatterRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
DescriptionRequired
Type of AssigneeRequired
Matter
Task Due Date
Task Priority
Task Status
Notify Assignee
Notify Completion
Statute of Limitations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Clio Contact ID #Required
Prefix
First name
Middle name
Last name
Title
Date of Birth
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
Company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Name
Description
Type of AssigneeRequired
Matter
Task Due Date
Task Priority
Task Status
Notify Completion
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search Type
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Matter by Custom Field
Find newest matter by custom field.
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
ClientRequired
Group
Client Reference
Matter DescriptionRequired
Practice Area
Originating Attorney ID#
Responsible Attorney ID#
Pending Date
Open Date
Close Date
Location
Status
Billable
Status
Due At
Destroy?
Budget
Include Expenses?
Notification Threshold
Notify Users?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Affiliate
Triggers when you add a new affiliate.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Contact
Triggers when you add a new contact.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Expense
Triggers when you add a new expense for an opportunity or leadsource.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Opportunity
Triggers when you add a new opportunity.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Payment
Triggers when you add a new payment of any type (Cash, Refund, check, PayPal, etc.).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProductRequired
Subscription PlanRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Subscription Plan
Triggers when you add a new subscription plan.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCompanyRequired
Phone 1
Phone 1 Ext
Email
Fax 1
Street Address 1
Street Address 2
City
State
Postal Code
Website
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Tag NamesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
TitleRequired
Description
Created By
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product NameRequired
Product Price
Description
SKU
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search FieldRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
EmailRequired
Action Set/Sequence
How to check for duplicates
Opt-in
First Name
Last Name
Tag Names
Job Title
Company
Lead Source
Person Type
Person Notes
Billing Address Street (Line 1)
Billing Address Street (Line 2)
Billing Address City
Billing Address State
Billing Address Zip Code
Billing Address Zip Extension
Billing Address Country
Billing Address Type
Shipping Address Street (Line 1)
Shipping Address Street (Line 2)
Shipping Address City
Shipping Address State
Shipping Address Zip Code
Shipping Address Zip Extension
Shipping Address Country
Shipping Address Type
Optional Address Street (Line 1)
Optional Address Street (Line 2)
Optional Address City
Optional Address State
Optional Address Zip Code
Optional Address Zip Extension
Optional Address Country
Optional Address Type
Phone 1
Phone 1 Ext
Phone 1 Type
Phone 2
Phone 2 Ext
Phone 2 Type
Phone 3
Phone 3 Ext
Phone 3 Type
Fax 1
Fax 1 Type
Fax 2
Fax 2 Type
Suffix
Title
Username
Email Address 2
Website
Facebook
Linked In
Twitter
Birthday
Anniversary
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Bill
Triggers when a new bill is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Calendar Entry
Triggers when a new calendar entry is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Matter
Triggers when a new matter is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Matter Note
Triggers when a new matter note is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTask Status Updated
Triggers when the status of a task has changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Clio Contact ID #Required
Company Name
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Matter
Date of Communication
SubjectRequired
BodyRequired
Type of CommunicationRequired
Type of Recipient
Type of Sender
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Expense Category
Description
DateRequired
Price
Matter
Matter Note
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ClientRequired
Group
Client Reference
Matter DescriptionRequired
Practice Area
Originating Attorney ID#
Responsible Attorney ID#
Pending Date
Open Date
Close Date
Location
Status
Billable
Status
Due At
Destroy?
Budget
Include Expenses?
Notification Threshold
Notify Users?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Prefix
First nameRequired
Middle name
Last nameRequired
Title
Date of Birth
Street
City
Province
Postal Code
Country
Email Address
Website
Phone Number
Instant Messenger
Company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity Category
Description
DateRequired
Time
Price
Matter
Matter Note
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MatterRequired
Client
Client Reference
Matter Description
Practice Area
Originating Attorney ID#
Responsible Attorney ID#
Pending Date
Open Date
Close Date
Location
Status
Billable
Status
Due At
Destroy?
Budget
Include Expenses?
Notification Threshold
Notify Users?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DocumentRequired
MatterRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice Number
Matter Id
Client Id
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Contact by Custom Field
Find newest contact by custom field.
ActionThis is an event a Zap performs.SearchFind existing data in your appClient EmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
Company NameRequired
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch Type
Search ValueRequired
Prefix
First nameRequired
Middle name
Last nameRequired
Title
Date of Birth
Street
City
Province
Postal Code
Country
Email Address
Website
Phone Number
Instant Messenger
Company
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Action Sequence
Triggers when a new action sequence is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Company
Triggers when you add a new company.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Contact Action
Triggers when you add a new action for a contact (task, note, or appointment).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCredit Card Charge
Triggers when a credit card charge is processed from Infusionsoft through a merchant account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggers when you add a new invoice.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggers when you add a new invoice (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Product
Triggers when you add a new product.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Tag
Triggers when you add a new tag.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEmailRequired
Action Set/Sequence
How to check for duplicates
Opt-in
First Name
Last Name
Tag Names
Job Title
Company
Lead Source
Person Type
Person Notes
Billing Address Street (Line 1)
Billing Address Street (Line 2)
Billing Address City
Billing Address State
Billing Address Zip Code
Billing Address Zip Extension
Billing Address Country
Billing Address Type
Shipping Address Street (Line 1)
Shipping Address Street (Line 2)
Shipping Address City
Shipping Address State
Shipping Address Zip Code
Shipping Address Zip Extension
Shipping Address Country
Shipping Address Type
Optional Address Street (Line 1)
Optional Address Street (Line 2)
Optional Address City
Optional Address State
Optional Address Zip Code
Optional Address Zip Extension
Optional Address Country
Optional Address Type
Phone 1
Phone 1 Ext
Phone 1 Type
Phone 2
Phone 2 Ext
Phone 2 Type
Phone 3
Phone 3 Ext
Phone 3 Type
Fax 1
Fax 1 Type
Fax 2
Fax 2 Type
Suffix
Title
Username
Email Address 2
Website
Facebook
Linked In
Twitter
Birthday
Anniversary
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contacts
From Address
To Address
CC Addresses
BCC Addresses
Content Type
Subject
HTML Body
Text Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Product
Subscription Plan
Promo Code
Lead AffiliateRequired
Sale AffiliateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Email
Action Set/Sequence
Opt-in
First Name
Last Name
Tag Names
Job Title
Company
Lead Source
Person Type
Person Notes
Billing Address Street (Line 1)
Billing Address Street (Line 2)
Billing Address City
Billing Address State
Billing Address Zip Code
Billing Address Zip Extension
Billing Address Country
Billing Address Type
Shipping Address Street (Line 1)
Shipping Address Street (Line 2)
Shipping Address City
Shipping Address State
Shipping Address Zip Code
Shipping Address Zip Extension
Shipping Address Country
Shipping Address Type
Optional Address Street (Line 1)
Optional Address Street (Line 2)
Optional Address City
Optional Address State
Optional Address Zip Code
Optional Address Zip Extension
Optional Address Country
Optional Address Type
Phone 1
Phone 1 Ext
Phone 1 Type
Phone 2
Phone 2 Ext
Phone 2 Type
Phone 3
Phone 3 Ext
Phone 3 Type
Fax 1
Fax 1 Type
Fax 2
Fax 2 Type
Suffix
Title
Username
Email Address 2
Website
Facebook
Linked In
Twitter
Birthday
Anniversary
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Description
Invoice Total
Total Due
Total Paid
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 Clio + Google Sheets + Keap Max Classic Integrations Work
- Step 1: Authenticate Clio, Google Sheets, and Keap Max Classic.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.