Automating4 Min.

How to automatically store form responses in Google Sheets and generate analysis reports

Connect your Tripetto form to Google Sheets to automatically store the form response data in a Google Sheets file and use that data to generate valuable analysis reports.


When to use

You can use this automation if you want to collect all data in your own Google Sheets file automatically. And once the data is in your Google Sheets file you can do all kinds of analysis with it.

Google Sheets documentation

This article will demonstrate how to get your Tripetto form data in Google Sheets, but it's not a guide to build analysis reports in Google Sheets. Click here for Google Sheets documentation.

Screenshot of a data report in Google Sheets
Collect and use form data in Google Sheets, for example to generate data analysis reports.

What you need

The scenario we describe in this article is an example of connecting Tripetto to other services, in this case Google Sheets. Click here for more general information about connecting Tripetto to other services.

For this scenario you will need the following:

  • Tripetto, to collect your form submissions;
  • Integromat, to connect your form data to other services;
  • Google Sheets, to store the form data and create analysis reports.

Integromat alternatives

There are alternatives to use for Integromat, for example Zapier, Pabbly Connect or even a custom webhook. Of course it's up to you to use your favorite automation tool.


How to use

These are the steps to take to automate the process of storing form data in Google Sheets.

Step 1 - Build Tripetto form

  • First make sure your Tripetto form collects the desired data.

The result of this step is your Tripetto form, which you will use to collect your data from your respondents.

Screenshot of Tripetto
Build your Tripetto form.

Step 2 - Prepare Google Sheets spreadsheet

  • In your Google Sheets account create a new file/spreadsheet.
  • Give your spreadsheet a name, for example Tripetto Form Results.
  • In the first row add the column header names of the data fields you want to store in this spreadsheet.

The result of this step is your Google Sheets spreadsheet with the desired column headers, that we will use later on in the process.

Screenshot of Google Sheets
Prepare your Google Sheets spreadsheet, with the columns header in the first row.

Step 3 - Connect Tripetto to Integromat

  • In your Integromat account add a new scenario.
  • Give your scenario a name, for example Add new row to Google Sheets for new Tripetto submission.
  • Add a Tripetto module to your Integromat scenario. As trigger select Watch Responses.
  • Connect your Tripetto form to that trigger, by copy-pasting the webhook URL from Integromat into your Tripetto form (AutomationsConnectionsIntegromat). Have a look at this article for the detailed description how to connect Tripetto to Integromat.
  • Test the connection, so Integromat receives the structure of your dataset.

The result of this step is that your Integromat scenario gets executed for each new form submission and you can use the data fields from your Tripetto form in the Integromat scenario.

Screenshot of Tripetto module in Integromat
Add a Tripetto trigger in your Integromat scenario.

Step 4 - Add new row to Google Sheets

  • Add a Google Sheets module to your Integromat scenario. As action select Add a Row.
  • Grant access to your Google account.
  • Under Spreadsheet select your earlier created Google Sheets spreadsheet file.
  • Under Table contains headers select Yes.
  • Integromat will now recognize the column header names that you prepared earlier. For each column name you can now select the corresponding data field from your Tripetto form. This is the part where you map the entered data from your Tripetto form to the columns in your Google Sheets spreadsheet file.

The result of this step is you now have automated sending the data from Tripetto to Google Sheets.

Screenshot of Google Sheets module in Integromat
Add a Google Sheets module in your Integromat scenario to add a new row.

Step 5 - Test and activate

  • Click Run once in Integromat to start testing your automation.
  • Fill out and submit your Tripetto form once.
  • Check if your Integromat scenario has been processed correctly. If so, check the Google Sheets spreadsheet to see if the data is indeed added as a new row.
  • Activate your scenario in Integromat.

From now on this scenario will be executed automatically for each new form submission! Every new submission will now automatically be added to your Google Sheets spreadsheet 🎉

Screenshot of Google Sheets
The data of each form submission has been added as a new row in Google Sheets.

Step 6 - Generate analysis reports (optional)

  • Now that your data comes into your Google Sheets spreadsheet automatically, you can use that data to generate all kinds of analysis reports.
  • It totally depends on your use case and wishes for the analysis how to set that up in Google Sheets. Click here for Google Sheets documentation.

The result of this step will be you get valuable insights in your collected data.

Screenshot of a data analysis report in Google Sheets
Example of a data analysis report with graphs.

Other examples

Tripetto lets you connect to 1.000+ services. We have made some step-by-step examples for often used scenarios:

In this article

    Help us improve