How to automatically create a new row or update an existing row in Google Sheets whenever a form response is submitted in Google Forms

A playbook always starts with a trigger, 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.

Integrate Google Sheets automation into your workflow to automatically create a new row or update an existing row in Google Sheets every time a form response is submitted in Google Forms.

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.

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 row in Google Sheets 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.