Weekly

Get reminders about SharePoint list items due soon

Each Friday you see the list items due next week, so timesheets and reviews don't slip.

Runs: Weekly
Apps: SharePoint
AI: Not needed
Access: read

Send this to your assistant

Create a ClickRuntime automation: every Friday at 3pm, email me the items in our Timesheets list on the HR SharePoint site whose Due Date falls next week, with the owner for each.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A SharePoint list is often the place where recurring obligations live: weekly timesheets, equipment returns, compliance training, contract renewals. Each item has a due date, and each belongs to a person. But SharePoint lists do not nag. People forget, the due date passes, and a manager spends Friday afternoon messaging people one by one. Payroll waits on late timesheets, an audit finds uncompleted training, and the person chasing everyone becomes the team's unofficial reminder service.

Once a week the automation reads the items in your SharePoint list with their fields, selects those whose due date is coming up or already past, and emails each person the items that need their attention. It runs on the weekly schedule you choose. Office managers, project coordinators and HR teams use it to keep list-based obligations from slipping.

What you get out of it

Timesheets arrive on time
Payroll runs on schedule when people are reminded before the deadline. Chasing late submissions by hand is slow, and reminding in advance avoids most of it. Payroll closes on time when people are reminded Wednesday, not chased individually on Friday afternoon.
No manual chasing
The person who used to send reminders can stop. The same message goes out each week to the right people, and the manager's time goes to work that actually needs judgment.
Obligations are visible to the owner
Each person receives their own items with due dates. That is clearer than a general announcement, because people act when a message names exactly what they owe. Each person sees only the three items they owe, which is why they act, unlike a general announcement.
Compliance gaps shrink
Training or certification due dates are reminded before expiry. When the auditor arrives, there are fewer overdue items to explain, and fewer penalties from lapsed requirements. Training due dates are flagged weeks before expiry, so the auditor does not find lapsed certifications.
Works with the lists you already have
Nothing has to move to a new tool. The existing SharePoint list stays the source of truth, and reminders read from it, so adoption needs no change in how people work.

How it works

What happens, step by step

Every Friday, ClickRuntime reads the items in your SharePoint list, such as Timesheets.
It keeps the items with a due date in the coming week.
You get one email listing each item with its due date and owner, in date order.

Before it runs live

Connect SharePoint

What you get

RunsWeekly

Get reminders about SharePoint list items due soontoday, 9:00Succeeded

Email · Timesheets due next week2026-10-27 October timesheet (owner: Finance team)

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other SharePoint steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

list_item_reminders.pyexample

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

SITE_ID = "contoso.sharepoint.com,5555-eeee,6666-ffff"  # HR site
LIST = "Timesheets"

@on_trigger
def run(event):
    monday = date.today() + timedelta(days=7 - date.today().weekday())
    resp = http.get(f"https://graph.microsoft.com/v1.0/sites/{SITE_ID}/lists/{LIST}/items",
                    params={"expand": "fields", "$top": 500},
                    headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}",
                             "Prefer": "HonorNonIndexedQueriesWarningMayFailRandomly"})
    resp.raise_for_status()
    due = []
    for item in resp.json()["value"]:
        f = item["fields"]
        d = (f.get("DueDate") or "")[:10]
        if d and str(monday) <= d <= str(monday + timedelta(days=6)):
            due.append((d, f"{d}  {f.get('Title')} (owner: {f.get('Owner', 'unassigned')})"))
    lines = [line for _, line in sorted(due)]
    notify.email_me(f"{len(lines)} timesheets due next week", "\n".join(lines) or "Nothing due next week.")
    return {"due": len(lines)}

FAQ

Common questions

Which column holds the due date?

Any date column in the list. During setup you name the column and how far ahead to remind, such as items due within seven days or already overdue. A list with both a start date and a due date works too, as long as you say which one drives the reminder.

How does it know who to email?

It uses a person or email column in the list, such as Assigned To or Owner. SharePoint person columns carry an email address, which the automation reads, so each person receives only their own items.

Will it keep reminding after someone completes an item?

Only if the item still meets the condition. Filter out items with a Status of Complete, and finished items stop appearing in reminders. The list itself must be kept up to date for that to work.

What permissions does it need?

read. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (weekly). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

WeeklyAI