In this how-to guide

How to send Slack messages whenever a Google spreadsheet is added to a designated folder
1. Set the Google Sheets trigger as “Spreadsheet added to folder”
2. Add the “Send message” 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 send Slack messages whenever a Google spreadsheet is added to a designated folder

How to send Slack messages whenever a Google spreadsheet is added to a designated folder

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 message” action for each Google Sheets “Spreadsheet added to folder” event.

Try it in Relay.app

Google Sheets > Slack

Trigger

Last triggered

Spreadsheet added to folder

Send message

1

Set the Google Sheets trigger as “Spreadsheet added to folder”

Add the Google Sheets trigger to initiate your playbook's actions before adding a Spreadsheet to a folder.

To do this, access your playbook and click the "Add trigger" button. Then, select "Spreadsheet added to folder" under Google Sheets. Next, choose a "Parent Folder" where you want to store your Spreadsheets, for example, "My Drive". This will enable your playbook to initiate necessary actions automatically.

If you haven't connected your Google Sheets account with Relay yet, a prompt will guide you through the connection process.

2

Add the “Send message” step in Slack

Integrate the Slack automation into your playbook to ensure that you receive timely updates about new Spreadsheets added to a folder.

Select "Add Step" and then find the "Send message" automation for Slack. Enter all the required details, including the sender's name, the Slack channel for updates, and the detailed message body.

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

3

Activate your playbook

Activating your playbook is the final step. Once turned on, it will respond to send messages in Slack whenever Google Sheets rows are added to a folder without manual intervention.

To enable your playbook, click the toggle button located in the header. It is advisable to perform a test run of your playbook beforehand to ensure all 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 send Slack direct messages whenever a new row is added to your Google Sheets

Are you tired of the mundane and time-consuming task of manually sending Slack direct messages when a new row is added to your Google Sheets? Do you feel like this process hinders your team's efficiency and productivity? In today's fast-paced work environment, we must work smarter and stay informed to succeed. That's where Relay.app comes in - the ultimate solution for seamless communication and real-time collaboration. Relay.app empowers your team to focus on more important strategic tasks, streamlining communication and ensuring that your team receives real-time alerts without extra effort. At Relay.app, we believe in revolutionizing how teams work and communicate. Our tool helps ensure that your team is always informed and up-to-date, leading to better decision-making and more efficient workflows. So, if you're ready to take your team's communication and teamwork to new heights, let Relay.app be your guide. Set up this integration in just four easy steps and say goodbye to manual notifications and hello to a more productive and efficient team dynamic.

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 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