How to automatically delete a specific row in Google Sheets every time a response is submitted in Google Forms

In this how-to guide

How to automatically delete a specific row in Google Sheets every time a response is submitted in Google Forms
1. Set the Google Forms trigger as “Form response submitted”
2. Add the “Delete row” step in Google Sheets
3. Activate your playbook
Learn more about integrating with Google Forms and Google Sheets
Related blog posts
More how-to guides featuring Google Forms and Google Sheets

Integrationsarrow_forwardGoogle Forms Integrationsarrow_forwardGoogle Forms + Google Sheets Integrationsarrow_forward

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 “delete row” action in Google Sheets for each form response submitted in Google Forms using Relay.app.

Try it in Relay.app

Google Forms > Google Sheets

Trigger

Last triggered

Form response submitted

Delete row

Set the Google Forms trigger as “Form response submitted”

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 every time a response is submitted. Click "Add trigger" in your playbook and choose "Form response submitted" 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.

Add the “Delete row” step in Google Sheets

Integrate the Google Sheets automation into your playbook to ensure the prompt deletion of a specific row in Google Sheets every time a response is submitted in Google Forms.

Click the "Add step" button, locate the “Delete 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.

Activate your playbook

Activating your playbook is the last step in the process. Once you turn it on, it will automatically delete a specific row in Google Sheets every time a 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.