Once tasks are created, they can be managed directly from the Schedule & Email Spreadsheets add-on interface. Each task has a menu with various options for modification, execution, and backup.

Task Options Menu (⋮)

Clicking the three dots (⋮) next to a task reveals the following options:

• Edit: Modify the task configuration, including schedule, recipients, and attachments.

• Delete: Permanently remove the task from the list.

• Export: Save the task configuration as a backup file. This file can be re-imported later using the Import Task option from the add-on menu.

• Run: Manually trigger the task to execute the configured email and report immediately.

Task Icons & Their Meaning

Each task is displayed with an icon that represents its scheduling status:

• Timer Icon: Indicates that the task is scheduled and will run automatically based on the configured recurrence.

• Email Icon: Indicates that the task is not scheduled for automatic execution but can still be manually run using the Run option.

Users can efficiently manage their scheduled tasks, modify configurations, and back up tasks for future use, ensuring smooth automation of Google Sheets email reports.

Importing a Task

To restore a previously exported task, use the Import Task feature from the Schedule & Email Spreadsheets add-on menu:

1. Click the Choose File button.

2. Select the exported .json file from your device (e.g., Daily Sales Report.json).

3. Click the IMPORT button to upload and restore the task.

Once imported, the task will appear in the task list, ready to be scheduled or modified.