agentsclimarketplace

Email send bulk

Skill aAAaqwq/AGI-Super-Team/skills/email-send-bulk

Gmail API bulk email sendingFrom its SKILL.md

Install
npx -y skills add aAAaqwq/AGI-Super-Team --skill email-send-bulk

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

2.4 KB, 645 tokens by cl100k_base, as published. Nobody here has run it

Email Send Bulk

Bulk email sending via Gmail API from Google Sheets

When to use

  • "send email"
  • "write an email"
  • "email campaign"
  • When preferred_channel = Email in data

IMPORTANT: Confirmation rule

ALWAYS show the email text (To, Subject, Body) and ask for user confirmation BEFORE sending. Never send an email without an explicit "yes" / "send it" from the user.

Dependencies

  • Python 3.12+ (venv: $GOOGLE_TOOLS_PATH/.venv/bin/python3)
  • google-api-python-client, google-auth-oauthlib
  • Google OAuth token with Gmail scope

Paths

WhatPath
Script$GOOGLE_TOOLS_PATH/send_emails.py
Token$GOOGLE_TOOLS_PATH/token.json
Credentials$GOOGLE_TOOLS_PATH/credentials.json

Spreadsheet Config

  • ID: YOUR_SPREADSHEET_ID
  • Sheet: Form Responses (1)
ColumnIndexPurpose
B1Name
C2Email
T19Email Status
U20Email text

How to run

cd $GOOGLE_TOOLS_PATH
.venv/bin/python3 send_emails.py 5      # send 5 emails
.venv/bin/python3 send_emails.py 10     # send 10 emails
.venv/bin/python3 send_emails.py        # default 5

How it works

  1. Reads Google Sheet
  2. Filters: status != Sent AND email is not empty AND text is not empty
  3. Composes email from Your Name <[email protected]>
  4. Sends via Gmail API
  5. Updates status in column T
  6. 1 sec delay between emails

Subject

Hardcoded in script:

Data labeling training from YourCompany Inc.

To change -- edit SUBJECT in the script.

Statuses (column T)

  • Sent -- success
  • Error: ... -- error details

Sender

From: Your Name <[email protected]>

Limits

  • Gmail limit: ~500 emails/day
  • ~2000 emails/day for Google Workspace
  • 1 sec delay (can be reduced)

How to prepare email text

Text is taken from column U. Can be prepared via:

# $GOOGLE_TOOLS_PATH/prepare_emails.py
# Generates personalized text for each recipient

Troubleshooting

ProblemSolution
401 UnauthorizedRefresh token: google-auth
Daily limit exceededWait 24 hours
Invalid emailCheck format in spreadsheet

Related skills

  • telegram-send -- alternative channel
  • google-auth -- if authorization issues
  • update-lead -- update status after campaign

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.