Google Sheets + Kiwili

Google Sheets + Kiwili integrations

Create Google Sheets rows for newly created project steps in Kiwili

Keep track of your Kiwili project steps in an organized manner with this workflow. Every time a new project step is created in Kiwili, a row is instantly added to your Google Sheets spreadsheet. This way, you can conveniently maintain a detailed progress report of your projects without having to manually enter data into your spreadsheet. Streamline your project management process with this time-saving automation.

When this happens...
Project Step CreatedTriggers when a project step is created.
TriggerInstant
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 Kiwili and Google Sheets

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

Accounting Code Created
Triggers when a new Accounting Code is created.
Trigger
Instant
Try It
Contact Created
Triggers when a new Contact is created.
Trigger
Instant
Try It
Expense Account Created
Triggers when an Expense Account is created.
Trigger
Instant
Try It
Invoice Payment Created
Triggers when an Invoice Payment is created.
Trigger
Instant
Try It
Product Created
Triggers when an Product is created.
Trigger
Instant
Try It

Project Step Created
Triggers when a project step is created.
Trigger
Instant
Try It
Sprint Created
Triggers when a Sprint is created.
Trigger
Instant
Try It

Tax Profile Created
Triggers when an Tax Profile is created.
Trigger
Instant
Try It
Accounting Code Deleted
Triggers when an Accounting Code is deleted.
Trigger
Instant
Try It
Contact Deleted
Triggers when a Contact is deleted.
Trigger
Instant
Try It
Expense Account Deleted
Triggers when an Expense Account is deleted.
Trigger
Instant
Try It
Payment Type Deleted
Triggers when a Payment Type is deleted.
Trigger
Instant
Try It
Project Deleted
Triggers when a Project is deleted.
Trigger
Instant
Try It
Service Deleted
Triggers when a Service is deleted.
Trigger
Instant
Try It
Time Entry Deleted
Triggers when a Time Entry is deleted.
Trigger
Instant
Try It
Bank Account Updated
Triggers when a Bank Account is updated.
Trigger
Instant
Try It
Enterprise Updated
Triggers when an Enterprise is updated.
Trigger
Instant
Try It
Invoice Updated
Triggers when an Invoice is updated.
Trigger
Instant
Try It
Payment Type Updated
Triggers when a Payment Type is updated.
Trigger
Instant
Try It
Project Updated
Triggers when a Project is updated.
Trigger
Instant
Try It
Service Updated
Triggers when a Service is updated.
Trigger
Instant
Try It
Task Updated
Triggers when a Task is updated.
Trigger
Instant
Try It
Time Entry Updated
Triggers when a Time Entry is updated.
Trigger
Instant
Try It
- Bank Account bank number
- Bank Account branch number
- Bank Account account number
- Bank Account name
- Bank Account description
- Bank Account currency
- Bank Account credit limit
- Bank Account accounting code
- Bank Account EFT originator number
- Bank Account EFT data processing center number
Action
Write
- Enterprise Name
  Required
- Enterprise Email
- Enterprise Phone
- Enterprise Phone2
- Enterprise Fax
- Enterprise Address
- Enterprise City
- Enterprise Province/State
- Enterprise Country
- Enterprise Postal Code
- Enterprise Note
- Enterprise Active
- Enterprise is Natural Person
- Enterprise Language
- Enterprise Payments Term
- Enterprise is a Client
- Enterprise is a Provider
- Enterprise is a Prospect
- Enterprise Administrator Id
- Enterprise WebSite
- Enterprise Origin
- Enterprise Code
- Enterprise Bank Number
- Enterprise Branch Number
- Enterprise Account Number
- Enterprise Discount
- Enterprise Account Receivable
- Enterprise Account Payable
- Enterprise Tax Profile Id
- Enterprise Tax1 Number
- Enterprise Tax2 Number
- Enterprise number of employees
- Enterprise Activity Code List
Action
Write
- Invoice Number
- Invoice EnterpriseId
  Required
- Invoice Description
- Invoice InvoiceDate
  Required
- Invoice DueDate
  Required
- Invoice Status
- Invoice TermsAndConditions
- Invoice Recipient
- Invoice Archived
- Invoice Tax Profile Id
  Required
