BUTTON

Change the cell interaction type to BUTTON and executes the formulas when clicking on the button.

Syntax

BUTTON(label, formula)

label

The text displayed on the button.

formula

The formula to be executed on button click.

BUTTON("Click me!", SEND_EMAIL(A1,A2,A3,A4)) returns sends an email when the button is clicked.