Google sheets script program work for output labels

We require a PDF output that displays specific data sourced from Google Sheets. The PDF should include information from the following five categories:

1. Product Name and Size - Sourced from Google Sheets: https://docs.google.com/spreadsheets/d/1i4_UbACcYGm3ktviilI706Jkyud1xAoAZ8pK4cGw_Zk/edit?usp=sharing

2. Product Image - Correlated with the data in point 1 within Google Sheets: https://docs.google.com/spreadsheets/d/1i4_UbACcYGm3ktviilI706Jkyud1xAoAZ8pK4cGw_Zk/edit?usp=sharing

3. Colour Swatch (Circle) - To be generated; can potentially be added to the Google Sheet specified above in points 1 & 2.

4. Barcode - Information available in the Google Sheet. Google Sheet Link: from a private sheet: cannot share - see attached

5. Product SKU - Data found in the same Google Sheet as point 4. Google Sheet Link: from a private sheet: cannot share - see attached


The output should conform to the dimensions of the attached PDF Product Label Template.

It is essential to have a straightforward method for generating new product labels.

Offers for accomplishing this task are welcome.