Changelog

Follow new updates and improvements to ClickUp to Sheets.

December 29th, 2024

๐ŸŽฏ New Features

Time Entries Export

  • Export time tracked data at workspace, space, folder, or list level

  • Filter by date range and billable status

  • Automatic timezone handling based on user settings

  • Formatted duration display (e.g., "2h 30m")

Admin Tools Section

  • New dedicated section for advanced features

  • Quick access to Time Entries export

  • Improved organization of administrative functions

UI Improvements

  • Better organization of multiple syncs with collapsible sections

  • Clearer sync status indicators

  • Optimized column widths for time entry data

  • Enhanced visual hierarchy in sync management

Bug Fixes

  • Fixed timezone handling in time entry exports

  • Improved error handling for sheet name conflicts

  • Better handling of deleted ClickUp lists

  • Fixed sync status update issues

November 27th, 2024

Daily Syncs โฐ

  • Added new sync option "Sync every Day โฐ" for automatic daily updates

  • Daily syncs are performed every 24 hours for PRO and BUSINESS users

Better Sync Update Handling

  • Improved validation when updating syncs with missing sheets or lists

  • Better error messages when sheets or ClickUp lists are inaccessible

  • Updated sync status messages for better clarity

  • Added new warning messages for sync limitations

๐Ÿ› Bug Fixes

  • Fixed issue with sync updates when sheets were deleted

  • Resolved problems with failed syncs not being properly marked

  • Corrected handling of missing ClickUp lists during update

November 6th, 2024

New Features

Enhanced Sync Visibility ๐Ÿ”

  • View all your syncs across your entire Google Drive

  • Easily identify which syncs belong to current and other spreadsheets

  • Better organization and management of your synced data

Improved Subtask Support โœจ

  • Include subtasks in your synchronizations

  • View parent task information directly in your sync:

    • Parent task ID

    • Parent task name

    • Note: This extends beyond standard ClickUp CSV export capabilities!

Performance Improvements ๐Ÿš€

Faster Synchronization

  • Increased sync speed through backend optimizations

  • Handle larger task volumes more efficiently

  • Reduced synchronization time for better productivity

July 22nd, 2024

๐Ÿ†• New Features:

โ€ข ๐Ÿ”— Sync ClickUp Lists to Google Sheets

โ€ข ๐ŸŽ› Customizable sync options:

  • Include closed tasks

  • Sync task descriptions

  • Sync latest comments

  • Sync custom fields

โ€ข ๐Ÿ‘€ View and manage all synced lists in one place

โ€ข ๐Ÿ”„ Update existing syncs with new settings

โ€ข ๐Ÿ—‘ Delete syncs and their associated sheets

โšก Technical Improvements:

โ€ข Lightning-fast Batch processing of tasks for efficient syncing

โ€ข Smart column management based on sync options

โ€ข Built-in rate limiting to ensure smooth operation

๐Ÿ›  Behind the Scenes:

โ€ข Secure OAuth2 authentication for accessing the ClickUp API

โ€ข Smart management of user settings and sync progress

โš  Known Limitations:

1. Sync process may be interrupted for very large lists due to Google Apps Script time limits

2. Beta version: Some imports may encounter issues with complex ClickUp setups

๐Ÿ”ฎ Future Plans:

We're working on improving reliability, adding more sync options, and enhancing overall user experience in upcoming versions.