In this how-to guide

How to automatically send Slack direct messages whenever a new row is added to your Google Sheets
1. Set the Google Sheets trigger as “Row added”
2. Add the “Send DM” step in Slack
3. Activate your playbook
Learn more about integrating with Slack and Google Sheets
Related blog posts
More how-to guides featuring Slack and Google Sheets

Integrationsarrow_forwardSlack Integrationsarrow_forwardSlack + Google Sheets Integrationsarrow_forward

How to automatically send Slack direct messages whenever a new row is added to your Google Sheets

How to automatically send Slack direct messages whenever a new row is added to your Google Sheets

Relay.app is an automation tool that lets you automate actions across Slack, Google Sheets, and many other apps. In this guide, we'll show you how to use Relay.app to automatically run the Slack “Send DM” action for each Google Sheets “Row added” event.

Try it in Relay.app

Google Sheets > Slack

Trigger

Last triggered

Row added

Send DM

1

Set the Google Sheets trigger as “Row added”

Add the Google Sheets trigger to initiate your playbook's actions whenever a new row is added.

To do this, click "Add trigger" in your playbook. Select the "Row added" trigger option from the dropdown menu under Google Sheets. It will enable your playbook to automatically identify newly added rows and trigger necessary actions.

If you still need to connect your Google Sheets account to Relay.app, a prompt will guide you through the connection process.

2

Add the “Send DM” step in Slack

Integrate Slack automation into your playbook to ensure that you receive timely updates on new rows added in Google Sheets.

Select "Add Step" and then find the "Send DM" automation for Slack. Enter all the required details, including the receiver's name and the body of the message containing detailed information.

If you still need to connect your Slack account to Relay.app, you will be prompted to complete that connection. Ensure you allow the necessary permissions for Relay.app to send direct messages through your Slack account.

3

Activate your playbook

Activating your playbook is the last step in the process. Once you turn it on, it will automatically send Slack direct messages whenever a new row is added to your Google Sheets without requiring manual intervention.

To activate your playbook, click the toggle button in the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.

Learn more about

See all appsarrow_forward

See all blog posts ➔

Start multiple Playbook runs at once with Batch Triggers

Batch riggers in Relay.app let you start multiple runs at once for the same Playbook. For example, you may use batch triggers to set off mail merge campaigns, or kick off a playbook on a weekly periodic schedule that checks in with the Account Executives for all stale Deals in sales pipeline in HubSpot.

Thijs van As

The Best Form Automation Software in 2024

Looking to streamline your workflow and reduce your workload? Form automation software transforms tedious manual processes into streamlined, automatic workflows, saving time and reducing errors

How to Build an Automated CRM System in Notion

Learn to leverage Notion's flexibility for improved lead tracking, team collaboration, and actionable insights, all in one intuitive platform.

Jacob Bank

How to Automate Coda

This article covers everything you need to know about Coda automation—from setting them up natively to buying "packs" or connecting with a third-party workflow tool like Relay.app.

8 Ways to Automate Slack

Make Slack real hub of your workspace with these handy workflow automations.

14 Ways to Automate Google Sheets

An automated Google Sheet can often replace multiple business processes and tools. Here's a guide—and a bunch of examples—to show that sometimes a simple spreadsheet is all you need.

Jacob Bank

How to Use Zapier with Google Sheets

Wondering how to connect your Google Sheet with Zapier? You've come to the right place.

Jacob Bank

How to Build a Custom CRM in Google Sheets

Avoid complex solutions and build your own simple, automated CRM in Google Sheets.

Jacob Bank

The Complete Guide to Workflow Automation Software [2024]

Transform your team's productivity. Discover how workflow automation can help you streamline tasks, save time, and focus on what truly matters.

More how-to guides featuring Slack and Google Sheets

See all how-to guides ➔

Automatically send Slack direct messages when a new spreadsheet is added to a Google Sheets folder

