Alla S.
Offer Alla work on your next project.
Private message 
Offer work 
Zaporizhzhia,
Ukraine
5 days 16 hours back
temporarily not working
on the service 4 years
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Русский: fluent
English: pre-intermediate
Български: elementary
Skills and abilities
Programming
Portfolio
-
Bot in Telegram that informs about daily operation summaries
Bot Development
The accounting of operations is conducted in Google Sheets. Once a day, the bot sends a message with the day's summary based on the specified parameters.
Implementation: Google Sheets, Google Apps Script, Telegram
-
GPT for in-depth analysis and segmentation of target audiences
AI & Machine Learning
GPT, configured for audience analysis and research for a business or product:
1. Gathers information about your business or product.
2. Determines whether general audience research is needed or analysis for specific goods/services.
… 3. Suggests 8-10 potential audience segments with brief descriptions.
4. Evaluates each segment based on parameters such as sales potential, ease of access to the audience, and strategic importance.
5. Helps choose priority segments.
6. Creates detailed descriptions of these segments: sociodemographic characteristics, needs, pain points, objections, triggers for purchase, etc.
7. Develops a strategy for working with each segment and helps create a content strategy.
-
Template for the order cost calculator table and their accounting
Data Processing
Consists of two sheets:
1. Sheet "Guides"
In this sheet, variables that affect the cost of the order (for example, printing on t-shirts) will be entered.
Also, data about your customers should be entered here.
…
2. Sheet "Orders"
To calculate the cost of orders, you need to select the required values in the corresponding cells (only the green-colored columns should be filled in, the others will be filled in automatically).
Filters for displaying summary data by any criteria have already been added in the first row.
Video instruction with step-by-step slides - at the link
-
180 USD Accounting table for a small network of flower shops
Data Processing
Goal: reduce the number of "manual" operations, organize a convenient and visual accounting of income and expenses
What was done:
… 1. Sales and expense data at various points were manually entered by employees into the Google sheet "Stores"
2. The manager manually transferred the summary data by income/expense categories to the Google sheets "Advertising" and "Operations" (financial summaries were calculated in this same sheet, but not all expenses were taken into account in the formulas)
What has been done:
1. Set up automatic transfer of necessary data from the "Stores" sheet to the "Advertising" and "Operations" sheets and data from the "Advertising" sheet to the "Operations" sheet (this sheet was chosen for maintaining summary accounting)
2. Organized the entry of data on business operations: created a sheet with directories "Operations," "Suppliers," and balances at the beginning of the year for each of the items; created a sheet for entering operations with convenient drop-down lists, which excluded the possibility of incorrect entry of the counterparty or operation name
3. Created a dashboard sheet for automatic output of summaries with the ability to select a specific time interval (sales by sources; cash flow; advertising metrics; calculations with suppliers; expense structure)
4. Created a sheet for automatic formation of annual summaries, where income and expenses are displayed by sources and the status of calculations with suppliers by month
Result:
1. The manager received a transparent and accurate accounting system for income and expenses — both for a specific period (day, week, etc.) and in dynamics over the months of the year
2. The volume of "manual" operations has been minimized, and working with the sheets takes less time.
#GoogleSheets #GoogleAppsScript #automation
-
383 USD Telegram bot for merchandise manufacturer
Bot Development
Goal: reduce order processing time and workload on sales managers through maximum automation of information gathering, order cost calculation, and generation of a file with a commercial proposal.
Implementation: Telegram, SendPulse, Google Sheets, Google Docs, Google Apps Script
… The link to the bot is placed on the manufacturer's website and in the corporate Telegram channel.
Bot operation logic:
1. The user activates the bot and sequentially selects:
- a category from three categories, product, model. During the selection process, the user is provided with a description, specifications, and photos of each model;
- fabric color for textile products and leather color for leather products;
- quantity;
- type of customization with a logo.
2. After entering the data, the user is offered to add other products to the calculation; if agreed, the bot sequentially queries the user according to the same algorithm, if declined — it moves to the next step.
3. The bot sends the collected data to the user for verification - if changes are needed, there is an option to either change the information of individual logical blocks or to go through the bot again from the very beginning. The bot also offers the user to provide information about the person (legal or physical) to whom the commercial proposal should be addressed.
4. Verified and agreed data is transferred by the bot to a Google Sheet on a separate tab.
5. The order cost calculation takes place on the corresponding tab. For this, the data transferred by the bot is compared with the input data located on separate tabs — prices for each product model and each type of customization depending on the quantity of a specific product in the order. Using formulas, the current price for this quantity of the product and the cost of customization are determined, the cost for each product is calculated, the unit price considering customization, and the total order cost.
6. When changes are made to the table, a script is activated that generates and sends the user a message with information on each ordered product (product, model, type of customization, unit price considering customization, cost for this product position, total product cost) and a note that detailed calculations are provided in the commercial proposal.
7. For the convenience of analyzing the requested calculations, information about the order date, counterparty, and amount is displayed on a separate tab.
8. A commercial proposal file in PDF format is generated on the official letterhead of the manufacturing company and sent to the user, along with a link to the created Google document.
9. The user is offered to make a new calculation.
Input data for order cost calculation:
- 13 products, each with up to 3 models;
- For each product, a different list of 10-12 colors is available;
- There are 8 customization options for textile products (different for various positions) and 3 options for leather products. The cost of customization for different options is calculated in various ways: unit price; fixed amount regardless of quantity; unit price + fixed amount.
- For each product, there are 3-4 quantity intervals, depending on which the unit price of the product changes.
Result:
1. Significant acceleration of order processing and saving of employees' working time:
- due to information gathering by the bot, automatic data transfer, and order cost calculation. An employee connects only when the user has chosen their color to check the possibility of purchasing materials of a specific color, as well as to discuss specific deadlines for order fulfillment.
2. Reduction of waiting time for customer responses and improvement of service quality - the customer does not need to wait for a manager to become available; they can go through the bot at their convenience, not just during the manager's working hours, and request as many calculation options as needed.
3. Elimination of errors by the executor in calculations through the use of formulas.
#GoogleSheets #GoogleDoc #Telegrambot #SendPulse #GoogleAppsScript #chatbots #automation
-
361 USD Telegram bot for notary
Bot Development
Goal: to increase the efficiency of notary assistants' work and reduce the workload through maximum automation of information collection and its transfer to standard documents.
Implementation: Telegram, SendPulse, Google Sheets, Google Docs, Google Apps Script
The link to the bot is placed on the notary's website or sent to the user in personal correspondence.
…
Bot operation logic:
1. The user activates the bot, selects the type of service/type of power of attorney.
2. The bot step-by-step surveys the user. Depending on the selected type of service, information is requested: who issues the power of attorney, to whom (options - one/two persons), object of actions (real estate, vehicle, land plot), data about the spouse (if necessary).
3. The bot sends the collected data to the user for verification - if changes are needed, there is an option to either change the information of individual logical blocks or to go through the bot again from the very beginning.
4. Verified and agreed data is transferred by the bot to a Google sheet - a separate sheet is provided for each type of document.
5. When changes are made to the table, a script is activated that checks which specific sheet has been changed, selects the corresponding document template for that sheet, creates a new Google document based on it, and transfers data from the table according to the markup with tags.
6. A PDF file is sent to the user for information, and a link to the created Google document with notes is sent to employees in a separate Telegram group for review and necessary changes.
Result:
1. Significant savings in employees' working time:
- due to information collection by the bot (self-passing of the bot by the user takes, depending on the specific situation, from 8-10 to 18-20 minutes)
- automatic data transfer and document formation
At this stage of communication with the client, the employee connects only for final verification and minimal edits, as well as for scheduling a meeting.
2. Reduction in the client's waiting time for a response and improvement in service quality - the client does not need to wait for an employee to become available, they can go through the bot at a convenient time for themselves, not just during the notary's working hours, including breaks (waiting for the user's response is provided for up to 24 hours).
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Creating Google Sheets / KPI table
200 USD
|
|||||
|
Creating Google Sheets or using other software to visualize weekly reports from Amazon.
11 USD
|
|||||
|
Table for production and procurement planning.
113 USD
|
|||||
|
Help with setting up 1 function in the bot in SendPulse
23 USD
|
|||||
|
It is necessary to set up several functions in Google Sheets for the work file.
34 USD
|
|||||
|
Hotel accommodation in Google Sheets / Excel file
68 USD
|
|||||
|
Evaluation of applications for the implementation of a chatbot
64 USD
|
|||||
|
Create a bot for text replacement in documents
180 USD
|
|||||
|
Auto-fill of contracts
90 USD
|
|||||
|
Develop and adapt the CRM system
113 USD
|
