Assignar + Google Sheets
Create spreadsheet rows in Google Sheets for updated orders in Assignar
Keep your record-keeping process seamless and efficient with this workflow. Each time an order is revised in Assignar, the modifications are immediately mirrored in your selected Google Sheets. This means less manual data entry and more time saved, improving your project management strategy significantly. Stay on top of order changes and maintain accurate records easily with this integrated solution.
Keep your record-keeping process seamless and efficient with this workflow. Each time an order is revised in Assignar, the modifications are immediately mirrored in your selected Google Sheets. This means less manual data entry and more time saved, improving your project management strategy significantly. Stay on top of order changes and maintain accurate records easily with this integrated solution.
- When this happens...
Updated OrderTriggers when any attribute in Order is updated.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - 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 Task
Triggers when a new Task is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Asset
Triggers when a new Asset is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Client
Triggers when a new Client is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Digital Docket
Triggers when a new digital docket is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order Task
When an Task is associated with an Order.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Site Diary
Triggers when a new Site Diary is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Supplier
Triggers when a new Supplier is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated User
Triggers when a new User is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Project
Triggers when any attribute of project is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAsset nameRequired
External Identifier
Integration Identifier
Description
Registration number
Year
Make
Model
Serial Numbers
Charge Rate
Number Reading
Tag Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client NameRequired
External Identifier
Integration Identifier
ActiveRequired
Business Number
Email
Office Phone
Mobile
Address Line 1
Address Line 2
City
Postcode
State
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External ID
First NameRequired
Last NameRequired
Company
Office Phone
Mobile Phone
Email
Job Title
Address Line 1
Address Line 2
City
State
Postcode
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Journal TypeRequired
Visible in FieldWorker AppRequired
CommentRequired
IdentifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order NumberRequired
Task IdentifierRequired
Task Quantity
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact identifierRequired
Client identifier
Project identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task NameRequired
Integration Identifier
External Identifier
ActiveRequired
Machine Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User TypeRequired
First NameRequired
Last NameRequired
Employee Identifier
Integration Identifier
Employment TypeRequired
UsernameRequired
PasswordRequired
Retype PasswordRequired
Email
Phone Number
Address Line 1
Suburb
State
Postcode
Date of Birth
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
InductionRequired
Description
Expiry Date
Date of Issue
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity IDRequired
Activity NameRequired
Integration Identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Charge Code IDRequired
Charge Code
Label
Integration Identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
First NameRequired
Last NameRequired
Company
Office Number
Mobile
Email
Job Title
Address Line 1
Address Line 2
City
State
Postcode
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Project NameRequired
ActiveRequired
Integration Identifier
Address
Suburb
Postcode
State
Tag Id
Activity Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Task NameRequired
ActiveRequired
Machine Required
Integration Identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
CompetencyRequired
Expiry Date
Description
Date of Issue
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Work Item IdRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External Identifier
Activity name
Display the Integration Id of the Activity
ActionThis is an event a Zap performs.SearchFind existing data in your appAsset IdentifierRequired
Display the Integration Id of the Asset
ActionThis is an event a Zap performs.SearchFind existing data in your appTimesheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompetency NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDigital Docket ID
Project ID
Order ID
Client ID
ActionThis is an event a Zap performs.SearchFind existing data in your appDigital Docket IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
Display the Integration Id of the Order
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IDRequired
Order Task Id
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Project Name
Project ID
Display the Integration Id of the Project
ActionThis is an event a Zap performs.SearchFind existing data in your appContact identifierRequired
Client identifier
Project identifier
ActionThis is an event a Zap performs.SearchFind existing data in your appTag TypeRequired
Tag NameRequired
Tag Description
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Project ID
Order ID
Job Number
User ID
Display the Integration Id of the Timesheet
ActionThis is an event a Zap performs.SearchFind existing data in your appUser TypeRequired
Active
Username
Employee Identifier
ID
Display the Integration Id of the User
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appUserRequired
InductionRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Activity NameRequired
Display the Integration Id of the Activity
Integration Identifier
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal Identifier
Client Name
Display the Integration Id of the Client
Client NameRequired
Integration Identifier
ActiveRequired
Business Number
Email
Office Phone
Mobile
Address Line 1
Address Line 2
City
Postcode
State
Comments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal Identifier
Email
Mobile Phone
External ID
First NameRequired
Last NameRequired
Company
Office Phone
Job Title
Address Line 1
Address Line 2
City
State
Postcode
Comments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundWork Order NumberRequired
ActiveRequired
Client IDRequired
Project ID
Start DateRequired
End DateRequired
Order StatusRequired
Job Description
Location
Location 2
Integration Identifier
Purchase Order Number
Supplier
Comments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContact identifierRequired
Client identifier
Project identifier
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundUser TypeRequired
Active
UsernameRequired
Employee Identifier
ID
Display the Integration Id of the User
Email
First NameRequired
Last NameRequired
Integration Identifier
Employment TypeRequired
PasswordRequired
Retype PasswordRequired
Phone Number
Address Line 1
Suburb
State
Postcode
Date of Birth
Comments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundUserRequired
InductionRequired
Description
Expiry Date
Date of Issue
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 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Bottom-Up
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?
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
Approved Filter TypeRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Activity
Triggers when a new Activity is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Charge Code
Triggers when a new Charge Code is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Contact
Triggers when a new Contanct is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Project
Triggers when a new Project is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Skill
Triggers when a new skill is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew User
Triggers when a new User is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Order
Triggers when any attribute in Order is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planActivity NameRequired
External Identifier
Integration Identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Charge CodeRequired
Label
Integration Identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Is expiry required?
Is issue date required?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Is expiry required?
Is issue date required?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ActiveRequired
Client IDRequired
Project ID
Start DateRequired
End DateRequired
Order StatusRequired
Job Description
Location
Location 2
Work Order Number
Integration Identifier
Purchase Order Number
Supplier
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project NameRequired
Client IdentifierRequired
Project Identifier
Integration Identifier
Project StatusRequired
Address
Suburb
Postcode
State
Parent ID
Tag Id
Activity Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
External ID
Business ID
Email
Office Phone
Mobile phone
Address Line 1
Address Line 2
City
Postcode or ZIP code
State
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Created DateRequired
User IDRequired
Client IDRequired
Integration Identifier
Task IDRequired
Project ID
Start TimeRequired
End TimeRequired
Break TimeRequired
Total TimeRequired
Travel Time To
Travel Time From
Comments
Submitted DateRequired
Activity IdRequired
Activity Start TimeRequired
Activity End TimeRequired
Asset ID
Approved
Locked
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
CompetencyRequired
Description
Expiry Date
Date of Issue
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ToRequired
Cc
Bcc
SubjectRequired
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset IDRequired
Asset NameRequired
External Identifier
Integration Identifier
Description
Registration Number
Year
Make
Model
Serial Number
Charge Rate
Number Reading
Tag Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IDRequired
Client NameRequired
ActiveRequired
Integration Identifier
Business Number
Email
Office Phone
Mobile
Address Line 1
Address Line 2
City
Postcode
State
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrderRequired
Order Status
Job Number
Integration Identifier
PO Number
Job Description
Order Owner
Comments
Supplier
End Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Supplier IDRequired
NameRequired
Business Number
Email
Office Phone
Mobile
Address Line 1
Address Line 2
City
Postcode
State
Comments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
First Name
Last Name
Employee ID
Integration Identifier
Username
Employment Type
Date of Birth
Email
Phone Contact
Address
Suburb
State
Postcode
Comments
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
InductionRequired
Expiry Date
Description
Date of Issue
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.External Identifier
Asset Name
Registration Number
Serial Number
ID
Display the Integration Id of the Asset
ActionThis is an event a Zap performs.SearchFind existing data in your appCharge Code ID
Charge Code
Label
Display the Integration Id of the Charge Code
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Client Name
Display the Integration Id of the Client
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Email
Mobile
ActionThis is an event a Zap performs.SearchFind existing data in your appDigital Docket IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWork OrderRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrderRequired
Task
Start Time
End Time
ActionThis is an event a Zap performs.SearchFind existing data in your appProject ID
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Supplier Name
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Task Name
Task ID
Display the Integration Id of the Task
ActionThis is an event a Zap performs.SearchFind existing data in your appTimesheet ID
ActionThis is an event a Zap performs.SearchFind existing data in your appUserRequired
ComptencyRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Code
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Asset nameRequired
Registration number
Serial Numbers
ID
Display the Integration Id of the Asset
Integration Identifier
Description
Year
Make
Model
Charge Rate
Number Reading
Tag Id
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Is expiry required?
Is issue date required?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Is expiry required?
Is issue date required?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal Identifier
Project NameRequired
Project ID
Display the Integration Id of the Project
Client IdentifierRequired
Project Identifier
Integration Identifier
Project StatusRequired
Address
Suburb
Postcode
State
Parent ID
Tag Id
Activity Id
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundExternal Identifier
Task Name
Task ID
Display the Integration Id of the Task
Task NameRequired
Integration Identifier
ActiveRequired
Machine Required
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundUserRequired
CompetencyRequired
Description
Expiry Date
Date of Issue
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 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
Bottom-Up
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
Bottom-Up
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 Assignar
Assignar is a workforce and asset management platform for construction sub contractor and self-perform general contractors.
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
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
