Clio + Google Sheets
Update person contacts in Clio when new or updated spreadsheet rows occur in Google Sheets team drive
Keep your contacts up to date effortlessly. With this workflow, any new or updated row on your Google Sheets Team Drive immediately updates the corresponding Person Contact in Clio. This ensures your contact information is always current and consistent across both platforms, saving you time and enhancing efficiency.
Keep your contacts up to date effortlessly. With this workflow, any new or updated row on your Google Sheets Team Drive immediately updates the corresponding Person Contact in Clio. This ensures your contact information is always current and consistent across both platforms, saving you time and enhancing efficiency.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Update Person ContactUpdates an existing person contact.
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
New Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Bill State Updated
Triggers when the state of a bill has changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Communication
Triggers when a new communication is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Document
Triggers when a new document is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Task
Triggers when a new task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Matter IDRequired
Task Template ListRequired
Notify AssigneesRequired
Due At
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SummaryRequired
Description
Location
Starts at:Required
Ends at:Required
All Day Event
Send Email Notification
CalendarRequired
Contact Attendee
Matter
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
MatterRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note SubjectRequired
Note DetailRequired
MatterRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
DescriptionRequired
Type of AssigneeRequired
Matter
Task Due Date
Task Priority
Task Status
Notify Assignee
Notify Completion
Statute of Limitations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Name
Description
Type of AssigneeRequired
Matter
Task Due Date
Task Priority
Task Status
Notify Completion
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.Search Type
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Matter by Custom Field
Find newest matter by custom field.
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch 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?
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
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 Bill
Triggers when a new bill is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Calendar Entry
Triggers when a new calendar entry is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Matter
Triggers when a new matter is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Matter Note
Triggers when a new matter note is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTask Status Updated
Triggers when the status of a task has changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Clio Contact ID #Required
Company Name
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Matter
Date of Communication
SubjectRequired
BodyRequired
Type of CommunicationRequired
Type of Recipient
Type of Sender
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Expense Category
Description
DateRequired
Price
Matter
Matter Note
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity Category
Description
DateRequired
Time
Price
Matter
Matter Note
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DocumentRequired
MatterRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice Number
Matter Id
Client Id
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Contact by Custom Field
Find newest contact by custom field.
ActionThis is an event a Zap performs.SearchFind existing data in your appClient EmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search ValueRequired
Company NameRequired
Email Address
Street
City
Province
Postal Code
Country
Website
Phone Number
Instant Messenger
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch 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
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 Clio
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create multiple spreadsheet rows in Google Sheets for every new matter in Clio
- Add new Clio matters to Google Sheets as rows
- Add new Clio contacts to Google Sheets spreadsheet rows
- Create time entries in Clio from new or updated spreadsheet rows in Google Sheets
- Add new Clio bills to a Google Sheets spreadsheet as rows
- Add new Google Sheets rows to Clio as person contacts
- Update Google Sheets rows with bill state changes in Clio
- Create new Clio contacts from updated Google Sheets spreadsheet rows
- Create Google Sheets rows for new Clio activities
- Update Google Sheets rows instantly with new matters from Clio
- Create tasks in Clio from new or updated rows in Google Sheets
- Create person contacts in Clio from new or updated spreadsheet rows in Google Sheets team drive
- Create time entries in Clio from new rows in Google Sheets
- Track new Clio activities by creating multiple rows in Google Sheets
- Create new matters in Clio from new rows in Google Sheets
- Update Clio contacts when new rows are added to Google Sheets
- Create activities in Clio from new or updated rows in Google Sheets
- Update multiple spreadsheet rows in Google Sheets whenever matters status gets updated in Clio
- Create new expense entries in Clio from new rows in Google Sheets
- Create Google Sheets rows for new Clio bills
- Create new Clio communications from new or updated Google Sheets rows
- Create new Clio contacts from new or updated Google Sheets rows
- Update matters in Clio for new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new calendar entries in Clio
- Update Google Sheets rows when matters status updates in Clio
- Create multiple spreadsheet rows in Google Sheets for every new bill in Clio
- Update multiple spreadsheet rows in Google Sheets when bill states are updated in Clio
- Update Clio contacts when new or updated rows are detected in Google Sheets
- Create spreadsheet rows in Google Sheets for every new matter in Clio
- Create expense entries in Clio for new or updated rows in Google Sheets team drive
- Update Google Sheets rows with new activities from Clio
- Update Google Sheets rows with new activities from Clio
- Create new Clio matters from new or updated rows in Google Sheets
Related Zap Templates
- Create multiple spreadsheet rows in Google Sheets for every new matter in Clio
- Create time entries in Clio from new or updated spreadsheet rows in Google Sheets
- Update Google Sheets rows with bill state changes in Clio
- Update Google Sheets rows instantly with new matters from Clio
- Create time entries in Clio from new rows in Google Sheets
- Update Clio contacts when new rows are added to Google Sheets
- Create new expense entries in Clio from new rows in Google Sheets
- Create new Clio contacts from new or updated Google Sheets rows
- Update Google Sheets rows when matters status updates in Clio
- Update Clio contacts when new or updated rows are detected in Google Sheets
- Update Google Sheets rows with new activities from Clio
- Add new Clio matters to Google Sheets as rows
- Add new Clio bills to a Google Sheets spreadsheet as rows
- Create new Clio contacts from updated Google Sheets spreadsheet rows
- Create tasks in Clio from new or updated rows in Google Sheets
- Track new Clio activities by creating multiple rows in Google Sheets
- Create activities in Clio from new or updated rows in Google Sheets
- Create Google Sheets rows for new Clio bills
- Update matters in Clio for new or updated rows in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for every new bill in Clio
- Create spreadsheet rows in Google Sheets for every new matter in Clio
- Update Google Sheets rows with new activities from Clio
- Add new Clio contacts to Google Sheets spreadsheet rows
- Add new Google Sheets rows to Clio as person contacts
- Create Google Sheets rows for new Clio activities
- Create person contacts in Clio from new or updated spreadsheet rows in Google Sheets team drive
- Create new matters in Clio from new rows in Google Sheets
- Update multiple spreadsheet rows in Google Sheets whenever matters status gets updated in Clio
- Create new Clio communications from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for new calendar entries in Clio
- Update multiple spreadsheet rows in Google Sheets when bill states are updated in Clio
- Create expense entries in Clio for new or updated rows in Google Sheets team drive
- Create new Clio matters from new or updated rows in Google Sheets