Google Sheets + MyGadgetRepairs

Google Sheets + MyGadgetRepairs integrations

Add MyGadgetRepairs customers as new rows on Google Sheet spreadsheets

Add new MGR customers to Google Sheet spreadsheet automatically. Just set up this integration to add the details for each new contact in MyGadgetRepairs to a specified Google Sheets spreadsheet.

When this happens...
New CustomerTriggers when a new customer is created.
TriggerPolling
automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with MyGadgetRepairs and Google Sheets

Discover other triggers and actions you can use with MyGadgetRepairs and Google Sheets

- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It

- Category ID
- Type
Trigger
Polling
Try It
- Ticket UUID
- Tracking Number
Trigger
Polling
Try It

- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- Shop Only Products
- include Custom Fields
- include Xsell Upsell
- Include Tag Along
- Include Ordered Qty
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Ticket UUID
- Type
- include Created By Info
- include Updated By Info
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- Estimate No
- Status
- Status Condition
- Priority
- Priority Condition
- Issue Type
- Issue Type Condition
- Action
- Include Lines
- Include Created By Info
- Include Updated By Info
Trigger
Polling
Try It
- Keyword
- Ticket Reference
- Status
- Status Condition
- Issue
- Issue Type
- Issue Type Condition
- Include Item Lines
- Include Payments
- Include Assets
- include Updated By Info
- include Custom Fields
- include Created By Info
Trigger
Polling
Try It
- Keyword
- Include Lines Items
- Created From
Trigger
Polling
Try It
- Keyword
- Include Item Lines
Trigger
Polling
Try It
- Date From
- Date To
- Based On
Trigger
Polling
Try It
- Year
- Based On
Trigger
Polling
Try It
- Keyword
- Include Item Lines
- Include Payments
- Include Returns
- Include Credit Notes
- Created From
- Show Only Credit Notes
- Show Only Returns
Trigger
Polling
Try It
- Task UUID
  Required
- Tag
  Required
Action
Write
- Subject
  Required
- Appointment Start Date and time
  Required
- Appointment Duration
  Required
- 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
Action
Write
- Name
  Required
Action
Write
- Name
  Required
- Profit Margin
- Parent Category ID
Action
Write
- Inbound Number
  Required
Action
Write
- Brand ID
  Required
- Name
  Required
- Model Group ID
- Status
  Required
Action
Write
- Customer UUID or Customer Name
  Required
- User ID
  Required
- order Date
- Tax
- Discount
- Discount Level
- Customer Group Discount
- Delivery Method Id
- Notes
- Notes For Customer
- Product Code
  Required
- Description
- Quantity
  Required
- Price
Action
Write
- Type
  Required
- Name
  Required
- Description
- Condition
  Required
- Code
  Required
- IMEI
- Category
- Brand
- Model
- Additional Models
- Status
  Required
- One Time Use
- inventory Control
- Tax Included In Cost
- Cost
  Required
- Tax Included In Price
- Price
  Required
- Enable Offer Price
- Offer Start Date
- Offer Price
- Tax
- Discountable
- Alert Quantity
- Reorder Quantity
- Supplier
- Supplier Item Code
- Supplier Item URL
- 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
- Cross Sell Products
- Up Sell Products
- Tag Along Products
Action
Write
- Name
  Required
- Colour
Action
Write
- Project UUID
  Required
- List ID
  Required
- Name
  Required
- Parent Task UUID
- Start Date
- Due Date
- Estimated Time
- Detail
- Users
- Priority
- Private
- Tag
- Progress
- Dependencies
- Follow Up Reminder
- Follow Up Reminder Text
Action
Write
- RMM Asset ID
  Required
- Alert Date
  Required
- Alert Text
  Required
- Alert Severity
  Required
- Current Status
- Alert Link
Action
Write
- Adjustment Date
  Required
- Reference No
- Notes
- Product UUID
  Required
- Quantity
  Required
- Type
- Internal Use
- Breakage
Action
Write
- Ticket UUID
  Required
- Start Date
  Required
- End Date
  Required
- User ID
  Required
- Notes
Action
Write
- Staff UUID
  Required
- Shift Start Time
  Required
- Shift Start Notes
  Required
- Shift End Time
- Shift End Notes
Action
Write
- Brand ID
  Required
Action
Write
- Customer UUID
  Required
Action
Write
- Model ID
  Required
Action
Write
- Product UUID
  Required
Action
Write
- Message UUID
  Required
Action
Write
- Reminder UUID
  Required
Action
Write
- Adjustment UUID
  Required
Action
Write
- Ticket UUID
  Required
Action
Write
- Time Clock ID
  Required
Action
Write
- Asset UUID
  Required
- 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
Action
Write
- Category ID
  Required
