Custom Functions

What is a Custom Function?

A custom function in Google Sheets is a user-defined function created using Google Apps Script, which allows you to extend the functionality of Google Sheets beyond its built-in features. These functions operate similarly to standard functions in Sheets (like SUM, AVERAGE, etc.) but are tailored to specific needs or repetitive tasks you want to automate.

How is this working on Google Sheets with Sheet Director?

In Sheet Director, the custom function is implemented to get the configured service data without even opening the addon/extension. In this way, you can directly query your app records from Google Sheets.

What are the available custom function?

Custom functions on AI Capabilities, you can perform any Generative AI-related activities using custom functions. please read more about that under our AI capabilities.

AI Capabilities

Custom functions to query app by configured service, users can easily call the configured service without opening the addon/extension.
Available Functions
- - GET_APP():
    - GET_APPDATA functions takes 6 paramters
      - ServiceName: Provide the configured service name (required)
      - Field1...n and Value1 ....n: You can pass the filter names and their respective values sequentially

Here is an example request.

Why Choose Sheet Director Custom Functions?

Sheet Director's Custom Functions bring live business data directly into Google Sheets, making it easy to build dynamic reports, dashboards, and automated spreadsheets.
By combining configured services with simple spreadsheet formulas, you can retrieve filtered data from CRM, accounting, project management, and other business applications without opening the add-on.
Together with Query Services, Synchronization, Scheduler, and AI Capabilities, Custom Functions provide a powerful solution for Google Sheets automation, real-time data integration, and business reporting.