Telegram + Viber Bot with data extraction in the Google Sheets API
Create a bot to collect data about the type of moving composition, direction of movement and date.All data must be recorded in Google Sheets.2ndFunctional requirements:
2.1 The Interface in two languages: Russian and Ukrainian.2.2 The Possibility of selecting the interface language.2.3 The The menu to choose the type of moving composition.2.4 The Menu for choice of direction (in or from Ukraine).2.5 of 5. Menu to choose the country of route.2.6 The Enter a date by the user or choose from the proposed options.2.7 The Integration with Google Sheets API for data recording.ThreeDetailed description of the work of the bot:
3.1 The Russian language:
The choice of language:
The user is offered to choose the language of the interface: Russian.Choice of the type of moving composition:
The user sees the following questions:
What kind of mobile compound do you use?Tent
Reef / Isotherma
Vegetables / Samosval
Click the "Return" button to return to the previous menu.Choosing the direction:
The user has the following options:
From Ukraine
in Ukraine
Click the "Return" button to return to the previous menu.Select the country of route (in Ukraine):
When choosing "In Ukraine" the user sees the following buttons:
Bulgaria
Romania
Poland
Italy
Greece
“No on the list” (introduction of the country and the city manually).Click the "Return" button to return to the previous menu.When choosing from Ukraine:
The user must indicate the country and the city."No on the list" (after clicking this button, the user must indicate the country and city).Click the "Return" button to return to the previous menu.Determination of date:
The user is asked, “On what date?”The Options:
for the next 1-3 days
Indicate the date by hand (e.g. the day and the month).Click the "Return" button to return to the previous menu.3.2 Ukrainian language:
The choice of language:
The user is offered to choose the language: Ukrainian language.Choice of the type of moving composition:
The user sees the following questions:
What kind of mobile warehouse do you use?Tent
Reef / Isotherma
The Samosquid / Samosquid
The "Return" button to return to the previous menu.Choosing the direction:
The user has the following options:
from Ukraine
in Ukraine
The "Return" button to return to the previous menu.Select the country of route (in Ukraine):
If the "In Ukraine" is selected, the user must indicate the country and city.Bulgarian
Romania
Poland
Italy
Greece
"No on the list" (after clicking this button, the user must indicate the country and city).The "Return" button to return to the previous menu.Determination of date:
The user is asked, “On which date?”The Options:
The nearest 1-3 days
To indicate your (abonnent indicates your date).The "Return" button to return to the previous menu.4 .Integration with Google Sheets API:
After collecting all the necessary data, the information is sent to Google Sheets.The data is recorded in certain cells that correspond to the type of information (e.g., the type of moving composition, direction and date).and 5.End of the BOT:
After successful recording the data in the table, the user is sent a message: "Thank you for contacting!Our manager will contact you.”When re-entering the bot, the process should start first.
6 .Technical requirements :
The bot should be compatible with the latest versions of Telegram and Viber.Integration with Google Sheets API should be secure and reliable.The bot should correctly handle possible errors and unexpected situations.7 .The prototyping:
To visualize the workflow of a bot, you can create a prototype using specialized tools, such as Figma or Sketch.This is a refined TZ to create your bot.It takes into account all your requirements and functional features.
-
5 days67 USD
5 days67 USD
Good day !
I am a telegram bot developer (now I am not a weber) with great experience (80+ bots, including work with Google Sheets), see reviews.
I write in the Node JS language, which allows you to make bots "under the key" and the cheapest in service (4-8$ a month for hosting).
I will write a share of the bot, connect to the hosting and make a long-term technical support!
-
10 days223 USD
2138 22 2 10 days223 USD
Good day .
Your bot will collect data from customers (contractually) and store them in Google Ships.
Now I can estimate it in about 25 hours.
Price per hour: $10
Let us communicate.
-
3 days67 USD
10123 117 0 3 days67 USD
Hello to you.
I’m developing bots for telegram on NodeJS. Ready to take. Let’s write, we will discuss.
-
14 days178 USD
3638 7 0 14 days178 USD
Welcome to! Here’s a rather complex bot of another direction, but the logic is substantially overlap with your TZ (it’s in the portfolio. To evaluate the entire functional needs at least 2 accounts, because the bot is made for interaction between different people). There is a choice between two languages. There is also commercial experience working with Google Sheets API.
-
12 days178 USD
12 days178 USD
Hello to
Ready to make such a bot on the designer Smart Sender. There is direct integration with Google tables, you can easily change text blocks, even without attracting the developer.
You can also send a notification to the TG group about the new application.
Examples of my realizations will be presented in a personal letter.
Current freelance projects in the category Bot Development
Bot or application for sending messages in Telegram
22 USD
The task is simple - a multi-account cabinet is needed, all in one place. Mailing to groups that are on each account. Adding a message for mailing, setting the time when it is automatically sent. Installation on the server. Turnkey. Python, Bot Development ∙ 6 hours 54 minutes back ∙ 25 proposals |
BotTelegram bot for cryptocurrency exchange, the client needs to create a request, and the request should come to me in Telegram. Bot Development ∙ 20 hours 51 minutes back ∙ 63 proposals |
Development of a Telegram bot for a personal buyer service (MVP)Budget: up to 2200 USD Deadline: 4–6 weeksProject Description I am looking for an experienced Python developer to create an MVP Telegram bot for a personal buyer service (purchasing goods from Ukrainian and foreign stores). The project is designed for further scaling, so quality… Bot Development ∙ 6 hours 5 minutes back ∙ 63 proposals |
Telegram chatbot for a closed club
22 USD
Good day! I need to set up a bot for Telegram. Task: selling access to a closed channel. The bot should accept payments and after successful payment, issue a one-time invitation link. It is also necessary to set up automatic removal of a participant from the channel when their… Bot Development ∙ 1 day 22 hours back ∙ 91 proposals |
Mini apps Telegram. StoreGood afternoon An application is required in Telegram (online store) Example - essentially 1 to 1 like here brandspacebot Your experience is important, the stack you propose to use and why Price and timeframe approximately to start, I will be waiting for questions Web Programming, Bot Development ∙ 2 days back ∙ 87 proposals |
Mykolaiv