How i made google forms automatically post submissions in our discord server

How i made google forms automatically post submissions in our discord server

axieax/google-forms-to-discord

Use Git or checkout with SVN using the web URL.

Work fast with our official CLI. Learn more.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

Google Form responses to Discord automation

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Setting up a Google Form

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Create a Discord Webhook

Assumed: you have created a Discord account, joined a Discord server with the «Manage Webhooks» permmission enabled and there is at least one text channel (to display the notifications).

Link the Google Form to the Discord Webhook

Congratulations, your automation is now set up!

Note: if you cannot find the Edit menu in the script editor, make sure you are using the Legacy editor.

About

Automate Google Form responses to a Discord channel

How i made google forms automatically post submissions in our discord server

Create a Google Form for use with this script

Make the form however you’d like.

Go to the Script editor.

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

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

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

This option will allow you to set a colour to your embed. The colour option requires a numerical input instead of hexadecimal. E.g. Red in Hexadecimal is #FF0000. As a decimal, this would be translated into 16711680.

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

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

Displays a description for the embed.

Displays an image inside of the embed.

Allows for a thumbnail to be displayed in the embed.

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

Footer

© 2022 GitHub, Inc.

You can’t perform that action at this time.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.

Iku / Google-Forms-to-Discord Goto Github PK

A quick way to automatically send Google Form responses to a Discord channel

License: MIT License

Google-Forms-to-Discord’s Introduction

Create a Google Form for use with this script

Make the form however you’d like.

Go to the Script editor.

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

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

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

This option will allow you to set a colour to your embed. The colour option requires a numerical input instead of hexadecimal. E.g. Red in Hexadecimal is #FF0000. As a decimal, this would be translated into 16711680.

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

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

Displays a description for the embed.

Displays an image inside of the embed.

Allows for a thumbnail to be displayed in the embed.

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

Google-Forms-to-Discord’s People

Contributors

Stargazers

Watchers

Forkers

Google-Forms-to-Discord’s Issues

Pictures on readme are dead

2 pics about trigger

I mean I still figured it out but there may be people who didn’t

Syntax Error on line 44 fixed: solution included

Include a comma on line 45 after the curly bracket
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Request failled | returned code 400 | Truncated server response:

As stated above I am getting this failures:
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Is there a yt tutorial for this?

I mess things like this up a lot, and was wondering if there is a step by step tutorial for this.

TypeError: Can not call the method «getItemResponses» of undefined

I wanted to test your script but at the time of launching I have this error that comes back to me

TypeError: Can not call the method «getItemResponses» of undefined. (line 7, file «Code»)

Here is the code below that I use

Help Needed

First, let me thank you for the code, it works like a charm.

I have a small request, i would like to display only certain fields in discord and not all fields. Is there a possible way to do that.

Thanks in Advance

TypeError: Cannot read property «response» from undefined. (line 4, file «Code»)

Keep getting this error. Haven’t changed any of your code.
https://i.imgur.com/negPeRw.png

text: Date

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

What do I have to write here, to show the Date, when the Google FOrm was send?

Can’t get it to to work

i made the google script and trigger and did a test response and it did not work i correctly made the web hook but it just doesn’t work.

Error when making trigger

When I try to make the trigger I recieve this error when trying to save it: http://prntscr.com/oof1iu

Error Running Script

I’m getting «Script function not found: myFunction». it may be because I didn’t add triggers because quite frankly I’m not sure what they are. I’m also curious if this script runs 24/7 or if it needs to be added to a Bot?

Form Script Error

Getting the below error from the script. It works fine for one form, but doesn’t for another;

Request failed for https://discordapp.com/api/webhooks/xxxxxxxxxxxx returned code 400. Truncated server response: <"embeds": ["0"]>(use muteHttpExceptions option to examine full response). (line 52, file «Code»)

I don’t have any # in my form, so unsure what’s causing the issue. I have no coding experience, so not able to figure it out. 🙁

Help Me!

How do you make the embed colors?

Q: @Mention in Form Webhook

Hi there,
I tried this according to your previous answer to #11 and, as a newbie non-coder, I would love a specific way to add this!

Any help is appreciated, thanks!

Error script not working 2 days now

Error running script

Getting this error while trying to run the script, any ideas?

«TypeError: Cannot read property ‘getResponses’ of null (line 5, file «Code»)»

var POST_URL = «REMOVED»;

OnSubmit Trigger Problem

Can’t change «Choose Which function to run» in the current projects trigger’s from myFunction to OnSubmit.

Multiple Choice Tick Boxes Don’t Work

any update for this function?

Sorry i know it’s been discussed before.
Just wanted an update 🙂

