Google Sheets + Lawcus

Create new Google Sheets rows for each new matter in Lawcus

This workflow activates when a New Matter arises within Lawcus. It then proceeds to construct a new row in your selected Google Sheets spreadsheet. This process ensures that your Google Sheets document remains up-to-date with the latest Matters from Lawcus, providing a seamless and efficient system without manual data entry. Take control of your legal practice with this powerful automation.

When this happens...
New Matter Created
Triggered when a new legal matter is opened in the system. Recommended for launching matter intake procedures, assigning legal teams, or initiating workflow automation.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
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

Invoice State Changed
Triggers when the status of an invoice is updated (e.g., from Draft to Approved or from Sent to Paid). Use this trigger to monitor billing progress and automate workflows based on invoice state.
Trigger
Instant
Try It
Lead Not Hired
Triggers when a lead is marked as “Not Hired.” Helps you track lost opportunities and kick off follow-up workflows or reporting.
Trigger
Instant
Try It
Matter Closed
Triggers when a legal matter is marked as closed. Perfect for initiating post-matter processes like archiving, invoicing, or client follow-up.
Trigger
Instant
Try It
New Company Created
Triggered when a new organization or company contact is added. Facilitates streamlined integration with business contact records and supports corporate client onboarding processes.
Trigger
Instant
Try It
New Expense
Triggers when a new expense is logged. Use this to automate expense tracking, approvals, or syncing with accounting software.
Trigger
Instant
Try It

New Invoice Generated
Triggered when a new invoice is issued within the system. Enables downstream billing automation, financial tracking, and client notification processes.
Trigger
Instant
Try It
Lead Converted to Matter
Triggered when a lead is successfully converted into an active matter. Ensures smooth transition by initiating matter-specific processes, updating records, and assigning legal resources.
Trigger
Instant
Try It

New Person Created
Triggered when a new individual contact is added to the system. Ideal for syncing personal contact details across CRMs, initiating introductory communications, or updating client profiles.
Trigger
Instant
Try It
Task Completed
Triggers when a task’s status changes to “Completed.” Use this to update progress reports, trigger follow-up tasks, or notify stakeholders.
Trigger
Instant
Try It
- Workflow IdRequired
- Matter IdRequired
Action
Write
- NameRequired
- Title
- Website
- Phone
- Phone Type
- Email
- Email Type
- Street
- City
- State
- Zip/Postal Code
- Country
Action
Write
- TitleRequired
- Calendar
- Matter
- Start dateRequired
- End dateRequired
- Location
- Description
Action
Write
- AmountRequired
- Matter/LeadRequired
- Timekeeper
- Activity Category
- UTBMS task code
- DateRequired
- Discount
- Description
- Private Note
Action
Write
- CommentRequired
- Lead idRequired
Action
Write
- MatterRequired
- CommentRequired
Action
Write
- NameRequired
- Description
- WorkflowRequired
- StageRequired
- Billing TypeRequired
- Rate
- Client
- Open Date
- Country
- Due Date
- Close Date
- Practice
- Number
- Location
Action
Write
- Timekeeper
- Matter/LeadRequired
- DateRequired
- Description
- Rate
- Discount
- Duration
- Activity Category
- UTBMS task code
Action
Write
- IdRequired
- Lead Type
- First Name
- Last Name
- Email
- Phone
- Lead Source
- Referred by
- Description
- Street
- City
- State/Province
- Zip/Postal code
- Country
- Pipeline
- Stage
- Practice Area
- Location
- Responsible Attorney
- Originating Attorney
- Members
- Tags
Action
Write
- IdRequired
- Company
- First Name
- Last Name
- Title
- Website
- Email
- Email Type
- Phone Number
- Phone Type
- Street
- City
- State
- Zip/Postal Code
- Country
Action
Write
- Search ContactRequired
Action
Search
- NameRequired
Action
Search
- EmailRequired
Action
Search
- Name or EmailRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