Are you tired of the manual process of sending Slack direct messages every time a new spreadsheet is added to a Google Sheets folder? This process can be time-consuming and error-prone, requiring constant attention and leaving you with less time to focus on essential tasks. But imagine a world where you can say goodbye to all this chaos and welcome a seamless communication solution instead. Relay.app is here to revolutionize your workflow, making you work smarter and stay on top of your tasks. With Relay.app, you can receive instant notifications via Slack direct messages when a new spreadsheet is added to a Google Sheets folder without any additional effort. Streamline your workflows, enhance team efficiency, and take your communication to the next level with Relay.app. Are you ready to embrace the future of communication? Follow these four easy steps to set up this integration. Let's get started!

Set up a Relay playbook (example with 1 Trigger + 1 Step)

This is a short tutorial on how to create a Playbook in Relay. Using one Trigger and one Step as an example to help you get started.

Create a new channel in Slack for a newly added spreadsheet in Google Sheets

Integrate Google Sheets with Slack to automatically create a new channel in Slack for each newly added spreadsheet in Google Sheets. This integration streamlines collaboration by organizing Slack channels according to newly added spreadsheets. When a new spreadsheet is added to Google Sheets, the integration triggers the creation of a new channel in Slack. The integration can use the spreadsheet name or other relevant information from the spreadsheet to set the channel name and initial settings.

Create a new channel in Slack for a newly added row in Google Sheets

Automate your collaboration process by integrating Google Sheets with Slack through Relay.app. This integration enables the automatic creation of a new channel in Slack for each newly added row in Google Sheets. As new rows are added in Google Sheets, Relay.app dynamically creates corresponding channels in Slack, facilitating focused discussions and efficient collaboration on the new data. This streamlined approach ensures that your team is immediately alerted to new information and can work together effectively.

Automatically add a new person to a Slack channel when a new row is added in Google Sheets

Integrate Google Sheets with Slack to automatically add a new person to a Slack channel for each newly added row in Google Sheets. This integration streamlines collaboration by quickly onboarding new team members or participants to the relevant Slack channel. When a new row is added to your Google Sheets spreadsheet, the integration triggers the addition of a new person to the specified Slack channel. The integration can use information such as email addresses or usernames from the new row to identify the person to be added.

Send Slack messages whenever a Google spreadsheet is added to a designated folder

Do you ever feel like you're drowning in spreadsheets and struggling to keep up with your team? We know how tough it can be to stay on top of everything. That's why Relay is here to revolutionize the way you work. With Relay, you'll receive a notification in Slack every time a new spreadsheet is added to your designated Google Sheets folder. No more juggling multiple platforms or trying to catch up on missed information. Relay transforms the chaos into a synchronized system where real-time updates meet empathy, simplicity, and efficiency. It's time to redefine how your team communicates and stays informed, ensuring everyone is always up-to-date and ready for whatever comes next. In this guide, we’ll show you how to set this integration up in four easy steps. Let Relay unlock your team's full potential and elevate your productivity!

Send Slack messages whenever Google Sheet rows are added

Do you ever find yourself caught in a sea of data, struggling to stay afloat while ensuring everyone else is on the same page? Imagine working diligently on your Google Sheets only to be bogged down by manually updating your team about the latest addition. It's time-consuming and leaves room for errors, not to mention the risk of overlooking team members needing critical information. But what if you could effortlessly bridge the gap between Google Sheets and Slack? With Relay, every new row added triggers an automated message in Slack, instantly informing your team and transforming how you communicate and share crucial updates. Relay isn't just about automation; it's about streamlining collaboration. It's a simple and efficient tool that translates your Google Sheets into real-time messages in Slack, keeping everyone connected and projects moving forward with precision. In this guide, we’ll show you how to set up this integration in four easy steps. Elevate your workflow and witness your projects thrive.

What will you automate?

Sign up and get started with your first Relay.app playbook today.

Try Relay.app for free

Background image