Functions

Task Placement and Execution Guide for Sheet Workflows Overview This guide explains how tasks work in Google Sheets workflows, focusing on where to...

TASK_SPLIT Function Overview TASK_SPLIT is a custom function that intelligently splits a text file into logical sections using AI. It analyzes your...

Function Overview TASK_CLEAR is a custom function that generates instructions for clearing both contents and formatting from a specified range in your...

Function Overview The TASK_COPY function copies data and formatting from a source range to a destination range, possibly across different sheets in...

Overview TASK_API is a custom function in Sheet Workflows that enables users to execute API calls directly from Google Sheets. This function creates a...

TASK_SEARCH Function Overview TASK_SEARCH allows you to perform web searches directly from Google Sheets using the Tavily API. Results are...

Function Overview TASK_DOC_TO_MARKDOWN converts Google Docs to Markdown format and places the resulting text in a specified spreadsheet cell. This...

Function Overview TASK_MARKDOWN_TO_DOC converts Markdown content into a Google Doc and creates a hyperlink to the document in your spreadsheet. This...

Function Overview The TASK_TRANSCRIBE function transcribes audio or video files from Google Drive using the Deepgram API. This powerful function...

Function Overview The TASK_URL_READER function fetches content from a specified URL and places the result in a designated cell. This function is...

Function Overview The TASK_WEBHOOK function sends data from your Google Sheets to external webhook URLs, allowing you to integrate your spreadsheet...

Function Overview The TASK_FORMULA function generaties Google Sheets formulas using AI language models. It allows you to describe the formula you need...

Function Overview TASK_FORMAT is a custom function that generates formatting instructions for spreadsheet ranges using natural language prompts and AI...

Function Overview The TASK_SHEET_UPDATE function generates a JSON-based task definition to manipulate spreadsheet data using a language model. When...

Function Overview The TASK_LM function runs language model operations in a cell in Google Sheets. It allows you to send prompts to various AI models,...

Function Overview JSON_EXTRACT is a powerful custom function that extracts specific values from JSON strings in your spreadsheet. It can find both...

Function Overview TASK_TEMPLATE is a dynamic template rendering function that replaces placeholders in text with actual content from cells, URLs,...

Function Overview TASK_ROW_UPDATE is a powerful custom function that intelligently updates the current row in a Google Sheet based on natural language...

Function Overview The TASK_CONCAT function combines content from multiple cell ranges, extracting text from cells and linked files, and optionally...