<- All use cases

Recurring deadlines tracker

If you keep track of recurring deadlines in a Google Sheet, this automation will ensure that you never miss an important recurring deadline again.

Try this in Lido for free ->Schedule an onboarding call
Watch demo video
Lido is trusted by sales, marketing, and operations teams at:
and 100s of other companies

Why you should use this

A recurring deadlines tracker automates the monitoring and notification of regular deadlines, preventing missed tasks and helping teams stay on schedule. It enhances organizational efficiency by providing clear visibility of upcoming due dates, which is essential for maintaining continuous productivity and meeting operational targets consistently.

How it Works

This automation checks to see if today's date matches a recurring deadline date specified in a spreadsheet and automatically sends an email if TRUE.

Schedule an onboarding callTry this in Lido for free ->

Connect recurring deadline dates in a Google Sheet to Lido

Lido connects to anywhere your recurring deadlinetracking dates live, most commonly Google Sheets.

Check if today’s date is equal to the tracked recurring deadline date in the Google Sheet

IF(TODAY() = C2,SENDGMAIL(<tim@gmail.com>,B2,”Reminder", "Upcoming deadline date”….)

Send an email if there is an upcoming recurring deadline

Send a personalized email from Gmail or Outlook account for each tracked recurring deadline that requires an alert.

SENDGMAIL(<sender-credential>,B2,"Recurring deadline in 3 days","[Deadline] is coming up")

Tutorials to help you get started

Step-by-step instructions to guide you through setting up this automation in Lido.
Instructions from the Lido blog ->
Youtube video ->
Talk to a product specialistTry this in Lido for free ->

Who should use this

Ideal for project managers, editorial teams, and any professionals who manage tasks with recurring deadlines in Google Sheets, such as reports, publications, or routine submissions. This tool is crucial for keeping track of ongoing responsibilities and ensuring timely completions.
Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Send daily KPI reports via SMS

Convert Credit Card Statements to Google Sheets

Convert Receipts to Google Sheets

Send emails triggered by values in PostgreSQL columns

Send Slack messages when a new row is added to MySQL

Contract management software

View all