Skip to main content
Best answer

Possible to prefill Google form response when new row is added in Google Sheets?

  • August 22, 2021
  • 3 replies
  • 312 views

Hi,

I am wondering if it is possible to have a google form prefilled when a new row is added into a google sheet?

Thanks,

Best answer by SamB

I’m a little late to the party here but wanted to share this article I’ve just written that happens to have a workaround for adding the response to both the Google Form and Google Sheets: 

Hope that helps! :)

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

robschmidt
Forum|alt.badge.img+9
  • Zapier Solution Partner
  • August 23, 2021

Hi @Dshirt 

Yes, that’s totally doable. Here’s how the workflow will look:

  • Trigger: New Row added in Google sheet.
  • Action: Create Response in Google form.

  • Author
  • New
  • August 23, 2021

Thanks mate

I've made the Zap but it only seems to add a new row in the original spread sheet, not create a response in Forms

Any tips?


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Answer
  • October 22, 2021

I’m a little late to the party here but wanted to share this article I’ve just written that happens to have a workaround for adding the response to both the Google Form and Google Sheets: 

Hope that helps! :)