Using Make Connector with Rows

Quick Overview

The tutorial successfully demonstrates how to integrate Typeform submissions with the Rows spreadsheet platform using Make (formerly Integromat) by setting up a scenario that watches for new Typeform responses and automatically adds the data (First name, Last name, Email) as a new row in the specified Rows spreadsheet.

Key Points: The integration workflow is built in Make, connecting Typeform (as the trigger) to Rows (as the action) to automatically log form submissions. The Typeform module is configured to "Watch Responses" on a form titled "My branded typeform", set to check for new submissions every 1 minute. A new connection for Rows is established in Make using a newly generated API key from the Rows workspace settings. The Rows module is set up to "Add a Row" to the "Make demo" spreadsheet, specifically targeting the "Typeform response" table. The setup confirms the Rows table contains headers, and the corresponding Typeform fields (First name, Last name, Email) are successfully mapped to the respective columns (A, B, C) in the Rows table. After running the scenario once (using the 'All' option for initial run), a test submission filled with 'Saurabh', 'Choraria', and 'saurabh@rows.com' appeared correctly in the Rows spreadsheet, validating the connection.

Context: This video provides a step-by-step tutorial on automating data transfer between Typeform, a popular online form builder, and Rows, an AI-powered spreadsheet platform, utilizing Make (an integration platform) to bridge the two services. The process involves setting up triggers, creating necessary API connections for both platforms, and mapping the incoming form data fields to the correct columns in the destination Rows spreadsheet.

Detailed Analysis

The tutorial begins by navigating to the Rows platform workspace and creating a new scenario in Make. The first module added is Typeform, configured to "Watch Responses" (0:59), ensuring the workflow triggers whenever a new submission is received. Connection setup for Typeform is shown, using an existing connection. For the Form ID, the presenter selects "My branded typeform" (1:26), and ensures the "Completed" option is set to "Yes" (1:29). The scenario proceeds by adding a second module, Rows, configured to "Add a Row" (1:55). This requires creating a new Rows connection using a freshly generated API key obtained from the Rows account settings under the API section (2:14). After creating the connection, the presenter maps the output fields from Typeform to the input columns in the Rows table. Specifically, Typeform's "First name / Parent Group" maps to Column A, "Last name / Parent Group" maps to Column B, and "Email / Parent Group" maps to Column C (2:40-2:47). The Rows module is configured to use the "Make demo" spreadsheet and the "Typeform response" table, confirming that the table contains headers (2:35). Finally, the scenario is run once, initially fetching all existing data, and then a live test submission is performed on the Typeform itself (3:14). The successful execution, marked by green checkmarks on both modules (2:54), results in the test data appearing instantly in the corresponding row of the Rows spreadsheet (3:01), confirming the automation is functional.