ClickUp Google Sheets integration

Changelog

What's new in ClickUp to Sheets

Scheduled syncs that keep going

Fixes

  • A **scheduled sync** that runs long no longer stops your hourly updates. The next one still runs on time.

A smoother ClickUp connect

Fixes

  • Reloading the page after you **connect ClickUp** no longer shows an error when you're already connected.

Say it when ClickUp says no

Improvements

  • Starting a sync on a **Space you have lost access to** now tells you so, and that some columns may be missing, instead of syncing quietly with gaps.

Time reports keep their own sheets

Fixes

  • A scheduled time entry report builds its pivot table and its dashboard on their own sheets again, instead of writing across your data.

Scheduled time reports heal themselves

Improvements

  • A scheduled time entry report that was interrupted now finishes into its own sheet on the next run, instead of failing on a sheet that already exists.
  • Losing access to one Space no longer disconnects the whole add-on; the affected sync carries on with what it can read.
  • Pressing a button before finishing the add-on's authorization now explains what to do instead of showing a generic error.

Fixes

  • The pivot table sheet for time reports formats correctly again.
  • A view whose visible fields can't be read no longer removes every column from its sheet.

Deleted tasks always leave the sheet

Improvements

  • The **hierarchy picker** reacts faster when you change a workspace, space, folder, or list

Fixes

  • Deleting a task in ClickUp now always clears its row, including **subtasks deleted along with their parent**, which used to need a manual full sync
  • A row is no longer left behind when a task is deleted moments after it was edited

Sync a view from a subfolder, and keep your syncs on reconnect

Features

  • **Subfolder** is now a level in the picker, so views and time tracking can target a view that lives in a subfolder instead of only a workspace, space, folder, or list Sync

Fixes

  • Starting a sync on a subfolder's view failed with **Couldn't find this view**, even though the picker had just listed it. It now starts normally
  • Picking a subfolder no longer shows a List step that leads nowhere
  • Reconnecting ClickUp no longer removes your saved syncs. The add-on now checks which workspaces your new connection can reach and asks before removing only the syncs it cannot
  • A sheet edit that could not reach the sync queue is now reported and retried locally instead of being dropped

Add-on loading fix

Fixes

  • After the previous update, the add-on could fail to open and syncs would not start. It loads and syncs normally again. No setup changes are needed on your side.

Subtask matrix rendering fix

Fixes

  • The **subtask matrix** could show a placeholder message in its cells instead of subtask statuses after the previous update. It now renders correctly. Run one sync to refresh an affected matrix.

Subtask matrix updates in real time

Improvements

  • The **subtask matrix** sheet now refreshes on its own whenever your tasks change, including through live sync. Manual syncs are no longer needed to keep it current.

Fixes

  • Subtasks created through **live sync** now show their parent task's name in the Parent Name column.

Live sync fix for subtask matrix, clearer error messages

Fixes

  • **Live sync** could fail to start or repair when the **subtask matrix** option was turned on. It now connects normally.
  • Error messages in the sidebar are now short and in plain language. Technical details no longer appear in notifications.

Time tracking shows the correct month

Fixes

  • The **Month** column in time tracking exports could show the previous month in some timezones. It now always matches the time entry's end date.

Live syncs no longer show false errors

Fixes

  • Some **live syncs** showed a connection error by mistake when more than one person on the same workspace used the add-on. Those syncs now keep running normally.

See your parent task's status in the matrix

Improvements

  • The **subtask status matrix** now has a **Parent Status** column, so you can see where each parent task stands right next to its subtasks

See every subtask's status at a glance

Features

  • **Subtask status matrix** - a new sheet with your parent tasks down the side and subtask names across the top, so each cell shows that subtask's status in one grid Reporting

Improvements

  • The subtask matrix picks up your status colors, so the grid matches the rest of your sheet
  • **Reports** and the **subtask matrix** are now available on the Pro plan

Two-way sync that reconnects itself

