First, connect your Google account to Albato.
Follow these required parameters to send Google Sheets data correctly:
- Fill in column A from the first row to the last.
- Data transferring is available only at sequential rows filling. For example, if you have filled in the row 25, then you should fill in the row 26. If you fill in the row 27 first, the data will not be transferred.
After starting an automation scenario, Albato will send new and sequentially added rows.
Google Sheets and Telegram automation scenario
Open the Automations page and click the New button.
Set up the sending app. Choose Google Sheets from the list, and the «New sheet row» trigger. When you select your app connection, Albato will open two additional fields.
Specify the spreadsheet where to take the data from and its sheet, then click the Continue button.
Now set up the receiving app.
Select Telegram from the list, the «Send messages» action, and specify your connection.
Click the Continue button.
In the next step you need to match the fields with sending data. You can select more than one column, as shown below.
You can also add a text description before the column, such as phone number or full name. It will be sent to Telegram.
Click Continue button.
The automation is ready. Click the Start button.
How it works
Let’s look at the spreadsheet example, how it should be filled without spaces. Empty rows may be between columns A and E, as well as column E may be empty. The main thing is that column A is to be filled from the beginning:
Now we fill in rows 11 and 12 with the data:
As result, we receive two Telegram messages with the data from each row. The data can be transferred within 1-2 minutes:
We can fill in the columns at once or sequentially. Deleting row 12, we cannot send data until we fill in rows 12 and 13, but data sending will start only from row 13.
Albato catches the last received row (in our example it is row 12) then waits for data from the next row 13. The platform checks the filling of a new row by column A, for this reason it must be filled in.
