Clio + Google Sheets + HubSpot Integrations
How to connect Clio + Google Sheets + HubSpot
Zapier lets you send info between Clio, Google Sheets, and HubSpot automatically—no code required.
Do even more with Clio + Google Sheets + HubSpot
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Clio, Google Sheets, and HubSpot. And don’t forget that you can add more apps and actions to create complex workflows.
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 ZapScheduledZapier 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
Will this task be assigned to one of your Clients/Contacts, or a fellow Clio User?
Matter
Task Due Date
Task Priority
Task Status
Users without advanced tasks are only allowed to select Complete or Pending
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
Must be a Contact of type Company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
ID number of the Task to be updated
Name
Description
Type of AssigneeRequired
Will this task be assigned to one of your Clients/Contacts, or a fellow Clio User?
Matter
Task Due Date
Task Priority
Task Status
Users without advanced tasks are only allowed to select Complete or Pending
Notify Completion
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Clio are located here http://api-docs.clio.com/v2/
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search Type
Search by ID or Wildcard (name, email or phone number).
Search ValueRequired
Search by name, email or phone number.
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search by ID or Wildcard (number, display number, description, or client name).
Search ValueRequired
Search by number, display number, description, or client name.
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
Search by name
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search by ID or Wildcard (number, display number, description, or client name).
Search ValueRequired
Search by number, display number, description, or client name.
ClientRequired
Group
Client Reference
Client Reference string for external uses.
Matter DescriptionRequired
Practice Area
Originating Attorney ID#
Clio ID# of the originating attorney
Responsible Attorney ID#
Clio ID# of the attorney responsible for this matter
Pending Date
Date the Matter is set to pending
Open Date
Date the Matter is set to open
Close Date
Date the Matter is set to close
Location
Status
Billable
Status
Users without advanced tasks are only allowed to select Complete or Pending
Due At
The due date of Statute of Limitations
Destroy?
Make sure your Clio account has access to this feature, you Zap will fail if not
Budget
Include Expenses?
Notification Threshold
Percentage of the budget when it starts notifying users.
Notify Users?
Determine whether to notify users when the matter reaches the notification threshold.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNote
Properties to retrieve:
firstname, lastname, email, company, website, mobilephone, phone, fax, address, city, state, zip, salutation, country, jobtitle, hs_createdate, hs_email_domain, hs_object_id, lastmodifieddate, hs_persona, hs_language, lifecyclestage, createdate, numemployees, annualrevenue, industryLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
firstname, lastname, email, company, website, mobilephone, phone, fax, address, city, state, zip, salutation, country, jobtitle, hs_createdate, hs_email_domain, hs_object_id, lastmodifieddate, hs_persona, hs_language, lifecyclestage, createdate, numemployees, annualrevenue, industryLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
createdate, description, name, price, tax, hs_lastmodifieddateLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planType
Determines what the metadata field should look like
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
name, description, price, quantity, amount, discount, tax, createdate, hs_object_id, hs_product_id, hs_images, hs_lastmodifieddate, hs_line_item_currency_code, hs_sku, hs_url, hs_cost_of_goods_sold, hs_discount_percentage, hs_term_in_monthsLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planContact ListRequired
The list you want to check for new contacts.
Note
Properties to retrieve:
firstname, lastname, email, company, website, mobilephone, phone, fax, address, city, state, zip, salutation, country, jobtitle, hs_createdate, hs_email_domain, hs_object_id, lastmodifieddate, hs_persona, hs_language, lifecyclestage, createdate, numemployees, annualrevenue, industryLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Whenever this property is updated on any deal, this trigger will fire.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProperty NameRequired
Whenever this property is updated on any ticket, this trigger will fire.
Properties to retrieveRequired
Whenever the trigger will fire, this properties will be retrieved as well as the tracked one.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
subject, content, source_type, createdate, hs_pipeline, hs_pipeline_stage, hs_resolution, hs_ticket_category, hs_ticket_id, hs_ticket_priority, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProperty NameRequired
Whenever this property is updated on any contact, this trigger will fire.
Note
Properties to retrieve:
firstname, lastname, email, company, website, mobilephone, phone, fax, address, city, state, zip, salutation, country, jobtitle, hs_createdate, hs_email_domain, hs_object_id, lastmodifieddate, hs_persona, hs_language, lifecyclestage, createdate, numemployees, annualrevenue, industryLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
List NameRequired
The name of the list which the contact will be added to. Only static lists are shown here, as dynamic lists cannot be manually added to.
Contact EmailRequired
The email of the contact to be added to the list. Note - this needs to be a contact that already exists within HubSpot. You may need to add a Create or Update Contact step before this one. Then, use the email created in that step in this field.
Halt my task if contact is already a member of the list
If contact is already a member of the list the task would not be counted against task quota, and further zap steps would not be executed.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Create Company
Creates a Company in HubSpot.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Associations
Creates associations between objects.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
Halt task if any associations error occurred
Operations to create the engagement and then create the requested associations are not atomic.
Engagement TypeRequired
Assigned To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- Please note that this action is using deprecated version of the API and will be removed in a near future.
- Please switch to "Create Deal" action for the most reliable experience with your Zap.
Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
NameRequired
A name for this deal
Company
List of companies to associate with
Contact
List of contacts to associate with
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
Workflow NameRequired
Contact's EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
This is HubSpot's internal ID for the contact
Note
Properties to retrieve:
firstname, lastname, email, company, website, mobilephone, phone, fax, address, city, state, zip, salutation, country, jobtitle, hs_createdate, hs_email_domain, hs_object_id, lastmodifieddate, hs_persona, hs_language, lifecyclestage, createdate, numemployees, annualrevenue, industryLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
This is HubSpot's internal ID for the product
Note
Properties to retrieve:
createdate, description, name, price, tax, hs_lastmodifieddateLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Line_item
Creates a Line_item in HubSpot.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
Contact Email AddressRequired
This ties the event that you're triggering to a contact in HubSpot. If the contact doesn't yet exist in HubSpot, it will be created. If the contact does exist, the event will be attributed to the existing contact.
Event IDRequired
Each event that you create in the HubSpot UI will have its own unique Event ID. You must provide this Event ID to trigger the event.
Contact Value
You can use Events to keep track of the monetary value that a contact is worth to you. Any numerical amount that you provide here will be appended to the "Value" field on the contact record for the email address that you provide.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Remove Associations
Removes associations between objects.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
FormRequired
Select the form that should be submitted.
Note
Following fields are used to set additional Context for Form submission
HubSpot usertoken
The tracking cookie token value used for HubSpot lead activity tracking
IP address
The IP address of the visitor filling out the form
Page name
The name or title of the page the submission happened on
Page URI
The URI of the page the submission happened on
Page ID
The ID of a page created on the HubSpot CMS
SFDC campaign ID
If the form is for an account using the HubSpot Salesforce Integration, you can include the ID of a Salesforce campaign to add the contact to the specified campaign
GoToWebinar key/ID
If the form is for an account using the HubSpot GoToWebinar Integration, you can include the ID of a webinar to enroll the contact in that webinar when they submit the form
Submission timestamp
A millisecond timestamp representing the time of the form submission
Skip validation
Whether or not to skip validation based on the form settings. Defaults to false
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
Properties to retrieve:
name, domain, industry, about_us, phone, address, address2, city, state, zip, country, website, type, description, founded_year, hs_createdate, hs_lastmodifieddate, hs_object_id, is_public, timezone, total_money_raised, total_revenue, owneremail, ownername, numberofemployees, annualrevenue, lifecyclestage, createdate, web_technologiesLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
Properties to retrieve:
dealtype, dealname, amount, description, closedate, createdate, num_associated_contacts, hs_forecast_amount, hs_forecast_probability, hs_manual_forecast_category, hs_next_step, hs_object_id, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
Properties to retrieve:
createdate, description, name, price, tax, hs_lastmodifieddateLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
EmailRequired
Permanently unsubscribe an email address from all emails.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for HubSpot are located here https://developers.hubspot.com/docs/api/overview
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
Properties to retrieve:
name, domain, industry, about_us, phone, address, address2, city, state, zip, country, website, type, description, founded_year, hs_createdate, hs_lastmodifieddate, hs_object_id, is_public, timezone, total_money_raised, total_revenue, owneremail, ownername, numberofemployees, annualrevenue, lifecyclestage, createdate, web_technologiesLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.SearchFind existing data in your appNote
- Please note that this search is using deprecated version of the API and will be removed in a near future.
- Please switch to "Find Deal" search for the most reliable experience with your Zap.
NameRequired
A name for this deal
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Associations
Find associations between objects.
ActionThis is an event a Zap performs.SearchFind existing data in your appObject TypeRequired
The object type that you want the pipelines for.
Pipeline IdRequired
The pipeline that contains specific stage.
Stage IdRequired
The pipeline stage that you want the details for.
ActionThis is an event a Zap performs.SearchFind existing data in your appNote
Properties to retrieve:
name, description, price, quantity, amount, discount, tax, createdate, hs_object_id, hs_product_id, hs_images, hs_lastmodifieddate, hs_line_item_currency_code, hs_sku, hs_url, hs_cost_of_goods_sold, hs_discount_percentage, hs_term_in_monthsLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.SearchFind existing data in your appNote
Properties to retrieve:
subject, content, source_type, createdate, hs_pipeline, hs_pipeline_stage, hs_resolution, hs_ticket_category, hs_ticket_id, hs_ticket_priority, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.SearchFind existing data in your appNote
Properties to retrieve:
name, domain, industry, about_us, phone, address, address2, city, state, zip, country, website, type, description, founded_year, hs_createdate, hs_lastmodifieddate, hs_object_id, is_public, timezone, total_money_raised, total_revenue, owneremail, ownername, numberofemployees, annualrevenue, lifecyclestage, createdate, web_technologiesLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNote
- Please note that this action is using deprecated version of the API and will be removed in a near future.
- Please switch to "Create Deal" action for the most reliable experience with your Zap.
NameRequired
A name for this deal
Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
Company
List of companies to associate with
Contact
List of contacts to associate with
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNote
Properties to retrieve:
name, description, price, quantity, amount, discount, tax, createdate, hs_object_id, hs_product_id, hs_images, hs_lastmodifieddate, hs_line_item_currency_code, hs_sku, hs_url, hs_cost_of_goods_sold, hs_discount_percentage, hs_term_in_monthsLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNote
Properties to retrieve:
subject, content, source_type, createdate, hs_pipeline, hs_pipeline_stage, hs_resolution, hs_ticket_category, hs_ticket_id, hs_ticket_priority, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
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 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 ZapScheduledZapier 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.Description
Activity Note
DateRequired
Price
The expense amount.
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
Client Reference string for external uses.
Matter DescriptionRequired
Practice Area
Originating Attorney ID#
Clio ID# of the originating attorney
Responsible Attorney ID#
Clio ID# of the attorney responsible for this matter
Pending Date
Date the Matter is set to pending
Open Date
Date the Matter is set to open
Close Date
Date the Matter is set to close
Location
Status
Billable
Status
Users without advanced tasks are only allowed to select Complete or Pending
Due At
The due date of Statute of Limitations
Destroy?
Make sure your Clio account has access to this feature, you Zap will fail if not
Budget
Include Expenses?
Notification Threshold
Percentage of the budget when it starts notifying users.
Notify Users?
Determine whether to notify users when the matter reaches the notification threshold.
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
Must be a Contact of type Company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Activity Note
DateRequired
Time
Enter in minutes
Price
The hourly or flat amount.
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
Client Reference string for external uses.
Matter Description
Practice Area
Originating Attorney ID#
Clio ID# of the originating attorney
Responsible Attorney ID#
Clio ID# of the attorney responsible for this matter
Pending Date
Date the Matter is set to pending
Open Date
Date the Matter is set to open
Close Date
Date the Matter is set to close
Location
Status
Billable
Status
Users without advanced tasks are only allowed to select Complete or Pending
Due At
The due date of Statute of Limitations
Destroy?
Make sure your Clio account has access to this feature, you Zap will fail if not
Budget
Include Expenses?
Notification Threshold
Percentage of the budget when it starts notifying users.
Notify Users?
Determine whether to notify users when the matter reaches the notification threshold.
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 by ID or Wildcard (first name, last name, email or phone number).
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Type
Search by ID or Wildcard (name, email or phone number).
Search ValueRequired
Search by name, email or phone number.
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 by ID or Wildcard (first name, last name, email or phone number).
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
Must be a Contact of type 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 foundNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNote
Properties to retrieve:
name, domain, industry, about_us, phone, address, address2, city, state, zip, country, website, type, description, founded_year, hs_createdate, hs_lastmodifieddate, hs_object_id, is_public, timezone, total_money_raised, total_revenue, owneremail, ownername, numberofemployees, annualrevenue, lifecyclestage, createdate, web_technologiesLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
name, domain, industry, about_us, phone, address, address2, city, state, zip, country, website, type, description, founded_year, hs_createdate, hs_lastmodifieddate, hs_object_id, is_public, timezone, total_money_raised, total_revenue, owneremail, ownername, numberofemployees, annualrevenue, lifecyclestage, createdate, web_technologiesLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
name, description, price, quantity, amount, discount, tax, createdate, hs_object_id, hs_product_id, hs_images, hs_lastmodifieddate, hs_line_item_currency_code, hs_sku, hs_url, hs_cost_of_goods_sold, hs_discount_percentage, hs_term_in_monthsLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
dealtype, dealname, amount, description, closedate, createdate, num_associated_contacts, hs_forecast_amount, hs_forecast_probability, hs_manual_forecast_category, hs_next_step, hs_object_id, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEmail Subscriptions Timeline
Triggers when new email timeline subscription added for the portal.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStart DateRequired
The beginning value of the query range, in UTC, in milliseconds
End DateRequired
The end value of the query range, in UTC, in milliseconds
Category
Type of task
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBlog UrlRequired
If you have multiple blog domains, select the domain that the article will published on.
Article StateRequired
Choose if you want this to trigger on the creation of blog drafts or only published articles, or both.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planChannelRequired
Select the channel the message is coming from.
Status
Message with a specific status. If the status isn't set, it returns message in status
success
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Properties to retrieve:
createdate, description, name, price, tax, hs_lastmodifieddateLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProperty NameRequired
Whenever this property is updated on any company, this trigger will fire.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
Please consider that trigger tracks deals which were moved to specific stage for the last 30 minutes
Note
Properties to retrieve:
dealtype, dealname, amount, description, closedate, createdate, num_associated_contacts, hs_forecast_amount, hs_forecast_probability, hs_manual_forecast_category, hs_next_step, hs_object_id, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_id, dealstage, pipelineLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote
- Please note that this action is using deprecated version of the API and will be removed in a near future.
- Please switch to "Create Company" action for the most reliable experience with your Zap.
NameRequired
A name for this company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Contact
Creates a Contact in HubSpot.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
NameRequired
Due DateRequired
Event TypeRequired
Task CategoryRequired
Task StateRequired
Assigned To
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
Social Media ChannelRequired
Message ContentRequired
When
A Unix timestamp in milliseconds of the time that the message should be published to the channel. If this is not included in the request, the message will be published immediately.
Save as draft
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Deal
Creates a Deal in HubSpot.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
This is HubSpot's internal ID for the company
Note
Properties to retrieve:
name, domain, industry, about_us, phone, address, address2, city, state, zip, country, website, type, description, founded_year, hs_createdate, hs_lastmodifieddate, hs_object_id, is_public, timezone, total_money_raised, total_revenue, owneremail, ownername, numberofemployees, annualrevenue, lifecyclestage, createdate, web_technologiesLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
This is HubSpot's internal ID for the deal
Note
Properties to retrieve:
dealtype, dealname, amount, description, closedate, createdate, num_associated_contacts, hs_forecast_amount, hs_forecast_probability, hs_manual_forecast_category, hs_next_step, hs_object_id, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Line_item IDRequired
This is HubSpot's internal ID for the line_item
Note
Properties to retrieve:
name, description, price, quantity, amount, discount, tax, createdate, hs_object_id, hs_product_id, hs_images, hs_lastmodifieddate, hs_line_item_currency_code, hs_sku, hs_url, hs_cost_of_goods_sold, hs_discount_percentage, hs_term_in_monthsLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket IDRequired
This is HubSpot's internal ID for the ticket
Note
Properties to retrieve:
subject, content, source_type, createdate, hs_pipeline, hs_pipeline_stage, hs_resolution, hs_ticket_category, hs_ticket_id, hs_ticket_priority, hs_lastmodifieddate, hubspot_owner_id, hubspot_team_idLearn more about object’s properties
Specify here a list of additional properties to retrieve
Additional properties to retrieve
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note
- During action testing step Zapier will call your portal API, which will create/update some instance(s)
- Also, it could cause error(s) in case of using fake identifiers, in such cases we recommend to use SKIP TEST button
Blog URLRequired
Blog AuthorRequired
Publish This Post?Required
Blog Post URLRequired
The path of the URL on which the post will live. For example if your blog domain is "blog.example.com" and in this field you enter "my-blog-post" then your blog post will be at
http://blog.example.com/my-blog-post.Please do not enter spaces or special characters in this field; hyphens are allowed.
Blog Post TitleRequired
Blog Post ContentRequired
Meta DescriptionRequired
A description that goes in a <meta> tag on the page. A good meta description will drive search engine traffic to your page, so be descriptive but keep it under 300 characters.
Featured image URL
The URL of the image that the post will use as the featured image.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.