SPLIT Function/TRANSPOSE Function

SEQUENCE Function

EOMONTH Function/WORKDAY Function

NETWORKDAYS Function

FILTER Function

SPLIT Function:

Breaks down multiple values into separate cells based on a specified delimiter (e.g., a comma)

Example:
With =SPLIT(◯2, ","), you can split the value test,,test3 into test, an empty cell, and test3.

TRANSPOSE Function:

Switches the positions of rows and columns.

Turn comma-separated data into individual records and retrieve them one by one using a repeated process.

When AI features (like file/image reading) extract multiple values that aren't in list format, first convert them into records in Google Sheets, then retrieve them one by one.

👉 Flowbot Template Example - View Template

Collect data like your team’s clock-in status, and send a summary notification via email or chat.

SEQUENCE Function:

Generates a sequence of numbers (e.g., 1, 2, 3, 4, etc.).

After using SPLIT/TRANSPOSE to convert data into records, use SEQUENCE to assign unique numbers to each record. This ensures there are no duplicates and helps keep the process accurate when repeating it.

👉 Flowbot Template Example - View Template

Collect and organize data, such as team clock-in status, and send a notification summarizing the information via email or chat.

EOMONTH Function:

Calculates the last day of a month, based on a given start date and a specified number of months before or after.

WORKDAY Function:

Returns a date that is a specified number of working days before or after a given start date.

EOMONTH:

Automatically calculate the first or last day of a target month.

WORKDAY:

Automatically calculate the first or last business day of a target month.

NETWORKDAYS Function:

Calculates the number of working days between two dates.

Use a scheduled trigger to determine whether the current day is a working day or non-working day, and branch your workflow accordingly.

👉 Flowbot Template Example - View Template

Determine if a day is a weekend or holiday, then branch your flowbot’s route based on that information.

FILTER Function:

Filters and returns a range of cells from a dataset based on specified conditions.

Use FILTER for invoice management. Filter out only the relevant billing records on another sheet, and then use those records to issue and send invoices.

👉 Flowbot Template Example - View Template

When a specific date arrives, trigger a flowbot that uses invoice data from your spreadsheet to attach and send the invoice via email.