The partner enters the details in google forms and receives an invoice in excell. How?

Question

Google Sheets

Good afternoon.
There is a business process: partners send us invoices for payment. They take the amount for payment from their personal account in our service. Accounts are made independently in Excel.
Is it possible to do the following: the partner enters the amount and his payment details in Google Forms, and google forms gives him a ready-made invoice Excel file? By gives I mean will let you download the file in the browser or send it to email. Partners see only their accounts. The invoice template is on google spreadsheets.
Thank you.

Answer 1

Generate an invoice in google spreadsheets and use the menu item File -> Download as -> Microsoft Excel (XLSX)

Answer 2

You will have to program.
The basic idea is that the user submits a Google Form with some required amount of identification data. In the Drive system, an event called "Form Submission" is triggered. This event can be intercepted using Google Apps Script. Further as your imagination wishes. The following scenarios can be implemented:

• Only the identifier is sent, an invoice for the amount of the balance (advance) is sent to the mail
  
• The details are sent, according to which the kidney is located, to which the invoice for the amount of the balance (advance) is sent
  
• The previous paragraphs are expanded by sending the invoice amount