- How to automatically add a new row to a Google Sheet every time a form response is submitted in Google Forms
- 1. Set the Google Forms trigger as “New form submission”
- 2. Add the “Add row to sheet” 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
How to automatically add a new row to a Google Sheet every time a form response is submitted in Google Forms
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.
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.
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.