Google Forms

Create and manage Google Forms - create forms, add questions, batch updates, and retrieve form data

Overview

Google Forms tools allow you to programmatically create and manage Google Forms, add questions, perform batch updates, and retrieve form information. These tools provide comprehensive form management capabilities for surveys, feedback collection, and data gathering.

Key Features

• GOOGLE_FORMS_CREATE_FORM: Create new Google Forms
• GOOGLE_FORMS_ADD_QUESTIONS: Add questions to existing forms
• GOOGLE_FORMS_BATCH_UPDATE: Perform batch updates on forms
• GOOGLE_FORMS_GET_FORM: Retrieve form information and structure

Authentication

These tools require Google OAuth credentials with Google Forms API access. You need to set up OAuth credentials through the Google Cloud Console and enable the Google Forms API.

Note: Treat API keys as sensitive information and never commit them to public repositories.

Tools

GOOGLE_FORMS_CREATE_FORM

Create a new Google Form.

Input:

• title (string, required): The form title
• description (string, optional): Form description
• document_title (string, optional): Document title (defaults to form title)

Output:

• form_id: Unique identifier for the created form
• form_url: Direct URL to the form
• edit_url: URL to edit the form
• response_url: URL to view responses

GOOGLE_FORMS_ADD_QUESTIONS

Add questions to an existing Google Form.

Input:

• form_id (string, required): ID of the form to modify
• questions (array, required): Array of question objects containing:
  • title (string, required): Question title
  • type (string, required): Question type (“multiple_choice”, “text”, “paragraph_text”, “checkboxes”, “dropdown”, “linear_scale”, “multiple_choice_grid”, “checkbox_grid”, “date”, “time”, “file_upload”)
  • required (boolean, optional): Whether the question is required
  • options (array, optional): Options for choice-based questions
  • description (string, optional): Question description

Output:

• updated_form_id: Form ID
• question_ids: Array of IDs for the added questions
• form_url: URL to the updated form

GOOGLE_FORMS_BATCH_UPDATE

Perform batch updates on a Google Form.

Input:

• form_id (string, required): ID of the form to update
• updates (array, required): Array of update requests containing:
  • update_type (string): Type of update (“update_form_info”, “update_item”, “move_item”, “delete_item”)
  • update_data (object): Update-specific data

Output:

• form_id: Updated form ID
• update_results: Results of each update operation
• form_url: URL to the updated form

GOOGLE_FORMS_GET_FORM

Retrieve information about a Google Form.

Input:

• form_id (string, required): ID of the form to retrieve

Output:

• form_info: Complete form information including:
  • form_id: Form identifier
  • title: Form title
  • description: Form description
  • questions: Array of all questions with their settings
  • settings: Form settings (collect emails, response limits, etc.)
  • response_count: Number of responses received

Examples

Example: Create a New Form

- id: create_feedback_form
  tool: GOOGLE_FORMS_CREATE_FORM
  config:
    - name: oauth_credentials
      value: "{{secrets.GOOGLE_OAUTH_CREDENTIALS}}"
  input:
    - name: title
      value: "Customer Feedback Survey"
    - name: description
      value: "Help us improve our services by sharing your feedback"
    - name: document_title
      value: "Customer Feedback Survey 2024"

Example: Add Questions to Form

- id: add_questions
  tool: GOOGLE_FORMS_ADD_QUESTIONS
  config:
    - name: oauth_credentials
      value: "{{secrets.GOOGLE_OAUTH_CREDENTIALS}}"
  input:
    - name: form_id
      value: "{{steps.create_feedback_form.result.form_id}}"
    - name: questions
      value:
        - title: "How would you rate our service?"
          type: "linear_scale"
          required: true
          description: "Rate from 1 (Poor) to 5 (Excellent)"
        - title: "What could we improve?"
          type: "paragraph_text"
          required: false
          description: "Please provide detailed feedback"
        - title: "Would you recommend us to others?"
          type: "multiple_choice"
          required: true
          options:
            - "Definitely"
            - "Probably"
            - "Not sure"
            - "Probably not"
            - "Definitely not"

Example: Retrieve Form Information

- id: get_form_details
  tool: GOOGLE_FORMS_GET_FORM
  config:
    - name: oauth_credentials
      value: "{{secrets.GOOGLE_OAUTH_CREDENTIALS}}"
  input:
    - name: form_id
      value: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"

Example: Batch Update Form

- id: batch_update_form
  tool: GOOGLE_FORMS_BATCH_UPDATE
  config:
    - name: oauth_credentials
      value: "{{secrets.GOOGLE_OAUTH_CREDENTIALS}}"
  input:
    - name: form_id
      value: "{{steps.create_feedback_form.result.form_id}}"
    - name: updates
      value:
        - update_type: "update_form_info"
          update_data:
            title: "Updated Customer Feedback Survey"
            description: "Updated description for our feedback survey"
        - update_type: "update_item"
          update_data:
            item_id: "question_1"
            title: "Updated question title"

Question Types

Supported Question Types:

• multiple_choice: Single selection from options
• checkboxes: Multiple selections from options
• dropdown: Dropdown menu selection
• text: Short text input
• paragraph_text: Long text input
• linear_scale: Rating scale (1-5, 1-10, etc.)
• multiple_choice_grid: Grid of multiple choice questions
• checkbox_grid: Grid of checkbox questions
• date: Date picker
• time: Time picker
• file_upload: File upload field

Use Cases

• Customer feedback collection
• Survey and questionnaire creation
• Event registration forms
• Employee feedback and HR surveys
• Educational assessments and quizzes
• Market research and data collection
• Application and contact forms
• Automated form generation from templates