Daily personalized Skool community invites from a Google Sheet queue

Build me an agent workflow that drains my Skool community invite queue every weekday morning with personalized outreach instead of a generic mass invite.

Trigger: cron, every weekday (Monday through Friday) at 8:00am America/New_York.

Inputs I will provide when I save the workflow: the Google Sheets spreadsheet ID and the tab/range that holds my prospect list, the name of my Skool group, and the Gmail address I send from. My sheet has these columns in this order: name, email, context (where I met them and why they would like the community), status, and invited_at.

Steps the agent should run on each fire:

1. Use Google Sheets Get Values to read the full prospect tab. Filter the rows down to ones where the status column is exactly "pending" and the email column is non-empty. Stable-sort by sheet row order so the oldest entries get invited first. Take at most the first 25 rows. If there are zero pending rows, do nothing and exit cleanly.

2. For each selected row, draft a short, warm, personal invitation email (about 4 to 7 sentences). It should: greet the person by first name, reference the specific context from the context column (where I met them and why they would like this community), invite them to join my Skool community, and let them know the official Skool invite link will arrive in a separate email right after. Keep the tone like a one to one note from me, not a marketing blast. No emojis, no marketing-style subject lines. Subject line should feel like a personal email.

3. Send that draft via Gmail Send a Message from my address to the prospect's email.

4. Immediately after the Gmail send succeeds, call Skool Invite Member with that prospect's email so the official Skool join link is delivered separately by Skool.

5. Update that row's status column to "invited" and the invited_at column to today's date in ISO format (YYYY-MM-DD). Use Google Sheets to write back to the exact same row. If the platform supports a targeted update, prefer that; otherwise append a new row to a sibling "invite_log" tab with the email, status "invited", and the date, and treat that log as the source of truth for which prospects have already been contacted.

Error handling: if any single prospect fails (bad email, Skool rejects the invite, Gmail rate limit), log the failure and continue with the next row instead of failing the whole batch. Do not mark a row as invited unless the Gmail send succeeded. If the Skool invite fails after the Gmail send, leave the row as pending and add a short note in the context column so I can see it on the next run.

At the end of the run, return a short summary: how many prospects were invited, how many failed and why, and how many pending rows are still in the queue.

Additional information

What does this prompt do?

Reads your Google Sheet of prospects every weekday morning and picks up only the rows still marked as pending.
Writes a short, personal invitation email for each prospect using the context you captured (where you met, why they would like the community) and sends it from your Gmail.
Sends the official Skool community invite to the same person so the join link arrives as a separate, recognizable message.
Marks each row as invited with today's date so the queue stays clean and you never double-invite the same person.
Caps the batch at 25 invitations per run so every message still feels handwritten, not mass produced.

What do I need to use this?

A Skool group on the Pro plan where you are a group admin (the integration plugin is only available on Pro).
A Google account with access to both Gmail and the Google Sheet that holds your prospect list.
A spreadsheet with columns for name, email, the context behind the lead, a status column (pending or invited), and a date column for the invite timestamp.

How can I customize it?

Change the schedule (for example, run it three mornings a week, or move it to your own time zone).
Raise or lower the 25 per day cap based on how personal you want the outreach to feel.
Edit the voice and length of the invitation email, or add a P.S., a calendar link, or a short video link.
Point the workflow at a different sheet or tab, or rename the status values to match how your spreadsheet is already set up.

Frequently asked questions

Will this work on the free Skool plan?

No. Skool only exposes the invite action on Pro group plans, so your community needs to be on Pro and you need to be a group admin to use it.

Why send a personal email AND the official Skool invite?

The personal email explains why you are reaching out and warms the prospect up. The official Skool invite is the recognizable join link they actually click. Splitting them keeps the human note human and avoids your warm email looking like a system notification.

How does it know which prospects to skip?

It only acts on rows where your status column says pending. After it invites someone, it flips that row to invited with today's date, so the next run automatically skips them.

Why a 25 per day cap?

Mass community invites get ignored or reported as spam. Limiting the batch keeps the volume low enough that each email reads like a one to one note, which is what makes this kind of outreach work in the first place.

Can I review the emails before they go out?

Yes. You can ask for a version that drops the personalized email into your Gmail drafts instead of sending automatically, so you can scan or tweak each one before it ships.