Assignar + Microsoft Excel
Create rows in Microsoft Excel for new Assignar users
Effortlessly keep track of new Assignar users with this seamless integration that automatically adds their information to Microsoft Excel. When a new user is added in Assignar, this workflow quickly updates your Excel spreadsheet by adding a row with their details. Stay organized and save time, as your user data is consistently updated with every new addition in Assignar.
Effortlessly keep track of new Assignar users with this seamless integration that automatically adds their information to Microsoft Excel. When a new user is added in Assignar, this workflow quickly updates your Excel spreadsheet by adding a row with their details. Stay organized and save time, as your user data is consistently updated with every new addition in Assignar.
- When this happens...
New UserTriggers when a new User is created.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Add RowAdds a new row to the end of a worksheet.
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 foundStorage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
TableRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
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 foundStorage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
Folder
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
Folder
TitleRequired
Column Headers
Zap Step Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
FolderRequired
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Assignar
Assignar is a workforce and asset management platform for construction sub contractor and self-perform general contractors.
Related categories
About Microsoft Excel
Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets.
Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.
Related categories
Similar apps
OneDrive
File Management & Storage, Microsoft
Smartsheet
Spreadsheets
