What script code do I need to send Google Form results to Discord?

[allure]

I have used a lot of script codes but nothing really works. I already have the webhook created and followed multiple tutorials. I already created the Google Form. I just need a script code that can send the results to the channel.

[Noah]

Have you tried researching: What did you find?

[happyshot10]

How to send Google Form results to Discord through Webhooks

Hey! Have a group and want to review Google Form applications in Discord? Well here is a tutorial showing you just how to do that! Step 1 - Creating a Webhook To create a Webhook, go to the channel you want the applications to appear and click Edit Channel [image] Once you are there, go under the category Integrations and create a brand new Webhook. You can change the name and profile picture to whatever you would like. [image] Step 2 - Forms Crea…

[allure]

I have already used this code. But it did not work. I seen someone create a new code in the replies I also used that one. It did work but it didn’t send the message in the channel.

[allure]

Sorry, I didn’t see this till now! But yes I did research. I used youtube tutorials that I could find. I don’t know if I did it wrong or the code just didn’t work because all the tutorial scripts were old…

[Noah]

For the ones you tried did you manage to get errors?

[allure]

Yes, I did get errors on every one.

[Noah]

Can you show me the tutorial you ended up using?

[allure]

It’s most of these scripts. Even the ones that are recent don’t work

[Noah]

Try the one from 2022. Then is there a way to get errors from google automations?

[allure]

This is what it says… it also send the same response 2 times in the channel.

[Noah]

So it’s working, but it’s kinda working, can you send all the code here using code tags?

[allure]

 
  
const WEBHOOK_URL = 'https://discord.com/api/webhooks/...'
const COLOUR = 0xFFD400

const form = FormApp.getActiveForm()
const message = form.getItems()[0]

function handleSubmit ({ response }) {
  const content = response.getResponseForItem(message).getResponse()
  UrlFetchApp.fetch(WEBHOOK_URL, {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json'
    },
    payload: JSON.stringify({
      content: '',
      embeds: [
        {
          // author: {
          //   name: 'Anonymous',
          //   url: 'https://docs.google.com/forms/d/e/.../viewform'
          // },
          description: content,
          color: COLOUR
        }
      ],
      allowed_mentions: {
        parse: []
      }
    })
  })
}

// https://developers.google.com/apps-script/guides/triggers/installable#managing_triggers_programmatically
/**
 * Creates an installable trigger for when a user responds to the form.
 */
function createSubmitTrigger () {
  // https://developers.google.com/apps-script/reference/script/form-trigger-builder#onformsubmit
  ScriptApp.newTrigger('handleSubmit')
    .forForm(form)
    .onFormSubmit()
    .create()
}
   

[Noah]

Can you put it in code tags please?

[allure]

I edited the message! Is that better??

[allure]

anyone there?? i still need help.

[Noah]

Is there any error logs for this?

[allure]

This is the only one that it’s showing but there might be more

[Noah]

Okay, what exactly are you trying to achieve?

[allure]

I am trying to get a script code that works for the form to send the response in the discord channel.