Clio + Smartsheet

Create Smartsheet rows for new Clio contacts

Efficiently manage your new contacts with this automation between Clio and Smartsheet. When new contacts are added in Clio, it will create a new row in the specified Smartsheet, keeping your contact information organized and easily accessible. Stay on top of communication and save time by streamlining your contact management process.

When this happens...
New ContactTriggers when a new contact is created.
TriggerInstant
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Clio and Smartsheet

Discover other triggers and actions you can use with Clio and Smartsheet

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
Polling
Try It
- Event
  Required
Trigger
Instant
Try It

New Task
Triggers when a new task is created.
Trigger
Instant
Try It
- Matter ID
  Required
- Task Template List
  Required
- Notify Assignees
  Required
- Due At
Action
Write

- Summary
  Required
- Description
- Location
- Starts at:
  Required
- Ends at:
  Required
- All Day Event
- Send Email Notification
- Calendar
  Required
- Contact Attendee
- Additional Contact Attendees
- Matter
Action
Write
- Company Name
  Required
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Write
- Expense Category
- Description
- Date
  Required
- Price
- Matter
- Matter Note
- User
Action
Write
- Client
  Required
- Group
- Client Reference
- Matter Description
  Required
- 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 name
  Required
- Middle name
- Last name
  Required
- Title
- Date of Birth
- Street
- City
- Province
- Postal Code
- Country
- Email Address
- Website
- Phone Number
- Instant Messenger
- Company
Action
Write
- Activity Category
- Description
- Date
  Required
- Time
- Price
- Matter
- Matter Note
- User
- Non-Billable
Action
Write
- Matter
  Required
- 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
- Document
  Required
- Matter
  Required
Action
Write
- Invoice_number
- Matter_id
- Client_id
Action
Search
Find Contact by Custom Field
Find newest contact by custom field.
Action
Search
- Client Email
  Required
Action
Search
- Search Type
- Search Value
  Required
Action
Search
- Search Type
- Search Value
  Required
- Company Name
  Required
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Search or write
- Search Type
- Search Value
  Required
- Prefix
- First name
  Required
- Middle name
- Last name
  Required
- Title
- Date of Birth
- Street
- City
- Province
- Postal Code
- Country
- Email Address
- Website
- Phone Number
- Instant Messenger
- Company
Action
Search or write
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

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
Polling
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
- Subject
  Required
- Body
  Required
- Type of Communication
  Required
- Type of Recipient
- Type of Sender
Action
Write
- Matter
  Required
- Document Template
  Required
- Document Name
  Required
- Generate PDF
- Generate Original Format
Action
Write
- Name
  Required
- Matter
  Required
Action
Write
- Note Subject
  Required
- Note Detail
  Required
- Matter
  Required
- Date
Action
Write
- Name
  Required
- Description
  Required
- Type of Assignee
  Required
- 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 ID
  Required
- Name
- Description
- Type of Assignee
  Required
- Matter
- Task Due Date
- Task Priority
- Task Status
- Notify Completion
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Search Type
- Search Value
  Required
Action
Search
- Search Type
- Search Value
  Required
Action
Search
Find Matter by Custom Field
Find newest matter by custom field.
Action
Search
- Search Value
  Required
Action
Search
- Search Type
- Search Value
  Required
- Client
  Required
- Group
- Client Reference
- Matter Description
  Required
- 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
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Workspace
- Source Folder
  Required
- Destination Workspace
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

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 moreLearn moreHelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

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.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Create rows in Smartsheet for new activities in Clio