How to assign a cell value to a post in google spreadsheet?

Question

Google Sheets

Task:
As soon as the user has ordered for the nth amount, the call center operator must enter it into the database and immediately inform the user of his number. After a certain period, we will draw a prize among the numbers. So that the numbers are not duplicated, I decided to use the google docs form.
Outcome:
There is a form (google docs).
The data from the form is entered into the table , each time adding a new line and not filling in the existing one. Thus, the number of rows increases each time by 1 and a gap appears in the table.
If anyone has experience with this kind of problem, please let me know.

Answer 1

Using Google Script, create your form and implement the desired mechanism.

Answer 2

I can help with implementation (Google Apps Script, Google Forms, Google Spreadsheet). The truth is not quite understood what kind of gap in question.
- generation of individual numbers (identifiers);
- mailing to all participants with one button;
Write if you have similar questions [email protected]