How to connect Webhooks by Zapier + Google Sheets + Assignar
Zapier lets you send info between Webhooks by Zapier and Google Sheets and Assignar 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 Webhooks by Zapier + Google Sheets + 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 Webhooks by Zapier, Google Sheets, and Assignar. And don’t forget that you can add more apps and actions to create complex workflows.
URLRequired
Key
Deduplication Key
Xpath
Basic Auth
Headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planURLRequired
Query String Params
Send As JSON
JSON key
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Payload Type
Data
Wrap Request In Array
File
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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
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
Headers
Overwrite existing worksheets
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 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
Catch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MethodRequired
URLRequired
Data Pass-Through?
Data
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Payload Type
Data
Wrap Request In Array
File
Unflatten
Basic Auth
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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.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
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 foundApproved 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.