How to add new Jotform responses to a Google Sheet
Create your playbook
To automate this workflow, you'll create a Relay playbook that runs automatically every time there is a new form submission in Jotform.
Get started by signing up at Relay.app and clicking "New playbook." Give your new playbook a unique name and emoji.
Add the Jotform trigger
Every playbook starts with a trigger. The trigger detects changes in your connected apps and runs your playbook in response.
Click "Add trigger" and select "New form submission" under Jotform. Then, select the specific form you're working with. If this is your first time using a Jotform integration in Relay, you'll be prompted to connect your Jotform account.
Now, your playbook will run automatically with each new form submission in Jotform.
Add the Google Sheets Add row automation
Now you can easily add a new row in Google Sheets whenever Jotform receives a new submission. Add a new step and select "Add row" from the list of Google Sheets automations.
Connect Google Sheets to Relay if you haven't already, then specify the target sheet, where to insert the new data, and what values to add. You can reference fields from Jotform to automatically pass along the right data.
Turn on the playbook
When you are done with the playbook, it's time to turn it on.
The playbook will now run automatically with each new form submission in Jotform. You can also click "Check now" to do a manual check whenever you'd like.