Question

How can you make pre-filled, auto-submitting links in Google Forms for an email survey?

I'm wanting to include buttons for a poll or survey in an email, and would like to automatically record and submit the response the user chose when they click a button. How can I do this in Google Forms?

Mentioned
#Google Workspace #Forms and Surveys #Customer.io #Mailchimp
Share
maguay's avatar
2 years ago
Build the form, choose "Get pre-filled link", then edit the URL

Make pre-filled Google Forms links

Google Forms has a built-in way to make pre-filled links that include the form responses you want—and if you tweak that URL, you can make it automatically submit the form entry so the people who vote in your poll or survey will never see the actual form.

Here's how to do it.

First make a form with the survey or poll question(s) you need. Include a plain text field for email address if you want to gather that as well (which you can prefill if sending this survey via an email marketing tool like Mailchimp or Customer.io).

Once your form is done, click the 3 dot menu on the top right of Google Forms and select "Get pre-filled link". That will open your form in a new tab. Select the options you want for this result, and if there's an email field, put TEST or something else easily recognizable in that field. Click "Get Link," then Google Forms will automatically copy the form link to your clipboard.

Now, you need to edit that link. Paste it into a text editor, and where the Google Forms link says /viewform?, replace that with /formResponse?. Additionally, add &submit=Submit to the end of the URL. If you have an email field in your form, also replace TEST in the URL with the field for your email address in your app ({{customer.email}} in Customer.io or *|EMAIL|* in Mailchimp, for example)

Finally, open your email editor, and add that link to the text or button to vote on the option you want—and repeat the steps to get the correct form submission link for every other option in your poll. When your recipient clicks the link, their vote will automatically be recorded.

7 points
chua's avatar
@chua (replying to @maguay )
a year ago

Hi, i tried to send a pre filled google form with auto response but I received this message - There was a problem submitting your response. Can you advise what is the issue? thanks

0 points
chua's avatar
@chua (replying to @chua )
a year ago

I can send you the link for your checking. thanks

0 points
ecwl0328's avatar
@ecwl0328 (replying to @chua )
a year ago

Hi , sorry for late reply. Would be good if you can help. Tks

1 point
irishgeoff's avatar
10 months ago

You can submit form data to google sheets using fabform.io

1 point
How do you manage your chat inbox?

Hey guys, first post here. As part of my work, I have to deal with and respond to a lot of incoming messages from different chats: Linkedin/WhatsApp/Signal/IG. I try to use Unreads/Archive features...

What are your favorite small, single-purpose apps?

There are plenty of advanced, powerful software filled with enough features to do almost anything. And then there are the tiny utilities that don't do much, but that are great at what they do do. ...

Do you use Readwise app? How much are you paying for the service?

I came across Readwise this week and I thought it was a very nice app. It sends emails with highlights from Kindle books, Instapaper, Pocket, iBooks and other services. It also offers the spaced re...

The community for power users.