Improvements

  • **Two-way sync** now reconnects on its own after an update, so your edits keep syncing back to ClickUp without you turning it on again
  • You can now fix a live sync that needs attention straight from any sheet, even when it belongs to a different spreadsheet

Fixes

  • Two-way sync write times now match each sheet's own timezone
  • Turning on two-way sync now tells you right away if it could not be set up, instead of appearing on when it was not

Your own columns stay put, and sync settings save on their own

Fixes

  • Columns you add next to the synced data are now kept on every sync instead of being removed
  • Changing **When to sync** now saves on its own with a new **Save settings** button, so you no longer have to run a sync for the change to take effect

Refreshed Google Sheets logo to match Google's 2026 brand

Improvements

  • The Google Sheets icon shown on the connection screens and admin dashboard now uses Google's refreshed 2026 logo

Spot a broken ClickUp connection sooner

Fixes

  • When your ClickUp connection expires or gets revoked, the add-on now detects it automatically, stops scheduled syncs from running on a dead connection, and shows a clear **Reconnect ClickUp** screen the next time you open the sidebar

See where each comment came from in Latest Comment

Features

  • Comments in the **Latest Comment** column are now tagged with their origin: `ClickUp:` for comments posted in ClickUp and `Sheets:` for comments you write in the sheet, so you can tell at a glance where each update came from Live Sync

Improvements

  • Picking **Live** when starting a new sync now reveals the Latest Comment option right away instead of waiting until you reopen the sync
  • Added a heads-up note explaining that Latest Comment only captures comments going forward, so a fresh column starting empty no longer looks like a bug

Smoother first-open and friendlier sync errors

Features

  • Added a **Watch demo** button to the Connect screen so new users can see the add-on in action before linking their ClickUp account Onboarding

Improvements

  • Terms and FAQ open in a full-size view from the Connect screen, so the content is easier to read on smaller sidebars
  • View syncs now stop early with a clear message when the daily fetch quota is hit, instead of burning the rest of the run on retries that cannot succeed

Fixes

  • Disconnecting from a partially-installed state no longer surfaces a generic error toast
  • Replaced a few generic error cards with friendlier copy when a sheet is unsaved, deleted, or no longer shared with you

Scheduled time entry sync reports the correct period

Fixes

  • Fixed **monthly** and **weekly** time entry syncs landing on the wrong period at the boundary. The trigger now reports the period that just finished, not the new one starting

Richer descriptions in live syncs

Improvements

  • Description columns in live-synced sheets now show the formatted version of task descriptions, so styled text comes through cleanly instead of raw markup

Grouping column anchors view layouts

Improvements

  • View syncs that have a grouping field now place the grouped column first, then **Name**, **Link**, **Description**, and **Status**. The grouping field anchors the layout so it lines up with how you read the view in ClickUp
  • When the grouping field on a view changes, re-syncing now repositions the grouped column to the leading position instead of leaving it at the end
  • View syncs in the **My Syncs** sidebar now show a clearer label that pairs the parent level with the view name (for example, **List-View Name**), matching the sheet tab

Fixes

  • Edits on a sheet you've lost access to no longer cause the edit trigger to retry forever. After repeated access errors, the trigger now removes itself cleanly

Consistent column order on view syncs

Fixes

  • View syncs now place **Name**, **Link**, **Description**, and **Status** as the leading columns, matching list syncs. Previously these could land far to the right depending on how the ClickUp view ranked its columns

Sync feature status now reflects reality

Improvements

  • Sync feature status now appears above plan management on the Connected screen, so what needs your attention is right where you'll see it first

Fixes

  • Fixed **Scheduled sync** and **Two-way sync** showing as inactive on the Connected screen even after they were turned on. The status now correctly reflects what's already enabled on the spreadsheet

Clearer Active and Action needed groups

Improvements

  • On the homepage, the sync feature status now shows a clear **Action needed** label above the inactive sync prompts when some are running and others still need to be turned on

