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

Noah · 2023-05-13T12:53:39.454Z

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

allure · 2023-05-13T15:25:09.090Z

Yes, I did get errors on every one.

Noah · 2023-05-13T21:51:51.375Z

Can you show me the tutorial you ended up using?

allure · 2023-05-14T00:56:52.464Z

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

image1366×768 170 KB

Noah · 2023-05-14T11:22:15.050Z

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

allure · 2023-05-15T01:39:06.221Z

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

image1366×768 108 KB

Noah · 2023-05-15T16:18:01.252Z

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

allure · 2023-05-16T22:01:08.182Z

 
  
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 · 2023-05-16T23:10:38.233Z

Can you put it in code tags please?

allure · 2023-05-16T23:31:52.122Z

I edited the message! Is that better??

allure · 2023-05-20T18:43:22.910Z

anyone there?? i still need help.

Noah · 2023-05-20T20:02:26.635Z

Is there any error logs for this?

allure · 2023-05-20T20:41:23.186Z

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

image1143×485 26.2 KB

Noah · 2023-05-20T20:43:36.801Z

Okay, what exactly are you trying to achieve?

allure · 2023-05-20T20:48:22.197Z

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

Noah · 2023-05-20T20:53:01.571Z

Is this necessary, or is there another method you could take to achieve this?

allure · 2023-05-20T21:03:05.914Z

Yeah… we’ve already put out the join video and some people have said they wanted to join. I also tried websites that do this but they don’t work the way that they are supposed to…

peter · 2023-05-21T01:17:35.954Z

Try this one, it worked well for me.

allure · 2023-05-21T01:50:31.555Z

This is the error that came up

image798×297 20.4 KB

Noah · 2023-05-21T20:45:22.568Z

Are there any permissions that need to be set and or @peter do you get this error?