EMBEDDED URL TO TEXT ON CHAT MESSAGE

[Duya]

Hi, there.

I am hoping you are doing well.

I am currently having a concern on te following problem.

What script I want to make;

- Get a data table from spreadsheet

- using 'forEach', create a text with embedding google form link that 'id' is prefilled and send a chat

Multiple challenges did not come good unfortunately although the following sample script I made was successful.

function sample(){
  const url = '<https://docs.google.com/forms/d/e/xxx/viewform?usp=pp_url&entry.1181110482=00003977|url>';

  const options = {
      'method' : 'POST',
      'headers' : { 'Content-Type' : 'application/json; charset=UTF-8' },
      'payload' : JSON.stringify({'text' : url}),
      'muteHttpExceptions' : true
    };

    Utilities.sleep(300);
    const result = UrlFetchApp.fetch('xxx', options);

} 

Thank you for your support in advance.

  

[Duya]

Just to add,

When I created the text, I put ``` at both front and end of the text