Automating7 Min.

How to automate a webhook for each new result (using Zapier)

By connecting Tripetto to a webhook you can do all kinds of actions with your response data, like pushing it to a spreadsheet editor (Microsoft Excel/Google Sheets) or a database, or trigger other follow-up actions.

The goal

In this article, we will show an example covering how to create a new row in a Google Sheets document for each new response that's entered in your Tripetto form. We will set up the Zapier connection and link the available fields in the Tripetto form to the corresponding columns in the Google Sheets document. In the end, we will get a Google Sheets document that's filled automatically with all response data.

Sidenote 1 - Zapier alternatives

In this example we describe a connection with Zapier, but you can also use any other automation platform like Integromat, or n8n. As long as the platform provides a webhook integration to receive data from Tripetto, it should be possible to use.

Sidenote 2 - Improvements

Ideally we'd be offering on-the-go Tripetto apps inside all automation platforms. That would make integrations even easier, but at the moment we don't have those. So in this article we will help you with the current possibilities, using webhooks. And we promise: it's still no rocket science.

Webhooks by Zapier

The method we're going to use is the 'Webhook by Zapier'. You can find all details on that with the link below.

We use Zapier in this article, but you can also use other automation tools that support webhooks.

Step 1 - Receive data in your Zap

Zapier works with Zaps. Inside a Zap you can specify what data is coming in and how you want to process that data.

So the first step is to create a new Zap. In Zapier, click Make a Zap!.

After creating the Zap, you'll immediately see the first block called When this happens .... This is where we are going to collect the responses from Tripetto.

Choose app

In the search bar search for Webhooks by Zapier and click the corresponding app button in the search results. The webhook app will be added to your Zap.

Choose trigger event

Next step, select the trigger that receives new responses. From the dropdown, select Catch Hook.

The settings of the webhook block.

Click Continue.

Set up webhook

Zapier will now show the webhook URL, which you need in Tripetto. So, copy the webhook URL and switch to Tripetto. At the top menu bar of the form builder click Automate. The Automate pane will show up on the right side of the form builder.

The third feature of this screen is Webhook. After enabling the feature Notify an external service when someone completes your form you can paste the webhook URL you got from your new Zapier Zap.

Important: leave the option Send raw response data to webhook disabled, so don't select that option!

Copy-paste the webhook URL to Tripetto (of course including your own Zap's id's).

After you pasted the webhook URL, switch back to Zapier and click Continue.

Test webhook

Next up, Zapier wants to test if the Zap is receiving data. To test this, we're going to submit a test response in our Tripetto form.

First let Zapier know you're going to submit some test data, by clicking Test & Review. Zapier now enables your Zap temporarily to receive data.

Now, switch back to Tripetto and submit an entry to your Tripetto form. The best way to do so, is by just completing your form once.

It's recommended to enter some proper test data inside your test response, by which you can recognize each field in your form later on. You can use the Test button in Tripetto, but that will not send proper data to your webhook.

After you completed your form, return to Zapier and you will see Zapier has found some data. This means the connection between your Tripetto form and Zapier works! When you click on the response, you'll recognize your test data.

Zapier has received some test data.

Finally click Done Editing to proceed to the next step.

Step 2 - Create Spreadsheet Row in Google Sheets

The second step is to use the data from the Tripetto form, in this case use it to create a new row in a Google Sheet. Zapier already created a second block, called Do this .... Click Edit to fill in this block the way we want.

Choose app

In this example we want to add a Google Sheets block, so search for the app Google Sheets and click the corresponding app button in the search results.

Choose action event

Next step, select the action. As we want to create a new row for each response, select Create Spreadsheet Row from the dropdown.

The settings of the Google Sheets block.

Click Continue.

Choose account

You now can link your Google Drive where your designated Google Sheet is/will be located. By connecting your Google account, you give Zapier the necessary access.

After selecting your Google account, click Continue.

Prepare a Google Sheet

To make the next step a bit easier, it is recommended you first create a Google Sheet that you want to write the data to. So go to your Google Drive, create a Google Sheet and ideally also prepare the column headers you want to use in your sheet.

After you've prepared your target file, return to Zapier.

Select target file

Now select the file you just created, so Zapier will know where to write to. It consists of three settings:

  • Drive - Select the right drive if your Google account has multiple drives in it;
  • Spreadsheet - Select the file you want to write to;
  • Worksheet - Select the worksheet inside the selected file where you want to write to (in most cases you only have one worksheet).

Now the real magic comes in. Zapier will now show the column headers you previously added to your selected Google Sheets file. Now you can link those column headers to the data that Zapier receives in the webhook from the Tripetto form.

For each column you can now select the desired data. You can select the corresponding data fields that you tested with in step 1. Zapier will also show the test data that's inside that field, so you can easily recognize each Tripetto field and link it to the corresponding column in your Google Sheet.

Repeat this for every column you want to fill with response data.

The settings of the Google Sheets file.

Click Continue.

Test sending data

Lastly Zapier will test if it's able to send the data correctly to the Google Sheet and the right columns. You'll see an overview of that test and you can click Test & Review.

The result of the test of the data.

Click Done Editing.

Enable your Zap

The setup of your Zap is now done, but your Zap is still in test mode. To really let the Zap receive response data, you'll need to enable it. Use the big switch at the right top corner to switch if from Off to On.

If this is your first Zap, you might need to confirm your Zapier account, by following the confirmation steps Zapier provides.

And that's it! Every response you get on your Tripetto form will now be converted into a new spreadsheet row automatically!

Discover the possibilities!

In this article, we showed an example of how to create a new spreadsheet row, but Zapier has lots of integrations you can use. Take a look at their apps overview what other integrations you can use. Just make sure you configure the first two steps as described in this article and then integrate it with the app you want.

In this article

    Help us improve