dePAC | Web Proxy Auto Discovery | Proxy library

I believe your goal as follows.

• You want to convert the table from Google Spreadsheet to Google Slides.

  • As the sample situation, you want to achieve as follows. This is from your question.

• When I saw your sample situation, I can confirm that there are 2 values of Samuel Tuffuor in Google Slides. From this situation, you want to put the values to the Google Slides using the row titles of METRIC.

• In your current script,
  • duplicate() is used in the loop. By this, new slide is inserted every loop. I think that this is one of several reasons of your issue.
  • At 1st loop of values.forEach(), all values are replaced. Because in the template of your Google Slides, {{current}}, {{Target}}, {{Emea}}, {{Depac}}, {{Emma}}and{{Comment}}of each row is replaced by eachreplaceAllText`.
  • In this case, it is required to distinguish {{current}}, {{Target}}, {{Emea}}, {{Depac}}, {{Emma}}and{{Comment}}` of each row.

In order to distinguish the values of each row of template of Google Slides, I would like to propose to group each row.

Please group each row of template of Google Slides as follows. The red dotted line is the groups. In your sample Google Slides, 9 groups are created. Using these groups, the values retrieved from Google Spreadsheet are replaced with the placeholders of each group.

In order to replace the values retrieved from Google Spreadsheet with the place holders of each row of Google Slides, I modified your script as follows.