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.

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??

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.

 

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.

@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! 

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! :)

Terms & Conditions