Google Tasks API example 1

google-tasks-api-example-1.js

// MaxResults:
//   TaskList: 20
//   Task: 100 per TaskList

function getTaskCount() {
  let count = 0;
  Tasks.Tasklists.list({maxResults: 20}).items.forEach(function(taskList) {
    const tasks = Tasks.Tasks.list(taskList.id, {
      maxResults: 100,
      showCompleted: false,
      showDeleted: false,
      showHidden: false,
    }).items;
    count += tasks.length;
  });
  return count;
}

function appendTaskCountToSpreadSheet(taskCount) {
  const spreadSheetId = "<YourSheetId>";
  const spreadSheetName = "<YourSheetName>";
  const sheet = SpreadsheetApp.openById(spreadSheetId).getSheetByName(spreadSheetName);
  sheet.appendRow([
    new Date(),
    taskCount,
  ]);
}

function main() {
  const taskCount = getTaskCount();
  appendTaskCountToSpreadSheet(taskCount);
}