Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Freeelancers' best works

9
  • 13 USD

    Updates for Google Sheets + GAS

    Application programming
    Fill the price in Google Sheets based on data on the supplier’s warehouse remains. The code in GAS receives data, processes, compares the names of positions. The script is launched periodically - by a temporary trigger.
    #GoogleSheets and #AppsScript


  • 76 USD

    Integration of Google Forms in ManyChat (Change)

    JavaScript
    The task:
    In the menu chat, you will realize the filling of tags and special fields in the user profile with answers from the Google form, which is filled by the user after switching from the bot telegram to the Google form.The problem:
    There is no integration with Google forms.Accordingly, sending the client to the Google form is possible, but after the user's answer in the form there is no possibility to link the answer in the form to the specific user in the menu.There is also no possibility this survey to be carried out in a telegram or instagram bot due to the fact that there are many options of answer in one question (about 40 answers).In the bot, customers will hardly understand that in addition to the visible options of response, there are other options.Google forms on the link do not accept data.For example, userId to link data from different sources.Options of Solution:

    I offered the customer two technical options:
    Writing a node.js server script is more expensive, but there are no limitations on the amount and time of the script work
    Writing on Apps Script (a simplified version based on JavaScript) with Google hosting is cheaper.There are limitations on the time of execution of the script and the number of requests


    Given the fact that the bar is in the test mode, the customer has chosen the second option of the issue.The realization:
    The userId is transmitted in a special way from the bots telegram by link
    A set of data is formed to be recorded in the tags and a set of data to be added to the user's special fields in Manychat
    Recording userId data in the Manychat user card

    #manychat #mench #googleFormsApi #google-scripts #googleforms #appsScript #javascript js #chat-bot #scripts #scripts #web-scripts #web-scripts #scripts #scripts #scripts #GoogleDocs #GoogleSheets


  • 25 USD

    Google Apps Script to hide rows under condition

    Data processing
    Script based on Google Apps Script to hide rows under a certain condition. If the data on the columns offers is empty, then the script hides a line, otherwise misses
    The script is attached to the triggers of the structure change and the boot by the button.

    Result: HTTPS://youtu.be/zdm8FMPsmYo

    #GoogleSheets #Excel #GoogleAppsScript


  • 89 USD

    Google Sheets Screenshot New Post

    Online stores and e-commerce
    Screenshot to monitor the status of New Posts.
    With the given regularity checking all TNTs from the list of

    It automatically changes the status in the main table and enters data on the date and time of the status change into a separate file for deep analysis.

    Collects data about the status of "Come to the department" and sends the aggregated data to a separate group with managers

    Collects data about the status of "customer" and sends it to the group

    Collect data on the status of "Money in the Department" and sends it to the person responsible for the finance in the company

    If the goods are not taken from the department for more than 2 days - the data is sent to the telegram of the "Call" department.

    Posts Tagged ‘google’ #googleapp
    #GoogleSheets #google-scripts #NewsPost #Telegram #node-telegram-bot-api #appscript #telegrambot #telegram-bot #Telegram-developer #telegram #telegram #telegram #telegram #telegram-bot #telegram-bot #telegram-bot #telegram ##


  • 76 USD

    Automatization of the order accounting process prom.ua and rozetka.ua

    Data parsing
    Automatize the order accounting process on Google Apps Script, which receives order data from these platforms and saves them in the Google Sheets table.

    #rozetka.ua #prom.ua #GoogleSheets #GoogleAppsScript #orders


  • 127 USD

    Integration of Trello API with Google tables

    JavaScript
    Requirements: Get and summarize in Google tables the results of tasks from projects placed on trello

    The solution is based on Google Apps Script (JavaScript)
    #Javascript #Web programming


  • Telegram bot UkrTenderbot

    Bot development
    The boat that monitors the appearance of tender in Prozorro according to the specified criteria and sends notifications.
    Background: Google Apps Script + Spreadsheet (as a database)
    Integrated Payment System of WayForPay

    HTTPS://sites.google.com/view/ukrtenderbot

    #GoogleAppsScript #Telegram-bot


  • The Telegram Bot

    Data processing
    The boat that follows the appearance of auctions in Prozorro.Sale according to the specified criteria and sends notifications.
    Background: Google Apps Script + Spreadsheet (as a database)
    Integrated Payment System of WayForPay


  • Generator of email boxes and parser of received emails from Google Sheets

    Data parsing
    Generator (register) of mailboxes with the ability to collect data from received letters
    Implementation on Google Apps Script + PHP, the interface implemented in Google Tabs
    #GoogleDocs #GoogleSheets #GoogleAppsScript #PHP7 #Javascript #email #parser #Parsing