appscript.dev

Google Forms automation

Notify, route, and post-process Google Forms responses automatically with Apps Script.

Notifications

Email, Slack, or SMS the right person on submit.

5 articles

Response handling

Validate, clean, and route incoming responses.

25 articles

Automatisation Intermédiaire Forms Gmail Drive Sheets

Trigger an onboarding sequence on form submit

Kick off tasks when a new Northwind hire submits their starter form.

Mis à jour le 17 oct. 2025

Automatisation Débutant Forms Sheets

Build a content-submission queue

Collect Northwind guest posts or ideas for review through a Form.

Mis à jour le 9 oct. 2025

Automatisation Intermédiaire Forms Sheets

Score sentiment in open-text feedback

Rate Northwind feedback comments without manual review — using the in-Sheet sentiment function.

Mis à jour le 5 oct. 2025

Automatisation Intermédiaire Forms Sheets

Build a peer-nomination and voting system

Collect and tally Northwind nominations for awards or initiatives — one ballot, anonymous.

Mis à jour le 1 oct. 2025

Automatisation Intermédiaire Forms Sheets Drive

Roll a form over each cycle

Archive old responses and reset for the next Northwind cycle — quarterly OKR check-ins.

Mis à jour le 27 sept. 2025

Automatisation Débutant Forms Sheets

Build an RSVP system with live headcounts

Track attendance and dietary needs for Northwind events — running count, live.

Mis à jour le 23 sept. 2025

Automatisation Intermédiaire Forms Sheets

Build a live dashboard of form responses

Visualise Northwind submissions as they arrive — counts, splits, sentiment.

Mis à jour le 19 sept. 2025

Automatisation Avancé Forms Gmail

Build a conditional intake-form router

Send long Northwind forms only to relevant respondents based on short pre-survey answers.

Mis à jour le 15 sept. 2025

Automatisation Intermédiaire Forms Sheets Gmail Drive

Build a form-driven expense claim system

Collect Northwind receipts via a Form and route them through approval for payment.

Mis à jour le 7 sept. 2025

Automatisation Avancé Forms

Auto-grade open responses against a rubric

Score and rank Northwind submissions with AI — keep grading consistent across reviewers.

Mis à jour le 3 sept. 2025

Automatisation Intermédiaire Forms Sheets Gmail

Build an asset or inventory request form

Track stock requests through approval — Northwind teammates ask, Awadesh approves, the warehouse ships.

Mis à jour le 30 août 2025

Automatisation Avancé Forms

Serve a form in multiple languages

Auto-translate one Northwind form into localised versions — same questions, different copies.

Mis à jour le 18 août 2025

Automatisation Avancé Forms Sheets

Build a 360-degree feedback collector

Gather and aggregate multi-rater reviews for Northwind teammates anonymously.

Mis à jour le 14 août 2025

Automatisation Intermédiaire Forms Docs Drive Gmail

Issue certificates after quiz completion

Generate a certificate Doc when someone passes a Northwind training quiz.

Mis à jour le 10 août 2025

Automatisation Intermédiaire Forms Sheets Gmail

Build a registration system with waitlists

Manage Northwind workshop signups and overflow — first N get a slot, the rest get a waitlist.

Mis à jour le 6 août 2025

Automatisation Intermédiaire Forms

Push form data to a CRM or external API

Send Northwind form submissions downstream to HubSpot, Notion, or a custom endpoint.

Mis à jour le 2 août 2025

Automatisation Débutant Forms

Auto-close a form at a capacity limit

Stop accepting Northwind RSVPs once a quota is hit — no overselling the workshop.

Mis à jour le 29 juil. 2025

Automatisation Intermédiaire Forms Sheets Gmail

Build a form-based help-desk ticket system

Convert Northwind support submissions into tracked tickets with an ID and status.

Mis à jour le 25 juil. 2025

Automatisation Intermédiaire Forms Sheets

Detect and flag spam or duplicate submissions

Filter junk before it reaches the Northwind response sheet.

Mis à jour le 21 juil. 2025

Automatisation Intermédiaire Forms Sheets

Refresh form dropdowns from a live Sheet

Keep Northwind form choices in sync with a source-of-truth Sheet — no manual editing.

Mis à jour le 17 juil. 2025

Automatisation Intermédiaire Forms Calendar

Create a calendar booking from a form

Schedule Northwind appointments from form data — slot, attendee, confirmation.

Mis à jour le 13 juil. 2025

Automatisation Intermédiaire Forms Gmail

Build a quiz with instant personalized feedback

Email scored Northwind quiz results with explanations the moment a quiz is submitted.

Mis à jour le 9 juil. 2025

Automatisation Intermédiaire Forms Docs Drive

Generate a PDF from each form response

Turn Northwind submissions into formatted documents stored under the right client folder.

Mis à jour le 5 juil. 2025

Automatisation Avancé Forms Sheets Gmail

Build a multi-stage approval form workflow

Chain Northwind forms for request, review, and sign-off — three approvals in sequence.

Mis à jour le 27 juin 2025

Voir les 25 dans Response handling →