SGF - SUBMIT GOOGLE FORM

INTRODUCTION: What does SGF do?

SGF is used to automatically submit a google form at a specific time.

HOW TO USE IT?

Use Google App Scripts to run this. All you really have to do is run the main function BUT before that, you need to initialise some variables in the Variables.gs file.

Step 1: Pre filled google form link

First, you get the link to fill in the form. Here's an example - https://docs.google.com/forms/d/e/1FAIpQLSejzmFmE8b2CidvukmZ6Y4ZjMxnkesZlZ6LX6rKr1XsJGRHIg/viewform?usp=sf_link
You click on the link and inspect the page (Right click -> Inspect (Q) at least on Firefox)
Search for entry in the search bar like shown below

Each entry is connected to a field you have to fill or pick in the form. I only had one field in my test form but you can find an example with multiple fields below. After obtaining the entry ID, append this to your original url without the usp=sf_link. Here is also where you'll append your response in the url. In our example, the url would be https://docs.google.com/forms/d/e/1FAIpQLSejzmFmE8b2CidvukmZ6Y4ZjMxnkesZlZ6LX6rKr1XsJGRHIg/viewform?entry.768086295=Hello and Hello is what we're inputting in the field.
To input more than one word as your answer, simply add a + between the words. Here's an example - https://docs.google.com/forms/d/e/1FAIpQLSejzmFmE8b2CidvukmZ6Y4ZjMxnkesZlZ6LX6rKr1XsJGRHIg/viewform?entry.768086295=Hello+how+are+you+doing
You'll also have to change "viewForm" in the url to "formResponse". For our example - https://docs.google.com/forms/d/e/1FAIpQLSejzmFmE8b2CidvukmZ6Y4ZjMxnkesZlZ6LX6rKr1XsJGRHIg/formResponse?entry.768086295=Hello
And there's your pre-filled url.
As promised, here's an example with multiple fields -

Follow the same steps as above but when appending the entry IDs and reponses to the url, add a '&' between them. Here's a random example (not connected to the image) - https://docs.google.com/forms/d/e/1FAIpQLSejzmFmE8b2CidvukmZ6Y4ZjMxnkesZlZ6LX6rKr1XsJGRHIg/formResponse?entry.768086295=Hello&entry.123456=Fruit
Also, the examples above only dealt with textual responses in the google form but you might have to pick some options in the form. In those cases, you simply follow a similar procedure as above. Instead of writing your response (as entry.ID=response), you'd write entry.ID=Option+1&entry.ID2=Option+1. Another random example - https://docs.google.com/forms/d/e/1FAIpQLSfhMfnx00m1A_n5RysUgVklqqD_wNFX4cWFsGcbgutKPfkNbQ/formResponse?entry.806606999=ewewewew&entry.1239433641=eqwe&entry.2086571612=Option+1&entry.1691435913=Option+1&entry.903059671=Option+1

Once you have your pre filled url, replace it in the Variables.gs file (preFilledURL). Additionally, make sure to provide a response for all the required fields.

Step 2: Timezone

Find your timezone from the following list - http://worldtimeapi.org/api/timezone/. Some examples of timezones include - "Europe/Amsterdam", "Asia/Dubai". Once you have your timezone, replace it in the Variables.gs file (timeZone).

Step 3: Setting max values

updateTime is how often you'll receive an update about the current time and the time your google form will be submitted at. By default, it is set to 30 seconds.

You are free to modify this value in the Variables.gs file.

Step 4: Choose input method

There are two ways to specify when you'd like to submit the form.

The first one is of numerical type. This is where you'd input classic numbers like pi and e (these constants can also be found in the Variables.gs file)
The second one is in ISO 8601 date and time format.

If you're wondering how to format date and time in ISO 8601 format,

This information is also present in the Variables.gs file.

If you'd like to go with the first way, set dtInNumber to 1 and dateNum to the date in numerical form.
If you'd like to go with the second way, set dtInNumber to 0 and dateStr to the date in ISO 8601 form.

NavyaGovind/SubmitGoogleForm