- Name
- Profit Margin
- Parent Category ID
Action
Write
- Lead UUID
  Required
- 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
- Status
  Required
Action
Write
- Product UUID
  Required
- 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
- Discountable
- Alert Quantity
- Rreorder Quantity
- Supplier
- Supplier Item Code
- Supplier Item URL
- 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
- Cross Sell Products
- Up Sell Products
- Tag Along Product
Action
Write
- Message UUID
  Required
- Message
- Display Type
- Users
Action
Write
- Reminder ID
  Required
- Date/Time
- Staff
- Notes
- Ticket
- Customer
- Lead
- Supplier
- Project Task
Action
Write
- Adjustment UUID
  Required
- Adjustment Date
- Reference No
- Notes
- Product UUID
- Quantity
- Type
- Internal Use
- Breakage
- Stock UUID
- Quantity
- Type
- Internal Use
- Breakage
- Stock UUID
Action
Write
- Ticket
  Required
- 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 Receipt Template ID
- Print Label
Action
Write
- Time Clock ID
  Required
- User UUID
- Shift Start Time
- Shift Start Notes
- Shift End Time
- Shift End Notes
Action
Write
- 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
- Internal Appointments
- No Show Appointments
- No Show Date From
- No Show Date To
- Completed Appointments
- Completed Date From
- Completed Date To
- Reminder On Date From
- Reminder On Date To
- Follow-up On Date From
- Follow-up On Date To
- Sort
- Page
Action
Search
- Keyword
- Created Date From
- Created Date To
- Name
- Page
- Sort
Action
Search
- Keyword
  Required
- Created Date From
- Created Date To
- Page
- Sort
Action
Search
- searchKeyword
- Created Date From
- Created Date To
- Name
- Billing Name
- Billing Mobile
- Billing Email
- Page
- Sort
Action
Search
- Keyword
- Page
- Sort
Action
Search
- Date From
- Date To
- Based On
Action
Search
- Keyword
- Created Date From
- Created Date To
- Approved Date From
- Approved Date To
- Page
- Sort
Action
Search
- Group
  Required
Action
Search
- Keyword
  Required
- Created Date From
- Created Date To
- Make
- Model
- Model Group
- Page
- Sort
Action
Search
- Year
- Based On
Action
Search
- Keyword
- Created Date From
- Created Date To
- Type
- Priority
- Page
- Sort
Action
Search
- Keyword
- 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
Action
Search
- Keyword
- 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
Action
Search
- Project UUID
- Task UUID
- Keyword
- Created Date From
- Created Date To
- page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Tag Name
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Reminder Date From
- Reminder Date To
- Staff
- Ticket
- Customer
- Lead
- Supplier
- Project Task
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Adjustment Date From
- Adjustment Date To
- Internal Use
- Breakage
- Page
- Sort
Action
Search
- Keyword
- 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
Action
Search
- Keyword
- 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
- Show Only Returns
- Created From
- Page
- Sort
Action
Search
- Keyword
- Ticket UUID
- Ticket Timer ID
- Running
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Name
- Mobile
- Phone
- Email
- Address
- Website
- Gender
- Type
- Status
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Name
  Required
- Page
- Sort
Action
Search or write
- Keyword
  Required
- Created Date From
- Created Date To
- Page
- Sort
- Name
  Required
- Profit Margin
- Parent Category ID
Action
Search or write
- Keyword
  Required
- Created Date From
- Created Date To
- Make
- Model
- Model Group ID
- Page
- Sort
- Brand ID
  Required
- Name
  Required
- Status
  Required
Action
Search or write
- Project UUID
  Required
- Task UUID
- Keyword
- Created Date From
- Created Date To
- page
- Sort
- Message
  Required
- Display Type
- Users
Action
Search or write
- Project UUID
  Required
- Keyword
- Created Date From
- Created Date To
- Start Date From
- Start Date To
- Due Date From
- Due Date To
- Name
  Required
- Priority
- Status
- Tag
- Users
- Private
- Page
- Sort
- List ID
  Required
- Parent Task UUID
- Start Date
- Due Date
- Estimated Time
- Detail
- Users
- Progress
- Dependencies
- Follow Up Reminder
- Follow Up Reminder Text
Action
Search or write
- Keyword
- Ticket
- Created Date From
- Created Date To
- Updated Date From
- Updated Date To
- Customer Name
- Company
- Customer Group
- Issue - Short Info
- Issue Type ID
- Status ID
- Status Condition
- Invoice Status
- 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 Name
  Required
- Short Info
  Required
