Share Google Sheets data with services and apps

Share Google Sheets data with services and apps
Google Sheets
·
2021-12-09
·
3 min read
eye

How to connect Google Sheets to Albato. 

To send Google Sheets data correctly, you need to follow two required parameters:

  1. Fill in column A from the first row to the last. 
  2. Data transferring is available at sequential rows filling. For example, you have filled row 25, then fill in row 26. If you fill in row 27 first, the data will not be transferred. 

After creating a bundle, Albato will send new and sequentially added rows. If we filled rows 1-10, then we can send row 11. When we delete row 10 and fill in it again, the data from this row will not be sent.

Example: a bundle of GoogleSheets and Telegram

Open My bundles page and click Create a bundle -> New.

In the first column select «Upload data from»  Google Sheets, and  «New sheet row» as a trigger in the second. When you select your service (app) connection, Albato will open two additional fields. 

Specify the spreadsheet where to take the data and its sheet, then click Continue button.

Now set up the service where to send data.

Select Telegram in the first column, «Send messages» action in the middle, and specify your service (app) connection in the third column.

Click Continue button.

On the next step you need to specify columns to send the data. You can select more than one column, as shown in the screenshot. 

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 bundle is ready. Click 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:

The data from row 13 and further will be sent now. 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 from row 13. 

Albato remembers the last received row (in our example it is row 12) then waits for data from the next row 13. Service check the the filling of a new row through column A, for this reason it must always be filled.


Google Sheets