Google Sheets + MyGadgetRepairs
Create new MyGadgetRepairs customers from new or updated rows in Google Sheets
Manage your customer records efficiently with this powerful automation. When you add or update a row in your Google Sheets, this workflow simultaneously creates a customer in your MyGadgetRepairs system. This process offers a streamlined method for keeping your customer data up-to-date, saving you time and ensuring accuracy across your platforms.
Manage your customer records efficiently with this powerful automation. When you add or update a row in your Google Sheets, this workflow simultaneously creates a customer in your MyGadgetRepairs system. This process offers a streamlined method for keeping your customer data up-to-date, saving you time and ensuring accuracy across your platforms.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create CustomerCreates a Customer.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
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 foundKeyword
include Custom Fields
Include Notes
Include Credit Limit Log
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Lines
Include Payments
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Shop Only Products
include Custom Fields
include Xsell Upsell
Include Tag Along
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTicket UUID
Type
include Created By Info
include Updated By Info
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
include Custom Fields
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Item Lines
Include Payments
Include Returns
Created From
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProject IDRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
Video TitleRequired
Video SourceRequired
Video File CodeRequired
Display Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUID or Customer NameRequired
Asset NameRequired
Asset IdentifierRequired
Asset Tag
Brand ID
Model ID
Asset Type
Asset Location
Latitude
Longitude
StatusRequired
Notes
Watchout Notes
RMM Asset ID
RMM Asset Link
RMM Status
RMM Current Status Date
Maintenance Plan
Plan Duration
Service Schedule
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.NameRequired
MobileRequired
Email Address
Address
Shipping Address
Add Address Part
Account Manager
Telephone
Referred By
GDPR Compliant
VAT Registration
Longitude
Latitude
Invoice Email
Comments
Company
Customer Group ID
City
Country Code ISO Format
Payment Term Days
Due Each Month
Due Next Month
Gender
Opt-in for Print Media
Opt-in for Email Marketing
Opt-in for Email Notifications
Opt-in for SMS Messages
Intra-Community Supplies (ICS)
VAT Exemption
VAT/TAX Rate
Credit Limit
Credit Limit Notes
Watchout
Notes Title
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Referred By
Customer's NameRequired
Customer's MobileRequired
Country Code
Customer's Email
Company/Business Name
Telephone
Address
Leads Detail
Issue Type
Device Mode lD/Name
Technician User ID
GDPR Compliant
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IDRequired
Payment Date
Invoice Note
AmountRequired
Payment MethodRequired
Payment Note
Is Advance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUID or Customer NameRequired
User IDRequired
order Date
Tax
Discount
Discount Level
Customer Group Discount
Delivery Method Id
Notes
Print Receipt
Product CodeRequired
Description
QuantityRequired
Price
AmountRequired
Payment MethodRequired
Payment Note
Is Advance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Customer UUID or Customer NameRequired
Priority
Start Date
Due Date
End Date
Budget
Rate per hour
StatusRequired
Category
Tags
Leader Ids
Member Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project UUIDRequired
Task UUID
MessageRequired
Display Type
Users
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Date/TimeRequired
StaffRequired
NotesRequired
Ticket
Customer
Lead
Supplier
Project Task
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Quantity
COG Per Item
Expires On
Supplier
Supplier Item Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
StatusRequired
TypeRequired
CommentRequired
important Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUID or Customer NameRequired
Short InfoRequired
Status ID
Issue Description
Issue Type
Priority
Device Brand ID
Device Model ID
Created Date
Due Date
Technician User ID
Work Approved?
Pre Diagnosed
Asset UUID
Preset Id
Create Invoice
Invoice Date
Invoice Due Date
Print Invoice
Print Receipt
Print Label
Product Code
Description
Quantity
Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.POS On Hold UUID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stock UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.serial UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timer IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointment UUIDRequired
Appointment Start Date and time
Appointment Duration
Subject
Description
Type
Color
Location
Latitude
Longitude
Ticket ID
Customer ID
Lead ID
Asset ID
Attendees
No Show Appointment
Internal Appointment
Completed Appointment
Reminder On
Follow-up On
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUIDRequired
Name
company
VAT Registration
Email
Invoice Email
Telephone
Mobile
Full Address
Shipping Address
City
Country Code ISO Format
Date Of Birth - Format: dd-mmm-yyyy
Customer Group
Latitude
Longitude
Gender
Referred By Customer ID
Account Manager - Staff ID
Payment Term in Days
Due Each Month
Due Next Month
Comments
GDPR Compliant
Receive SMS?
Receive Print Media?
Receive Email Marketing?
Receive Email Notifications?
Intra-Community Supplies (ICS)
VAT Exemption
VAT/TAX Rate
Credit Limit
Credit Limit Notes
Watchout
Notes Title
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Model IDRequired
Brand ID
Name
Status
Model Group ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Name
Description
Priority
Start Date
Due Date
End Date
Budget
Rate per hour
Status
Category
Tags
Append Tag
Leader Ids
Member Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task UUIDRequired
List ID
Parent Task ID
Name
Start Date
Due Date
Estimated Time
Detail
Users
Priority
Private
Tag
Append Tag
Progress
Dependencies
Follow Up Reminder
Follow Up Reminder Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stock UUIDRequired
Product UUID
Quantity
COG Per Item
Expires On
Supplier
Supplier Item Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.serial UUIDRequired
Term In Days
Serial
Other Serial Update
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket Timer IDRequired
Start DateRequired
End DateRequired
User IdRequired
Notes
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.Keyword
Created Date From
Created Date To
Customer
Asset Name
Asset Identifier
Asset Tag
Asset Location
Notes
Watchout Notes
Asset Type
RMM Asset ID
RMM Asset Link
RMM Status
Show Only Watchout
includeCustomFields
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeywordRequired
Created Date From
Created Date To
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Name
Mobile
Phone
Company
Email
Invoice Email
Address
City
Customer Group
Gender
Type
Page
Sort
include Custom Fields
Created From
Include Notes
Include Credit Limit Log
ActionThis is an event a Zap performs.SearchFind existing data in your appsearchKeyword
Created Date From
Created Date To
Updated Date From
Updated Date To
Customer
Identification
Status
Include Lines
Include Payments
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appDate From
Date To
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Approved Date From
Approved Date To
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appGroupRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appKeywordRequired
Created Date From
Created Date To
Make
Model
Model Group
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appYear
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Type
Priority
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Order No
Order Amount Min
Order Amount Max
Status
include Payments
include Lines
include Returns
Created From
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Start Date From
Start Date To
End Date From
End Date To
Due Date From
Due Date To
Budget From
Budget To
Customer Name
Customer's Company
Project Name
Priority
Status
Category
Tag
Staff
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appProject UUID
Task UUID
Keyword
Created Date From
Created Date To
page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Tag Name
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Reminder Date From
Reminder Date To
Staff
Ticket
Customer
Lead
Supplier
Project Task
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Adjustment Date From
Adjustment Date To
Internal Use
Breakage
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Company
Contact Name
Mobile
Phone
Email
Address
Town
County
Post Code
Country Code
VAT Registration
Account No
Website
Status
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Payment Date From
Payment Date To
invoice No
Invoice Amount Min
Invoice Amount Max
ticket No
Status
include Payments
include Lines
include Returns
Include Credit Notes
Show Only Credit Notes
Created From
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Ticket UUID
Running
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Name
Mobile
Phone
Email
Address
Website
Gender
Type
Status
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
NameRequired
Page
Sort
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeywordRequired
Created Date From
Created Date To
Page
Sort
NameRequired
Profit Margin
Parent Category 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 foundKeywordRequired
Created Date From
Created Date To
Make
Model
Model Group ID
Page
Sort
Brand IDRequired
NameRequired
StatusRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProject UUIDRequired
Task UUID
Keyword
Created Date From
Created Date To
page
Sort
MessageRequired
Display Type
Users
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProject UUIDRequired
Keyword
Created Date From
Created Date To
Start Date From
Start Date To
Due Date From
Due Date To
NameRequired
Priority
Status
Tag
Users
Private
Page
Sort
List IDRequired
Parent Task UUID
Start Date
Due Date
Estimated Time
Detail
Users
Progress
Dependencies
Follow Up Reminder
Follow Up Reminder Text
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Ticket
Created Date From
Created Date To
Updated Date From
Updated Date To
Customer Name
Company
Issue - Short Info
Issue Type ID
Status ID
Status Condition
Priority
Page
Sort
Has SLA
SLA Name
Include Item Lines
Include Payments
include Custom Fields
Include Assets
Include Created By Info
Include Updated By Info
Priority Condition
Asset UUID
Issue Type Condition
Created From
Customer UUID or Customer NameRequired
Short InfoRequired
Issue Description
Issue Type
Device Brand ID
Device Model ID
Created Date
Due Date
Technician User ID
Work Approved?
Pre Diagnosed
Asset UUID
Preset Id
Create Invoice
Invoice Date
Invoice Due Date
Print Invoice
Print Receipt
Print Label
Product Code
Description
Quantity
Price
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 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 foundInvoice ID
Order ID
Filter
Include Resource
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTicket UUID
Customer UUID
Tracking Number
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Custom Fields
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Stock Count
Triggers when new stock count is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Item Lines
Include Payments
include Custom Fields
Include Assets
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Custom Fields
Include Notes
Include Credit Limit Log
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Ticket Reference
Include Item Lines
Include Payments
include Custom Fields
include Created By Info
include Updated By Info
Status
Status Condition
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Lines Items
Created From
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Item Lines
Include Payments
Include Returns
Include Credit Notes
Created From
Show Only Credit Notes
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTask UUIDRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Appointment Start Date and timeRequired
Appointment DurationRequired
Description
Type
Color
Location
Latitude
Longitude
Ticket ID
Create Ticket
Preset ID
Customer ID
Lead ID
Asset ID
Attendees
No Show Appointment
Internal Appointment
Completed Appointment
Reminder On
Follow-up On
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.NameRequired
Profit Margin
Parent Category ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Inbound NumberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
NameRequired
Model Group ID
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUID or Customer NameRequired
User IDRequired
order Date
Tax
Discount
Discount Level
Customer Group Discount
Delivery Method Id
Notes
Product CodeRequired
Description
QuantityRequired
Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
NameRequired
Description
ConditionRequired
CodeRequired
IMEI
Category
Brand
Model
Additional Models
StatusRequired
One Time Use
inventory Control
Tax Included In Cost
CostRequired
Tax Included In Price
PriceRequired
Enable Offer Price
Offer Start Date
Offer Price
Tax
Alert Quantity
Discountable
Supplier
Reorder Quantity
Supplier Item Code
Email To Supplier
Physical Location
Warranty
Serialised Stock
Maintenance Plan
Plan Duration
Service Schedule
Stock Quantity
Stock COG Per Item
Sell in bundle Only
Sell as a Tag Along Only
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Colour
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project UUIDRequired
List IDRequired
NameRequired
Parent Task UUID
Start Date
Due Date
Estimated Time
Detail
Users
Priority
Private
Tag
Progress
Dependencies
Follow Up Reminder
Follow Up Reminder Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.RMM Asset IDRequired
Alert DateRequired
Alert TextRequired
Alert SeverityRequired
Current Status
Alert Link
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment DateRequired
Reference No
Notes
Product UUIDRequired
QuantityRequired
Type
Internal Use
Breakage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket UUIDRequired
Start DateRequired
End DateRequired
User IDRequired
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Staff UUIDRequired
Shift Start TimeRequired
Shift Start NotesRequired
Shift End Time
Shift End Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Model IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reminder UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Clock IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset UUIDRequired
Customer UUID or Customer Name
Asset Name
Asset Identifier
Asset Tag
Brand ID
Model ID
Asset Type
Asset Location
Latitude
Longitude
Status
Notes
Watchout Notes
RMM Asset ID
RMM Asset Link
RMM Status
RMM Current Status Date
Maintenance Plan
Plan Duration
Service Schedule
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
Name
Profit Margin
Parent Category ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead UUIDRequired
Subject
Referred By
Customer's Name
Customer's Mobile
Country Code
Customer's Email
Company/Business Name
Telephone
Address
Leads Detail
Issue Type
Device Model ID/Name
Technician User ID
GDPR Compliant
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product UUIDRequired
Type
Name
Description
Condition
Code
IMEI
Category
Brand
Model
Additional Models
Status
One Time Use
Inventory Control
Tax Included In Cost
Cost
Tax Included In Price
Price
Enable Offer Price
Offer Start
Offer End
offer Price
Tax
Alert Quantity
Discountable
Supplier
Rreorder Quantity
Supplier Item Code
Email To Supplier
Physical Location
Warranty
Serialised Stock
Maintenance Plan
Plan Duration
Service Schedule
Stock Quantity
Stock COG Per Item
Sell in bundle Only
Sell as a Tag Along Only
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Message UUIDRequired
Message
Display Type
Users
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reminder IDRequired
Date/Time
Staff
Notes
Ticket
Customer
Lead
Supplier
Project Task
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment UUIDRequired
Adjustment Date
Reference No
Notes
Product UUID
Quantity
Type
Internal Use
Breakage
Stock UUID
Quantity
Type
Internal Use
Breakage
Stock UUID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
Customer ID
Short Info
Status
Issue Type
Priority
Device Brand ID
Device Model ID
Due Date
Technician User Id
Asset UUID
Create Invoice
Invoice Date
Invoice Due Date
Print Invoice
Print Receipt
Print Label
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Clock IDRequired
User UUID
Shift Start Time
Shift Start Notes
Shift End Time
Shift End Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Keyword
Created Date From
Created Date To
Start Date From
Start Date To
End Date From
End Date To
Ticket
Customer
Lead
Asset
Attendee
Type
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Name
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeywordRequired
Created Date From
Created Date To
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appsearchKeyword
Created Date From
Created Date To
Name
Billing Name
Billing Mobile
Billing Email
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appDate From
Date To
Based On
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appProject ID
Keyword
Created Date From
Created Date To
Due Date From
Due Date To
Name
Status
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appYear
Based On
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Amount From
Amount To
Include Lines
Created From
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Updated Date From
Updated Date To
Brand
Type
Condition
Category
code
Model
Status
page
sort
Shop Only Products
include Custom Fields
include Xsell Upsell
include Tag Along
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Category Name
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Status
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appProject ID
Keyword
Created Date From
Created Date To
Start Date From
Start Date To
Due Date From
Due Date To
Name
Priority
Status
Tag Name
Users
Private
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Product UUID
Serialize Stock
Internal Use
Breakage
Include Custom Fields
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Product UUID
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Ticket
Created Date From
Created Date To
Updated Date From
Updated Date To
Customer Name
Company
Issue - Short Info
Issue Type ID
Status
Status Condition
Priority
Page
Sort
Has SLA
SLA Name
Include Item Lines
Include Payments
include Custom Fields
Include Assets
Include Created By Info
Include Updated By Info
Priority Condition
Asset UUID
Issue Type Condition
Created From
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Category ID / Name
Brand ID / Name
Model ID / Name
Issue Type ID / Label
Legal document ID
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
User UUID
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Customer
Asset NameRequired
Asset IdentifierRequired
Asset Tag
Asset Location
Notes
Watchout Notes
Asset Type
RMM Asset ID
RMM Asset Link
RMM Status
Show Only Watchout
includeCustomFields
Page
Sort
Customer UUID or Customer NameRequired
Brand ID
Model ID
Asset Type
Latitude
Longitude
StatusRequired
RMM Current Status Date
Maintenance Plan
Plan Duration
Service Schedule
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeywordRequired
Created Date From
Created Date To
Page
Sort
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 foundKeyword
Created Date From
Created Date To
NameRequired
MobileRequired
Phone
Company
Email Address
Invoice Email
Address
City
Customer Group ID
Gender
Type
Page
Sort
include Custom Fields
Created From
Include Notes
Include Credit Limit Log
Shipping Address
Add Address Part
Account Manager
Telephone
Referred By
GDPR Compliant
VAT Registration
Longitude
Latitude
Comments
Country Code ISO Format
Payment Term Days
Due Each Month
Due Next Month
Opt-in for Print Media
Opt-in for Email Marketing
Opt-in for Email Notifications
Opt-in for SMS Messages
Intra-Community Supplies (ICS)
VAT Exemption
VAT/TAX Rate
Credit Limit
Credit Limit Notes
Watchout
Notes Title
Notes
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Created Date From
Created Date To
Start Date From
Start Date To
End Date From
End Date To
Due Date From
Due Date To
Budget From
Budget To
Customer Name
Customer's Company
NameRequired
Priority
StatusRequired
Category
Tags
Staff
Page
Sort
Description
Customer UUID or Customer NameRequired
Start Date
Due Date
End Date
Budget
Rate per hour
Leader Ids
Member Ids
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Created Date From
Created Date To
Tag Name
Page
Sort
NameRequired
Colour
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Created Date From
Created Date To
Reminder Date From
Reminder Date To
StaffRequired
Ticket
Customer
Lead
Supplier
Project Task
Page
Sort
Date/TimeRequired
NotesRequired
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 Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About MyGadgetRepairs
MyGadgetRepairs gives you tracking, inventory management, invoicing, point of sale and much more. Trusted by hundreds of users across the globe.
