Skip to main content

Documentation – Google Sheets to Slack Automation (Row Add Trigger)

1. Purpose​

This workflow automates the notification process when new form submissions are added to a Google Sheet. Whenever a new row is added to the specified Google Sheet, the workflow automatically sends a formatted Slack notification to the team channel with all relevant submission details. This ensures immediate visibility of new form submissions without manual monitoring.

2. Trigger​

Type: Google Sheets Trigger

Details:

The workflow is triggered automatically when a new row is added to the configured Google Sheet. The trigger monitors the sheet for new row additions and initiates the workflow execution immediately upon detection.

Event: rowAdded - Triggered when a new row is inserted into the Google Sheet

Google Sheet: Website Details for Accessibility Audit (Responses)

Credentials: Google Sheets API (stored in n8n credentials)

3. Step-by-Step Process​

Step 1: Google Sheets Trigger​

What happens here: Monitors the configured Google Sheet for new row additions. When a new row is detected, the trigger fires and passes the row data to the next step.

What input it uses:

  • Google Sheet ID and worksheet configuration
  • Google Sheets API credentials

What output it produces: Row data containing all column values from the newly added row, including:

  • Timestamp
  • Full Name
  • Email Address
  • Mobile Number
  • Website/App URL
  • Web Page URLs (multiple URLs if provided)
  • Platform Where Website/App is Hosted
  • Framework or Site Builder Used
  • Testing Framework Used
  • 3rd Party Plugins Used
  • Test Login Credentials (if restricted pages exist)

Why this step is needed: Provides the entry point for the workflow, automatically detecting new form submissions without requiring manual intervention or polling.

Event Type: rowAdded

Step 2: Send a message​

What happens here: Constructs a formatted Slack message using the column data from the newly added Google Sheet row and sends it to the designated Slack channel.

What input it uses:

  • All column values from the Google Sheets trigger
  • Slack channel configuration
  • Slack API credentials

What output it produces: Slack message delivery confirmation

Why this step is needed: Notifies the team immediately when new form submissions are received, ensuring timely follow-up and visibility of all submissions.

Slack Channel: #sebi-form-submissions

Message Format: The Slack message includes all mapped column details formatted clearly:

  • Timestamp - When the form was submitted
  • Full Name - Submitter's full name
  • Email Address - Contact email
  • Mobile Number - Contact phone number
  • Website/App URL - Primary website or application URL
  • Web Page URLs - Additional URLs if provided (supports multiple URLs)
  • Platform Where Website/App is Hosted - Hosting platform information
  • Framework or Site Builder Used - Technology stack details
  • Testing Framework Used - Testing tools information
  • 3rd Party Plugins Used - Plugin and integration details
  • Test Login Credentials - Login credentials if restricted pages exist

Credentials: Slack API (stored in n8n credentials)

4. Workflow Logic Summary​

The workflow executes the following sequence from start to finish:

  1. Monitors Google Sheet for new row additions
  2. Detects new row when a form submission is added to the sheet
  3. Extracts row data including all column values (Timestamp, Full Name, Email, Mobile, URLs, Platform details, Framework info, Testing details, Plugins, Credentials)
  4. Constructs Slack message with all mapped column details formatted clearly
  5. Sends notification to #sebi-form-submissions Slack channel

This automated process ensures that every new form submission is immediately visible to the team via Slack, eliminating the need for manual sheet monitoring and ensuring no submissions are missed.

Expected Outcome: On every new row addition, exactly one Slack notification is sent with all mapped column details formatted clearly.

5. Diagram / Screenshot​

Wally SAM.GOV Unauthorised Workflow Diagram

6. Dependencies​

This workflow depends on external APIs and third-party platforms to function properly.

External APIs​

Google Sheets API

  • Endpoint: Google Sheets API (via n8n Google Sheets node)
  • Method: GET (for reading sheet data)
  • Purpose: Monitor Google Sheet for new row additions and retrieve row data
  • Requires Auth: Yes (OAuth 2.0)
  • Credentials: Google Sheets API (stored in n8n credentials)
  • Usage: Triggers workflow when new rows are added to the configured sheet
  • Configuration:
    • Sheet ID: 1ghZxOvwRmf9O3wVQh35CSxrbJ49H8Dy6UaPFKULk1W0
    • Worksheet GID: 1418234621
    • Event: rowAdded

Third-Party Services​

Slack API

  • Purpose: Team notifications for new form submissions
  • Usage: Sends formatted notifications to #sebi-form-submissions channel with all submission details
  • Configuration: Slack webhook integration or Slack API
  • Channel: #sebi-form-submissions
  • Credentials: Slack API (stored in n8n credentials)
  • Message Content: Includes all mapped Google Sheet columns:
    • Timestamp
    • Full Name
    • Email Address
    • Mobile Number
    • Website/App URL
    • Web Page URLs (multiple)
    • Platform Where Website/App is Hosted
    • Framework or Site Builder Used
    • Testing Framework Used
    • 3rd Party Plugins Used
    • Test Login Credentials

n8n Instance​

Workflow URL: https://agent.fsgarage.in/workflow/hOyuudADpIperavt

Workflow Name: Personal / Google-sheet Automation -Wally

Workflow ID: hOyuudADpIperavt

n8n Instance URL: https://agent.fsgarage.in

Google Sheet​

Sheet URL: https://docs.google.com/spreadsheets/d/1ghZxOvwRmf9O3wVQh35CSxrbJ49H8Dy6UaPFKULk1W0/edit?gid=1418234621#gid=1418234621

Sheet ID: 1ghZxOvwRmf9O3wVQh35CSxrbJ49H8Dy6UaPFKULk1W0

Worksheet GID: 1418234621