Create a ClickUp comment to a task when a Google Sheets spreadsheet is modified

If you are working on a team project in Google Sheets, you may want to keep everyone in the loop on the latest changes. This automation will do just that. It will create a ClickUp comment on a task when a modification is made to a Google Sheets spreadsheet. 

Let’s set it up! 

Step 1: Pin the playbook and integrate Google Sheets

First, click the 'Pin it' button at the top of this page to save this automation. You will be redirected to download the Bardeen.ai browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets.

Step 2: Configure the playbook

Click on the playbook card and select the Google Sheet you want to use for this automation. Then, choose the worksheet and range of cells you want to monitor. 

Step 3: Run the automation

Make a modification to the Google Sheets. The automation will trigger and create a comment on the linked ClickUp task.

‍