Automation overview
Automate your spreadsheet using Logic Sheet.
Use Logic Sheet Automation to automate your Google Sheets tasks.
With Logic Sheet, you can set up triggers that initiate specific actions upon certain events, such as when a cell is edited or a form is submitted, or at a specific time.
To create an automation workflow in Logic Sheet, you will need to establish a trigger, optional conditions, and at least one action.
All of your automations for a single document can be accessed and managed from add-on sidebar.
To turn an automation on or off, click the toggle bar next to the automation.
To delete an automation, hover over the menu button and select "Delete." Confirm the deletion in the pop-up prompt, and the automation will be removed.
To add a new automation, click the "New automation" button and use the automation builder to set up the trigger, conditions, and actions. It is good practice to change the name of your automation workflow as soon as you open the automation builder.
Logic Sheet Automation Builder
A trigger is the event that fires up the automation workflow. In Logic Sheet, you can set up the following triggers:
- Run at a specific time
- Run every hour, every day, every week, or every month
- When a Google Forms response is received
- When a new row/column is inserted
Conditions allow you to specify additional criteria that must be met in order for the automation workflow to run. For example, you can set up a condition to only run the automation if the value of a specific cell meets a certain criterion.
An action is the task that will be performed when the automation workflow is triggered. Here are some actions you can use in Logic Sheet.
- Send an email: This action will send an email with specified content and recipients
- Update cell value: This action will update the value of a specific cell in the spreadsheet
- Create a new row: This action will add a new row to the spreadsheet with specified values
- Send a Slack message to a specified channel
- Append a new row in Airtable
- Remove duplicates
- Remove rows in a sheet
- Set formula at a cell
- Refresh formulas in a sheet
- Send an HTTP/API request to a service
Last modified 26d ago