geoCapture + Google Sheets
Create spreadsheet rows in Google Sheets for new alarm events in geoCapture
This workflow springs into action with each New Alarm Event in geoCapture, culminating in the creation of a new row in your Google Sheets spreadsheet. Keep track of all your geoCapture events in an organized manner, ensuring you have all the vital data right at your fingertips. This seamless connection between geoCapture and Google Sheets not only saves time but also increases the productivity of your day-to-day operations.
This workflow springs into action with each New Alarm Event in geoCapture, culminating in the creation of a new row in your Google Sheets spreadsheet. Keep track of all your geoCapture events in an organized manner, ensuring you have all the vital data right at your fingertips. This seamless connection between geoCapture and Google Sheets not only saves time but also increases the productivity of your day-to-day operations.
- When this happens...
New Alarm EventTriggers when an alarm was triggered.
TriggerInstantThis event starts a Zap instantly. - 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
ActionsRequired
Filter by Departments
Filter by Locations
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ActionsRequired
Filter by Categories
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order id
Order external reference
Tour id
Before stop id
After stop id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee id
Application type
Application priority
Absence absence type id
Absence absence type external id
Absence duration type
Absence date from
Absence date to
Absence duration
Stamp time
Stamp state
Stamp tracker id
Stamp tracker vin
Stamp project id
Stamp project reference sign
Accounting entry date
Accounting entry salary type id
Accounting entry salary type
Accounting entry value
Accounting entry project id
Accounting entry project reference sign
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Identifier
Cost center
Resource planning
Ignore project worktime approval rule
Sequence
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reference
Card number
Import source
Import key
First name
Last name
Name
Phone number
Ibutton
Ibutton number
Email
Cost center
Entry date
Day of birth
Gender
Num vacation days
Termination date
Social security number
Health insurance from date
Health insurance type
Health insurance company number
Time tracking
Image name
Image data
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Date
Description
Salary type id
Value
Value unit
Project id
Cost center
Employee id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter by cost type ids
Filter by project ids
Filter by department ids
Filter by vehicle category ids
Filter by tool category ids
Filter by cost sources
Filter from
Filter to
Group by group by field1
Group by group by field2
Group by group by field3
Format
Mark as exported
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Identifier
Sequence
Zip code
City
Street
Country code
Accounting client
Created at
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Date
Employee
Duration
Material cost
Service cost
Invoice number
Company
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reference
Import source
Import key
Name
Description
Extra name1
Extra name2
Extra name3
Street
Zip code
City
Country code
Latitude
Longitude
Cost center
Order reference
Offer reference
Contact person
Phone number
Mobile number
Email
Valid from
Valid to
Resource planning from
Resource planning to
Radius
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Cost center
External id
Export
Ignore reverse geocoding
Home category
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Description
Category id
Category name
Serial number
Inventory number
Manufacturer id
Manufacturer name
Model
Machine type
Assessory
Supplier
Icon name
Icon data
Purchase cost
Purchase date
Warranty month
Year of manufacture
Outgoing date
Status
Weight
Length
Width
Height
Dguv check number
Beacon id
Tracker id
License number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tracker idRequired
Tracker category id
Cost type source
Cost type id
Cost type reference
Cost distribution
Logistics km distribution
Logistics km rate
Logistics hourly rate
Logistics daily rate
Machine hourly rate
Machine daily rate
Machine transport day distribution
Automatic booking
Release on inactivity
Operating hour source
Min duration
Min distance
From
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee id
Department id
From
Wage group source
Wage group id
Fallback project id
Automatic booking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Description
Active
Base url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter by employee reference
Filter from
Filter to
Filter by absence type id
Filter by id
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Projects by ids
Projects by references
Projects by import keys
Projects import source
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter by ids
Filter by external ids
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filename
Data
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
External id
Offer number
Addendum
Text1
Text2
Note start
Note end
Date
Total value
Currency
Project name
Import source
Import key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Identifier
Inventory number
License number
Identification number
Import source
Import key
Name
Description
Driver name
Driver phone number
Cost center
Model
Activity type
Fuel type
Battery capacity
Consumption
Co2 emissions
Pool vehicle
Location id
Department id
Usage start date
Default driver name
Default driver phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
IdRequired
Name
Type
Container id
Container type id
Amount
Project id
Street
Zip code
City
Country code
Latitude
Longitude
Contact person phone number
Contact person name
Target date time
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Reference
Start date
Team
Team external reference
District
District reference
Status
Orders
Order external references
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Import source
Import key
Id
Employee
Employee reference
Type
Date
Half day
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
External id
Object type
Target id
Target reference
Type id
Type reference
Filename
Description
Date
Valid to
Data
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
IdRequired
Description
Note
Maintenance type id
Tracker id
Tool id
Active
Scheduler definition type
Scheduler definition performance type
Scheduler definition performance value
Scheduler definition max hits
Scheduler definition max days after last maintenance
Scheduler definition last maintenance value
Scheduler definition last maintenance date
Scheduler definition next maintenance date
Date scheduler definition type
Date scheduler definition interval days
Date scheduler definition weekdays
Date scheduler definition interval weeks
Date scheduler definition day
Date scheduler definition interval months
Date scheduler definition occurrence
Date scheduler definition month
Date scheduler definition interval years
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Reference
Order type
External reference
Status
Subject
Text
Order date
Duration
Priority
Target date
Name
Name2
Name3
Street
Zip code
City
Country code
Latitude
Longitude
Contact person name
Contact person email
Contact person phone number
Contact person mobile number
Customer order reference
Offer reference
Category
Type
Project
Project reference sign
Created at
Province code
Performance fields name
Performance fields value
Planning type
Assigned tracker id
Assigned employee id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
IdRequired
Tracker id
Tool id
Type
Assigned project id
From date
To date
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Records key field
Id
Tour id
Sequence
Type
Name
Name2
Name3
Street
Zip code
City
Country code
Province code
Latitude
Longitude
Contact person name
Contact person email
Contact person phone number
Contact person mobile number
Duration
Break duration
Note driver
Note planner
Additional costs
Fixed arrival date
Fixed arrival time
Fixed departure date
Fixed departure time
Before stop id
After stop id
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Name
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
IdRequired
External id
External name
Application id
Application external id
Configuration
Active
Url
Sequence
Application name
Application base url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Logs by assignee
Logs by employee
Logs by statuses
Logs by object type
Logs by object id
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appBeacons by ids
Beacons by uuids
Beacons by tool ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by references
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appJob IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by project ids
Filter by employee ids
Filter by tracker ids
Filter by beacon ids
Filter by text
Filter by form definition ids
Filter by external reference
Filter by status
Filter by order ids
Filter from
Filter to
Min. Latitude
Min. Longitude
Max. Latitude
Max. Longitude
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
Log Access
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by district
Filter by team
Filter by status
Filter from
Filter to
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by employee reference
Filter from
Filter to
Filter by absence type id
Filter by department ids
Filter updated from
Filter updated to
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter from
Filter to
Filter by ids
Filter by project ids
Filter by salary type ids
Filter by employee ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployees by ids
Employees by references
Employees by card numbers
Employees by ibutton numbers
Employees by import keys
Employees import source
Stamp id
From
To
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appEvent types
Sensor value type name
Trackers by ids
Trackers by license numbers
Trackers by identifiers
Trackers by identification numbers
Trackers by import keys
Trackers by project changed after
Trackers import source
Trackers by name
Trackers by driver
By employees by ids
By employees by references
By employees by card numbers
By employees by ibutton numbers
By employees by import keys
By employees import source
Employees by ids
Employees by references
Employees by card numbers
Employees by ibutton numbers
Employees by import keys
Employees import source
Offset
Limit
From
To
Date
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appId
ActionThis is an event a Zap performs.SearchFind existing data in your appId
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by tracker ids
Filter by tool ids
Filter by maintenance type ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by external references
Filter from
Filter to
Filter by tour ids
Filter by status text
Filter by order type
Min. Latitude
Min. Longitude
Max. Latitude
Max. Longitude
Filter by unassigned
Filter by project ids
Filter by team ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
Order log
Order qualification
Tour info
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by project ids
Filter by tracker ids
Filter by tool ids
Filter from date
Filter to date
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appProject reference
Project import key
From
To
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by external ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by external ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appTrackers by ids
Trackers by license numbers
Trackers by identifiers
Trackers by identification numbers
Trackers by import keys
Trackers by project changed after
Trackers import source
Trackers by name
Trackers by driver
Date
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appTracker by id
Tracker by license number
Tracker by identifier
Tracker by identification number
Tracker by import key
Tracker import source
After track point id
From
To
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by wage group id
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by external ids
Filter by application ids
Filter by application external ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
ActionsRequired
Filter by Form Data objects
Filter by Form Definitions
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ActionsRequired
Filter by Files
Filter by File Types
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ActionsRequired
Filter by Categories
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Type
Container id
Container type id
Amount
Project id
Street
Zip code
City
Country code
Latitude
Longitude
Contact person phone number
Contact person name
Target date time
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reference
Start date
Team
Team external reference
District
District reference
Status
Orders
Order external references
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Import source
Import key
Employee
Employee reference
Type
Date
Half day
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee reference
Time
State
Note
Tracker id
Tracker vin
Project ref
Salary type
Cost center
Latitude
Longitude
Import source
Import key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External id
Object type
Target id
Target reference
Type id
Type reference
Filename
Description
Date
Valid to
Data
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Note
Maintenance type id
Tracker id
Tool id
Active
Scheduler definition type
Scheduler definition performance type
Scheduler definition performance value
Scheduler definition max hits
Scheduler definition max days after last maintenance
Scheduler definition last maintenance value
Scheduler definition last maintenance date
Scheduler definition next maintenance date
Date scheduler definition type
Date scheduler definition interval days
Date scheduler definition weekdays
Date scheduler definition interval weeks
Date scheduler definition day
Date scheduler definition interval months
Date scheduler definition occurrence
Date scheduler definition month
Date scheduler definition interval years
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reference
Order type
External reference
Status
Subject
Text
Order date
Duration
Priority
Target date
Name
Name2
Name3
Street
Zip code
City
Country code
Latitude
Longitude
Contact person name
Contact person email
Contact person phone number
Contact person mobile number
Customer order reference
Offer reference
Category
Type
Project
Project reference sign
Created at
Province code
Performance fields name
Performance fields value
Planning type
Assigned tracker id
Assigned employee id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tracker id
Tool id
Type
Assigned project id
From date
To date
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order reference
Order order type
Order external reference
Order status
Order subject
Order text
Order order date
Order duration
Order priority
Order target date
Order external address id
Order name
Order name2
Order name3
Order street
Order zip code
Order city
Order country code
Latitude
Longitude
Order contact person name
Order contact person email
Order contact person phone number
Order contact person mobile number
Order customer order reference
Order offer reference
Order category
Order category external id
Order type
Order project
Order project reference sign
Order created at
Scheduler definition type
Scheduler definition interval days
Scheduler definition weekdays
Scheduler definition interval weeks
Scheduler definition day
Scheduler definition interval months
Scheduler definition occurrence
Scheduler definition month
Scheduler definition interval years
Order scheduler start date
Order scheduler end date
Order scheduler max runs
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tool id
Tool category id
From
Cost type source
Cost type id
Cost type reference
Daily rate source
Daily rate
Hourly rate
Fallback project id
Automatic booking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order id
Order reference
Order order type
Order external reference
Order status
Order subject
Order text
Order order date
Order duration
Order priority
Order target date
Order external address id
Order name
Order name2
Order name3
Order street
Order zip code
Order city
Order country code
Latitude
Longitude
Order contact person name
Order contact person email
Order contact person phone number
Order contact person mobile number
Order customer order reference
Order offer reference
Order category
Order category external id
Order type
Order project
Order project reference sign
Order created at
Pickup location type
Latitude
Longitude
Custom project name
Custom project street
Custom project street name
Custom project street number
Custom project zip code
Custom project city
Custom project country code
Custom project full address
Pickup location external address id
Pickup location project
Delivery location type
Latitude
Longitude
Custom project name
Custom project street
Custom project street name
Custom project street number
Custom project zip code
Custom project city
Custom project country code
Custom project full address
Delivery location external address id
Delivery location project
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project costs per hour
Logistics costs per hour
From
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External id
External name
Application id
Application external id
Configuration
Active
Url
Sequence
Application name
Application base url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ids
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employees by ids
Employees by references
Employees by card numbers
Employees by ibutton numbers
Employees by import keys
Employees import source
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee accounting entries from
Employee accounting entries to
Employee accounting entries by ids
Employee accounting entries by employee ids
Employee accounting entries by salary type ids
Employee accounting entries by project ids
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter by ids
Filter by external references
Filter from
Filter to
Filter by tour ids
Filter by status text
Filter by order type
Min. Latitude
Min. Longitude
Max. Latitude
Max. Longitude
Filter by unassigned
Filter by project ids
Filter by team ids
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter by project ids
Filter by tracker ids
Filter by tool ids
Filter from date
Filter to date
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ids
Dry run
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.File
Format
External id
Offer number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id
From sequence
To sequence
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id
Status text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Log id
Status
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Uuid
Mac address
Name
Object identifier
Object serial number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Name
Identifier
Cost center
Resource planning
Ignore project worktime approval rule
Sequence
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Reference
Card number
Import source
Import key
First name
Last name
Name
Phone number
Ibutton
Ibutton number
Email
Cost center
Entry date
Day of birth
Gender
Num vacation days
Termination date
Social security number
Health insurance from date
Health insurance type
Health insurance company number
Time tracking
Image name
Image data
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Date
Description
Salary type id
Value
Value unit
Project id
Cost center
Employee id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Name
Identifier
Sequence
Zip code
City
Street
Country code
Accounting client
Created at
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Description
Date
Employee
Duration
Material cost
Service cost
Invoice number
Company
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Reference
Import source
Import key
Name
Description
Extra name1
Extra name2
Extra name3
Street
Zip code
City
Country code
Latitude
Longitude
Cost center
Order reference
Offer reference
Contact person
Phone number
Mobile number
Email
Valid from
Valid to
Resource planning from
Resource planning to
Radius
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Description
Cost center
External id
Export
Ignore reverse geocoding
Home category
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
Id
Name
Description
Category id
Category name
Serial number
Inventory number
Manufacturer id
Manufacturer name
Model
Machine type
Assessory
Supplier
Icon name
Icon data
Purchase cost
Purchase date
Warranty month
Year of manufacture
Outgoing date
Status
Weight
Length
Width
Height
Dguv check number
Beacon id
Tracker id
License number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
IdRequired
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Key FieldRequired
IdRequired
Name
Description
Active
Base url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by import keys
Filter by external ids
Filter from
Filter to
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by container ids
Filter by container references
Filter by container type ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter from date
Filter to date
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appExport id
ActionThis is an event a Zap performs.SearchFind existing data in your appForm Data IdRequired
FilenameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by text
Filter by external reference
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployees by ids
Employees by references
Employees by card numbers
Employees by ibutton numbers
Employees by import keys
Employees import source
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by external ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee reference
Import key
From
To
ActionThis is an event a Zap performs.SearchFind existing data in your appId
ActionThis is an event a Zap performs.SearchFind existing data in your appId
External Id
Log Access
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by external ids
Filter by type id
Filter by type references
Filter owner type
Filter owner id
Filter from
Filter to
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appId
ActionThis is an event a Zap performs.SearchFind existing data in your appId
From
To
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by tracker ids
Filter by tool ids
Filter by maintenance type ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by project ids
Filter by employee ids
Filter by tracker ids
Filter by beacon ids
Filter by text
Filter by form definition ids
Filter by external reference
Filter by status
Filter by order ids
Filter from
Filter to
Min. Latitude
Min. Longitude
Max. Latitude
Max. Longitude
Field name
Limit
Offset
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter from
Filter to
Filter by name
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appProjects by ids
Projects by references
Projects by import keys
Projects import source
By employee activities from
By employee activities to
By tracker work activities from
By tracker work activities to
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appLat LngRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by serial numbers
Filter by external ids
Filter by beacon ids
Filter by project changed after
Filter by license numbers
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by tool id
Filter by tool category id
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appTrackers by ids
Trackers by license numbers
Trackers by identifiers
Trackers by identification numbers
Trackers by import keys
Trackers by project changed after
Trackers import source
Trackers by name
Trackers by driver
Normalized search
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by tracker id
Filter by tracker category id
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appVehicle id
ActionThis is an event a Zap performs.SearchFind existing data in your appOffset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by external ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by employee id
Filter by department id
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by ids
Filter by external ids
Offset
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 geoCapture
Related categories
