Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

After creating a Google From, get the URL to fill it in

A

Hi,

 

I have created a zap that:

  • creates a folder on GDrive
  • copies a Google Form and its corresponding Sheet to this new folder
  • sends a message with a link to this form to someone who can fill in the form

I have two challenges, I hope you can help.

  1. Although the zap gives me the ID of the copy of the form, this is different from the ID that is part of the URL to fill in the form (as I just found out). This means that I can create a link in the mail message, but it would link to the edit functionality of the form. How can I get the ID that I need to construct a URL that I can send to someone who needs to fill in the form (obviously, I don't want to do that manually, in that case half of the work would be outside the zap)?
     
  2. I also want to link the form and the sheet. Again, you can do that manually once the form and sheet have been copied, but is it possible to let a zap action do that?
     

Thanks,
André 

 

Best answer by christina.dBest answer by christina.d

Hey there! I wanted to pop in and consolidate some of the info in this thread. 
 

SamB wrote:

You’re right. I’ve taken a look and it seems that we’re only able to get the “edit” ID for the form, not the “preview” ID that would be needed in order to create a link to view/fill out the form. And it’s not currently possible to set the spreadsheet a Google Form saves responses to when copying a form.

 

It looks like Andre was able to successfully find a workaround and was kind enough to share it here:

 

André R. wrote:

 

I have even a better, real solution (for the first issue). I made a change in how I build the URL to the form. What I initially did was:

https://docs.google.com/forms/d/e/ + ID + /viewform

 

I added the '/e’ because that is in the URL a Google Form creates for sending to people to fill in the form.

 

The following works, however:

https://docs.google.com/forms/d/ + ID + /viewform

 

It actually redirects the URL to the one that Google generates, but without the button to request editing rights. For this, it is necessary to add '/viewform’, without this addition you still get the 'request editing rights’ button on the bottom of the page.

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7811 replies
  • January 11, 2022

Hey @André R., welcome to the Community! :)

You’re right. I’ve taken a look and it seems that we’re only able to get the “edit” ID for the form, not the “preview” ID that would be needed in order to create a link to view/fill out the form. And it’s not currently possible to set the spreadsheet a Google Form saves responses to when copying a form.

I’m certain having the ability to copy existing Google Forms where a link to view the form is provided, as well as the ability to link the copied form to a specific spreadsheet would be super useful to others as well. We don’t have any existing feature requests for this that I can add you to, so I’d suggest reaching out to our Support team to get a feature request opened up for this. I’m sorry to not have a quicker solution to suggest here! 

A
  • André R.Beginner
  • Author
  • Beginner
  • 3 replies
  • January 11, 2022

Hi Sam,

Thank you for your answer (that unfortunately is also a confirmation :-( ) 

I may have a workaround that could work because the number of people that need to fill out the form is small (2 lecturers grading a thesis by a student, each copy of the form is used to grade an individual student). I found out that the the link with the edit ID can also be used to fill in the form! The only (?) disadvantage is that there is also a 'Request access’ button visible, and I would have to inform the lecturers that they need to ignore that button. 

Linking the sheet to the form must be done by hand, it seems :-(

I will send in a feature request!

 

Best,

André

 

 

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7811 replies
  • January 11, 2022

I’m so glad you were able to figure out a workaround, @André R.. Hopefully the feature request will be implemented soon! :)

A
  • André R.Beginner
  • Author
  • Beginner
  • 3 replies
  • January 12, 2022

Hi Sam,

 

I have even a better, real solution (for the first issue). I made a change in how I build the URL to the form. What I initially did was:

https://docs.google.com/forms/d/e/ + ID + /viewform

 

I added the '/e’ because that is in the URL a Google Form creates for sending to people to fill in the form.

 

The following works, however:

https://docs.google.com/forms/d/ + ID + /viewform

 

It actually redirects the URL to the one that Google generates, but without the button to request editing rights. For this, it is necessary to add '/viewform’, without this addition you still get the 'request editing rights’ button on the bottom of the page.

 

Now working on the second issue :-)

Best,

André

 

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7811 replies
  • January 12, 2022

Great work! That’s fantastic news, @André R. :)

Thanks so much for sharing your solution here. I’m sure it will be helpful to others in Community as well. Best of luck in finding a solution for linking the spreadsheets to the Google Forms! 

christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • 2653 replies
  • Answer
  • March 10, 2022

Hey there! I wanted to pop in and consolidate some of the info in this thread. 
 

SamB wrote:

You’re right. I’ve taken a look and it seems that we’re only able to get the “edit” ID for the form, not the “preview” ID that would be needed in order to create a link to view/fill out the form. And it’s not currently possible to set the spreadsheet a Google Form saves responses to when copying a form.

 

It looks like Andre was able to successfully find a workaround and was kind enough to share it here:

 

André R. wrote:

 

I have even a better, real solution (for the first issue). I made a change in how I build the URL to the form. What I initially did was:

https://docs.google.com/forms/d/e/ + ID + /viewform

 

I added the '/e’ because that is in the URL a Google Form creates for sending to people to fill in the form.

 

The following works, however:

https://docs.google.com/forms/d/ + ID + /viewform

 

It actually redirects the URL to the one that Google generates, but without the button to request editing rights. For this, it is necessary to add '/viewform’, without this addition you still get the 'request editing rights’ button on the bottom of the page.

 

 

Terms & Conditions