Custom Google Sheets

create a function that creates a column chart with the maximum value of 100 that uses different series: Chart type is Column Chart. Use the name of the series as the labels of the each column. Create the graphs and save it, turn it into an image url and paste the image url of the each graph under the cell that has the value "Hareket Grafik Link" on the Google Sheets. Do this action for the each cell that has a value in in the A column. Stop doing the function if there is no data A row. Make different graphs for each row that has values and paste the image url accordingly under the column. 6 different charts are needed for the each row. I know the structure so it will be easy one who knows the JavaScript. If you want to help me use the AutoCrat it will be more helpful too. I am trying to create a report card tool.