- Invoice QtyHeader
- Invoice PayPalInfo
- Invoice PayPalDate
- Invoice AllowPayPal
- Invoice AllowStripe
- Invoice ClientReferenceNumber
- Invoice SignatureDate
- Invoice ContactId
- Invoice CurrencyCode
- Invoice ExchangeRate
- Invoice CancellationDate
- Invoice Template
  Required
- Invoice ReplyTo
- Invoice SellerUserId
- Invoice AddressId
- Line Description
- Line ItemId
  Required
- Line ItemType
  Required
- Line UnitCost
  Required
- Line Quantity
  Required
- Line Taxes Profile Id
- Line Discount
Action
Write
- Payment Type name
Action
Write
- Project Name
  Required
- Project Enterprise Id
  Required
- Project Contact Id
- Project Description
- Project Rate
- Project Billing Type
- Project Budget Hours
- Project Code
- Project Number
- Project Purchase Order Number
- Project Active
- Project Archive
- User member Id
  Required
- User member is administrator
- User member Rate
- Service Id
  Required
Action
Write
- Service Name
  Required
- Service Description
- Service Rate
  Required
- Service Taxes Profile Id
- Service Code
- Service Number
- Service Active
  Required
- Service Billable
  Required
Action
Write
- Task Summary
  Required
- Task Description
- Task Assignee User Id
- Task Administrator User Id
- Task Enterprise Id
- Task Project Id
- Task Project Step Id
- Task Service Id
- Task Status
- Task Priority
- Task Start Date
- Task Due Date
- Task Reminder Date
- Task Remaining Work
- Task Budgeted Work
- Task Archive
- Task Sprint Id
Action
Write
- Time Entry Date
  Required
- Time Entry Description
- Time Entry Hours
- Time Entry User Id
  Required
- Time Entry Project Id
  Required
- Time Entry Project Step Id
  Required
- Time Entry Service Id
  Required
- Time Entry Billed
- Time Entry Start Time
- Time Entry End Time
- Time Entry location Longitude
- Time Entry location Latitude
- Time Entry Invoice Line Id
- Time Entry Task Id
- Time Entry Is OverTime
Action
Write
- Bank Account Id
  Required
Action
Write
- Enterprise Id
  Required
Action
Write
- Invoice Id
  Required
Action
Write
- Product Id
  Required
Action
Write
- Project step Id
  Required
Action
Write
- TaxProfile Id
  Required
Action
Write
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Accounting Code
- Accounting Code description
- Accounting Code percentage tax reclaim.
- Accounting Code class
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Contact First Name
- Contact Last Name
- Contact Phone
- Contact Mobile Phone
- Contact Email
- Contact Login
- Contact Login Active
- Contact Enterprise Id
- Contact Title
- Main Contact of Enterprise
- Contact Profession Id
- Contact Gender
- Contact Language
- Contact Address
- Contact City
- Contact Postal Code
- Contact Province/State
- Contact Country
- Contact Notes
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Enterprise Name
- Enterprise Email
- Enterprise Phone
- Enterprise Phone2
- Enterprise Fax
- Enterprise Address
- Enterprise City
- Enterprise Province/State
- Enterprise Country
- Enterprise Postal Code
- Enterprise Note
- Enterprise Active
- Enterprise is Natural Person
- Enterprise Language
- Enterprise Payments Term
- Enterprise is a Client
- Enterprise is a Provider
- Enterprise is a Prospect
- Enterprise Administrator Id
- Enterprise WebSite
- Enterprise Origin
- Enterprise Code
- Enterprise Bank Number
- Enterprise Branch Number
- Enterprise Account Number
- Enterprise Discount
- Enterprise Account Receivable
- Enterprise Account Payable
- Enterprise Tax Profile Id
- Enterprise Tax1 Number
- Enterprise Tax2 Number
- Enterprise number of employees
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- ExpenseAccount Name
- ExpenseAccount Description
- ExpenseAccount Code
- ExpenseAccount Active
- ExpenseAccount Price
- Expense Account Taxes Profile Id
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- InvoicePayment Number
- InvoicePayment InvoiceId
- InvoicePayment UserId
- InvoicePayment Amount
- InvoicePayment PaymentDate
- InvoicePayment Description
- InvoicePayment TypeId
- InvoicePayment BankAccountId
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Product Name
- Product Description
- Product Price
- Product Taxes Profile Id
- Product Code
- Product Number
- Product Active
- Product SKU
- Product UPC
- Product IsInventoryEnabled
- Product ResaleActive
- Product ResaleCode
- Product ResaleMargin
- Product ResalePercentMargin
- Product ResalePriceType
- Product MinStock
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Project Name
- Project Enterprise Id
- Project Contact Id
- Project Description
- Project Rate
- Project Billing Type
- Project Budget Hours
- Project Code
- Project Number
- Project Purchase Order Number
- Project Active
- Project Archive
- Project Creation Date
- Project Creation User Id
- Project Last Modification Date
- Project Last Modification User Id
- Project Administrator Id
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Service Name
- Service Description
- Service Rate
- Service Taxes Profile Id
- Service Code
- Service Number
- Service Active
- Service Billable
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Task Summary
- Task Description
- Task Assignee User Id
- Task Administrator User Id
- Task Enterprise Id
- Task Project Id
- Task Project Step Id
- Task Service Id
- Task Status
- Task Priority
- Task Start Date
- Task Due Date
- Task Reminder Date
- Task Remaining Work
- Task Budgeted Work
- Task Archive
- Task Creation Date
- Task Creation User Id
- Task Last Modification Date
- Task Last Modification User Id
- Task Sprint Id
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Time Entry Date
- Time Entry Description
- Time Entry Hours
- Time Entry User Id
- Time Entry Project Id
- Time Entry Project Step Id
- Time Entry Service Id
- Time Entry Billed
- Time Entry Billed by user
- Time Entry Billed date
- Time Entry Start Time
- Time Entry End Time
- Time Entry location Longitude
- Time Entry location Latitude
- Time Entry Invoice Line Id
- Time Entry Task Id
- Time Entry Is OverTime
- Time Entry Creation Date
- Time Entry Creation User Id
- Time Entry Last Modification Date
- Time Entry Last Modification User Id
Action
Search
- Accounting Code Id
  Required
