ClickUp Google Sheets integration

Changelog

What's new in ClickUp to Sheets

Scheduled syncs finish on slow days

Fixes

  • A scheduled sync that runs short on time picks up where it left off on the next run, instead of stopping with a time-out error when Google Sheets is slow.
  • With live sync on a view, a task you edit out of the view's filter now leaves the sheet.

Faster syncs for big lists

Improvements

  • A sync whose colours haven't changed skips repainting them, so it finishes sooner.
  • Lists with many custom fields load them once per sync instead of twice.

A shorter feedback button

Improvements

  • The feedback button at the bottom of the sidebar now reads "Ask feature" and fits on one line.

Clearer feature rows

Improvements

  • When two-way sync or live sync is off, its row now says that a tap turns it on.

Due and start times stay put

Fixes

  • Due dates, start dates and date fields set with a time show that time in your sheet's time zone. Before, only the day came through.
  • With two-way sync, editing a dated row no longer wipes its time in ClickUp. A time you type goes back as that time.
  • A scheduled sync keeps running on the next hour after a temporary Google error. Before, one error could stop the schedule until you opened the add-on again.

A faster start, and your first sync in view

Improvements

  • The add-on opens right away the first time. The Quick Start Guide tab is now a button on the welcome screen, so nothing lands in your file until you ask for it.
  • Connect is ready to press. Connecting accepts the Terms, which sit right under the button, so there's no checkbox to tick first.
  • After you start a sync, the add-on shows it running. Press Refresh to check on it, then Open sheet to jump to your new tab. If a sync fails, you see why and can try again from the same screen.

Scheduled syncs keep their schedule

Improvements

  • To schedule a sync, pick Scheduled on the sync itself. The separate Scheduled sync switch on the home screen is gone, because the schedule now follows your syncs.
  • Scheduled task syncs no longer show a next sync time. Google picks the minute within each hour, so the time we showed was often wrong.

Fixes

  • Scheduled syncs keep running when Google has a short hiccup. Before, a brief outage on Google's side could stop your hourly syncs, with no warning, until you set them up again.

Your plan turns on for the account that upgraded

Fixes

  • When you upgrade from the add-on, your plan now turns on for the Google account that clicked Upgrade, even if you type a different email at checkout.
  • In two-way sync, clearing a due date, start date, priority or description cell now clears it in ClickUp. Before, ClickUp kept the old value and the next sync brought it back.
  • A column of your own between synced columns keeps its formulas after a sync. Two-way sync also catches your edits in the synced column right after it again.
  • If a sync fails partway through, your sheet keeps last run's rows. It used to keep only the rows that had loaded, so a 1,050-task list could show 1,000.
  • When several scheduled syncs run back to back, a late one now stops in time and finishes on the next run. It used to hit Google's 6-minute limit and leave the sheet half written.
  • A task you create from the sheet gets its ID written back once, so a retry never creates it twice. If Google refuses a sync's write to your sheet, the sync now shows as failed, not complete.

Two-way sync is back in sync settings

Fixes

  • If you turned two-way sync on and then saved a one-way sync, two-way switched itself off and dropped out of the sync's Direction menu. It now stays on until you turn it off.

The right fix when Google access drops

Fixes

  • When live sync stops because Google access to your sheet was lost, the message now asks you to reconnect Google. It used to ask you to reconnect ClickUp, which didn't help.
  • Saving a sync that isn't two-way now turns off sheet-edit tracking once no two-way sync is left in that spreadsheet.

Quick edits stay put

Improvements

  • When a saved two-way sync doesn't run two-way on your plan, a note under Direction now says so, and says what happens to your sheet edits until it does.

Fixes

  • In a live two-way sheet, a second edit made right after the first no longer gets the old value written back over it.

Big dropdowns sync faster

Fixes

  • A list with long dropdown option lists now reads its fields once per sync, not once per batch, so a large sync finishes sooner.
  • Turning on live sync for the first time no longer says it registered 0 sheets.

Deleting a sync asks in the sidebar

Improvements

  • Deleting a sync, or all of them, now asks first on a card in the sidebar with Delete and Cancel buttons. The old pop-up over the sheet could stop the delete halfway when you answered late.

Fixes

  • A scheduled sync that starts while another run is already syncing the same sheet no longer shows as failed. It skips that turn and lets the other run finish.
  • A sync you just started no longer shows as failed on My Syncs for a moment before it begins.

Edits wait for two-way, and one sync runs at a time

Improvements

  • When your plan stops including two-way sync, edits you typed before the change no longer go to ClickUp one last time. They wait, the sync's row lists them, and they go out as soon as two-way runs again.
  • Pressing Sync while a scheduled sync is running now asks you to wait. Before, both could run at once.

Fixes

  • When ClickUp changed a task in the same moment you edited it in the sheet, live sync could skip ClickUp's other changes to that task. They now reach the sheet.
  • A new row that hit a short connection error could get stuck with a note saying it might already exist. It now goes to ClickUp on the next try.
  • A sync that Google stopped partway now frees the add-on after 7 minutes instead of 10, and its row offers Retry.

Sheet edits always reach ClickUp

