Automated Gear Return Tracking
Every morning, WebRun reads your gear tracking sheet in Google Sheets and identifies rented equipment due for return today or within the next 24 hours. It posts a flagged list to the production Slack channel, sends a Telegram reminder to the responsible crew member, and queues a return reminder so no rental runs over and racks up late fees.
How do I automatically track rented gear returns and remind crew members?
Every morning, WebRun checks your Google Sheets gear tracker for rented equipment due back today or tomorrow. It posts a flagged return list to the production Slack channel and sends a direct Telegram reminder to each responsible crew member so late fees are avoided and no rental runs over without anyone knowing.
- Late rental fees are avoided with same-day gear return reminders
- Crew members get direct Telegram reminders before the return deadline
- The production team sees every imminent return in one daily Slack alert
Built for video production coordinators · film set producers · equipment rental managers · freelance directors of photography
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
sheets.google.comin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - find gear due for return
google.com
WebRun opens Google Sheets to find gear due for return. - Open the gear tracking sheet in Google Sheets
- Filter rows where the return date is today or tomorrow and the status is still Out
- Collect the gear name, rental company, due date, day rate, responsible crew member, and their Telegram contact for each item
Done when Every piece of rented gear due for return within 24 hours is identified with its details.
-
2
Slack - post the returns alert to the team
slack.com
WebRun opens Slack to post the returns alert to the team. - Post a return alert to the production Slack channel listing all gear due back today or tomorrow
- Include gear name, rental company, due date, and the crew member responsible
- Flag any item already overdue as urgent
Done when The production team has a Slack alert with all imminent gear returns listed.
-
3
Telegram - send a reminder to the responsible crew member
telegram.org
WebRun opens Telegram to send a reminder to the responsible crew member. - Send a direct Telegram message to each responsible crew member listing the specific gear they need to return
- Include the rental company name, return deadline, and any return instructions from the tracking sheet
- Send the message automatically as this is an internal, non-client-facing operational reminder
Done when Every responsible crew member has received a Telegram return reminder for their gear.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it send the Telegram reminder automatically or wait for approval?
Telegram reminders to crew members are internal operational messages and are sent automatically each morning. These go only to your own team, not to rental companies or external contacts, so no external communication happens without a human in the loop.
How does it know who is responsible for each piece of gear?
It reads the responsible crew member column in your gear tracking sheet and their linked Telegram handle. Keep the sheet updated when gear is checked out and WebRun will always ping the right person.
What happens when gear is returned and marked back in the sheet?
WebRun reads the live status column each morning, so any item marked as Returned in the sheet is automatically skipped and no reminder is sent for that item again.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.