Google No Code

---
name: google-no-code
description: Design Google Forms and wire Apps Script triggers (onFormSubmit) for email alerts, spreadsheet logging, and dynamic questions — no code editor required. 
category: Document Processing
source: antigravity
tags: [javascript, api, claude, ai, automation, design, spreadsheet, security, rag]
url: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/google-no-code
---


# Google No-Code Forms Automation

## Overview

Guides the user through building a Google Form in the Forms UI and connecting it to Google Apps Script triggers, without writing a custom integration or leaving the browser. Covers form design, the Apps Script editor, the `onFormSubmit` trigger, and small response-handling scripts that run automatically when a form is submitted.

## When to Use This Skill

- Use when the user wants to build a Google Form and automate what happens after submissions.
- Use when the user asks for email alerts, spreadsheet logging, or conditional handling of form responses.
- Use when the user wants Apps Script snippets to paste into a form bound script project.
- Skip this skill if the user needs custom UI, paid APIs, or a full standalone Apps Script application.

## How It Works

### Step 1: Define the form in the Forms UI

Create the form in Google Forms with clear questions, answer types (short answer, multiple choice, checkbox), and required fields. Match question IDs to what the script will need later. Add a description to the form so respondents know what to expect.

### Step 2: Open the bound Apps Script editor

In the form, go to `Extensions > Apps Script`. This opens a project bound to the form. The script can read each submission through the `e.response` event object.

### Step 3: Write the response handler

Add a function that accepts the `onFormSubmit` event, reads `e.response` with `getItemResponses()`, and then performs the desired action: send an email, write to a spreadsheet, or branch on answers.

### Step 4: Install the trigger

In Apps Script, go to the clock/triggers menu, select the `onFormSubmit` function, choose the event source **From form** and event type **On form submit**, then save and authorize. The function runs automatically on each new submission.

### Step 5: Test with a real submission

Submit a test response from a private/incognito window and verify the email, sheet row, or log arrives once. Check the Apps Script executions page (`Executions` in the editor) for errors and read the stack trace if something fails.

## Examples

### Example 1: Email notification on every response

```javascript
function onFormSubmit(e) {
  const response = e.response;
  const email = getEmail(response);
  MailApp.sendEmail({
    to: email,
    subject: "Form submission received",
    body: "Thank you. We have recorded your response."
  });
}

function getEmail(response) {
  const items = response.getItemResponses();
  for (const item of items) {
    if (item.getItem().getTitle().toLowerCase().includes("email")) {
      return item.getResponse();
    }
  }
  return Session.getActiveUser().getEmail();
}
```

### Example 2: Log each response to a Google Sheet

```javascript
function onFormSubmit(e) {
  const sheet = SpreadsheetApp.openById(SHEET_ID).getSheetByName("Responses");
  const itemResponses = e.response.getItemResponses();
  const row = [new Date()].concat(itemResponses.map(r => r.getResponse()));
  sheet.appendRow(row);
}
```

### Example 3: Branch on a multiple-choice answer

```javascript
function onFormSubmit(e) {
  const items = e.response.getItemResponses();
  for (const item of items) {
    if (item.getItem().getTitle().toLowerCase() === "priority") {
      const priority = item.getResponse();
      const subject = priority === "High" ? "[URGENT] " : "";
      MailApp.sendEmail({ to: MANAGER_EMAIL, subject: subject + "New submission", body: itemResponsesText(e) });
    }
  }
}
```

## Best Practices

- ✅ Test every trigger with a real submission before telling the user it works.
- ✅ Use clear, stable question titles so the script can match items by title instead of fragile indexes.
- ✅ Keep secrets and API keys in script properties, never hard-coded in the file.
- ✅ Add try/catch around handler logic and log errors with `Logger.log` so failures surface in the Executions page.
- ❌ Do not grant broad scopes; run with the minimum permission the form action needs.
- ❌ Do not send email to addresses that the form did not legitimately collect.

## Limitations

- Apps Script quotas apply (email rate limits, daily triggers, execution time); heavy volume needs review.
- Only form submissions trigger the event; edits to responses by users do not fire `onFormSubmit` by default.
- The skill produces scripts the user must paste, authorize, and deploy; it cannot create a Google Forms project by itself.
- Sheets integration requires the sheet's ID and permission, which must be confirmed with the user.

## Security & Safety Notes

- The script runs inside the user's Google account with the scopes it declares. Review the authorization prompt and grant only the minimum requested scope.
- Do not log, print, or embed passwords, OAuth tokens, or API keys in form scripts or shared files.
- Form responses can arrive from anyone the form is shared with; validate inputs before acting on them.
- Test in a controlled environment first; sending email or appending rows happens o