Best answer

How to get google response data into google forms

  • 15 April 2021
  • 4 replies
  • 28 views

Userlevel 1

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 

icon

Best answer by mrmac2you 11 June 2021, 21:25

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.

View original

4 replies

Userlevel 7
Badge +10

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

Userlevel 1

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. 

Userlevel 7
Badge +10

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

Userlevel 1

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.

Reply