Improvements

  • Edits ClickUp refuses no longer disappear. The sync's row lists them with the value you typed, a Retry button and a Discard button, and the sheet keeps updating meanwhile.
  • When your plan stops including a sync mode, your saved settings stay and that part pauses. Change your plan back and live and scheduled syncs start again on their own.
  • If you buy a plan during your trial, the add-on follows that plan from the day you buy it.
  • The lightning button on a live sync now offers the step that fixes the problem: reconnect ClickUp, connect Google Sheets again, or see plans.

Fixes

  • An edit you typed just before pressing Sync could be lost. It now always reaches ClickUp.
  • After you deleted a sync that was waiting to run, Start sync said another sync was running for up to 10 minutes. It now starts right away.
  • Tasks renamed during a live update sometimes kept their old name in the sheet. They now update.
  • Live rows showed 0m for tasks with no tracked time. They now stay blank, as in a full sync.

Edits from your teammates reach ClickUp

Fixes

  • When someone outside your Google Workspace edited a synced sheet, some of their edits never reached ClickUp. They now go through under your account, like your own edits do.

Your plan follows the address you sign in with

Fixes

  • If your Google Workspace admin renamed your account, the add-on now uses the address you sign in with today. It used to keep the address from the day you installed it, so the sidebar could show your plan while a new live sync said your subscription was inactive.

Your workspaces load when ClickUp is slow

Fixes

  • When ClickUp is slow to list your workspaces, the picker now shows the ones your syncs already use. It used to ask you to reconnect your account, which didn't help.

Request a feature from the sidebar

Features

  • A Request a feature link now sits beside Help at the bottom of the sidebar. It opens our feature board, where you can post an idea or vote on one.

Fixes

  • When the add-on can't reach ClickUp, the time entries and user exports now say so. They used to show an empty workspace list.

The Team Dashboard opens again

Fixes

  • Team Dashboard in the sidebar opens your team page on our website. It used to show Google's "unable to open the file" page. Owners and admins can add, remove and promote teammates there, and manage billing.

Edits no longer lost in live two-way sync

Fixes

  • With live sync and two-way on, a cell you edit no longer flips back when the same task changes in ClickUp before your edit reaches it. That edit used to vanish with no warning.

Task hours per person and per tag

Features

  • The time tracking dashboard has new tables that show each task's hours per person and per time tag, plus a Top 10 Tasks by User chart.

Improvements

  • Dashboard charts now use a violet-to-teal palette that stays readable with colour blindness. They used to get Google's default colours.

Fixes

  • With live sync on, a task you move to another list now leaves your sheet within a minute. It used to stay until the next full check.
  • When a trial or plan ends, live sync turns off only on your own sheets. A teammate on the same ClickUp account keeps theirs.

Two-way pushes send only your edits

Fixes

  • A manual push on a two-way sync now sends only the cells you edited. A date someone changed in ClickUp since your last pull no longer gets overwritten by the older one in your sheet.
  • When Google stops a scheduled sync partway through, your sheet keeps its last good rows and the next scheduled update still runs.
  • If your plan has ended, turning on live sync now says so. It used to show an error with no reason.

Slow ClickUp replies no longer drop tasks

Fixes

  • When ClickUp is slow to answer, a sync now tries again. It used to skip tasks and still say it worked, and now it tells you when it can't finish.

Big pastes that keep up

Improvements

  • Team plans: the person who pays can manage the team without taking a seat. Their seat goes to someone who syncs.

Fixes

  • Pasting into many rows at once on a live two-way sync no longer stalls. All the pasted rows now reach ClickUp.

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 with gaps and saying nothing.

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 stopped partway 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
  • When you delete a task moments after editing it, its row no longer stays behind

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
  • When a sheet edit can't reach the sync queue, the add-on now reports it and retries it locally instead of dropping it

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. You don't need to change anything in your setup.

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

  • When live sync creates a subtask, it now shows 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 with the subtask matrix option 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

  • The subtask status matrix is 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

  • Syncs now keep the columns you add next to the synced data instead of removing them
  • 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 connection screens and admin dashboard now use Google's new 2026 Google Sheets 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

Latest Comment now shows whether a comment came from ClickUp or Sheets

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 which side wrote it 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
  • A new note explains that Latest Comment only captures comments from the moment you add it, so a fresh column starting empty no longer looks like a bug

Smoother first-open and friendlier sync errors

Features

  • The Connect screen now has a Watch demo button, 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
  • A few generic error cards now use 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 instead of 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 you turned them 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 you still need to turn on the others

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
  • The inactive sync prompts now show 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 can see at a glance which features you need to turn back on
  • 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 it catches any change that slips past the live channel

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

  • Users whose free trial had ended saw a confusing webhook error message. 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 moved to a new system.

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

  • Edit triggers no longer retry on spreadsheets they can't open
  • Users on heavy Workspace plans no longer hit a bandwidth quota issue
  • 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

  • Large lists (2,500+ tasks) no longer silently lose data in later batches

Sync Reliability Fix

Fixes

  • Scheduled syncs no longer fail to write some task batches

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

  • When the add-on creates a task in ClickUp, it now writes the task URL back to your sheet Two-Way
  • Spaces with only top-level lists skip the folder dropdown for a cleaner flow Navigation

Fixes

  • The add-on now clears the sheet before a two-way sync push, so rows don't get corrupted
  • 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
  • A highlight now marks the columns you can edit

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