receiving responses as normal text

Is there a way to post responses via a webhook without an embed?
Like normal text.

Missing > after property list. (line 44, file «Code»)

I keep getting this error:

Missing > after property list. (line 44, file «Code»)

TypeError: Function match in object trifft zu,trifft zu,trifft zu not found

When submitting the form and thereby run the script, I get the stated error. The «trifft zu, trifft zu, trifft zu» is coming from a GridItem (https://developers.google.com/apps-script/reference/forms/grid-item) in the form which has three rows with 2 buttons each. I guess the match() function doesn’t know how to handle the data it’s getting passed. Is there any way around this? Maybe by excluding this answer from matching or something else?

Any help would be greatly appreciated 🙂

Form script error

I have updated my script with the latest merge pull and still get this error 🙁

Request failed for https://discordapp.com returned code 400. Truncated server response: <"message": "Cannot send an empty message", "code": 50006>(use muteHttpExceptions option to examine full response) (line 52, file «Code»)

readme unclear

Literally everyone I introduced this to pasted the code inside myfunction(the default one).

Request fails every time it runs

I’ve been getting the following message every time the script runs
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

script works but no output

did everything i was told and i am getting no output, the script runs properly but nothing happens

Embedding images from form upload

Is there a way to embed uploaded images into the webhook? For example, someone can upload an image into a form, and I would like that to be embedded in the webhook post. However, the current script will give a string output of the image, something like this:

Upload Image if Applicable
1yQrFMA8gDU64QA6julWg8GdigNN5fY-Y
Where is this event happening?
some location
When is this event occurring or application due? If there are multiple dates, please use the earliest one.
2019-09-12
Application link or Contact info
some link
Description of Event or Application
testing description of what an application/event would look like.

Does anyone know how one could embed the image?

Q: Possible to mention a Role when it posts?

just wondering as we use this for staff apps and ban appeals so it would be nice to get a tag when something shows up

Send as a message instead of embed

im just wondering if its possible to get the script to send the information as a message and not as a embed?

Nothing happens

Hi
I follow with these steps in README and I think I configured it right.
But it doesn’t work.
I’m new at programming so maybe I can’t see the problem.
Some screenshots in attachments.
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

TypeError: Cannot call method «getItemResponses» of undefined. at onSubmit(Code:4)

I saw that two people submitted the error while trying to run the form, but I’m getting this error from submitting my form.

My event object looks like this:

I’ve also tried going through the source object and using getResponses(), but I get the following error:
You do not have permission to call Form.getResponses. Required permissions: (https://www.googleapis.com/auth/forms.currentonly || https://www.googleapis.com/auth/forms) at onSubmit(Code:5)

Is there any special permissions I need to access the responses? I’m the owner of the Google Form.

How do you add colour to the embed?

Line #13 Error

I am completely new to coding and I only know a few things about it so I have really no idea what is going on. I am just a person that wants a google form linked to a channel in the discord, as I have seen others do it and I think it would be useful for a group I am in. I’ve looked at the other issues that may be related to mine, and they don’t seem to work or I am confused by what is going on. I’ll show you an image of what’s going on with the code:

Any help would be much appreciated.

Error

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Request Failed returned code 400

Request failed for returned code 400. Truncated server response: <"embeds": ["0"]>(use muteHttpExceptions option to examine full response) (line 52, file «Code»).

Out of nowhere I started getting this issue. The script has worked beautifully for quite some time now. My forms only submit and show up in the discord channel when certain things are selected in the form. I didn’t change the script or the triggers from when they were working.

The error seems to be pointing to this line of code:
UrlFetchApp.fetch(POST_URL, options);

Thank you for any help you may be able to provide.

script error?

Recently I noticed the form was not posting to discord anymore so I came back to this and as I copied the new code from last month, without changing anything (except the webhook link), I got this error message in the script editor. and its keeping me from saving and continuing, it doesn’t work at the moment.

Missing > after property list. (line 44, file «Code»)

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Not deleting form after sent.

This would be a great feature to add

Webhook side color

How would you add a color to the side of the webhook when it gets sent

Issue with google forms

Not outputting the text from the form

The bot doesn’t output the text from the google form, and I’m not sure how to fix it. Any help would be very appreaciated.

Script Fails When Syntax Errors Fixed

Me and another person are having the same error. The error comes when we fix the syntax error by getting rid of the
«headers»: <
«Content-Type»: «application/json»,
>
and as soon as we remove these, the script compiles correctly but when tested it has a error of this:
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Embed size exceeds maximum size of 6000

Request failed for https://discordapp.com/api/webhooks/xxxxx/xxxxx returned code 400. Truncated server response: <"embeds": ["Embed size exceeds maximum size of 6000"]>(use muteHttpExceptions option to examine full response) (line 52, file «Code»)
OK

It was working, but it didn’t work when a really big google response was send in.

Form response with a string that has > 1024 characters

Due to discord’s embed limitations, each field of an embed is limited to 1024 characters

REQUEST: Display the content of a link?

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Is there a function line that would allow the link to display a video player or image preview or w/e link is being sent? Just like when someone sends a youtube link on discord?

No support for check boxes

The code has no support for check boxes. When I try to use checkboxes, I get an error:
TypeError: Can’t find function match in object Computer’s. (row 13, file ‘Code’)

A screen of the debugreporter:
Click on this

TypeError Line #7

Error states: «TypeError: Cannot read property ‘getItemResponses’ of undefined (line 7, file «Code»)»
Line #7 states: » var response = latestResponse.getItemResponses();»

2ed forum Not working

Hello, i got this script to work on one of my forums but when i made a new one (new webhook ofc) it seems to not get the submits, i followed the exact steps i did on the first one the only things being different are the forums, Webhook url and title/footer.

thank you for your time, any help is greatly appreciated.

Nothing is sending.

So, I followed the basic install instructions set up triggers and did the Oauth. When I click test script nothing gets sent to the discord channel. I’m not sure what I did wrong, I double checked everything. The success rate is 100% on the dashboard but no data to discord. Do I need to run it through a bot?
How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

Can’t get «Select event source» to forms

I tried following your Readme and since you have made it I think they have done the process differently. I tried doing the script editor from the 3 dots menu but it appears it has been removed and a completely new thing for making scripts. So I did the script in script.google.com and tried to add the trigger but when trying to add the event source for forms it only shows time and calendar. I also tried to run the script but got an error on line 5 saying

TypeError: Cannot call method «getResponses» of null. (line 5, file «google script»

Any help would be nice I do want to use this script

TypeError: Cannot read property «response» from undefined. (line 4, file «Code»)

When i change the POST_URL but when you try to run the scrip i get this error «TypeError: Cannot read property «response» from undefined. (line 4, file «Code»)»

Error 400 Code from Discord

Request failed for https://discordapp.com returned code 400. Truncated server response: <"embeds": ["0"]>(use muteHttpExceptions option to examine full response)
at onSubmit(text:56)

Getting the above error, I believe it may be due to the size out the output. Is there a way to send multiple messages to split the output?

Recommend Projects

A declarative, efficient, and flexible JavaScript library for building user interfaces.

Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

TensorFlow

An Open Source Machine Learning Framework for Everyone

Django

The Web framework for perfectionists with deadlines.

A PHP framework for web artisans

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

Some thing interesting about web. New door for the world.

server

A server is a program made to process requests and deliver data to clients.

Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

Visualization

Some thing interesting about visualization, use data art

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.

Microsoft

Open source projects and samples from Microsoft.

Iku/Google-Forms-to-Discord

Use Git or checkout with SVN using the web URL.

Work fast with our official CLI. Learn more.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

Create a Google Form for use with this script

Make the form however you’d like.

Go to the Script editor.

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

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

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

This option will allow you to set a colour to your embed. The colour option requires a numerical input instead of hexadecimal. E.g. Red in Hexadecimal is #FF0000. As a decimal, this would be translated into 16711680.

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

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

Displays a description for the embed.

Displays an image inside of the embed.

Allows for a thumbnail to be displayed in the embed.

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

About

A quick way to automatically send Google Form responses to a Discord channel

Kelo/Google-Forms-to-Discord-Extended

Use Git or checkout with SVN using the web URL.

Work fast with our official CLI. Learn more.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

This branch is 15 commits ahead of Iku:master.

Open a pull request to contribute your changes upstream.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

Google Forms to Discord (Webhook)

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

Create a Google Form for use with this script

Make the form however you’d like.

Go to the Script editor.

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

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

How i made google forms automatically post submissions in our discord server. Смотреть фото How i made google forms automatically post submissions in our discord server. Смотреть картинку How i made google forms automatically post submissions in our discord server. Картинка про How i made google forms automatically post submissions in our discord server. Фото How i made google forms automatically post submissions in our discord server

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

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.

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

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

Displays a description for the embed.

Displays an image inside of the embed.

Allows for a thumbnail to be displayed in the embed.

Allows you to put in a content message that will actually ping a user. E.g.

Allows you to put in a content message that will actually ping a role. E.g.

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

About

Automatically send Google Forms to Discord! Now including support for longer responses!

Источники информации:

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *