Actaport + Google Sheets
Create new Actaport contacts for new or updated Google Sheets rows
Easily maintain your Actaport contacts with this handy workflow that links Google Sheets and Actaport. Whenever a new or updated row is detected in your Google Sheets spreadsheet, the workflow creates a new contact in Actaport, sparing you from manual entry and ensuring your contact list is always current and accurate. It's a simple solution for efficient contact management.
Easily maintain your Actaport contacts with this handy workflow that links Google Sheets and Actaport. Whenever a new or updated row is detected in your Google Sheets spreadsheet, the workflow creates a new contact in Actaport, sparing you from manual entry and ensuring your contact list is always current and accurate. It's a simple solution for efficient contact management.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create ContactCreates a new 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
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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
Include Grid Data
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 Case File
Triggers when a new case file is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deadline
Triggers when a deadline is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Case File
Triggers when a new case file is created or an existing case file is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Deadline
Triggers when a new deadline is created or an existing deadline is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Resubmission
Triggers when a new resubmission is created or an existing resubmission is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Resubmission
Triggers when a new resubmission is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Case File
Triggers when an existing case file is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Deadline
Triggers when an existing deadline is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Resubmission
Triggers when an existing resubmission is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Case File NameRequired
Case File Alternative Name
Case File Clerk IdRequired
Case File Assistant(s) IdRequired
Case File Participant Contact IdRequired
Case File Participant Main RoleRequired
Case File Participant Sub RoleRequired
Case File Participant File Reference
Case File Participant VAT Treatment
Case File Participant Input Tax Reduction
Case File Participant Sub Participant Contact Id
Case File Participant Sub Participant Role
Case File Participant Sub Participant Insurance Number
Case File Participant Sub Participant Claim Number
Case File Dispute Value
Case File Law Area(s)
Case File Keyword(s)
Case File Reason
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deadline Case File NumberRequired
Deadline Note
Deadline Start Date
Deadline End DateRequired
Deadline ReasonRequired
Deadline Final
Deadline Early Date
Deadline Provisional
Deadline Document
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Resubmission Case File NumberRequired
Resubmission ReasonRequired
Resubmission DateRequired
Resubmission Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task TitleRequired
Task Description
Task PriorityRequired
Task Owner User IdRequired
Task Due DateRequired
Task Case File Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Case File NumberRequired
Case File Name
Case File Alternative Reference Number
Case File Clerk Id
Case File Assistant(s) Id
Case File Participant Contact Id
Case File Participant Main Role
Case File Participant Sub Role
Case File Participant File Reference
Case File Participant VAT Treatment
Case File Participant Input Tax Reduction
Case File Participant Sub Participant Contact Id
Case File Participant Sub Participant Role
Case File Participant Sub Participant Insurance Number
Case File Participant Sub Participant Claim Number
Case FIle Participant Id
Case File Participant Sub Participant Id
Case File Dispute Value
Case File Law Area(s)
Case File Keyword(s)
Case File Reason
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deadline Case File NumberRequired
Deadline IdRequired
Deadline Note
Deadline Start Date
Deadline End Date
Deadline Reason
Deadline Final
Deadline Early Date
Deadline Provisional
Deadline Document
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document IdRequired
Document Name
Document Description
Document Type
Document Status
Document Modified Creation Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Resubmission Case File NumberRequired
Resubmission IdRequired
Resubmission StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IdRequired
Task StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDeadline Case File NumberRequired
Deadline IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCase File NumberRequired
Page
Size
Filter
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appCase File Involved Person Contact IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTask IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUser me
ActionThis is an event a Zap performs.SearchFind existing data in your app
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Contact
Triggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Document
Triggers when a new document is created or uploaded.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Contact
Triggers when a new contact is created or an existing contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Document
Triggers when a new document is created or an existing document is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Task
Triggers when a new task is created or an existing task is updated.
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.Updated Contact
Triggers when an existing contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Document
Triggers when an existing document is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Task
Triggers when an existing task is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact First Name
Contact Last NameRequired
Contact Academical Titles
Contact Salutation
Contact TypeRequired
Contact Birth Date
Contact Email Addresses
Contact Legal Form
Contact Note
Contact Address Street
Contact Address House Number
Contact Address Additional Info
Contact Address Receiver
Contact Address Postal Code
Contact Address Country
Contact Address Postal
Contact Address Type
Contact Address Place
Contact Telephone Number Value
Contact Telephone Number Type
Contact Fax Number Value
Contact Fax Number Type
Contact Contact Person Id
Contact Bank Account IBAN
Contact Bank Account BIC
Contact Bank Account Owner
Contact Bank Account Institute
Contact Representative Type
Contact Representative Contact Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Case File NumberRequired
ReasonRequired
Expenditure TypeRequired
Comment
TypeRequired
QuantityRequired
Net Amount
Gross Amount
VATRequired
Creation DateRequired
User IdRequired
Client Id
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Case File NumberRequired
Activity TypeRequired
VATRequired
DescriptionRequired
Net AmountRequired
Remunaration NumberRequired
User IdRequired
Client Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Case File NumberRequired
ReasonRequired
Expenditure TypeRequired
Comment
QuantityRequired
Net AmountRequired
Creation DateRequired
User IdRequired
Client Id
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IdRequired
Contact Last Name
Contact First Name
Contact Academical Titles
Contact Salutation
Contact Type
Contact Birth Date
Contact Email Addresses
Contact Legal Form
Contact Note
Contact Address Street
Contact Address House Number
Contact Address Additional Info
Contact Address Receiver
Contact Address Postal Code
Contact Address Country
Contact Address Postal
Contact Address Type
Contact Address Place
Contact Telephone Number Value
Contact Telephone Number Type
Contact Fax Number Value
Contact Fax Number Type
Contact Contact Person Id
Contact Bank Account IBAN
Contact Bank Account BIC
Contact Bank Account Owner
Contact Bank Account Institute
Contact Representative Type
Contact Representative Contact Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deadline Case File NumberRequired
Deadline IdRequired
Deadline StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Resubmission Case File NumberRequired
Resubmission IdRequired
Resubmission Reason
Resubmission Date
Resubmission Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IdRequired
Task Description
Task Priority
Task Owner User Id
Task Due Date
Task Case File Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document Case File NumberRequired
Document Source UrlRequired
Document Name
Document Folder Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact First name
Contact Last Name
ActionThis is an event a Zap performs.SearchFind existing data in your appDocument Case File NumberRequired
Document IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCase File NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appResubmission Case File NumberRequired
Resubmission IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUser Enabled
User Clerk
User Assistant
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Actaport
Related categories
