Send form answers to Google Sheets
Add each new answer as a row in your own Google Sheet.
In your dashboardNext steps
If your team follows up from a spreadsheet, each Wells form can also add its answers to a Google Sheet in your church’s Google Drive. Answers still arrive in your Forms inbox as well.
- An Owner opens Settings, then Integrations, and presses Connect next to Google Sheets, using the Google account your church uses. This is done once.
- Open Next steps, open a step that uses a Wells form, go to After sending and tap Google Sheet.
- Press Make a Google Sheet. Wells makes a sheet named after the form and adds the answers already sent.
- From then on, each new answer is added as a row within a few seconds.
Each question has its own column, with the time the form was sent first. If you add a question later, it gets a new column at the end. Wells can only see and change the sheets it makes, never anything else in your Google Drive.