Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Basics of Webhooks from other applications via SurveyGizmo

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.

 

 

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    you could set this up with Zapier.

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

  • Jacob Hayslett
    edited 01/04/17

    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
    J. Craig Williams Top Contributor

    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
    dAVE Inden Employee

    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.

This discussion has been closed.