AppSheet Expression in Google Workspace allows you to build complex apps without writing code

By Estuti Bajpai Published on November 1, 2025, 13:47 IST

What if you get to know that you can build complex apps without writing code? Well, Google has introduced AppSheet expressions in the Google Workspace that allow you to tailor workflows, automate decisions, and embed specific business logic directly into your applications, often using similar spreadsheets like formulas.

Go beyond basic no-code apps. AppSheet expressions allow you to tailor workflows, automate decisions, and embed specific business logic directly into your applications – often using familiar spreadsheet-like formulas. Learn 🎓 more → https://t.co/49rkFi2Lm4… pic.twitter.com/MpJdGfRTlj

— Google Workspace (@GoogleWorkspace) October 31, 2025

AppSheet Expression in Google Workspace

Expressions are used within AppSheet to customize your applications in a wide variety of areas like when creating new records by using the UNIQUEID function, you can create a computed column with an expression, you can also write an expression to determine what email to send in an Automation or you can set a filter condition with an expression to determine whether an automation should even run and you can also use an expression to set a Row filter condition in a Slice.

AppSheet expressions are very similar to Google Sheets or Excel Formulas. Like a spreadsheet formula, AppSheet expressions can simply be a numerical evaluation or an expression can simply be a text string, while an ampersand can be used to concatenate multiple text strings.

Expressions can also carry a wide array of functions that are also similar to Excel and Google Sheets functions. Some commonly used AppSheet Functions include-

UNIQUEID()-Generate a unique alphanumeric ID, typically for a Row ID
USERMAIL()- Returns the current user’s email address
TODAY()- Returns today’s date
WEEKDAY(<date>)- Returns the numerical day of the week from <date>
EOWEEK(<date>)- Returns the end of the week date starting from <date>
WOWEEK (TODAY())+ 2- Returns the date of Monday of next week
LIST (“Oranges”, “Apples”, “Bananas”)- Returns list of “Oranges”, “Apples”, “Bananas”
SORT (LIST(“Oranges”, “Apples”, “Bananas”))- Returns “Apples”, “Bananas”, “Oranges”

You can access the data with features like square bracket notation, Expression Assistant, table column notation, and SELECT(). Many apps typically have related tables that are linked together in AppSheet via references. To fetch the data, you can use Dot Notation. AppSheet checks all expressions to ensure that they are correctly formed and being used in an appropriate manner.

Google