Google Sheets + Gmail + Assignar Integrations
How to connect Google Sheets + Gmail + Assignar
Zapier lets you send info between Google Sheets and Gmail and Assignar automatically—no code required. With 6,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Gmail + Assignar
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 Google Sheets, Gmail, and Assignar. And don’t forget that you can add more apps and actions to create complex workflows.
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.Welcome
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 foundSubjectRequired
To
Cc
Bcc
From
From Name
Body Type
BodyRequired
Signature
Label/Mailbox
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message to Remove Label(s) FromRequired
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 app
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 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
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.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
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
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
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
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.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
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
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.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
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
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
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
ActionThis is an event a Zap performs.SearchFind existing data in your appUser TypeRequired
Active
Username
Employee Identifier
ID
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
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
Client NameRequired
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
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
Email
First NameRequired
Last NameRequired
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
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 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.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
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(s) to Add
Message to be LabeledRequired
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
Signature
Label/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
Signature
Label/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/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
Signature
Label/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 foundApproved Filter TypeRequired
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 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client NameRequired
External 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
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
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IDRequired
Client NameRequired
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.OrderRequired
Order Status
Job Number
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
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.Welcome
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External Identifier
Activity name
ActionThis is an event a Zap performs.SearchFind existing data in your appAsset IdentifierRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appExternal Identifier
Client Name
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
Action