I want to post things in a discord but when I try to do this I get an error message. I was watching a tutorial and somehow still got hit with an error message.

What I want to happen is when something is posted in column A I want the script to run and post it into the Discord server. Once it’s posted I want it to say “posted” in column B.

I want to post a bunch of things in column A at once so the script should run and post everything that doesn’t have “posted” in the column B

I understand I can use a trigger to automatically have it run when the sheet is updated but I would also like to be able to have it post everything at once that hasn’t been posted VS one row at a time.

Google Sheet: https://docs.google.com/spreadsheets/d/1jRYuhhvA9GiJEmK-PNgPHC30QQ-RbjdEsT0T_nAS0og/edit#gid=0
App Script: https://script.google.com/u/0/home/projects/10DuYAzka5352INes9WdA_UxJ4sNgnDAnRFuRTNP4-oeczLbcZLIlI5Ih/edit

Here is the copy of the spreadsheet and app script to show what i tried but the error i got was:

Exception: Request failed for https://discord.com returned code 400. Truncated server response: {“message”: “Cannot send an empty message”, “code”: 50006} (use muteHttpExceptions option to examine full response)