floogos
    All templates
    New

    Daily overdue-task reminder on Slack

    Every morning it checks your task sheet and posts on Slack the ones due today or overdue; if there are none, it stays quiet.

    Everything is created inactive in a new folder of your account. Nothing runs until you activate it, and you can undo it for 24 hours.

    Workflow diagram: Daily overdue-task reminder on Slack

    What it does

    Keep your tasks in a Google Sheet with the columns tarea, responsable, estado and vencimiento (YYYY-MM-DD format). Every business day at 9:00 the workflow filters those not in hecha status that are due today or earlier, and posts a list to Slack with owner and date. If there are no pending tasks it sends nothing.

    What you need: the task sheet and a Slack Incoming Webhook.

    How to use it: install the template, pick your sheet, connect Slack and activate the workflow.

    How to set it up

    1. 1

      Connect the google credential

      This template uses google in: Leer tareas. Create or pick the credential and assign it in those nodes.

    2. 2

      Connect the slack credential

      This template uses slack in: Recordar en Slack. Create or pick the credential and assign it in those nodes.

    3. 3

      Prepare the sheet

      Create a sheet with the headers tarea, responsable, estado, vencimiento and pick it in the Leer tareas node. Mark finished ones as hecha.

    4. 4

      Connect Slack

      In the Recordar en Slack node paste your team channel Incoming Webhook.

    5. 5

      Test

      Add a task due yesterday and run the workflow manually: it should show up in the channel.

    6. 6

      Activate the workflow

      Workflows are installed inactive. Once everything is set, activate it.

    Try it in under 5 minutes

    Create the template in your account, connect your credentials and activate it when you are ready.

    Use this template