ASL Newsletter

Instructions

1. Make a copy of the Google Sheet template using the link above.

2. Download the Google Tasks app. I'd also recommend downloading the Google Calendar app, if you haven't already.

   • The Google Tasks app has a weird issue where the links aren't interactive when you click to expand the task. So while they resolve that (I of course submitted a feedback thing...we'll see..), I just use the Google Calendar app to interact with the links a bit more easily. However, the Google Tasks app is still needed to configure things.

3. Once you've downloaded the app, log into the app with the same Google profile that you're using for Google Sheets. Once there, create a new list named ASL Lessons.

   • You can also just name it anything you want. Just make sure it has a distinct name, as the Google Sheet will add tasks to whichever list that has the name that's entered in cell B3 on the Google Sheet. And do make sure that the name you choose to enter matches the contents of cell B3 on the Google Sheet.

4. On the Google Sheet you created in step 1, double check to make sure that your Google Tasks list matches the contents of cell B3 exactly.

5. Update the desired Start Date in cell B5. It will be set to today's date, by default. Whatever date you enter here will be the first date that these tasks are added to your list.

6. Update the desired number of signs you want to receive per day in cell B4. You'll see the updated End Date in cell A6 based on your preferences here.

7. If you don't want to include the previous day's signs in each day's task, be sure to uncheck cell B8. These will be included, by default, in all tasks after the first day unless you uncheck this box.

8. If you don't want to include a random, previously sent sign in each day's task, be sure to uncheck cell B9. This sign will be included, by default, in all tasks after the second day unless you uncheck this box.

9. Once you've updated all of your preferences, go to the custom menu item Sheet Controls at the top of the page and select Create Tasks.

10. When you first select this, you'll likely receive a request for access from the Google Sheet. You'll need to approve it with the profile you're using for the Sheet and Google Tasks. The you may need to select Advanced in the lower right corner of the modal if it tells you that the app is unregistered, and then elect to proceed after that.

11. After everything is approved, you'll probably need to repeat step 9 to add all tasks.

    • For some reason, the first time I did this, the Google Tasks app crashed and wouldn't complete the addition of the tasks. Hasn't happened since, but if you see a red box appear at the top of the page saying something along these lines, you'll want to do the following:

      1. Check to make sure that the last task on your ASL Lessons list is not on the End Date mentioned in step 6. If it is, then you're actually all set and can skip this process.

      2. If that last task is not on the specified end date, go back to the Google Sheet and select Sheet Controls > Delete All Uncompleted Tasks.

      3. Make sure that your ASL Lessons list is empty. If it's not, repeat the previous step. For some reason, I did have to do this a few times. Not sure if there's a limit to how many can be deleted.

         • If it's easier, you can also just delete the list in the Google Tasks app (three dots at lower right, Delete List) and create a new list with the same name you entered back in step 3.

      4. Once your ASL Lessons list is empty, repeat step 9.

12. That should do it! You'll now have all of the tasks queued up in your Google Tasks app and – for easier interaction – your Google Calendar app every day through the specified end date!