- Stage
Trigger
Instant
Try It
- Workflow
- Stage
Trigger
Instant
Try It
New Communication
Triggers when a new communication is logged in the system (e.g., emails, calls, or messages). Ideal for keeping your team or CRM in sync with the latest client interactions.
Trigger
Instant
Try It
New Calendar Entry
Triggers when a new calendar event is added. Great for syncing schedules or creating reminders and alerts across platforms.
Trigger
Instant
Try It
New Flat Fee
Triggers when a new flat fee entry is created for a matter. Useful for billing automation or syncing pricing structures across tools.
Trigger
Instant
Try It
New Lead Created
Triggered when a new prospective client (lead) is added to the system. Supports immediate engagement through lead qualification workflows, outreach automation, or system-wide updates.
Trigger
Instant
Try It
New Matter Created
Triggered when a new legal matter is opened in the system. Recommended for launching matter intake procedures, assigning legal teams, or initiating workflow automation.
Trigger
Instant
Try It
New Task
Triggers when a new task is created within a matter or project. Use this to automate task notifications, assignments, or integrations with project tools.
Trigger
Instant
Try It
New Time Entry
Triggers when a new time entry is created. Helpful for syncing time logs with billing tools or tracking productivity in real-time.
Trigger
Instant
Try It
- Matter IdRequired
- Date of CommunicationRequired
- SubjectRequired
- BodyRequired
- Type of CommunicationRequired
- To (Contacts)
- To (Teammates)
Action
Write
- ContactRequired
- CommentRequired
Action
Write
- Timekeeper
- Matter/Lead
- DateRequired
- RateRequired
- QuantityRequired
- Discount
- Activity Category
- Public Note
- Private Note
Action
Write
- First NameRequired
- Last NameRequired
- Phone
- Email
- Lead Source
- Referred by
- Street
- City
- State/Province
- Zip/Postal code
- Country
- Description
- StageRequired
- Practice Area
Action
Write
- Company nameRequired
- Phone
- Email
- Lead Source
- Referred by
- Street
- City
- State/Province
- Zip/Postal code
- Country
- Description
- StageRequired
- Practice Area
Action
Write
- NameRequired
- Description
- MatterRequired
- Due Date
- Assign Member
Action
Write
- Company
- First NameRequired
- Last NameRequired
- Title
- Website
- Email
- Email Type
- Phone Number
- Phone Type
- Street
- City
- State
- Zip/Postal Code
- Country
Action
Write
- IdRequired
- Name
- Title
- Website
- Phone
- Phone Type
- Email
- Email Type
- Street
- City
- State
- Zip/Postal Code
- Country
Action
Write
- IdRequired
- Pipeline
- Stage
- Practice
- Client
- Name
- Description
- Open Date
- Due Date
- Close Date
Action
Write
- idRequired
- Name
- Description
- Due Date
Action
Write
- Invoice numberRequired
Action
Search
- Search MatterRequired
Action
Search
- WorkflowRequired
- NameRequired
Action
Search
- NameRequired
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About Lawcus

Lawcus is a practice management tool that enables lawyers to organize matters and automate consistent processes to help deliver more with transparency and less effort.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

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

Google Sheets + Lawcus

Create new Google Sheets rows for each new matter in Lawcus

Invoice State Changed

Lead Not Hired

Matter Closed

New Company Created

New Expense

New Invoice Generated

Lead Converted to Matter

New Person Created

Task Completed

User Activated Workflow

Create Company

Create Event

Create Flat Fee

Add Note to Lead

Add Note to Matter

Create Matter

Create Time Entry

Update Lead

Update Person Contact

Find Contact

Find Lead

Find Newest Matter by Client

Find User

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

Lead Moved to Stage

Matter Moved to Stage

New Communication

New Calendar Entry

New Flat Fee

New Lead Created

New Matter Created

New Task

New Time Entry

Create Communication

Add Note to Contact

Create Expense Entry

Create Lead (Person)

Create Lead (Company)

Add Task to Matter

Create Person

Update Company

Update Matter

Update Task

Find Invoice

Find Matter

Find Stage on a Pipeline

Find Pipeline

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)