Basics of Webhooks from other applications via SurveyGizmo

Jacob Hayslett

Hi, I am new to attempting to work with these Webhooks and could use some help.

 

I use SurveyGizmo as a surveying tool to gather information from a large amount of users. I am trying to build it to where everytime a response is made in SurveyGizmo, it will transmit that data to Smartsheet to store on a sheet.

 

SurveyGizmo has the ability to create a Webhook (http post) that sends data to a URL. I am able to test and send data to RequestBin. Now, I am trying to figure out how to retrieve the data via Smartsheet and store it.

 

When reading the API information it seems a lot of it is geared towards using outside applications to modify and alter data and sheets, where I am just trying to retrieve and store data.

 

If someone might be able to help with the right information that will get me where I want to go, it would be highly appreciated!

 

Thank you for taking the time to read this.

 

 

Brett Evans

you could set this up with Zapier.

https://zapier.com/app/editor/template/5985

Jacob Hayslett

Thanks Brett for the suggestion, but I was really hoping to get more on the development side of things. I have HTML, CSS, JS, and minor PHP experience and am wondering what do I need to learn to build an integration between two applications like this. It would be great if someone can put the whole connection overview into layman terms.

 

Thanks!

J. Craig Williams

Jacob,

 

Start here:

https://www.smartsheet.com/developers

 

This section of the API doc (for Python, easily changed once you land there)

http://smartsheet-platform.github.io/api-docs/?python#intro-to-webhooks

explains the concept - but from the view of Smartsheet being the webhook.

Check your API doc for SurveyGizmo and there should be / could be something similar.

 

Depending on how that works, you'll want to check out either Add Row(s) or Update Row(s) in the Smartsheet API doc:

http://smartsheet-platform.github.io/api-docs/?python#update-row(s)

 

That should get you started.

 

Craig

dAVE Inden

Using the Smartsheet API you would need to build your own process to sit in the middle of Smartsheet and SurveyGizmo. It could receive the webhook from SurveyGizmo and use that data to send a request to Smartsheet and create the row in your sheet.

 

As Brett Evans pointed out above, it looks like this could be accomplished with Zapier. This looks like a simpler approach to building your own process and can create the new rows for you. I would usggest starting there and see if it works for your process.