Skip to content

jackjaxryan-ui/n8n-access-request-alert

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

39 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

n8n Micro-Project

Google Form → Google Sheet → Email/Slack alert (Access Request – Media Team)

Portfolio summary

A small ops-style automation that routes access requests from a Google Form into email/Slack alerts, with simple triage rules.

What it demonstrates:

  • Workflow automation using n8n
  • Basic intake + routing logic (Contributor vs Viewer)
  • Runbook-style documentation (repeatable setup steps)

What this does

When someone submits a Google Form (“Access Request – Media Team”), the response is written to a linked Google Sheet. n8n watches for new rows, formats a message, then sends alerts:

  • If Requested Access = Contributor → notify Team Leads
  • Else (Viewer) → notify Admin

Optional: also post to Slack channel #access-requests.

Form fields

  • Name
  • Email
  • Role (Writer/SEO/Video/Lead)
  • Requested Access (Viewer/Contributor)
  • Notes

Message format

New Access Request: {Name} ({Role}) – {Requested Access} – {Email}

Quick start

  1. Create the Google Form + link to Google Sheets: docs/01-google-form-and-sheet.md
  2. Run n8n via Docker on Mac: docs/02-run-n8n-docker-mac.md
  3. Connect n8n to Google Sheets (OAuth2): docs/02b-google-oauth-n8n.md
  4. Import the workflow JSON and set credentials: docs/03-import-and-configure-workflow.md
  5. Submit a test form → verify email/slack: docs/04-demo-and-screenshots.md

Notes

  • Workflow JSON files are provided as reference. Credential IDs are instance-specific.
    See workflows/README.md.

About

n8n workflow: Google Form → Google Sheets → Email/Slack alerts with simple routing rules.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors