Google Forms to Discord (Webhook)

Having issues?

Maybe this will help: HELP.md

Just a heads up that the 1st part of this README.md, including the images, is sourced from the original repo.

Basic Setup

1. Create a Google Form for use with this script

2. Make the form however you'd like.

3. Go to the Script editor.

4. Paste the contents of script.gs.

5. Open Discord and make a channel where you'd like the responses to be sent.

6. Create a webhook and copy the URL. Replace WEBHOOKURL at the top of the script with the URL you copied.

7. Add a trigger by selecting Current project's triggers in the Edit menu, and creating a new trigger using the settings given below.

8. Submit a test response to make sure it works.

Additional Options

In this section, we will outline the multiple different customizations that you can add to your webhook. You can use any combination of the options displayed below.

Forums Support

With the addition of Discord's new Forum channels, there is the ability to direct your google form responses into individual threads or the same singular thread!

New Forum channel thread for each response

There is a script for keeping extended responses in a singular thread: forum_script.gs.

thread_name can be used to specify the name of the thread you want to generate.

{
  "thread_name" : "THREAD TITLE GOES HERE",
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields" : items,
    "color": 16711680
  }]
}

Same Forum channel thread for each response

thread_id can be used to specify the thread you want all responses to go into.

{
  "thread_id" : 1234 //Your thread id goes here! ,
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields" : items,
    "color": 16711680
  }]
}

---

Cosmetics

Colour

This option will allow you to set a colour to your embed. The colour option requires a numerical input instead of hexadecimal, I recommend using this site to convert between hex and decimal https://www.spycolor.com/.

Putting 0 as the colour value will make the bar transparent.

E.g. Red in Hexadecimal is #FF0000. As a decimal, this would be translated into 16711680.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields" : items,
    "color": 16711680
  }]
}

Author

This option adds an author block to the embed. The author block (object) includes three values:

• name - the name field.
• url - allows for a hyperlink to be attached to the name.
• icon_url - avatar displayed.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "author": {
      "name": "AUTHOR NAME CHANGE THIS IN SCRIPT",
      "url": "URL CHANGE THIS IN SCRIPT",
      "icon_url": "ICON URL CHANGE THIS IN SCRIPT"
    }
  }]
}

URL

This option binds a url link to the title of your embed.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "url": "URL CHANGE THIS IN SCRIPT"
  }]
}

Description

Displays a description for the embed.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "description": "DESCRIPTION CHANGE THIS IN SCRIPT"
  }]
}

Image

Displays an image inside of the embed.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "image": {
      "url": "URL CHANGE THIS IN SCRIPT"
    }
  }]
}

Thumbnail

Allows for a thumbnail to be displayed in the embed.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "thumbnail": {
      "url": "URL CHANGE THIS IN SCRIPT"
    }
  }]
}

Tag a user

Allows you to put in a content message that will actually ping a user. <@user id here> E.g. <@123123123>

{
  "content" : "<@user id here>"
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "thumbnail": {
      "url": "URL CHANGE THIS IN SCRIPT"
    }
  }]
}

Tag a role

Allows you to put in a content message that will actually ping a role. <@&role id here> E.g. <@&123123123>

{
  "content" : "<@&role id here>"
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "thumbnail": {
      "url": "URL CHANGE THIS IN SCRIPT"
    }
  }]
}

Footer icon

An optional customization you can make to footer text, is to add an icon image which will be displayed next to it.

{
  "embeds" :[{
    "title": "TOP TEXT CHANGE THIS IN SCRIPT",
    "fields": items,
    "footer": {
      "text": "BOTTOM TEXT CHANGE THIS IN SCRIPT",
      "icon_url": "URL CHANGE THIS IN SCRIPT"
    }
  }]
}