How to send data from Google Forms to Bitrix 24?

Question

CRM

Good day.
The situation is this, the site has a button into which a link was inserted to take the test using a Google form in a new tab. How can I link this form to Bitrix 24? There is another option: the form can be sent by mail, and the mail can be linked to CRM. And everything would be fine, only here a message comes to the mail saying that "you have filled out the form", but the fields with data, etc. do not come, just follow the link, which naturally managers in CRM will not do. And if it is still not possible to link the form to CRM, then it can be done so that a detailed notification with fields comes to the mail.
Linking the form to CRM due to the live table WILL NOT SUIT, I need the call to be IN THE FORM OF A NEW APPLICATION, and not just transfer to the database.

Answer 1

you can send a letter through google app script, save the form in a table and send a letter from google sheets