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.
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, Automate.io 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.
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
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!
After you pasted the webhook URL, switch back to Zapier and click
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
Testbutton 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.
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.
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.
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
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).
Link data to columns
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.
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.
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
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.