Connect Google Sheets to Sevdesk

Add Sheet to Existing Spreadsheet

Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spreadsheet with rows/columns. Use properties to set dimensions, tab color, etc. - OBJECT: Sheet contai...

Aggregate Column Data

Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.

Append Dimension

Tool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or columns to an existing sheet.

Auto-Resize Rows or Columns

Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.

Batch Clear Values By Data Filter

Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared...

Batch get spreadsheet

Retrieves data from specified cell ranges in a Google Spreadsheet.

Book Invoice Amount

Tool to book an invoice amount in SevDesk. Use when you need to record a payment for an invoice, either full or partial. This creates an invoice log entry and updates the invoice status accordingly.

Check Customer Number Availability

Tool to check if a customer number is available in sevDesk. Use when you need to verify that a customer number can be assigned without conflicts.

Create Accounting Contact

Tool to create a new accounting contact in sevDesk. Use when you need to assign debitor or creditor numbers to existing contacts for accounting purposes.

Create Check Account Transaction

Tool to create a new check account transaction in SevDesk. Use when you need to manually record a transaction for a payment account, such as bank transfers, cash movements, or other financial transactions that need to be tracked in the a...

Create Clearing Account

Tool to create a new clearing account in sevDesk. Use when you need to set up accounts for tracking intermediate transactions like coupons, gift cards, or prepayments. Clearing accounts are offline accounts used for booking purposes.

Create Communication Way

Tool to create a new contact communication way (email, phone, website, etc.) in SevDesk. Use when you need to add contact information like email addresses, phone numbers, or website URLs to an existing contact.