GoogleSheetsTrigger Automate

For Google Sheets, this automated workflow triggers a message to be sent to a Discord channel whenever a new row is added or an existing row is updated. It formats the data into a clear ASCII table, ensuring timely communication of important updates, enhancing collaboration and decision-making.

7/8/2025
4 nodes
Medium
manualmediumgooglesheetstriggerdiscordsticky notecommunicationbot
Categories:
Communication & MessagingManual TriggeredData Processing & AnalysisMedium Workflow
Integrations:
GoogleSheetsTriggerDiscordSticky Note

Target Audience

This workflow is ideal for:
- Investors: Who need real-time updates on their investments from Google Sheets.
- Discord Community Managers: Looking to keep their channels updated with the latest data.
- Data Analysts: Who require automated notifications for data changes in Google Sheets.
- Small Business Owners: Needing a simple way to communicate updates without manual effort.

Problem Solved

This workflow addresses the challenge of keeping team members and stakeholders informed about changes in investment data stored in Google Sheets. It automates the process of sending updates to a Discord channel whenever a new row is added or an existing row is updated, thus eliminating the need for manual checks and notifications.

Workflow Steps

  • Trigger: The workflow begins with the Google Sheets Trigger. It checks for new or updated rows in the specified Google Sheet at 1-minute intervals.
    2. Data Retrieval: When a change is detected, the workflow retrieves the relevant data from the Google Sheet.
    3. Data Conversion: The Convert to ASCII table node processes the data to format it into a readable ASCII table, focusing on key columns such as Security Code, Price, and Quantity.
    4. Message Sending: Finally, the Send message node sends the formatted ASCII table to the specified Discord channel via a webhook, ensuring that all stakeholders receive timely updates.

    • Customization Guide

    To customize this workflow:
    - Google Sheets Configuration: Update the sheetName and documentId parameters in the On new or updated row node to point to your specific Google Sheet.
    - Columns to Watch: Modify the columnsToWatch parameter to include other columns you want to monitor for changes.
    - Discord Webhook: Change the webhookUri in the Send message node to your Discord webhook URL to direct messages to your preferred channel.
    - Message Formatting: Adjust the jsCode in the Convert to ASCII table node to include additional columns or change how data is presented in the message.