Qubot Google Sheets Setup

Connecting Google Sheets to a Bot

By connecting your Google spreadsheets to the bot, your bot experience will improve significantly. For example, your bot will be able to download data directly from your Google spreadsheet, as well as upload new data in real time. Using Google Sheets will make your work much easier, because you will have direct access to read and edit the saved data at any time without interfering with the bot code.

The instructions below will help you to share Google spreadsheets:

Step 1

Sign in or create an account at https://accounts.google.com

Step 2

Open your Google Sheets here https://docs.google.com/spreadsheets

You can also access your Google Sheets from the Google homepage(https://www.google.com/) by clicking the Google apps button.

Step 3

Share the Google Spreadsheet with your bot:

In your Google Sheets, open a spreadsheet and click the Share button.



Share the access in any of the possible ways. First way. Share with a specific account: copy the following account into the input field of the sharing window and send the invitation.

qudata-bot-service@qudata-services.iam.gserviceaccount.com



Second way. Get shareable link: in the Get link section change status Restricted to Anyone with the link, and click Done.



Please note that you can control the access: if the bot will only read data from Google spreadsheet, then the Viewer role is enough, and if the bot will also save data to Google spreadsheet, then the Editor role is required. You can change the role at any time in the sharing settings.

Step 4

Set up data loading to a spreadsheet in the bot editor. Additional information about this can be found in the bot editor templates (e.g. Trivia, Order Food templates) or in our help center.

Setting up work with Google Spreadsheet data in a bot

Choose the bot you need. Go to the bot's Editor.

Loading data from a table

1. Select the desired step in your bot where you want to load data from the google spreadsheet (For example, Main)



2. Select/create an element whose action should be to load data from the table. It can be Buttons, Actions element, just user input (click to show actions when) and other elements.


3. In the Item properties field you will be able to add a property:


4. Select the load property:



5. В свойстве load выберите из списка Google Sheets



6. В поле Google Sheets table url введите url(ссылку) вашей google таблицы




7. В поле Slot name введите имя переменной, в которой будут хранится данные с вашей таблицы в виде массива объектов:



Используйте эту переменную для работы с вашими данными.

Убедитесь, что вы дали доступ на чтение или редактирование своей таблицы

Запись данных в таблицу

Пройдите шаги 1-3 описанных выше в "Загрузка данных с таблицы" выбрав шаг на котором нужно сделать запись в таблицу.

4. Выберите свойство save:



5. В свойстве save выберите из списка Google Sheets



6. В поле Google Sheets table url введите url(ссылку) вашей google таблицы




7. В поле Data value введите данные, которые будут записаны в таблицу в указанном формате в виде объекта:

Убедитесь, что вы дали доступ на редактирование своей таблицы