Action
Search
- Company Name
Action
Search
- Currency Id
  Required
Action
Search
- EnterpriseActivityCode Id
  Required
Action
Search
- Invoice Id
  Required
Action
Search
- Payment Type Id
  Required
Action
Search
- ProfessionCode Id
  Required
Action
Search
- Project Step Id
  Required
Action
Search
- Sprint Id
  Required
Action
Search
- TaxProfile Id
  Required
Action
Search
- User Id
  Required
Action
Search
- Bank Account Id
  Required
- Bank Account bank number
- Bank Account branch number
- Bank Account account number
- Bank Account name
- Bank Account description
- Bank Account currency
- Bank Account credit limit
- Bank Account accounting code
- Bank Account EFT originator number
- Bank Account EFT data processing center number
Action
Search
- Enterprise Id
  Required
- Enterprise Name
  Required
- Enterprise Email
- Enterprise Phone
- Enterprise Phone2
- Enterprise Fax
- Enterprise Address
- Enterprise City
- Enterprise Province/State
- Enterprise Country
- Enterprise Postal Code
- Enterprise Note
- Enterprise Active
- Enterprise is Natural Person
- Enterprise Language
- Enterprise Payments Term
- Enterprise is a Client
- Enterprise is a Provider
- Enterprise is a Prospect
- Enterprise Administrator Id
- Enterprise WebSite
- Enterprise Origin
- Enterprise Code
- Enterprise Bank Number
- Enterprise Branch Number
- Enterprise Account Number
- Enterprise Discount
- Enterprise Account Receivable
- Enterprise Account Payable
- Enterprise Tax Profile Id
- Enterprise Tax1 Number
- Enterprise Tax2 Number
- Enterprise number of employees
- Enterprise Activity Code List
Action
Search
- Invoice Id
  Required
- Invoice Number
- Invoice EnterpriseId
  Required
- Invoice Description
- Invoice InvoiceDate
  Required
- Invoice DueDate
  Required
- Invoice Status
- Invoice TermsAndConditions
- Invoice Recipient
- Invoice Archived
- Invoice Tax Profile Id
  Required
- Invoice QtyHeader
- Invoice PayPalInfo
- Invoice PayPalDate
- Invoice AllowPayPal
- Invoice AllowStripe
- Invoice ClientReferenceNumber
- Invoice SignatureDate
- Invoice ContactId
- Invoice CurrencyCode
- Invoice ExchangeRate
- Invoice CancellationDate
- Invoice Template
  Required
