Connecting apps (Google Sheets, Slack, Email) in No-Code - Mini Project: Build & Apply

Connecting apps (Google Sheets, Slack, Email)

📖 Scenario: You work in a small team that tracks project tasks in Google Sheets. You want to get notified in Slack and by Email whenever a new task is added to the sheet. This helps your team stay updated without checking the sheet constantly.

🎯 Goal: Build a simple automation that connects Google Sheets, Slack, and Email. When a new task is added to the sheet, a message is sent to a Slack channel and an email notification is sent to your team.

📋 What You'll Learn

Create a Google Sheet with a list of tasks

Set up a trigger to detect new rows added to the sheet

Configure a Slack message to notify a channel about the new task

Configure an Email notification to send details of the new task

💡 Why This Matters

🌍 Real World

Teams often use Google Sheets to track work and want to get instant notifications in communication tools like Slack and Email to stay updated.

💼 Career

Automation skills connecting apps are valuable for roles in project management, operations, and any job that requires coordinating team tasks efficiently.

1

Create the Google Sheet with tasks

Create a Google Sheet named ProjectTasks with columns Task and Deadline. Add these two rows exactly: "Design logo", "2024-07-01" and "Write content", "2024-07-05".

No-Code

# Create a Google Sheet named ProjectTasks with columns Task and Deadline
# Add two rows: "Design logo", "2024-07-01" and "Write content", "2024-07-05"

Need a hint?

Use Google Sheets to create a new sheet named exactly ProjectTasks. Add the column headers Task and Deadline. Then add the two rows with the exact task names and deadlines.

2

Set up a trigger for new rows

In your automation tool, create a trigger that watches the ProjectTasks Google Sheet for new rows added. Name this trigger NewTaskAdded.

No-Code

Google Sheet named ProjectTasks with columns Task and Deadline
Row 1: Design logo, 2024-07-01
Row 2: Write content, 2024-07-05
# Create a trigger named NewTaskAdded that watches for new rows in ProjectTasks

Need a hint?

Use your automation platform's Google Sheets integration to create a trigger called NewTaskAdded that activates when a new row is added to the ProjectTasks sheet.

3

Configure Slack notification

Add an action to your automation that sends a message to the Slack channel #project-updates whenever NewTaskAdded triggers. The message should say: New task added: [Task] with deadline [Deadline] using the data from the new row.

No-Code

Google Sheet named ProjectTasks with columns Task and Deadline
Row 1: Design logo, 2024-07-01
Row 2: Write content, 2024-07-05
Trigger NewTaskAdded watching ProjectTasks for new rows
# Add Slack action to send message to #project-updates with new task details

Need a hint?

Use the Slack integration in your automation tool to send a message to the #project-updates channel. Use placeholders or variables to insert the Task and Deadline values from the new row.

4

Configure Email notification

Add another action to your automation that sends an email to [e-mail] when NewTaskAdded triggers. The email subject should be New Task Alert and the body should say: A new task [Task] is due by [Deadline].

No-Code

Google Sheet named ProjectTasks with columns Task and Deadline
Row 1: Design logo, 2024-07-01
Row 2: Write content, 2024-07-05
Trigger NewTaskAdded watching ProjectTasks for new rows
Slack action sending message to #project-updates: "New task added: [Task] with deadline [Deadline]"
# Add Email action to send to [e-mail] with subject and body using new task data

Need a hint?

Use the Email integration in your automation tool to send an email to [e-mail]. Set the subject to New Task Alert and use variables to include the task name and deadline in the email body.