- 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 Receipt Template ID
- Print Label
- Product Code
- Description
- Quantity
- Price
Action
Search or write
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- include Custom Fields
- Include Notes
- Include Credit Limit Log
- Include Additional Numbers
Trigger
Polling
Try It
- Keyword
- Include Lines
- Include Payments
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- Issue Type
- Issue Type Condition
- Status
- Status Condition
- Priority
- Priority Condition
- Include Lines
- Include Created By Info
- Include Updated By Info
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Invoice ID
- Order ID
- Filter
- Include Resource
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Ticket UUID
- Customer UUID
- Tracking Number
Trigger
Polling
Try It
- Keyword
- Include Custom Fields
Trigger
Polling
Try It
New Stock Count
Triggers when new stock count is created.
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- Include Item Lines
- Include Payments
- include Custom Fields
- Include Assets
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- Include Custom Fields
- Include Notes
- Include Credit Limit Log
Trigger
Polling
Try It
- Keyword
- include Custom Fields
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Keyword
- Include Item Lines
- Include Payments
- Include Returns
- Created From
Trigger
Polling
Try It
- Date From
- Date To
- Based On
Trigger
Polling
Try It
- Year
- Based On
Trigger
Polling
Try It
- Keyword
Trigger
Polling
Try It
- Project ID
  Required
- Tag
  Required
Action
Write
- Ticket
  Required
- Video Title
  Required
- Video Source
  Required
- Video File Code
  Required
- Display Type
Action
Write
- Customer UUID or Customer Name
  Required
- Asset Name
  Required
- Asset Identifier
  Required
- Asset Tag
- Brand ID
- Model ID
- Asset Type
- Asset Location
- Latitude
- Longitude
- Status
  Required
- Notes
- Watchout Notes
- RMM Asset ID
- RMM Asset Link
- RMM Status
- RMM Current Status Date
- Maintenance Plan
- Plan Duration
- Service Schedule
Action
Write
- Name
  Required
Action
Write
- Name
  Required
- Mobile
  Required
- Email Address
- Address
- Shipping Address
- Add Address Part
- Account Manager
- Telephone
- Telephone EXT
- 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
- Parent Customer ID
Action
Write
- Subject
  Required
- Referred By
- Customer's Name
  Required
- Customer's Mobile
  Required
- Country Code
- Customer's Email
- Company/Business Name
- Telephone
- Address
- Leads Detail
- Issue Type
- Device Mode lD/Name
- Technician User ID
- GDPR Compliant
- Status
  Required
Action
Write
- Invoice ID
  Required
- Payment Date
- Invoice Note
- Amount
  Required
- Payment Method
  Required
- Payment Note
- Is Advance
Action
Write
- Customer UUID or Customer Name
  Required
- User ID
  Required
- order Date
- Tax
- Discount
- Discount Level
- Customer Group Discount
- Delivery Method Id
- Notes
- Print Receipt
- Product Code
  Required
- Description
- Quantity
  Required
- Price
- Amount
  Required
- Payment Method
  Required
- Payment Note
- Is Advance
Action
Write
- Name
  Required
- Description
- Customer UUID or Customer Name
  Required
- Priority
- Start Date
- Due Date
- End Date
- Budget
- Rate per hour
- Status
  Required
- Category
- Tags
- Leader Ids
- Member Ids
Action
Write
- Project UUID
  Required
- Task UUID
- Message
  Required
- Display Type
- Users
Action
Write
- Date/Time
  Required
- Staff
  Required
- Notes
  Required
- Ticket
- Customer
- Lead
- Supplier
- Project Task
Action
Write
- Product
  Required
- Quantity
- COG Per Item
- Expires On
- Supplier
- Supplier Item Code
Action
Write
- Ticket
  Required
- Status
  Required
- Type
  Required
- Comment
  Required
- important Note
Action
Write
- Customer UUID or Customer Name
  Required
- Short Info
  Required
- 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 Receipt Template ID
- Print Label
- Product Code
- Description
- Quantity
- Price
Action
Write
- Asset UUID
  Required
Action
Write
- Category ID
  Required
Action
Write
- Lead UUID
  Required
Action
Write
- POS On Hold UUID
Action
Write
- Project ID
  Required
Action
Write
- Task UUID
  Required
Action
Write
- Stock UUID
  Required
Action
Write
- serial UUID
  Required
Action
Write
- Timer ID
  Required
Action
Write
- Appointment UUID
  Required
- 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
Action
Write
- Brand ID
  Required
- Name
  Required
Action
Write
- Customer UUID
  Required
- Name
- company
- VAT Registration
- Email
- Invoice Email
- Telephone
- Telephone Ext
- 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
- Banned
- Banned Notes
- Unbanned
- Unbanned Notes
Action
Write
- Model ID
  Required
- Brand ID
- Name
- Status
- Model Group ID
Action
Write
- Project ID
  Required
