Automate Send form data to Google Sheet
Automating the process of sending form data to Google Sheets involves setting up a workflow where form responses are automatically recorded in a Google Sheets document. This eliminates the need for manual data entry and allows for seamless data collection and analysis.
Setting up Google Sheet Integration
To add the new workflow action for form submissions data to Google Sheet, follow these steps:
- Make sure you have an account on Google Account if not.
- Log in to your dashboard and navigate to the the “Apps” Tab
- Click on Google Sheet “Connect”. This will bring an authorising window for you to authorise Google sheets. Here select the google account if not already logged in.
- Select all the required option while connecting to Google Sheet account and click “Allow”
- Now navigate to the “Forms” tab and select the form for which you want to set up Google sheet.
- Under the selected form page navigate to the “Workflows” Tab
- Under the workflows click on the “Actions” and select “Add action” this will bring up a new window.
- Here select the App as “Google Sheet” and Connection which was connected previously and Select the “Google Sheet Workspace Name” and “Google Sheet Name”.
- After Selecting all the options click on “Add” and test the Googlesheet workflow action by submitting a test form on your website and verifying that the new data is recieved in Googlesheet.
Toggling the Google Sheet Workflow
Once you have added the Google Sheet action to the form’s workflow, you can toggle the workflow action by:
- Navigate to the the “Workflow” tab under the selected form
- Just click on the toggle switch on the Google Sheet action to pause or resume the workflow.
Troubleshooting Google Sheet Workflow.
If you encounter any issues with Google Sheet workflow, such as not receiving notifications on your Google Sheet workspace, you can troubleshoot the issue by:
- Verify the connected Google Sheet workspace while authorising the connection.
- Reconnecting the Google Sheet connection by clicking the the reconnect button under the “Apps” tab and reconfigure the options according to your preference.
- Test the workflow by submitting the test submission on the form.