Best answer

Webhook POST for Google form response submission

  • 7 April 2021
  • 4 replies
  • 274 views

Userlevel 1

I am trying to a create a zap to push the responses of Microsoft forms to Google form through the POST method of Webhook.

So the trigger is on Microsoft excel for web in which all the responses are stored in real-time. And then the Action has to be Google form response submission. I have another script linked in the Google form which will be triggered only when the Form is submitted. And the Zapier Action for this does not actually submit the form response but rather directly adds the response as a new row in the response sheet.

So I thought so trying out webhook to do achieve this, but sadly I don't know how to use Webhooks. I found a solution online where I can automatically submit a form response with the help of a prefilled URL:
Eg: https://docs.google.com/forms/d/e/1FAIpQLSdDCmmHjGT8NlztYek5Tfr9_BYysakwg7l-fIawCSf2IDLu2g/formResponse?usp=pp_url&entry.225475901=rikita.s@tatvic.com&entry.1434046471=Task+ID-100&entry.1039880062=Approved&entry.1725448845=No+comments&submit=Submit

As I don't know my way around webhooks so can someone help me validate this option??

icon

Best answer by SamB 22 October 2021, 17:47

View original

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

Badge +4

Hi @Pallavi,

The reason why the data is going into a gsheet instead of filling out the gform is because that is how google likes to store their form data. Submitting another gform vs adding another row of data will do the same thing.

Since it sounds like you have another automation triggering off of a submission from gforms, another way around this would be to make sure the gform data is linked to a spreadsheet, that will auto populate the responses in the sheet. Then you could adjust the triggering event of the other automation to trigger off of a new row added to that spread sheet. This would allow the microsoft form zap to add another row of data, and the other automation would still trigger.

 

Hope this helps.

 

Userlevel 1

Hi @XRay Tech,

Thanks for the clarification and yes I too thought of that workaround. But the script I am trying to trigger is specifically for the Form responses and not for sheet entries. That is why I am looking for a way through Webhooks using the link I shared in my post. That URL allows me to submit an actual form response and Form submission scripts can also be triggered through it.

Userlevel 2
Badge

@Pallavi did you still need help with this workflow? And to clarify, sending the Excel data directly into a Google Sheet (where the form responses are being collected) is not an option, correct?

 

Let us know! 

Userlevel 7
Badge +11

It’s been a while so @Pallavi has likely already got this all figured out, but in case anyone else is looking for a way to do this, here’s an article that explains how to submit a Google Form response using a webhook:

Hope that helps! :)