GTasks

GTasks is a simple yet powerful Google Sheets™ add-on that lets you seamlessly import and export Google Tasks™. Whether you want to back up your tasks, share them with your team, or manage them in bulk, GTasks makes it effortless.

Features:

Import Google Tasks™ to Sheets™

• Select one or more task lists.

• Import into the current sheet or a brand-new sheet.

• Get all task details: Title, Description, Due Date, Completion Status.

Export Tasks from Sheets™ to Google Tasks™

• Export directly from a selected sheet range.

• Create new task lists or add to existing ones.

• Smart column mapping: tasklist, task, details, due date, completion.

Manage Tasks in Sheets™

• Edit tasks directly in your spreadsheet.

• Update due dates, mark completion, or add details in bulk.

• Sync changes back to Google Tasks™.

Simple Task Manager in Sidebar

• Create, edit, and organize tasks without leaving Sheets™.

• View completed tasks separately with collapsible sections.

Free Version Limitations:

• The free version lets you import and export only two tasks at a time from Google Sheets.

How It Works

1. Open Google Sheets™ → Go to Extensions > GTasks.

2. Import Tasks → Select your Google Task lists and bring them into Sheets™.

3. Export Tasks → Choose a sheet range and push tasks back to Google Tasks™.

4. Manage Tasks → Use the sidebar to quickly create and edit tasks inline.

Turn your Google Sheets™ data into actionable tasks with GTasks. Easily import, export, and manage Google Tasks™ directly from your spreadsheets to streamline productivity and stay organized.

* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas

GTasks use and transfer of information received from Google APIs to any other app will adhere to Workspace API User Data and Developer Policy, including the Limited use of user data.