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.

  1. An Owner opens Settings, then Integrations, and presses Connect next to Google Sheets, using the Google account your church uses. This is done once.
  2. Open Next steps, open a step that uses a Wells form, go to After sending and tap Google Sheet.
  3. Press Make a Google Sheet. Wells makes a sheet named after the form and adds the answers already sent.
  4. 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.