How to automatically add a new row to a Google Sheet every time a form response is submitted in Google Forms

Relay.app is an automation tool that lets you automate actions across Google Forms, Google Sheets, and many other apps. In this guide, we'll show you how to automatically run the “add row to sheet” action in Google Sheets for each form response submitted in Google Forms using Relay.app.
Google Forms logoGoogle Forms > Google Sheets
Trigger
Last triggered
Google Forms logoForm response submitted
Google Sheets logoAdd row to sheet
1

Set the Google Forms trigger as “New form submission”

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

Add the Google Forms trigger to initiate your playbook's actions whenever a form response is submitted. Click "Add trigger" in your playbook and choose "New form submission" from the dropdown menu under Google Forms.

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

2

Add the “Add row to sheet” step in Google Sheets

Integrate Google Sheets automation into your workflow to automatically add a new row to a Google Sheets every time a form response is submitted in Google Forms.

Click the "Add step" button, locate the "Add row to sheet" 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 add a new row to a Google Sheet whenever a form response is submitted in Google Forms without 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 Forms and Google Sheets

See all how-to guides ➔

What will you automate?

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