- Name
- Description
- Priority
- Start Date
- Due Date
- End Date
- Budget
- Rate per hour
- Status
- Category
- Tags
- Append Tag
- Leader Ids
- Member Ids
Action
Write
- Task UUID
  Required
- 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
Action
Write
- Stock UUID
  Required
- Product UUID
- Quantity
- COG Per Item
- Expires On
- Supplier
- Supplier Item Code
Action
Write
- serial UUID
  Required
- Term In Days
- Serial
- Other Serial Update
Action
Write
- Ticket Timer ID
  Required
- Start Date
  Required
- End Date
  Required
- User Id
  Required
- Notes
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- 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
Action
Search
- Keyword
  Required
- Created Date From
- Created Date To
- Page
- Sort
Action
Search
- Keyword
- 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
- Include Additional Numbers
Action
Search
- searchKeyword
- Created Date From
- Created Date To
- Updated Date From
- Updated Date To
- Customer
- Identification
- Status
- Include Lines
- Include Payments
- Page
- Sort
Action
Search
- Date From
- Date To
- Based On
Action
Search
- Keyword
- Estimate No
- Created Date From
- Created Date To
- Updated Date From
- Updated Date To
- Customer
- Company
- Short Info
- Issue Type
- Issue Type Condition
- Status
- Status Condition
- Priority
- Priority Condition
- Include Lines
- Include Created By Info
- include Updated By Info
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Page
- Sort
Action
Search
- Project ID
- Keyword
- Created Date From
- Created Date To
- Due Date From
- Due Date To
- Name
- Status
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Page
- Sort
Action
Search
- Year
- Based On
Action
Search
- Keyword
- Created Date From
- Created Date To
- Amount From
- Amount To
- Include Lines
- Created From
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Updated Date From
- Updated Date To
- Brand
- Type
- Condition
- Category
- code
- Model
- Status
- Stock
- Stock Condition
- Ordered
- Ordered Condition
- Retail Price
- Retail Price Condition
- page
- sort
- Shop Only Products
- include Custom Fields
- include Xsell Upsell
- include Tag Along
- Include Ordered Qty
Action
Search
- Keyword
- Created Date From
- Created Date To
- Category Name
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Status
- Page
- Sort
Action
Search
- Project 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
Action
Search
- Keyword
- Created Date From
- Created Date To
- Product UUID
- Serialize Stock
- Internal Use
- Breakage
- Include Custom Fields
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Product UUID
- Page
- Sort
Action
Search
- Keyword
- Ticket
- Created Date From
- Created Date To
- Updated Date From
- Updated Date To
- Customer Name
- Company
- Customer Group
- Issue - Short Info
- Issue Type ID
- Status
- Status Condition
- Invoice Status
- 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
Action
Search
- Keyword
- Created Date From
- Created Date To
- Category ID / Name
- Brand ID / Name
- Model ID / Name
- Issue Type ID / Label
- Legal document ID
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- User UUID
- Page
- Sort
Action
Search
- Keyword
- Created Date From
- Created Date To
- Customer
- Asset Name
  Required
- Asset Identifier
  Required
- 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 Name
  Required
- Brand ID
- Model ID
- Asset Type
- Latitude
- Longitude
- Status
  Required
- RMM Current Status Date
- Maintenance Plan
- Plan Duration
- Service Schedule
Action
Search or write
- Keyword
  Required
- Created Date From
- Created Date To
- Page
- Sort
- Name
  Required
Action
Search or write
- Keyword
- Created Date From
- Created Date To
- Name
  Required
- Mobile
  Required
- 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
- Include Additional Numbers
- Shipping Address
- Add Address Part
- Account Manager
- Telephone
- Telephone EXT
- 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
- Parent Customer ID
Action
Search or write
- Keyword
- 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
- Name
  Required
- Priority
- Status
  Required
- Category
- Tags
- Staff
- Page
- Sort
- Description
- Customer UUID or Customer Name
  Required
- Start Date
- Due Date
- End Date
- Budget
- Rate per hour
- Leader Ids
- Member Ids
Action
Search or write
- Keyword
- Created Date From
- Created Date To
- Tag Name
- Page
- Sort
- Name
  Required
- Colour
Action
Search or write
- Keyword
- Created Date From
- Created Date To
- Reminder Date From
- Reminder Date To
- Staff
  Required
- Ticket
- Customer
- Lead
- Supplier
- Project Task
- Page
- Sort
- Date/Time
  Required
- Notes
  Required
Action
Search or write
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write
- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About MyGadgetRepairs

MyGadgetRepairs gives you tracking, inventory management, invoicing, point of sale and much more. Trusted by hundreds of users across the globe.

HelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Related Zap Templates

Create new MyGadgetRepairs customers from new or updated rows in Google Sheets

Create new MyGadgetRepairs leads from new Google Sheets rows