Integration of Google Forms in ManyChat (Change)

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