Skip to main content
Best answer

How to get google response data into google forms

  • April 15, 2021
  • 4 replies
  • 77 views

Forum|alt.badge.img

Good Day, 

I have two questions about a Zap I’m working and would really appreciate if anyone can shed some light on the snags I have run into please?

I have a Webhook collecting data and sending responses from a questionnaire into a google response form.

I have linked the form correctly and changes made to the Google Forms document are reflected in the Google Response form but when I run my Zap I am not able to get the responses to populate the Google Forms document in my drive.

The Google Response form populates every time I run a test.

Another question, is there a way to delete the responses from a Google Response form at the end of a Zap, once the Google Form has been populated? I envisage having to save the Google form as a copy first to preserve the answers from the previous triggered Zap?

Any suggestions are very much appreciated.

Thank you 

Best answer by mrmac2you

Thank you @AndrewJDavison_Luhhu - I was able to make some progress but eventually ended up using Cognito forms which seems to be the better way forward.

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

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • April 15, 2021

Hi @mrmac2you 

Perhaps you can help us better understand your use case by providing screenshots of how your Zap is configured.

 

To clarify some concepts, GForm responses are saved to a GSheet which is stored in a GDrive.

 

Check out the available triggers/actions/searches for each of the apps:

GForms: https://zapier.com/apps/google-forms/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

GDrive: https://zapier.com/apps/google-drive/integrations#triggers-and-actions


Forum|alt.badge.img
  • Author
  • Beginner
  • April 15, 2021

Hi @mrmac2you 

Perhaps you can help us better understand your use case by providing screenshots of how your Zap is configured.

 

To clarify some concepts, GForm responses are saved to a GSheet which is stored in a GDrive.

 

Check out the available triggers/actions/searches for each of the apps:

GForms: https://zapier.com/apps/google-forms/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

GDrive: https://zapier.com/apps/google-drive/integrations#triggers-and-actions

Hi @Troy Tessalone 
 

Thank you for your response, my Zap is pretty straightforward and all steps complete.

The problem that I have is the Google Forms document that I have created does not get populated with the responses that are collected in the Google Form Responses. 

 

I have attached a screen shot of my Zap steps, I don’t have much more aside from the empty responses sheet. 


AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • June 11, 2021

@mrmac2you 
Just checking in to see if you still need help with this? 


Forum|alt.badge.img
  • Author
  • Beginner
  • Answer
  • June 11, 2021

Thank you @AndrewJDavison_Luhhu - I was able to make some progress but eventually ended up using Cognito forms which seems to be the better way forward.