Google Sheets + Lawcus
Create new people in Lawcus from new rows in Google Sheets
Streamline your workflow by linking your Google Sheets with Lawcus. Whenever a new row is added to your spreadsheet, a corresponding person is swiftly created in Lawcus. This efficient workflow ensures your contacts remain up-to-date in Lawcus, eliminating the need for manual data entry, saving you time and boosting your productivity.
Streamline your workflow by linking your Google Sheets with Lawcus. Whenever a new row is added to your spreadsheet, a corresponding person is swiftly created in Lawcus. This efficient workflow ensures your contacts remain up-to-date in Lawcus, eliminating the need for manual data entry, saving you time and boosting your productivity.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create PersonCreates a new individual contact in the system. Supports contact management, client onboarding, or record keeping for individuals.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.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.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
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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Matter Closed
Triggers when a legal matter is marked as closed. Perfect for initiating post-matter processes like archiving, invoicing, or client follow-up.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Expense
Triggers when a new expense is logged. Use this to automate expense tracking, approvals, or syncing with accounting software.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice Generated
Triggered when a new invoice is issued within the system. Enables downstream billing automation, financial tracking, and client notification processes.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Completed
Triggers when a task’s status changes to “Completed.” Use this to update progress reports, trigger follow-up tasks, or notify stakeholders.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Workflow IdRequired
Matter IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Title
Website
Phone
Phone Type
Email
Email Type
Street
City
State
Zip/Postal Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Calendar
Matter
Start dateRequired
End dateRequired
Location
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AmountRequired
Matter/LeadRequired
Timekeeper
Activity Category
UTBMS task code
DateRequired
Discount
Description
Private Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CommentRequired
Lead idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MatterRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
WorkflowRequired
StageRequired
Billing TypeRequired
Rate
Client
Open Date
Country
Due Date
Close Date
Practice
Number
Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timekeeper
Matter/LeadRequired
DateRequired
Description
Rate
Discount
Duration
Activity Category
UTBMS task code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Company
First Name
Last Name
Title
Website
Email
Email Type
Phone Number
Phone Type
Street
City
State
Zip/Postal Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ContactRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName or EmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
No 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 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 foundNew 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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Calendar Entry
Triggers when a new calendar event is added. Great for syncing schedules or creating reminders and alerts across platforms.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Matter IdRequired
Date of CommunicationRequired
SubjectRequired
BodyRequired
Type of CommunicationRequired
To (Contacts)
To (Teammates)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timekeeper
Matter/Lead
DateRequired
RateRequired
QuantityRequired
Discount
Activity Category
Public Note
Private Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Phone
Email
Lead Source
Referred by
Street
City
State/Province
Zip/Postal code
Country
Description
StageRequired
Practice Area
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company nameRequired
Phone
Email
Lead Source
Referred by
Street
City
State/Province
Zip/Postal code
Country
Description
StageRequired
Practice Area
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
MatterRequired
Due Date
Assign Member
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company
First NameRequired
Last NameRequired
Title
Website
Email
Email Type
Phone Number
Phone Type
Street
City
State
Zip/Postal Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Name
Title
Website
Phone
Phone Type
Email
Email Type
Street
City
State
Zip/Postal Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Pipeline
Stage
Practice
Client
Name
Description
Open Date
Due Date
Close Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
Name
Description
Due Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch MatterRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkflowRequired
NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About Lawcus
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new leads in Lawcus
- Create new Lawcus matters from newly added Google Sheets rows
- Create Google Sheets rows from newly converted Lawcus leads
- Create spreadsheet rows in Google Sheets for new people in Lawcus
- Create new Google Sheets rows for each new matter in Lawcus