Connecting apps (Google Sheets, Slack, Email) in No-Code - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to send data from Google Sheets to Slack using a no-code tool.

No-Code

When a new row is added in Google Sheets, send a message to Slack channel [1].

Drag options to blanks, or click blank then click option'

A#general

[e-mail]

CNew Row

DSheet1

Attempts:

3 left

💡 Hint

Common Mistakes

Using an email instead of a Slack channel name

Using the sheet name instead of the channel

The Slack channel name must start with a # to send messages to the correct channel.

2fill in blank

medium

Complete the code to trigger an email when a Google Sheets row meets a condition.

No-Code

If the value in column Status is [1], send an email notification.

Drag options to blanks, or click blank then click option'

APending

BCompleted

CRejected

DIn Progress

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Pending' or 'Rejected' which are not final statuses

Using 'In Progress' which is not a completion status

The email should be sent when the status is 'Completed' to notify about finished tasks.

3fill in blank

hard

Fix the error in the automation that posts to Slack when a Google Sheets row is added.

No-Code

Trigger: New row added in Google Sheets
Action: Post message to Slack channel [1]

Drag options to blanks, or click blank then click option'

Ageneral

Bslack-general

C#general

[e-mail]

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting the # symbol

Using an email address instead of a channel name

The Slack channel must include the # symbol to correctly identify the channel.

4fill in blank

hard

Fill both blanks to filter Google Sheets rows and send Slack messages only for urgent tasks.

No-Code

Filter rows where Priority is [1] and Status is [2] before sending Slack message.

Drag options to blanks, or click blank then click option'

AHigh

BCompleted

CPending

DLow

Attempts:

3 left

💡 Hint

Common Mistakes

Using Low priority

Using Completed status which means no notification needed

Only rows with High priority and Pending status should trigger Slack messages.

5fill in blank

hard

Fill all three blanks to create an automation that emails a manager when a task is urgent and completed.

No-Code

Trigger when Priority is [1], Status is [2], then send email to [3].

Drag options to blanks, or click blank then click option'

AHigh

BCompleted

[e-mail]

DLow

Attempts:

3 left

💡 Hint

Common Mistakes

Using Low priority

Sending email before task completion

Using wrong email address

The automation should trigger for High priority tasks that are Completed and notify the manager's email.