Is it possible to create a telegram bot (or otherwise) that receives data from a google form and sends a response depending on the data in a google form?

Question

Bots

The bot receives data from a Google form and, based on it, sends a response to the email of the person who filled out the form.

With what can this be done?

Answer 1

There is such a service - zapier

Answer 2

Catch the form submit event, and send data to telegram via the API - there is an API - nowhere is easier

Answer 3

Google Form writes data to a Google Spreadsheet, so you need to dance from here.
Table:

• the first line is the column headings,
  
• the second is formulas for processing data from a Google form (it can also be processed with scripts).
  

The FormEmailer script is connected to the Google spreadsheet , which will send the desired response to the person who filled out the form.