← Back

Automation of ClickUp and Google Sheets

This Make scenario is implemented whenever a task gets completed in ClickUp.

Make Automations
Works with
  • Make
  • ClickUp
  • Google Sheets

Project Overview

This Make automation connects ClickUp with Google Sheets to transfer completed task details into the appropriate spreadsheet. When a task is completed in ClickUp, the scenario processes its information and uses custom fields to determine which Google Sheets file should receive the data.

The Business Need

Task information needs to be recorded in the relevant Google Sheets file when work is completed in ClickUp. This scenario automates that transfer and routes the data according to the task's custom fields.

The Solution

The Make scenario uses a custom webhook, variable configuration, and a router to direct information into Google Sheets.

  • Webhooks: Receives data through a custom webhook.
  • Tools: Sets multiple variables used during processing.
  • Router: Splits the workflow into two branches.
  • Google Sheets: Each branch adds a row to a spreadsheet.

How It Works

1. Receive the Webhook

The workflow starts when the custom webhook receives the task information.

2. Set Variables

The Tools module sets multiple variables that are used in the subsequent workflow steps.

3. Route the Data

The Router divides the workflow into two branches. The routing logic uses the task's custom fields to determine the appropriate destination.

4. Add a Row to Google Sheets

Each branch connects to a Google Sheets module configured to add a row to its respective spreadsheet.

Screenshot of working automation in make.com

Workflow Architecture

b82ec5b29b4f30420d70ccdc.png

The router splits the workflow into two Google Sheets branches, allowing data to be directed to the relevant destination.

Tools and Integrations

  • Make: Connects the workflow modules and manages routing.
  • ClickUp: Provides the completed task information.
  • Google Sheets: Receives task details as new spreadsheet rows.

Outcome

The scenario automates the transfer of completed task information into Google Sheets and routes the data according to custom fields, reducing the need to enter the same information manually.