All templates

Automated Local Line CSA Share Renewal Drafts

A few weeks before your season closes, WebRun opens Local Line, identifies CSA members whose subscriptions are set to expire, logs them in a Google Sheet, drafts a personalized renewal invitation in Gmail for each one, and saves every email as a draft for your approval.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Local Line find members with expiring subscriptions
2 Google Sheets log members due for renewal
3 Gmail draft a renewal invitation per member
In short

How do I automatically draft CSA share renewal emails before my season ends?

A few weeks before your CSA season closes, WebRun opens Local Line, finds every member with a subscription expiring in 30 days, logs them in Google Sheets, and drafts a personalized renewal invitation in Gmail for each one. Every email waits as a draft until you review and approve it.

  • Every expiring CSA member gets a personalized renewal invitation before the deadline
  • No renewal email is sent without your review
  • Renewal tracking is logged automatically in Google Sheets each week

Built for CSA farms · farm subscription managers · direct-to-consumer farms · small farm owners

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.localline.co in a real browser with your saved login - no setup, no API keys.

  2. 1
    Local Line - find members with expiring subscriptions
    localline.co
    WebRun in Local Line: find members with expiring subscriptions
    WebRun opens Local Line to find members with expiring subscriptions.
    • Open Local Line and navigate to Subscriptions or CSA management
    • Filter to subscriptions expiring within the next 30 days
    • Capture each member's name, email, share type, and expiry date
    • Skip members who have already renewed or paused their subscription

    Done when All members with subscriptions expiring in the next 30 days are listed.

  3. 2
    Google Sheets - log members due for renewal
    google.com
    WebRun in Google Sheets: log members due for renewal
    WebRun opens Google Sheets to log members due for renewal.
    • Open the designated renewal tracking sheet
    • Add a row for each expiring member with name, email, share type, expiry date, and status
    • Mark any previously listed members whose status has changed since last run

    Done when The renewal tracker sheet is updated with all currently expiring members.

  4. 3
    Gmail - draft a renewal invitation per member
    gmail.com
    WebRun in Gmail: draft a renewal invitation per member
    WebRun opens Gmail to draft a renewal invitation per member.
    • Draft a warm renewal invitation for each member, naming their share type and renewal deadline
    • Include a link to your Local Line storefront to re-subscribe
    • Save each email as a Gmail draft, addressed and ready to send
    • Never send any email without your explicit approval

    Done when A renewal invitation draft exists in Gmail for every eligible expiring member.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.localline.co
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Renewal tracker · Google Sheets
OutputWhat each run produces - A Google Sheet log of expiring CSA members plus a batch of personalized Gmail renewal invitation drafts, one per member.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it send the renewal emails automatically?

No. Every renewal invitation is saved as a Gmail draft only. Nothing is sent to a member until you review and approve each email yourself.

What if a member renews after the draft was created?

On the next weekly run, WebRun checks Local Line again and skips anyone who has already renewed, so you will not send a duplicate invitation to a current member.

Can I customize the renewal offer or pricing in the email?

Yes. During setup you provide the renewal details, pricing, and any seasonal offer you want included, and WebRun incorporates them into every draft.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.