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"

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

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

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

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.

Practice

1. What is the main purpose of connecting apps like Google Sheets, Slack, and Email in no-code platforms?

easy

A. To create complex programming code for apps

B. To manually enter data into each app separately

C. To increase the number of apps installed on your device

D. To automate tasks by linking triggers and actions across different tools

Solution

1. Step 1: Understand the role of app connections

   Connecting apps allows automatic actions when certain events happen, saving manual work.

2. Step 2: Identify the correct purpose

   Among the options, only automation by linking triggers and actions fits this role.

3. Final Answer:

   To automate tasks by linking triggers and actions across different tools -> Option D

4. Quick Check:

   Connecting apps = automate tasks [OK]

Hint: Think automation, not manual or coding tasks [OK]

Common Mistakes:

• Confusing automation with manual data entry
• Assuming more apps means better connection
• Thinking it requires programming skills

2. Which of the following is the correct way to trigger an action when a new row is added in Google Sheets?

easy

A. Use 'New Row Added' as the trigger event in your automation setup

B. Use 'Send Email' as the trigger event

C. Use 'Slack Message' as the trigger event

D. Use 'Delete Row' as the trigger event

Solution

1. Step 1: Identify the trigger event related to Google Sheets

   The trigger should be an event that happens in Google Sheets, like adding a new row.

2. Step 2: Match the correct trigger

   'New Row Added' matches the event of adding data, while others are unrelated or actions.

3. Final Answer:

   Use 'New Row Added' as the trigger event in your automation setup -> Option A

4. Quick Check:

   Trigger = new row added [OK]

Hint: Triggers start with events happening, not actions to perform [OK]

Common Mistakes:

• Confusing triggers with actions
• Choosing an action as a trigger
• Selecting unrelated events

3. Consider this automation setup: When a new row is added in Google Sheets with a person's email, an email is sent automatically. What will happen if the email address cell is empty?

medium

A. The automation will skip sending the email for that row

B. The Google Sheet will delete the row automatically

C. The email will be sent to a default address automatically

D. The email will be sent to a blank address, causing an error

Solution

1. Step 1: Understand how automation handles empty data

   If the email field is empty, most no-code tools skip sending emails to avoid errors.

2. Step 2: Identify the correct behavior

   Sending to a blank address causes errors, so skipping is the safe default action.

3. Final Answer:

   The automation will skip sending the email for that row -> Option A

4. Quick Check:

   Empty email = skip sending [OK]

Hint: Empty required fields usually skip or stop action [OK]

Common Mistakes:

• Assuming emails send to blank addresses
• Thinking rows get deleted automatically
• Believing default addresses are used without setup

4. You set up an automation to send a Slack message when a Google Sheets row is updated, but no messages are sent. What is the most likely error?

medium

A. The Slack app is not connected or authorized properly

B. The email app is missing

C. The automation trigger is set to 'New Row Added' instead of 'Row Updated'

D. The Google Sheets file is empty

Solution

1. Step 1: Check the trigger event setup

   If the automation triggers on 'New Row Added' but you want messages on updates, it won't run on updates.

2. Step 2: Identify the mismatch causing no messages

   The trigger must match the event you want to detect; here, 'Row Updated' is needed.

3. Final Answer:

   The automation trigger is set to 'New Row Added' instead of 'Row Updated' -> Option C

4. Quick Check:

   Trigger mismatch = no messages sent [OK]

Hint: Match trigger event exactly to the desired action [OK]

Common Mistakes:

• Ignoring trigger-event mismatch
• Assuming connection errors without checking triggers
• Confusing apps needed for the task

5. You want to create an automation that updates a Google Sheets row when a Slack message contains a specific keyword, and then sends an email notification. Which sequence correctly connects these apps?

hard

A. Google Sheets row update triggers Slack message, then sends an email

B. Slack message with keyword triggers updating Google Sheets row, then triggers sending an email

C. Email received triggers Slack message, then updates Google Sheets row

D. Slack message triggers sending an email only, without updating Google Sheets

Solution

1. Step 1: Identify the initial trigger

   The automation starts when a Slack message contains a keyword, so Slack is the trigger app.

2. Step 2: Determine the correct action sequence

   First update the Google Sheets row, then send an email notification to inform about the update.

3. Step 3: Confirm the correct flow

   Slack message with keyword triggers updating Google Sheets row, then triggers sending an email matches this sequence: Slack triggers update, then email sends.

4. Final Answer:

   Slack message with keyword triggers updating Google Sheets row, then triggers sending an email -> Option B

5. Quick Check:

   Slack trigger -> update Sheets -> send email [OK]

Hint: Start with trigger app, then chain actions in order [OK]

Common Mistakes:

• Starting with wrong trigger app
• Skipping update step before email
• Assuming email triggers Slack or Sheets