Get form response - Automate.ax

googleForms.getResponse returns a response by immutable ID, with answers in form display order.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleForms } from "automate.ax/google-forms"

export default automation("Load a survey response", () => {
  onDashboardRun({ title: "Load a survey response" })

  googleForms.getResponse({
    form: "form-id",
    responseId: "response-id",
    includeQuestionTitles: true,
  })
})

Inputs

Provide form and responseId. includeQuestionTitles defaults to true. Set it to false to avoid the additional form-metadata request. Second argument { account } selects the Google Account.

Output

interface FormResponse {
  formId: string
  responseId: string
  createTime?: string
  lastSubmittedTime?: string
  respondentEmail?: string
  totalScore?: number
  answers: Array<{
    questionId: string
    questionTitle?: string
    values: string[]
    files: Array<{ fileId: string; fileName: string; mimeType: string }>
    grade?: {
      correct?: boolean
      score?: number
      points?: number
      correctAnswers: string[]
      feedback?: string
      whenRight?: string
      whenWrong?: string
    }
  }>
}

Text answers can contain multiple values. File-upload answers use files and leave values empty. respondentEmail and quiz fields are present only when the form collects or grades them.