Tap-anywhere on inactive sync prompts

Fixes

  • Tapping the **Scheduled sync** or **Two-way sync** prompt on the homepage now turns the feature on. Previously only the small icon on the right was responsive
  • Cleaned up the inactive sync prompts: a single **Action needed** header instead of a red Inactive label repeating on every row

Sync feature status on every screen

Fixes

  • The inactive feature prompts for **Live**, **Scheduled**, and **Two-way** sync now also appear on the Connected screen, so you'll always know which features need re-enabling at a glance
  • Fixed Live Sync briefly showing as inactive right after opening the sidebar, even when it was already enabled

Cleaner sync settings and steadier Live Sync

Improvements

  • The **When to sync** menu now only shows sync modes you've enabled from the homepage, so it stays clean and matches what's actually available to you
  • **Live Sync** now also runs a periodic background pass alongside its real-time updates, so any change that slips past the live channel is reconciled automatically

Live Sync available during free trial

Features

  • **Live Sync** is now included in your free trial so you can experience real-time updates before subscribing Sync

Improvements

  • Live Sync setup automatically heals missing trial state so you never get stuck on an avoidable error

Fixes

  • Fixed a confusing webhook error message shown to users whose free trial had ended; you'll now see a clear upgrade prompt instead

Live Sync reliability and inactive status indicators

Improvements

  • Inactive sync features now show a clear red **Inactive** label in the sidebar so you can spot configuration issues at a glance

Fixes

  • Fixed **Live Sync** updates not reaching all sheets connected to the same ClickUp list
  • Fixed Live Sync connection not recovering correctly after an interruption

Subscription portal routing fix

Fixes

  • Reactivate subscription now reliably opens the correct billing account, even for customers whose original payment record was migrated.

Introducing Live Sync

Features

  • **Live Sync** keeps your sheet in sync with ClickUp the moment changes happen, no manual refresh needed Sync
  • **Two-way Live Sync** writes edits made in your sheet back to ClickUp automatically Sync
  • **Smart full-sync popup** previews what will happen before you start a full re-sync Sync

Improvements

  • Long task descriptions wrap cleanly with locked row heights for a consistent layout
  • Sheet name conflicts during sync setup are now handled gracefully
  • Sync status labels are clearer across the sidebar

Fixes

  • Fixed an issue where edit triggers could retry on inaccessible spreadsheets
  • Fixed a bandwidth quota issue affecting users on heavy Workspace plans
  • Stripe re-subscribe now updates account access immediately

Larger Syncs, Smarter Sheets

Improvements

  • **Doubled sync capacity** for both list and view syncs
  • Sheets now automatically expand to fit all your tasks during sync

Fixes

  • Fixed an issue where large lists (2,500+ tasks) could silently lose data in later batches

Sync Reliability Fix

Fixes

  • Fixed an issue where some task batches could fail to write during scheduled syncs

Sync Status Labels & Stability

Improvements

  • Active sync status labels are now clearer and easier to read at a glance

Org Member Access Fix

Fixes

  • Team members with expired trials now correctly see their active subscription status

Error Recovery & Stability

Improvements

  • Errors from deleted dashboard sheets no longer loop and lock up the sidebar
  • Support button now appears directly in error cards instead of a raw email address

Fixes

  • Ghost Stripe accounts no longer cause silent access failures
  • Time entries sync skips unnamed spreadsheets gracefully

Two-Way Sync & Navigation

Features

  • Task URLs are now written back to your sheet after a task is created in ClickUp Two-Way
  • Spaces with only top-level lists skip the folder dropdown for a cleaner flow Navigation

Fixes

  • Sheet is cleared before a two-way sync push to prevent row corruption
  • Dropdown fields now extract correctly for all field type configurations
  • Row updates no longer skip rows in non-contiguous ranges
  • Unnamed spreadsheets no longer break scheduled sync trigger setup

Sync Recovery & Reliability

