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
Setting up a Google Form
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.
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.
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.
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.
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
Request failled | returned code 400 | Truncated server response:
As stated above I am getting this failures:
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
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
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.
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
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»)
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:
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?
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?
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
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.
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.
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.
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.
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!