How to set up MySQL automation

MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime and agility.

Albato lets you connect your MySQL account with hundreds of the most popular apps - without a single line of code! You can automate your daily tasks and focus on what matters most.

First, connect the app to Albato

Next, set up an automation.

Let’s say we need to transfer data to the MySQL account when new Google Sheets rows are added.

Go to the Automation tab and click the New button.

Step 1 - set up a trigger

In the Automation builder select:

• App - Google Sheets
• Event which triggers the automation — New row
• Connection or create a new one

In the additional parameters, specify a spreadsheet and a sheet to get the data from.

Click the Add a trigger button.

Step 2 - set up an action

In the Automation builder select:

• App — MySQL
• Action which happens automatically — Create new rows
• Select your connection or create a new one

In the additional parameters, specify a table to receive the data.

Click the Add an action button.

Step 3 - fill in fields

Follow the hints about the data format for MySQL table.

The dropdown list contains fields from Google Sheets.

Here is an example of filled fields:

The automation is ready!

Click the Start button to run the scenario.