Assignar + Gmail + Google Sheets Integrations
How to connect Assignar + Gmail + Google Sheets
Zapier lets you send info between Assignar and Gmail and Google Sheets automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Assignar + Gmail + Google Sheets
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Assignar, Gmail, and Google Sheets. And don’t forget that you can add more apps and actions to create complex workflows.
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 found
New Label
Triggers when you add a new label.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Starred Email
Triggers when you receive a new email and star it within two days.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planLabel
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient Instructions
To
Cc
Bcc
SubjectRequired
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of labelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MessageRequired
Label(s) to removeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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.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
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 foundLabel or mailbox
Search keywords
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planEmail message to be DeletedRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger Instructions
ThreadRequired
To
Cc
Bcc
From
From Name
Reply To
Body type
BodyRequired
Label or mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search StringRequired
To
Cc
Bcc
From
From Name
Reply To
SubjectRequired
Body type
BodyRequired
Add signature default
Label or mailbox
Attachments
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 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
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
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
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
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Assignar + Gmail + Google Sheets Integrations Work
- Step 1: Authenticate Assignar, Gmail, and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Assignar
Related categories
About Gmail
