Build an automatic tool that generate mutiples pdfs from a google sheet

The objective of the tool is that we can place each contract to be generated in several lines of the sheet and that this is tied to a base model where the data is replaced by those required by each individual contract, that we can have a button where all are generated the documents and remain in a google drive folder.