- Invoice ReplyTo
- Invoice SellerUserId
- Invoice AddressId
- Line Description
- Line ItemId
  Required
- Line ItemType
  Required
- Line UnitCost
  Required
- Line Quantity
  Required
- Line Taxes Profile Id
- Line Discount
Action
Search
- Payment Type Id
  Required
- Payment Type name
Action
Search
- Project Id
  Required
- Project Name
  Required
- Project Enterprise Id
  Required
- Project Contact Id
- Project Description
- Project Rate
- Project Billing Type
- Project Budget Hours
- Project Code
- Project Number
- Project Purchase Order Number
- Project Active
- Project Archive
- User member Id
  Required
- User member is administrator
- User member Rate
- Service Id
  Required
Action
Search
- Service Id
  Required
- Service Name
  Required
- Service Description
- Service Rate
  Required
- Service Taxes Profile Id
- Service Code
- Service Number
- Service Active
  Required
- Service Billable
  Required
Action
Search
- Task Id
  Required
- Task Summary
  Required
- Task Description
- Task Assignee User Id
- Task Administrator User Id
- Task Enterprise Id
- Task Project Id
- Task Project Step Id
- Task Service Id
- Task Status
- Task Priority
- Task Start Date
- Task Due Date
- Task Reminder Date
- Task Remaining Work
- Task Budgeted Work
- Task Archive
- Task Sprint Id
Action
Search
- Time Entry Id
  Required
- Time Entry Date
  Required
- Time Entry Description
- Time Entry Hours
- Time Entry User Id
  Required
- Time Entry Project Id
  Required
- Time Entry Project Step Id
  Required
- Time Entry Service Id
  Required
- Time Entry Billed
- Time Entry Start Time
- Time Entry End Time
- Time Entry location Longitude
- Time Entry location Latitude
- Time Entry Invoice Line Id
- Time Entry Task Id
- Time Entry Is OverTime
Action
Search
- 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

Bank Account Created
Triggers when a new Bank Account is created.
Trigger
Instant
Try It
Enterprise Created
Triggers when an Enterprise is created.
Trigger
Instant
Try It
Invoice Created
Triggers when an Invoice is created.
Trigger
Instant
Try It
Payment Type Created
Triggers when a new Payment Type is created.
Trigger
Instant
Try It
Project Created
Triggers when a Project is created.
Trigger
Instant
Try It
Service Created
Triggers when a Service is created.
Trigger
Instant
Try It
Task Created
Triggers when a Task is created.
Trigger
Instant
Try It
Time Entry Created
Triggers when a Time Entry is created.
Trigger
Instant
Try It
Bank Account Deleted
Triggers when a Bank Account is deleted.
Trigger
Instant
Try It
Enterprise Deleted
Triggers when an Enterprise is deleted.
Trigger
Instant
Try It
Invoice Deleted
Triggers when an Invoice is deleted.
Trigger
Instant
Try It
Product Deleted
Triggers when an Product is deleted.
Trigger
Instant
Try It
Project Step Deleted
Triggers when a project step is deleted.
Trigger
Instant
Try It
Tax Profile Deleted
Triggers when an Tax Profile is deleted.
Trigger
Instant
Try It
Accounting Code Updated
Triggers when an Accounting Code is updated.
Trigger
Instant
Try It
Contact Updated
Triggers when a Contact is updated.
Trigger
Instant
Try It
Expense Account Updated
Triggers when an Expense Account is updated.
Trigger
Instant
Try It
Invoice Payment Updated
Triggers when an Invoice Payment is updated.
Trigger
Instant
Try It
Product Updated
Triggers when an Product is updated.
Trigger
Instant
Try It
Project Step Updated
Triggers when a project step is updated.
Trigger
Instant
Try It
Sprint Updated
Triggers when a Sprint is updated.
Trigger
Instant
Try It
Tax Profile Updated
Triggers when an Tax Profile is updated.
Trigger
Instant
Try It
- Accounting Code
- Accounting Code description
- Accounting Code percentage tax reclaim.
- Accounting Code class
Action
Write
- Contact First Name
- Contact Last Name
  Required
