Sheet Automation Button

Sheet Automation Button is a Google Sheets add-on to help you create buttons without writing script.

Once button is created and rule is configured, with a simple click you can do almost every action Sheet Automation supports including but not limited to:

• Copy/move row data
• Update row data
• Create new row
• Format row
• Sort sheet
• Export sheet
• Send email
• Many more

Installation

Install the add-on from Google Marketplace.

Start the add-on by clicking menu Extensions - Sheet Automation Button - Open…

You should see the sidebar showing up shortly.

Getting started

0. Enable Google Apps Script API

The add-on will create apps script behind the scene. It requires Google Apps Script API setting to be enabled in your account, otherwise button can not be created successfully.

Please go to https://script.google.com/home/usersettings and make sure the Google Apps Script API setting is on.

1. Create a new button.

Click “+Button” to start creating a new button.

2. Create a rule

Click the grey area to add a new rule associated to the button.

3. Configure rule condition

Click the grey area under Condition to add a condition. This is optional.

4. Configure rule action

Click the grey area under Action to add an action. We create a Format Row action in this case.

5. Save the the button

After rule is created, you can save the button.

Once the button is saved, a real button will be inserted to the active cell of the current sheet and you can click the button to see if the defined action is triggered.

Contact