- 🎊 New features
- 1) Main Features
- 1.a) Create scripts
- Create python scripts
- Create secrets
- 1.b) Add buttons in sheets that triggers python scripts
- 1.c) Use python scripts in automations
- 2) Improvements
- 2.a) Automations
🎊 New features
MAIN FEATURES | IMPROVEMENTS |
Python scripts | Automation |
This release brings a lot of bug fixes and UI improvements.
1) Main Features
1.a) Create scripts
Create python scripts
Python scripts are stored in the Scripts section of KAWA.
- Step 1: Go to Scripts section of your top left menu
- Step 2: Click on the + buttons to create a Script
- Step 3: Enter your python script directly into the input field or import a file.
Click on an existing script to edit script in “Overview”👇🏼
Find all Runs history in the “Runs” section. 👇🏼
Create secrets
Secrets are used for managing confidential data such as passwords, account authentication, security tokens, and related secrets.
- Step 1: Click on the + buttons to create a Secret
- Step 2: Add a key and a value
- Step 3: Import secrets in your python script to hide confidential data
1.b) Add buttons in sheets that triggers python scripts
To add a python script as a button in your sheet, follow these steps:
- Step 1: Go to Sheet > Open Controls panel and create a new control
- Step 2: Select “Button” as Control Type
- Step 3:
- You can either select an already existing script in your sheet
- Or add a script from library. In this case, you need to map the script inputs with columns from the sheet
When a new script is added from library, a button will appear in your top controls panel.
Click on “Run” to add an output column to your current view:
Buttons can be hidden, edited or deleted from controls panel 👇🏼
Find all logs by clicking on the 3 dots menu of a Python script button👇🏼
1.c) Use python scripts in automations
- Select “Script” as the Action of your automation.
- Select a script from your library and map the script inputs with fields from the Data Condition view.
- Save!
2) Improvements
2.a) Automations
We've enhanced the UX of our automation feature, making it more intuitive and user-friendly. To open automation, click on the familiar "robot" icon at the top of your sheet.
- Step 1: Click on Create Automation
- Step 2: Click Add Trigger to start configuring your automation. Triggers tell the system when to do something, and actions describe what should be done.
Triggers are either at schedule time or on data refresh.
- Step 3: Add Conditions. You’ll find the same features that are available in sheets.
- Step 4: Create Actions (Emails or Python scripts)