- Contact Phone
- Contact Mobile Phone
- Contact Email
- Contact Login
- Contact Password
- Contact Login Active
- Contact Enterprise Id
  Required
- Contact Title
- Main Contact of Enterprise
- Contact Profession Id
- Contact Gender
  Required
- Contact Language
  Required
- Contact Address
- Contact City
- Contact Postal Code
- Contact Province/State
- Contact Country
- Contact Notes
Action
Write
- Expense Account Name
  Required
- Expense Account Description
- Expense Account Code
- Expense Account Active
- Expense Account Price
- Expense Account Taxes Profile Id
Action
Write
- InvoicePayment InvoiceId
  Required
- InvoicePayment UserId
  Required
- InvoicePayment Amount
  Required
- InvoicePayment PaymentDate
  Required
- InvoicePayment Description
- InvoicePayment TypeId
  Required
- InvoicePayment BankAccountId
  Required
Action
Write
- Product Name
  Required
- Product Description
- Product Price
  Required
- Product Taxes Profile Id
- Product Code
- Product Number
- Product Active
  Required
- Product SKU
- Product UPC
- Product IsInventoryEnabled
  Required
- Product ResaleActive
  Required
- Product ResaleCode
- Product ResaleMargin
- Product ResalePercentMargin
- Product ResalePriceType
- Product MinStock
- FeeLine Name
- FeeLine Amount
- Fee Percentage
Action
Write
- Step Name
  Required
- Step Description
- Step Administrator Id
- Step Project Id
- Step Start Date
- Step End Date
- Step Completed
- Step Completed Date
- Step Percentage Complete
- Step Budgeted Hours
- Step Budgeted Amount
- Step Default Service Id
- User member Id
  Required
- User member Hours Allocated
Action
Write
- Sprint Name
  Required
- Sprint Description
- Sprint Start Date
  Required
- Sprint End Date
  Required
- Sprint Administrator Id
  Required
- Sprint Active
- Sprint Archive
- Sprint Ressource User Id
  Required
- Sprint Ressource Allocated Percentage
Action
Write
- TaxProfile Description
  Required
- TaxProfile Tax1
  Required
- TaxProfile Tax2
  Required
- TaxProfile Tax1Label
- TaxProfile Tax2Label
- TaxProfile Tax1Number
- TaxProfile Tax2Number
- TaxProfile IsGrossTax2
  Required
- TaxProfile IsDefaultTax
- Tax Profile Is Active
Action
Write
- Accounting Code Id
  Required
Action
Write
- contact Id
  Required
Action
Write
- ExpenseAccount Id
  Required
Action
Write
- Payment Type Id
  Required
Action
Write
- Project Id
  Required
Action
Write
- Service Id
  Required
Action
Write
- Time Entry Id
  Required
Action
Write
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Bank Account bank number
- Bank Account branch number
- Bank Account account number
- Bank Account name
- Bank Account description
- Bank Account currency
- Bank Account credit limit
- Bank Account accounting code
- Bank Account EFT originator number
- Bank Account EFT data processing center number
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Country Name
- Country Code
- Currency Code
- Currency Name
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- EnterpriseActivityCode Code
- EnterpriseActivityCode Description
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Invoice Number
- Invoice EnterpriseId
- Invoice Description
- Invoice InvoiceDate
- Invoice DueDate
- Invoice Status
- Invoice TermsAndConditions
- Invoice Recipient
- Invoice Archived
- Invoice TaxProfileId
- Invoice QtyHeader
- Invoice PayPalInfo
- Invoice PayPalDate
- Invoice AllowPayPal
- Invoice AllowStripe
- Invoice ClientReferenceNumber
- Invoice SignatureDate
- Invoice ContactId
- Invoice CurrencyCode
- Invoice ExchangeRate
- Invoice CancellationDate
- Invoice Template
- Invoice ReplyTo
- Invoice SellerUserId
- Invoice AddressId
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Payment Type name
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- ProfessionCode Code
- ProfessionCode Description
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Search steps by Name
- Search steps by Description
- Search steps by Administrator Id
- Search steps by project Id
- Search steps by start date
- Search steps by end date
- Search steps by completed
- Search steps by completed date
- Search steps by percentage completed
- Search steps by budgeted hours
- Search steps by budgeted amount
- Search steps by default service Id
- Project step Creation Date
- Project step Creation User Id
- Project step Last Modification Date
- Project step Last Modification User Id
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- Sprint Name
- Sprint Description
- Sprint Start Date
- Sprint End Date
- Sprint Administrator Id
- Sprint Active
- Sprint Archive
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- TaxProfile Description
- TaxProfile Tax1
- TaxProfile Tax2
- TaxProfile Tax1Label
- TaxProfile Tax2Label
- TaxProfile Tax1Number
- TaxProfile Tax2Number
- TaxProfile IsGrossTax2
- TaxProfile IsDefaultTax
- Tax Profile Is Active
Action
Search
- Search page index. Default is 0.
- Search page size. Default is 20, limit is 500.
- Search sort order property names. Seperated by a comma when multiple values.
- Search is in ascending order. Default is true.
- User FullName
- User Email
- User Language
Action
Search
- Bank Account Id
  Required
