Google Sheets + PracticePanther Legal Software
Create a new Google Sheets row for each event in PracticePanther Legal Software
Boost your efficiency in managing legal matters with this workflow. When a new event occurs in your PracticePanther Legal Software, it instantly adds a row at the top of your selected Google Sheets spreadsheet. Conquer legal tasks seamlessly, while ensuring all crucial information is organized in one location.
Boost your efficiency in managing legal matters with this workflow. When a new event occurs in your PracticePanther Legal Software, it instantly adds a row at the top of your selected Google Sheets spreadsheet. Conquer legal tasks seamlessly, while ensuring all crucial information is organized in one location.
- When this happens...
New EventTriggers when a new event is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet Row at TopCreates a new spreadsheet row at the top of a spreadsheet (after the header row).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Contact
Matter
Tag
Assigned To
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact
Matter
Tag
Assigned to User
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Expense Category
Triggers when a new expense category is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Item
Triggers when a new item is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact
Matter
Status
Tag
Assigned to User
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUserRequired
Company Name
Tags
First Name
Middle Name
Last Name
Email
Mobile #
Home #
Office #
Fax #
Address Street 1
Address Street 2
Address City
Address State/Province
Address Zip/Postal Code
Address Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Date/TimeRequired
DurationRequired
DirectionRequired
UserRequired
Contact
Matter
Notes
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Start Date/TimeRequired
End Date/TimeRequired
All Day Event?Required
UserRequired
Matter
Contact
Notes
Location
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Matter NameRequired
StatusRequired
UserRequired
Matter Number
Notes
Statute of Limitations Date
Open Date
Close Date
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
SubjectRequired
Contact
Matter
Status
Notes
Due Date
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search TextRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact
Search TextRequired
ContactRequired
Matter NameRequired
StatusRequired
UserRequired
Matter Number
Notes
Statute of Limitations Date
Open Date
Close Date
Tags
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 Bank Account
Get Bank Accounts.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact
Matter
Tag
Assigned To
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planMatter
Billed By
Expense Category
Contact
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAssigned To
Contact Tag
Matter Tag
Status
Contact
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact
Matter
Status
Tag
Assigned to User
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew User
Triggers when a new user is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTypeRequired
NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From - Email AddressRequired
To - Email AddressRequired
To - Display Name
SubjectRequired
DateRequired
Contact
Matter
BodyRequired
From - Display Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact
Quantity
MatterRequired
DateRequired
Price
Billable?Required
Description
Billed By
Category
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
RateRequired
Code
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
SubjectRequired
UserRequired
Contact
Matter
Note
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
MatterRequired
Billed ByRequired
Billable?Required
DateRequired
Hourly Rate
Description
Hours
Item
Private Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact
Search TextRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TextRequired
UserRequired
Company Name
Tags
First Name
Middle Name
Last Name
Email
Mobile #
Home #
Office #
Fax #
Address Street 1
Address Street 2
Address City
Address State/Province
Address Zip/Postal Code
Address Country
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
About Google Sheets
Related categories
About PracticePanther Legal Software
Related categories
Related Zap Templates
- Add new PracticePanther Legal Software matters to Google Sheets rows for organized tracking
- Add new PracticePanther Legal Software contacts to Google Sheets as rows
- Create new matters in PracticePanther Legal Software from new rows in Google Sheets
- Create new PracticePanther Legal Software events from new Google Sheets rows
- Create a new Google Sheets row for new PracticePanther Legal Software payments