1. Help
  2. Workflows
  3. Google Sheets

Record Responses in Google Sheets

Introduction

This workflow will show you how to turn new form responses into new rows in a Google Sheets spreadsheet, in real-time.

Create a new form

On your Formcrafts dashboard click on Add Form → Start from scratch. Enter a Form name and hit enter. This will create a new form.

You can also create a new form by clicking on Add Form → Use a Template and selecting a template. This would allow you to skip this step. We have a large collection of customer support form templates that you can use.

Now add some basic fields to your form using the Add field button on the top-left corner of the form editor:

  1. Name (One line input)
  2. Email (Email)
  3. Comments (Comment)
Simple contact us form

Create a workflow

Click on the Workflows button on the top-left corner of the form editor, and then click on the Add workflow button.

Now edit the new workflow, and click on Add action. Under (select action) find Google Sheets, and click on Connect to Google Sheets, and proceed as directed.

Connect to Google Sheets workflow

Configure the action

Now that you have connected your Google Sheets account, you can configure the action. You have to select the file and sheet where you want to record the responses. This sheet must be blank.

Google Sheets record new responses workflow
Configuration for the Google Sheets workflow

Save and test

Click on the Preview button on the top-right corner of the form editor, and submit the form to test the workflow.

Formcrafts keeps a record of all successful and failed workflows which you can view using the Logs button on the top-left corner of the form editor.

Learn more about Workflow logs.

Google Sheets preview
New responses recorded in real-time

Notes:

  1. We do not recommend modifying this sheet manually, as it may break the workflow. You can view and copy the data to another sheet if you need to.
  2. The first row of the sheet will contain the field IDs, and the second row will contain the field labels.
  3. The first column of the sheet contains the timestamp of the response.