Features

  • Failed syncs now show a recovery card with options to retry or delete the sync

Fixes

  • Orphaned background triggers are now cleaned up automatically
  • Corrupted user profiles self-heal missing account data on next load
  • Stale cached email no longer causes access check failures

Team Management & Access

Features

  • Manage team members and their subscription seats directly from the admin dashboard Team

Improvements

  • Subscription access checks now handle edge cases for users with unknown roles
  • Business plan is now highlighted as the most popular option on the pricing page

Scheduled Time Sync

Features

  • Automatically export time entries on a weekly or monthly schedule Time Tracking
  • New sheets created with period-based names (e.g., 'Time Entries: Jan 2025')

Improvements

  • Formulas now work correctly for all languages and regions
  • See immediate feedback when starting a sync

Fixes

  • Fixed formula errors for European users (Germany, France, etc.)

Live Sync & Tooltips

Features

  • Real-time updates: when tasks change in ClickUp, your sheet updates within seconds Live Sync
  • Hover over column headers to see helpful descriptions Sheets

Improvements

  • Live sync continues working even during temporary connection issues
  • Duplicate notifications automatically prevented

Webhook Foundation

Features

  • New webhook system for instant task change detection Live Sync

Improvements

  • Better error messages when ClickUp is temporarily unavailable
  • Syncs are more resilient to network interruptions

Hidden Fields & Performance

Features

  • Control which hidden ClickUp fields appear in your sync Customization

Improvements

  • Faster syncs with batch API requests
  • Column formatting runs after sync for quicker feedback
  • Better permission checks before starting syncs

Custom Field Editing & Pivot Tables

Features

  • Edit custom fields in Sheets and changes sync back to ClickUp Two-Way
  • Create pivot tables for time entry reporting (by user, task, or month) Time Tracking

Improvements

  • Headers and task name column stay frozen while scrolling
  • Time entries show duration in hours and human-readable times
  • Automatic cleanup of outdated sync configurations

View Sync & Two-Way Sync

Features

  • Sync filtered Views instead of entire Lists Views
  • Edit tasks in Google Sheets and changes sync back to ClickUp Two-Way
  • Task dashboards with scorecards, charts, and status breakdowns Dashboard
  • User analytics: track adoption, roles, and inactive members Dashboard

Improvements

  • Status and dropdown columns show ClickUp's colors automatically
  • Editable columns are highlighted so you know what can be modified

Time Entries & Team Sync

Features

  • Export time tracking data with date range selection Time Tracking
  • Sync your entire team roster with roles and activity status Team
  • Interactive date pickers for filtering time entries

Improvements

  • Admin tools section for power users
  • Confirmation dialog when deleting all syncs
  • Reconnect ClickUp account without full re-authentication

Fixes

  • Fixed 'Lists outside folders' display issue

Subtasks & Scheduled Syncs

Features

  • Include subtasks in your sync alongside parent tasks Subtasks
  • Sync task descriptions to your spreadsheet
  • Time tracking columns: estimates and time spent Time Tracking
  • Set up automatic syncs on a schedule Automation
  • 7-day free trial with no credit card required Trial

Improvements

  • Better handling of large lists with paginated fetching
  • Improved dropdown and custom field sync

Fixes

  • Fixed custom date fields not syncing correctly

New Card Interface

Features

  • Redesigned sidebar with card-based navigation UI
  • Browse Workspaces → Spaces → Folders → Lists with dropdowns Navigation
  • My Syncs dashboard to manage all your synced sheets Dashboard

Improvements

  • Columns automatically formatted based on field type
  • Clearer sync limits and usage indicators

Initial Release

Features

  • Sync ClickUp lists to Google Sheets with one click Core
  • All custom field types: dropdowns, dates, numbers, checkboxes, and more Custom Fields
  • Sync task descriptions and latest comments
  • Secure OAuth connection: we never see your ClickUp password Security

Ready to try it?

Get the Add-On