Actionstep + Google Sheets
Create individual contacts in Actionstep from new or updated rows in Google Sheets
When new data is added or updated in your Google Sheets, this workflow promptly creates an individual contact in your Actionstep. Simply connect your Google Sheets and Actionstep to keep your contacts up-to-date and streamlined. This automation saves time by eliminating manual data entry, ensuring all your necessary contact information is conveniently stored in Actionstep.
When new data is added or updated in your Google Sheets, this workflow promptly creates an individual contact in your Actionstep. Simply connect your Google Sheets and Actionstep to keep your contacts up-to-date and streamlined. This automation saves time by eliminating manual data entry, ensuring all your necessary contact information is conveniently stored in Actionstep.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Individual ContactCreates an individual 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 ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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 foundKeywordsRequired
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 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text Strikethrough
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
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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 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 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 found
About Actionstep
Actionstep is a Legal Practice Management Solution for Law firms.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Copy worksheets in Google Sheets when matter steps change in Actionstep
- Create spreadsheet rows in Google Sheets for new matters in Actionstep
- 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