Action
Search
- contact Id
  Required
Action
Search
- Enterprise Id
  Required
Action
Search
- ExpenseAccount Id
  Required
Action
Search
- InvoicePayment Id
  Required
Action
Search
- Product Id
  Required
Action
Search
- Project Id
  Required
Action
Search
- Service Id
  Required
Action
Search
- Task Id
  Required
Action
Search
- Time Entry Id
  Required
Action
Search
- Accounting Code Id
  Required
- Accounting Code
- Accounting Code description
- Accounting Code percentage tax reclaim.
- Accounting Code class
Action
Search
- Contact Id
  Required
- Contact First Name
- Contact Last Name
  Required
- Contact Phone
- Contact Mobile Phone
- Contact Email
- Contact Login
- Contact LoginActive
- Contact EnterpriseId
  Required
- contact Title
- Main Contact of Enterprise
- Contact Profession Id
- Contact Gender
  Required
- Contact Language
  Required
- Contact Address
- Contact City
- Contact Postal Code
- Contact Province/State
- Contact Country
- Contact Notes
Action
Search
- ExpenseAccount Id
  Required
- ExpenseAccount Name
  Required
- ExpenseAccount Description
- ExpenseAccount Code
- ExpenseAccount Active
- ExpenseAccount Price
- Expense Account Taxes Profile Id
Action
Search
- InvoicePayment Id
  Required
- InvoicePayment Number
  Required
- InvoicePayment InvoiceId
  Required
- InvoicePayment UserId
  Required
- InvoicePayment Amount
  Required
- InvoicePayment PaymentDate
  Required
- InvoicePayment Description
- InvoicePayment TypeId
  Required
- InvoicePayment BankAccountId
  Required
Action
Search
- Product Id
  Required
- Product Name
  Required
- Product Description
- Product Price
  Required
- Product Taxes Profile Id
- Product Code
- Product Number
- Product Active
  Required
- Product SKU
- Product UPC
- Product IsInventoryEnabled
  Required
- Product ResaleActive
  Required
- Product ResaleCode
- Product ResaleMargin
- Product ResalePercentMargin
- Product ResalePriceType
- Product MinStock
- FeeLine Name
- FeeLine Amount
- FeeLine Percentage
Action
Search
- Step Name
  Required
- Step Description
- Step Administrator Id
- Step Project Id
- Step Start Date
- Step End Date
- Step Completed
- Step Completed Date
- Step Percentage Complete
- Step Budgeted Hours
- Step Budgeted Amount
- Step Default Service Id
- User member Id
  Required
- User member Hours Allocated
Action
Search
- Sprint Id
  Required
- Sprint Name
  Required
- Sprint Description
- Sprint Start Date
  Required
- Sprint End Date
  Required
- Sprint Administrator Id
  Required
- Sprint Active
- Sprint Archive
- Sprint Ressource User Id
- Sprint Ressource Allocated Percentage
Action
Search
- TaxProfile Id
  Required
- TaxProfile Description
- TaxProfile Tax1
  Required
- TaxProfile Tax2
  Required
- TaxProfile Tax1Label
- TaxProfile Tax2Label
- TaxProfile Tax1Number
- TaxProfile Tax2Number
- TaxProfile IsGrossTax2
  Required
- TaxProfile IsDefaultTax
- Tax Profile Is Active
Action
Search
- 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 Kiwili

ERP & online account management software for your small business

HelpHelp

Related categories

Project Management