How to automatically create a new row or update an existing one in Google Sheets whenever there is a new response in Typeform

Relay.app is an automation tool that lets you automate actions across Google Sheets, Typeform, and many other apps. In this guide, we'll show you how to automatically run the “create or update row” action in Google Sheets for each new response in Typeform using Relay.app.
Typeform logoTypeform > Google Sheets
Trigger
Last triggered
Typeform logoNew response
Google Sheets logoCreate or update row
1

Set the Typeform trigger as “New response”

A playbook always starts with a trigger, which is responsible for detecting changes in your connected applications and responding accordingly.

Add the Typeform trigger to initiate your playbook's actions every time there is a new response. Click "Add trigger" in your playbook and choose "New response" from the dropdown menu under Typeform.

If you still need to connect your Typeform account to Relay.app yet, a prompt will guide you through the process.

2

Add the “Create or update row” step in Google Sheets

Integrate Google Sheets automation into your playbook to automatically create a new row or update an existing one in Google Sheets every time there is a new response in Typeform.

Click the "Add step" button, locate the “Create or update row” automation for Google Sheets, and input the mandatory and relevant details.

If your Google Sheets account still needs to be connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Google Sheets account.

3

Activate your playbook

Activating the playbook is the last step in the process. Once you turn it on, it will automatically create a new row or update an existing one in Google Sheets every time there is a new response in Typeform without requiring manual intervention.

To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.

More how-to guides featuring Google Sheets and Typeform

See all how-to guides ➔

What will you automate?

Sign up and get started with your first Relay.app workflow today.
Background imageBackground image