Clio + Smartsheet

Create new Smartsheet sheets from existing ones when new activities occur in Clio

Keep your Clio activities organized and easily accessible by integrating them with Smartsheet using this efficient workflow. When a new activity occurs in Clio, it will be added to a newly generated sheet in Smartsheet based on an existing template, ensuring all relevant information is consolidated and readily available. This automation not only saves you time but also helps maintain accurate and up-to-date records for seamless management.

When this happens...
New Activity
Triggers when a new activity is created.
TriggerInstant
automatically do this!
New Sheet From Existing Sheet
Create a new sheet from an existing sheet.
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

What does this mean?

New Activity
Triggers when a new activity is created.
Trigger
Instant
Try It
Bill State Updated
Triggers when the state of a bill has changed.
Trigger
Instant
Try It
New Communication
Triggers when a new communication is created.
Trigger
Instant
Try It
New Document
Triggers when a new document is created.
Trigger
Scheduled
Try It
- EventRequired
Trigger
Instant
Try It

New Task
Triggers when a new task is created.
Trigger
Instant
Try It
- Matter IDRequired
- Task Template ListRequired
- Notify AssigneesRequired
- Due At
Action
Write

- SummaryRequired
- Description
- Location
- Starts at:Required
- Ends at:Required
- All Day Event
- Send Email Notification
- CalendarRequired
- Contact Attendee
- Matter
Action
Write
- Company NameRequired
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Write
- NameRequired
- MatterRequired
Action
Write
- Note SubjectRequired
- Note DetailRequired
- MatterRequired
- Date
Action
Write
- NameRequired
- DescriptionRequired
- Type of AssigneeRequired
- Matter
- Task Due Date
- Task Priority
- Task Status
- Notify Assignee
- Notify Completion
- Statute of Limitations
Action
Write
- 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
Action
Write
- Task IDRequired
- Name
- Description
- Type of AssigneeRequired
- Matter
- Task Due Date
- Task Priority
- Task Status
- Notify Completion
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search Type
- Search ValueRequired
Action
Search
- Search Type
- Search ValueRequired
Action
Search
Find Matter by Custom Field
Find newest matter by custom field.
Action
Search
- Search ValueRequired
Action
Search
- Search 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?
Action
Search or write
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write
- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write
- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row
Find a row in a specified sheet using a query.
Action
Write

New Bill
Triggers when a new bill is created.
Trigger
Instant
Try It
New Calendar Entry
Triggers when a new calendar entry is created.
Trigger
Instant
Try It
- Contact Type
Trigger
Instant
Try It
New Matter
Triggers when a new matter is created.
Trigger
Instant
Try It
New Matter Note
Triggers when a new matter note is created.
Trigger
Scheduled
Try It
Task Status Updated
Triggers when the status of a task has changed.
Trigger
Instant
Try It
- Clio Contact ID #Required
- Company Name
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Write
- Matter
- Date of Communication
- SubjectRequired
- BodyRequired
- Type of CommunicationRequired
- Type of Recipient
- Type of Sender
Action
Write
- Expense Category
- Description
- DateRequired
- Price
- Matter
- Matter Note
- User
Action
Write
- 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?
Action
Write
- 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
Action
Write
- Activity Category
- Description
- DateRequired
- Time
- Price
- Matter
- Matter Note
- User
Action
Write
- 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?
Action
Write
- DocumentRequired
- MatterRequired
Action
Write
- Invoice Number
- Matter Id
- Client Id
Action
Search
Find Contact by Custom Field
Find newest contact by custom field.
Action
Search
- Client EmailRequired
Action
Search
- Search Type
- Search ValueRequired
Action
Search
- Search Type
- Search ValueRequired
- Company NameRequired
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Search or write
- Search 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
Action
Search or write
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write

About Clio

Clio is a practice management platform that helps lawyers work more efficiently by making it easy to do tasks like tracking time, managing matters, and generating invoices.

Learn more Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Help

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

PRODUCTS

CAPABILITIES

By team

Clio + Smartsheet

Create new Smartsheet sheets from existing ones when new activities occur in Clio

New Activity

Bill State Updated

New Communication

New Document

Matter Status Updated

New Task

Assign Task Template List

Matter IDRequired

Task Template ListRequired

Notify AssigneesRequired

Due At

Create Calendar Entry

SummaryRequired

Description

Location

Starts at:Required

Ends at:Required

All Day Event

Send Email Notification

CalendarRequired

Contact Attendee

Matter

Create Company Contact

Company NameRequired

Email Address

Street

City

Province

Postal Code

Country

Website

Phone Number

Instant Messenger

Create Matter Folder

NameRequired

MatterRequired

Create Matter Note

Note SubjectRequired

Note DetailRequired

MatterRequired

Date

Create Task

NameRequired

DescriptionRequired

Type of AssigneeRequired

Matter

Task Due Date

Task Priority

Task Status

Notify Assignee

Notify Completion

Statute of Limitations

Update Person Contact

Clio Contact ID #Required

Prefix

First name

Middle name

Last name

Title

Date of Birth