Chatbot in smartsender, integration with Google Table

Bot Development — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original You need to develop a chatbot on smartsender for a curriculum.In the chatboth we want to realize: 1 to 4 tests 2 – 4 practical tasks 3 – 2 research It is necessary to develop a system of scores for the passing of tests and practical.A total of 4 tests and 4 practical - for the total performance a person receives 60 points, 1 test = 5 points, 1 practical = 10 points.A chatbot should be integrated with a Google table when a person enters the chatbot for the first time to enter the PIB and e-mail, these data should be entered into a Google table.That is, in the table we have the following fields: IDI telegram, PIB, Post, 1 test, 2 test, 3 test, 4 test (and if the test is passed, then 5 points per pass, if not - 0 points).For each practical we have 2 steps, 1 - the text that a person wrote in response to the task, 2 - 10 points, or if not performed - 0 points.We also have 2 polls, and for a survey a person gets 20 points, i.e. 2 polls = 40 points.We have already such an integration to do with the Google table and the designer chat-bot through Zapier, I can share the prescribed formulas, maybe you can even simply copy everything or do without Zapier.This is the 1st and the same test that a person passes 2 times, before and after the study.This is a test to determine the level of burning, with only 22 questions.A person must pass this survey in the bot, and get a result in the chatbot, the level of his burning.The balls are counted simply: in 1 question there are 5 answers, for each answer a certain score is given, from 0 to 5, and the result is only 4 levels, according to the amount of points.In the main menu should be the "My Progress by Program" button where the amount of balls will be displayed and detailed what the balls are calculated, i.e., the data from the table and the bot will be displayed.The whole text in the bot is created, you just need to set up the integration

Proposals 7

Aleksey Krasnov

29 0

Budget: 7000 UAH Deadline: 7 days

Welcome to.
I’m working on the Smart Sender. I love you to do your task. To perform enough official integration of Smart Sender and Google tables.
However, there is a question, is the answer to a practical task written by the user text? How does the correctness of the answer be assessed, with the help of the curator, should this be done by the bot?

Oleg Gonchar

45 0

Budget: 10000 UAH Deadline: 6 days

So why do you get it out of the table if everything is inside the bot?
We just export to the table for convenience, but everything was counted inside the bot before shipping. If I am initially.
We don’t need Zapier. In the smart sander, direct integration with Google tables for data export.
The task is understandable. This is the main emphasis on mathematics. Updates of variables.