Google Sheets + Joblogic
Google Sheets + Joblogic
Google Sheets + Joblogic integrations
Create Joblogic sites from new Google Sheets rows
Switch this Zapier template on to add site information from a Google Sheets spreadsheet into Joblogic. It's a quick and easy way to add sites to your Joblogic account.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.TriggerInstant - automatically do this!
Create SiteCreates a SiteActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Google Sheets and Joblogic
Discover other triggers and actions you can use with Google Sheets and Joblogic
- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_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.- Api_docs_info
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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- Customer IdRequired
- Site IdRequired
- Job IdRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Customer Auto Id
- Site Auto Id
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Date RaisedRequired
- Raised By IdsRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
List Site (Beta)Triggers when there's a new site.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Quote Unique IdRequired
- Approved By User Id
- Order Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
- Site Contact Level Ids
- Customer Contact Level Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Line Unique IDRequired
- Complete DateRequired
- Set Job Complete?
- Add Job Line
- Completed By User ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
- First Warning Message
- First Warning Show
- Second Warning Message
- Second Warning Show
- Third Warning Message
- Third Warning Show
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Site Unique IdRequired
- Equipment Class
- DescriptionRequired
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Asset Warranty Expiry Date
- Estimated Replacement Date
- QuantityRequired
- Reference Number
- Is Suspended
- Equipment Library
- QR Code
- Contain Refrigerant
- Total Charge
- Gas Type
- Budget Replacement Cost
- Asset Condition Unique Id
- System Id
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ConditionRequired
- Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- Raised By User IdRequired
- Credit Reason
- Line DescriptionRequired
- Line PricePerUnitRequired
- Line QuantityRequired
- Line Tax Code Unique IdRequired
- Line Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- DescriptionRequired
- Price Per Unit
- Quantity
- Tax Code IdRequired
- Nominal Code Unique Id
- Discount Amount
- Discount Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Customer Unique IdRequired
- Site Unique IdRequired
- DescriptionRequired
- StatusRequired
- Job TypeRequired
- Job Category
- Priority Level
- Order Number
- Reference Number
- Date LoggedRequired
- Preferred Appointment Date
- Target Completion Date
- Date Complete
- Tags
- Contact First Name
- Contact Last Name
- Contact Telephone
- Contact Email
- Contact Position
- Trade
- Owner User Id
- Next Contact Date
- Is Require Approval
- Quoted Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CodeRequired
- Description
- Nominal Code Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- NumberRequired
- DescriptionRequired
- QuantityRequired
- Unit Of Measure
- Price Per UnitRequired
- Sell Per Unit
- Make
- Model
- Part Reference
- Part Library IdRequired
- Part Category Unique Id
- Tax Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Supplier Unique IdRequired
- Job Unique IdRequired
- Account NumberRequired
- Estimated Delivery Date
- Delivery Address TypeRequired
- Delivery Name
- Delivery Address 1
- Delivery Address 2
- Delivery Address 3
- Delivery Address 4
- Delivery Postcode
- Delivery Telephone
- Reference Number
- Tags
- Line DescriptionRequired
- Line QuantityRequired
- Line Price Per UnitRequired
- Line TaxRateRequired
- Line Part Unique Id
- Line Number
- Line DiscountRequired
- Line Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer IdRequired
- Site IdRequired
- Contact
- Telephone
- Email Address
- Parent Job Id
- Job TypeRequired
- Job Category
- Assigned To User IdRequired
- Title
- DescriptionRequired
- Reference
- Priority Level
- Source Unique Id
- Trade Unique Id
- Chance Of Sale
- Expiry Date
- Sale Date
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
- Sub Contractor Unique IdRequired
- Account NumberRequired
- Estimated Completion Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
- Price Per UnitRequired
- DescriptionRequired
- Tax Code Unique IdRequired
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- NameRequired
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Account Number
- Reference Number
- Part Library ID
- Contact First Name
- Contact Last Name
- Contact Primary Telephone
- Contact Secondary Telephone
- Contact Email
- Contact Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CodeRequired
- Value
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Area unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Class Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Nominal Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Category Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Item Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Report Auto IdRequired
- Mark As Passed To Accounts
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Class Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Credit Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Engineer Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Payment Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Category Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique Id of PriorityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Item Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique Id of TaskRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Uniqiue IdRequired
- ReasonRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Keyword
- Include Inactive
- Include Contact Level
- Page Number
- OrderBy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Keyword
- Include Inactive
- Page Number
- OrderBy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- KeywordRequired
- Include Inactive
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Job Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Priority
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Reports
- Only Include Favourite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Site Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Subcontractor Purchase Order
- PO Status
- Completion Status
- Date Raised StartRequired
- Date Raised End
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Tax Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- Date RaisedRequired
- Date DueRequired
- Order Number
- Account Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
- DescriptionRequired
- Background Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique idRequired
- Account NumberRequired
- Estimated Delivery Date
- Reference Number
- Additional Instructions
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor Purchase Order Unique IdRequired
- Subcontractor Unique IdRequired
- Account NumberRequired
- Estimated Completion Date
- Additional Instructions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IDRequired
- Supplier Unique IdRequired
- Supplier NameRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Account Number
- Reference Number
- Part Library Id
- Contact First Name
- Contact Last Name
- Contact Primary Telephone
- Contact Secondary Telephone
- Contact Email
- Contact Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
- Equipment Class
- DescriptionRequired
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Asset Warranty Expiry Date
- QuantityRequired
- Reference Number
- Is Suspended
- Tags
- Equipment Library
- QR Code
- Estimated Replacement Date
- Contain Refrigerant
- Total Charge
- Gas Type
- Budget Replacement Cost
- Asset Condition Unique Id
- System Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
- Condition
- Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Engineer Auto IdRequired
- Gas Registration Number
- Electrical Registration Number
- Oil Registration Number
- Fgas Registration Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
- First Name
- Last Name
- Telephone
- Email
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
- Customer Name
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Customer Type
- Reference Number
- Tags
- Account Number
- VAT Number
- Account Manager
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Invoice Payment Due
- Invoice Payment Term
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- Date Raised
- Date Due
- Order Number
- Account Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Payment Unique IdRequired
- Payment Date
- Payment Amount
- Payment Type
- Nominal Code UniqueId
- Payment Notes
- Payment Type Other Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
- Description
- Background Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- Code
- Description
- Nominal Code Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Category Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique idRequired
- Account Number
- Estimated Delivery Date
- Reference Number
- Additional Instructions
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote IdRequired
- Date LoggedRequired
- Job TypeRequired
- Job Category
- Assigned To User IdRequired
- Title
- DescriptionRequired
- Reference
- Priority Level
- Source Unique Id
- Trade Unique Id
- Chance Of Sale
- Expiry Date
- Sale Date
- Tags
- Next Contact Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
- Site NameRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Region
- Reference Number
- Tags
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Account Number
- Account Manager
- Order Number
- Site Type Unique Id
- Preferred Engineer Id
- Selling Rate Id
- Parent Site Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor Purchase Order Unique IdRequired
- Subcontractor Unique Id
- Account Number
- Estimated Completion Date
- Additional Instructions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line Unique IdRequired
- Price Per Unit
- Description
- Tax Code Unique Id
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External Id
- Supplier Unique IdRequired
- Supplier Name
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Account Number
- Reference Number
- Part Library ID
- Contact First Name
- Contact Last Name
- Contact Primary Telephone
- Contact Secondary Telephone
- Contact Email
- Contact Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- Code
- Value
- Description
- IsDefault
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Dont_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 plan- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found- List Contacts (Beta)
Triggers when there's a new contact.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - List Invoice (Beta)
Triggers when a new invoice ticket is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - List Part (Beta)
Triggers when a new part is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - Customer Auto Id
- Site Auto Id
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- List Supplier (Beta)
Triggers when a new supplier is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - List Customers (Beta)
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - Quote Unique IdRequired
- Site Contact Level Ids
- Customer Contact Level Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Uniqiue IdRequired
- Reason
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Delivery DateRequired
- Set Job as Part To Fit
- Pass Dicount
- Delivered By UserId
- Quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Entity Unique IdRequired
- Entity TypeRequired
- Is Primary
- First NameRequired
- Last Name
- Telephone
- Email
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Customer NameRequired
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Telephone
- Customer Type
- Reference Number
- Contact First Name
- Contact Last Name
- Contact Telephone
- Contact Email
- Contact Position
- Tags
- Account Number
- VAT Number
- Account Manager
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Invoice Payment Due
- Invoice Payment Term
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job IdRequired
- Tag
- Raised By User Id
- DescriptionRequired
- Price Per Unit
- Quantity
- Tax Code IdRequired
- Nominal Code Id
- Discount Amount
- Discount Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
- Payment DateRequired
- Payment AmountRequired
- Payment TypeRequired
- Nominal Code UniqueId
- Payment Notes
- Payment Type Other Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
- Background ColorRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- EntityIdRequired
- Entity TypeRequired
- Note TextRequired
- Date Added
- IsPrivate
- Attachment Link
- Attachments Name
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order IdRequired
- DescriptionRequired
- QuantityRequired
- Price Per UnitRequired
- Tax Rate
- Part Unique Id
- Number
- Discount
- Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Customer Unique IdRequired
- Site NameRequired
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Telephone
- Region
- Reference Number
- Contact First Name
- Contact Last Name
- Contact Telephone
- Contact Email
- Contact Position
- Tags
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Account Number
- Account Manager
- Order Number
- Site Type Unique Id
- Preferred Engineer Id
- Selling Rate Id
- Parent Site Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Email AddressRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Account Number
- Tax Code Unique Id
- IsSendPO
- Subcontractor Template Unique Id
- Trade Unique Ids
- Area Unique Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
- Attachment
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Reference Number
- Invoice Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
- Price Per UnitRequired
- Line Item DescriptionRequired
- Tax Code Unique IdRequired
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order IdRequired
- Base64 File
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Tax Rate
- Amount
- Discount
- Type
- Nominal Code
- Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Site Unique Id
- Equipment Class
- Description
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Asset Warranty Expiry Date
- Estimated Replacement Date
- Quantity
- Reference Number
- Is Suspended
- Equipment Library
- QR Code
- Contain Refrigerant
- Total Charge
- Gas Type
- Budget Replacement Cost
- Asset Condition
- System Id
- Tags
- Action TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact level unique IdRequired
- Entity IdRequired
- Entity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line IdRequired
- Invoice idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor PO Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Supplier Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Tax Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Area Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Entity Unique IdRequired
- Entity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Credit Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Export IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Nominal Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Staff Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Supplier Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Tax Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Visit Auto IdRequired
- Include Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Unique IdRequired
- Reverted By User Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Credit
- Start Date
- End Date
- Customer Auto Id
- Site Auto Id
- Job Auto Id
- PPM Contract Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Customer Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Keyword
- Tag Unique Ids
- Start Date
- End Date
- Customer Auto Id
- Site Auto Id
- Job Auto Id
- PPM Contract Id
- Exclude Invoice Id
- Payment Statuses
- Get Summary
- Include Standard Invoices
- Include PPM Invoices
- Include Customer Grouped Invoices
- Include SOR Invoices
- Include Related Job Invoices
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Purchase Orders
- PO Type
- Date Raised Start DateRequired
- Date Raised End Date
- PO Status
- Delivery Status
- Invoice Status
- Tag Unique Id
- Owner Unique Id
- Raised By Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- KeywordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Subcontractor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search TaskRequired
- Include Inactive
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
- ConditionRequired
- Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Payment Unique IdRequired
- Payment DateRequired
- Payment AmountRequired
- Payment TypeRequired
- Nominal Code UniqueId
- Payment Notes
- Payment Type Other Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- DescriptionRequired
- QuantityRequired
- Price Per UnitRequired
- Tax Rate
- Part Unique Id
- Number
- Discount
- Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- NameRequired
- EmailAddressRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Account Number
- IsActive
- TaxCodeId
- IsSendPO
- Subcontractor TemplateId
- TradeI ds
- Area Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Line Item DescriptionRequired
- Tax Code Unique IdRequired
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Area Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Class Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
- Equipment Class
- Description
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Quantity
- Reference Number
- Is Suspended
- Tags
- Equipment Library
- QR Code
- Estimated Replacement Date
- Budget Replacement Cost
- Asset Condition Unique Id
- System Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
- First NameRequired
- Last Name
- Telephone
- Email
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
- Customer NameRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Customer Type
- Reference Number
- Tags
- Account Number
- VAT Number
- Account Manager
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Invoice Payment Due
- Invoice Payment Term
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line Auto IdRequired
- Invoice Auto IdRequired
- DescriptionRequired
- Price Per Unit
- Quantity
- Tax Code IdRequired
- Nominal Code Id
- Discount Amount
- Discount Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
- DescriptionRequired
- StatusRequired
- Job TypeRequired
- Job Category
- Priority Level
- Order Number
- Reference Number
- Date LoggedRequired
- Preferred Appointment Date
- Target Completion Date
- Date Complete
- Next Contact Date
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique idRequired
- Description
- Status
- Job Type
- Job Category
- Priority Level
- Order Number
- Reference Number
- Date Logged
- Preferred Appointment Date
- Target Completion Date
- Date Complete
- Tags
- Next Contact Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique IdRequired
- NumberRequired
- DescriptionRequired
- QuantityRequired
- Unit Of Measure
- Price Per UnitRequired
- Sell Per Unit
- Make
- Model
- Part Reference
- Part Library Id
- Part Category Unique Id
- Tax Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique IdRequired
- Part Number
- Part Description
- Quantity
- Unit Of Measure
- Price Per Unit
- Sell Per Unit
- Make
- Model
- Part Reference
- Part Library Auto Id
- Part Category Unique Id
- Tax Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Description
- Quantity
- Price Per Unit
- Tax Rate
- Part Unique Id
- Number
- Discount
- Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote idRequired
- Date Logged
- Job TypeRequired
- Assigned To User IdRequired
- Job CategoryRequired
- Title
- Description
- Custom Reference
- Source IdRequired
- Priority LevelRequired
- Trade IdRequired
- Expiry Date
- Sale DateRequired
- Next Contact Date
- Chance Of SaleRequired
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
- Site Name
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Region
- Reference Number
- Tags
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Account Number
- Account Manager
- Order Number
- Site Type Unique Id
- Preferred Engineer Id
- Selling Rate Id
- Parent Site Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- Name
- Email Address
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Account Number
- Is Active
- Tax Code Unique Id
- IsSendPO
- Subcontractor Template Unique Id
- Trade Unique Ids
- Area Unique Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
- Attachment
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Line Item Description
- Tax Code Unique Id
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice IdRequired
- Base64 File
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Tax Rate
- Amount
- Discount
- Nominal Code
- Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
Related categories
Related Zap Templates
- Create Joblogic customers from new Google Sheets rows
- Add new Joblogic sites to Google Sheets row(s)
- Create Joblogic assets from new rows in Google Sheets
- Create Google Sheets row(s) for new Joblogic assets
- Create Joblogic parts from new Google Sheets rows
- Store new Joblogic parts in Google Sheets row(s)
- Add new Joblogic suppliers to Google Sheets row(s)
- Create suppliers in Joblogic from new Google Sheets rows
- Store new Joblogic jobs in Google Sheets row(s)
- Add new Joblogic contacts to Google Sheets row(s)
- Create Joblogic jobs from new Google Sheets rows
- Create Joblogic invoices from new Google Sheets rows
- Add new Joblogic customers to Google Sheets row(s)