Google Sheets + Smokeball
Create new Google Sheets rows for every new Smokeball matter
Streamline your legal workflows with this Smokeball to Google Sheets integration. Whenever a new matter appears in Smokeball, this workflow will create a corresponding row in your selected Google Sheets document. Save time and stay organized, without needing to manually transfer information between platforms.
Streamline your legal workflows with this Smokeball to Google Sheets integration. Whenever a new matter appears in Smokeball, this workflow will create a corresponding row in your selected Google Sheets document. Save time and stay organized, without needing to manually transfer information between platforms.
- When this happens...
New MatterTriggers when a new matter is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Sample MatterRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MatterRequired
StatusRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MatterRequired
StatusRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Search Term
Matter Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sample MatterRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Search Term
Matter Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Task Completed
Triggers when a task is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SubjectRequired
Description
Location
All day
OrganizerRequired
AttendeesRequired
Start date and timeRequired
End date and timeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assign to firm owner?Required
Invoice
DateRequired
Subject
Activity Code
Description
QuantityRequired
PriceRequired
Is Finalized?Required
Is Written Off?Required
Is Billable?Required
Is Invoiced Externally?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Matter TypeRequired
Description
Person Responsible
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Person Contact
Creates a person contact.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File nameRequired
Folder path
FileRequired
Created Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client
Is Lead?Required
Search
Status
Last Updated
Updated Since
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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 found
Sample MatterRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MatterRequired
StatusRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Search Term
Lead Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Search Term
Matter Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Search Term
Matter Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sample MatterRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Task
Triggers when a new task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Create Organization Contact
Creates an Organization Contact.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead TypeRequired
Description
Person Responsible
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Text
Created ByRequired
Created Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Created ByRequired
Assignees
Categories
Due Date
Duration
Is Completed
Completed By
Details
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Contact number (mobile, home or work)
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
About Google Sheets
Related categories
