Actionstep + Google Sheets
Create spreadsheet rows in Google Sheets for new matters in Actionstep
When a new matter is created in Actionstep, this workflow will quickly add it to a specific Google Sheets row. This integration streamlines your task management by maintaining your spreadsheets up-to-date with recent developments in your Actionstep. Save time and stay organized by ensuring every new matter from your project directly populates your Google sheets.
When a new matter is created in Actionstep, this workflow will quickly add it to a specific Google Sheets row. This integration streamlines your task management by maintaining your spreadsheets up-to-date with recent developments in your Actionstep. Save time and stay organized by ensuring every new matter from your project directly populates your Google sheets.
- When this happens...
New MatterTriggers when an action/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
New Matter
Triggers when an action/matter is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New File Note
Triggers when a new file note is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Matter Step Changed
Triggers when a step change occurs on an action/matter.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Matter
Triggers when an existing Matter is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Assigned to Participant ID
Action TypeRequired
Action NameRequired
Action StatusRequired
File Reference
Priority
File Note
Import External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MatterRequired
Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Rate Sheet
Assigned ToRequired
Action IDRequired
Task NameRequired
Task StatusRequired
PriorityRequired
Due DateRequired
Actual HoursRequired
Billable HoursRequired
Started Date/Time
Completed Date/Time
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Date
DescriptionRequired
Actual HoursRequired
Billable Hours
Rate
Matter Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File Note IdRequired
Note ContentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Matter IdRequired
Assign to Participant Id
Name
Status
Reference
Priority
Import External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IdRequired
Status
Priority
Assigned To
Due Date
Actual Hours
Billable Hours
Completed Date/Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom Field NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustom Field IdRequired
Matter IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch propertyRequired
Search valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
Search ValueRequired
Assigned to Participant ID
Action TypeRequired
Action NameRequired
Action StatusRequired
File Reference
Priority
File Note
Import External Reference
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
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 Matter Participant
Triggers when a participant/contact is added to an action/matter.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a participant/contact is created.
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.Participant TypeRequired
ParticipantRequired
MatterRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company/Business NameRequired
Physical Address - Line 1
Physical Address - Line 2
Physical Address - City
Physical Address -State/Province
Physical Address - ZIP/Post Code
Physical Address - Country CodeRequired
Mailing Address - Line 1
Mailing Address - Line 2
Mailing Address - City
Mailing Address - State/Province
Mailing Address - ZIP/Post Code
Mailing Address - CountryRequired
Phone 1 - Label
Phone 1 - Country Code
Phone 1 - Area Code
Phone 1 - Number
Phone 1 - Notes
Fax Number
SMS Number
Email Address
Website Address
Division ID
Phone 2 - Label
Phone 2 - Country Code
Phone 2 - Area Code
Phone 2 - Number
Phone 2 - Notes
Phone 3 - Label
Phone 3 - Country Code
Phone 3 - Area Code
Phone 3 - Number
Phone 3 - Notes
Phone 4 - Label
Phone 4 - Country Code
Phone 4 - Area Code
Phone 4 - Number
Phone 4 - Notes
Import External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salutation
First Name
Middle Name(s)
Last NameRequired
Suffix
Preferred Name
Physical Address - Line 1
Physical Address - Line 2
Physical Address - City
Physical Address -State/Province
Physical Address - ZIP/Post Code
Physical Address - Country CodeRequired
Mailing Address - Line 1
Mailing Address - Line 2
Mailing Address - City
Mailing Address - State/Province
Mailing Address - ZIP/Post Code
Mailing Address - CountryRequired
Phone 1 - Label
Phone 1 - Country Code
Phone 1 - Area Code
Phone 1 - Number
Phone 1 - Notes
Fax Number
SMS Number
Email Address
Website Address
Occupation
Birthday
Date of Death
Marital Status
Gender
Division ID
Phone 2 - Label
Phone 2 - Country Code
Phone 2 - Area Code
Phone 2 - Number
Phone 2 - Notes
Phone 3 - Label
Phone 3 - Country Code
Phone 3 - Area Code
Phone 3 - Number
Phone 3 - Notes
Phone 4 - Label
Phone 4 - Country Code
Phone 4 - Area Code
Phone 4 - Number
Phone 4 - Notes
Import External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Matter IdRequired
DateRequired
DescriptionRequired
Quantity
Unit priceRequired
Includes TaxRequired
Tax Code IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Company/Business Name
Physical Address - Line 1
Physical Address - Line 2
Physical Address - City
Physical Address - State/Province
Physical Address - ZIP/Post Code
Physical Address - Country Code
Mailing Address - Line 1
Mailing Address - Line 2
Mailing Address - City
Mailing Address - State/Province
Mailing Address - ZIP/Post Code
Mailing Address - Country Code
Phone 1 - Label
Phone 1 - Country Code
Phone 1 - Area Code
Phone 1 - Number
Phone 1 - Notes
Fax Number
SMS Number
Email Address
Website Address
Phone 2 - Label
Phone 2 - Country Code
Phone 2 - Area Code
Phone 2 - Number
Phone 2 - Notes
Phone 3 - Label
Phone 3 - Country Code
Phone 3 - Area Code
Phone 3 - Number
Phone 3 - Notes
Phone 4 - Label
Phone 4 - Country Code
Phone 4 - Area Code
Phone 4 - Number
Phone 4 - Notes
Import External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id
Salutation
First Name
Middle Names(s)
Last Name
Suffix
Preferred Name
Physical Address - Line 1
Physical Address - Line 2
Physical Address - City
Physical Address - State/Province
Physical Address - ZIP/Post Code
Physical Address - Country Code
Mailing Address - Line 1
Mailing Address - Line 2
Mailing Address - City
Mailing Address - State/Province
Mailing Address - ZIP/Post Code
Mailing Address - Country Code
Phone 1 - Label
Phone 1 - Country Code
Phone 1 - Area Code
Phone 1 - Number
Phone 1 - Notes
Fax Number
SMS Number
Email Address
Website Address
Occupation
Birthday
Date of Death
Marital Status
Gender
Phone 2 - Label
Phone 2 - Country Code
Phone 2 - Area Code
Phone 2 - Number
Phone 2 - Notes
Phone 3 - Label
Phone 3 - Country Code
Phone 3 - Area Code
Phone 3 - Number
Phone 3 - Notes
Phone 4 - Label
Phone 4 - Country Code
Phone 4 - Area Code
Phone 4 - Number
Phone 4 - Notes
Import External Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom Field Value IdRequired
Custom Field ValueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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.Tax CodeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch propertyRequired
Search valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
Search ValueRequired
Indentity TypeRequired
Company/Business Name
Salutation
First Name (Individual Only)
Middle Name(s) (Individual Only)
Last Name (Individual Only)
Suffix (Individual Only)
Preferred Name (Individual Only)
Physical Address - Line 1
Physical Address - Line 2
Physical Address - City
Physical Address -State/Province
Physical Address - ZIP/Post Code
Physical Address - Country CodeRequired
Mailing Address - Line 1
Mailing Address - Line 2
Mailing Address - City
Mailing Address - State/Province
Mailing Address - ZIP/Post Code
Mailing Address - CountryRequired
Phone 1 - Label
Phone 1 - Country Code
Phone 1 - Area Code
Phone 1 - Number
Phone 1 - Notes
Fax Number
SMS Number
Email Address
Website Address
Occupation (Individual Only)
Birthday
Date of Death
Marital Status
Gender
Division ID
Phone 2 - Label
Phone 2 - Country Code
Phone 2 - Area Code
Phone 2 - Number
Phone 2 - Notes
Phone 3 - Label
Phone 3 - Country Code
Phone 3 - Area Code
Phone 3 - Number
Phone 3 - Notes
Phone 4 - Label
Phone 4 - Country Code
Phone 4 - Area Code
Phone 4 - Number
Phone 4 - Notes
Import External Reference
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 propertyRequired
Search valueRequired
Indentity TypeRequired
Company/Business Name
Salutation
First Name (Individual Only)
Middle Name(s) (Individual Only)
Last Name (Individual Only)
Suffix (Individual Only)
Preferred Name (Individual Only)
Physical Address - Line 1
Physical Address - Line 2
Physical Address - City
Physical Address -State/Province
Physical Address - ZIP/Post Code
Physical Address - Country CodeRequired
Mailing Address - Line 1
Mailing Address - Line 2
Mailing Address - City
Mailing Address - State/Province
Mailing Address - ZIP/Post Code
Mailing Address - CountryRequired
Phone 1 - Label
Phone 1 - Country Code
Phone 1 - Area Code
Phone 1 - Number
Phone 1 - Notes
Fax Number
SMS Number
Email Address
Website Address
Occupation (Individual Only)
Birthday
Date of Death
Marital Status
Gender
Division ID
Phone 2 - Label
Phone 2 - Country Code
Phone 2 - Area Code
Phone 2 - Number
Phone 2 - Notes
Phone 3 - Label
Phone 3 - Country Code
Phone 3 - Area Code
Phone 3 - Number
Phone 3 - Notes
Phone 4 - Label
Phone 4 - Country Code
Phone 4 - Area Code
Phone 4 - Number
Phone 4 - Notes
Import External Reference
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
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
About Actionstep
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Copy worksheets in Google Sheets when matter steps change in Actionstep
- Create individual contacts in Actionstep from new or updated rows in Google Sheets
- Create file notes in Actionstep for new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new contacts in Actionstep
- Create Google Sheets rows when matter steps change in Actionstep