This add-on is completely free forever (not just a trial!), but if you need to remove the watermark, you can upgrade.
Your advantages:
Automate a never-ending and somewhat boring task: sending emails manually.


Simplify your work: lean back and let the plugin handle the recurring tasks.


Reduce mistakes: the add-on never forgets to send your emails.
Manually exporting and emailing Google Sheets™ can be time-consuming and repetitive. Schedule & Email Spreadsheets eliminates this hassle by automating your workflow. This powerful tool allows you to schedule reports, send sheet(s) in various formats, embed charts and tables in emails, and customize every detail—all within Google Sheets™.

🚀 Why Choose Schedule & Email Spreadsheets?
Whether you are a business owner, finance professional, sales manager, or educator, our add-on ensures that the right reports reach the right people at the right time—automatically. Say goodbye to missed deadlines and manual follow-ups.

⚡ Powerful Features to Streamline Your Work

► 📅 Automated Email Scheduling
— Set up recurring email reports on an hourly, daily (at two specified times), weekly, monthly, or even yearly basis, with full control over the exact delivery time. Automate your reporting and never miss a deadline again.

Examples:
— Daily at 9 AM and 5 PM — Send a morning sales update and an end-of-day performance summary.
— Weekly on Mondays at 10 AM — Email marketing performance reports to stakeholders.
— Monthly on the 1st at 3 PM — Share financial statements with management.
— Yearly on January 1st at 6 AM — Send an annual business performance report to investors.
— Custom schedule (e.g., every 3rd Friday at 4 PM) — Automate vendor order summaries for procurement.

► 📂 Tailored File Formats and Exports for Every Need
— Send entire spreadsheets, specific sheet(s), or custom cell ranges (e.g., B2:F20) so recipients get exactly what they need.

Export and send your Google Sheets™ in the following formats:
— 📊 Excel (.xlsx) — Ideal for financial reports, client data, and raw data sharing.
— 📄 CSV — Perfect for databases, analytics, and data imports.
— 📑 TSV — A tab-separated format suited for structured data and database processing.
— 🗂️ ODS — OpenDocument Spreadsheet format, compatible with LibreOffice and OpenOffice.
— 🖨️ PDF — Customize your exports with specific cell ranges (e.g., A1:F20) to ensure only relevant data is shared in a professionally formatted document. Ideal for reports, invoices, and presentations.
— 🖼️ PNG — Capture high-resolution snapshots of selected spreadsheet sections (e.g., D5:J15), preserving formatting and visuals for easy sharing of tables, charts, and key insights.

► 📌 Dynamic Data Embedding
— Embed live tables, charts, timelines, and formatted range data directly into the email body. No attachments necessary—just clear, visually appealing data within the email.

— ✍️ Smart Email Subject, Email Body, File Naming personalization
— {{Date}} — Inserts the current date in MM/dd/yyyy format.
— {{Date UK}} — Inserts the current date in dd/MM/yyyy format.
— {{Long Date}} — Inserts the full date in "MMMM dd, yyyy" format (e.g., January 31, 2025).
— {{Long Date UK}} — Inserts the full date in "dd MMMM yyyy" format (e.g., 31 January 2025).
— and many more date markers...
— {{Sheet Id}} — Inserts the Google Sheet’s unique identifier.
— {{Sheet Name}} — Inserts the name of the active sheet (e.g., "Sheet1").
— {{Spreadsheet Id}} — Inserts the unique identifier of the Google Spreadsheet.
— {{Spreadsheet Name}} — Inserts the name of the Google Spreadsheet.
— {{Random Id}} — Inserts a randomly generated alphanumeric string.
— {{Random Number}} — Inserts a randomly generated number.
— {{Image:'Employees'!A1:J50}} — Inserts an image of the specified range.
— {{Chart:'Data',1811248336}} — Embeds a chart image with the specified ID.
— {{Chart:'ChartSheet',331802849,800,600}} — Embeds a chart image with the specified size.
— {{Timeline:'Timeline 1',800,600}} — Embeds a timeline image with the specified size.
— {{Timeline:'Timeline 1!A1}} — Inserts timeline data image from the specified range.

— 🖋️ Advanced PDF Customization
— Tailor your PDFs with:
— Page Size: Choose from standard sizes like A4, Letter, Legal, or set custom dimensions.
— Scaling: Adjust scaling to fit your content perfectly.
— Margins & Orientation: Set custom margins and choose between Portrait or Landscape mode.
— Gridlines, Page Numbers & Headers/Footers: Customize alignment (horizontal/vertical), page order, and notes. Add gridlines, page numbers, and dynamic header/footer content. Optionally, repeat frozen rows and columns for better readability.

► 📧 Bulk Emailing with Dynamic Recipients
— Send reports to multiple recipients by specifying the TO, CC, and BCC fields. You can either manually input email addresses or pull them from a Google Sheet using placeholders like {{Sheet1!A2:A32}} to dynamically insert a range of email addresses.

► ⚙️ Additional features
— Custom Sender Name: Reflect your branding or personal touch.
— Flexible HTML Editor: Compose rich, formatted emails with images, links, and custom layouts.
— Preview and Send to Yourself: Preview the email before sending to your recipients.
— With these features, you can easily automate the sending of customized reports or communications to a large list of recipients, while maintaining personalization and control over the email content.

🌍 Real-World Use Cases
— 📊 Finance & Accounting — Automate monthly financial reports, invoices, and balance sheet(s) to stakeholders.
— 📈 Sales & Marketing — Send weekly sales reports and campaign performance summaries to clients and teams.
— 🏢 HR & Payroll — Distribute employee attendance sheet(s) and payroll summaries securely via email.
— 📦 Operations & Logistics — Ensure inventory reports, purchase orders, and supply chain updates are sent automatically.
— 🎓 Education — Share student progress reports, test scores, and attendance records with parents or administrators.

𝗦𝗰𝗵𝗲𝗱𝘂𝗹𝗲 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀:  
— Combine multiple time schedules  
— Define end date or number of occurrences to stop the schedule  
— Monthly schedule — Repeat every 1, 2, 3… months on a specific day and time  
— Weekday schedule — Sends on Mon–Fri  
— Weekly schedule — Repeat every 1, 2, 3… weeks on Mon–Sun at a specific time  
— One-time schedule — Send once on a specific future date and time  
— Define start date and time  
— Hourly schedule — Repeat every 1, 2, 3… hours  
— Bi-weekly schedule — E.g., every two weeks, every third month (quarterly), etc.  
— Weekend schedule — Sends on Sat and Sun  
— Daily schedule — Repeat every 1, 2, 3… days at a specific time  
— Annual schedule — Repeat yearly on a specific day and time  

𝗘𝗺𝗮𝗶𝗹 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀:  
— CC and BCC support — Specify additional recipients  
— Dynamic subject fields — Use current date or cell values  
— Google Drive export — Save files in a specific folder  
— Send Email Now — Instantly send emails for testing or manual delivery  
— Insert images — Add logos or visuals to the email body  
— WYSIWYG editor — Easily format email body  
— Email body — HTML or text-only  
— "To" field — Send emails to one or up to 50 recipients (Google limit may apply)  
— Multiple email configurations — Send different sheets with different settings to different recipients  
— Dynamic body fields — Insert current date, cell values, or cell ranges  

𝗘𝘅𝗽𝗼𝗿𝘁 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀:  
— Supported formats — PDF, Excel, ODS, CSV  
— PDF settings:  
   — Advanced formatting — Scale, margins, gridlines, etc.  
   — Custom header and footer settings  
   — Different paper sizes  
   — Landscape or portrait orientation  
— Dynamic file names — Use date or cell values  
— File Merger — Combine all sheets into a single PDF  
— Email sending not restricted — Subject to Google’s limits  
— Multiple configurations — Set up for any spreadsheet  
— Free version — Works forever with no time limit  
— Auto-refresh — Update formulas and filters before sending  
— Export specific cell ranges only  
— Export options — Export one or multiple sheets, the entire spreadsheet, or a selected range  
— Dynamic values — Use date and cell data for both export and email settings  
— Preview — Review export settings for each sheet  
— File Merger — Combine all sheets into a single PDF file for export  
— Include hidden sheets  
— Custom file names for attachments  
— Unlimited schedules — Create as many as you need  
— Advanced schedule options — Start/end dates, bi-weekly intervals  

📌 Suggested Alternative Names for This Add-on
 — Auto Emailer & Report Sender for Google Sheets™
 — Auto Email Reports & Exports for Google Sheets™
 — Auto Email Reports from Google Sheets™
 — Automated Email Scheduler for Google Sheets™
 — Automated Repeating Emails & Exports for Google Sheets™
 — Automated Reports for Google Sheets™
 — Automate Repeating Emails & Reports in Sheets™
 — Auto Recurring Emailer for Google Sheets™
 — Auto Recurring Email Reports for Google Sheets™
 — Auto Recurring Email Reports from Google Sheets™
 — Auto Recurring Reports & Email Scheduler for Sheets™
 — Auto-Send Recurring Reports & Emails in Sheets™
 — Data & Report Mailer for Google Sheets™
 — Email Reports & PDF Scheduler for Sheets™
 — Email Scheduler for Google Sheets™
 — Email Scheduler for Spreadsheets
 — Email Spreadsheets Schedule
 — Export & Email Tool for Google Sheets™
 — Recurring Email & Data Export for Google Sheets™
 — Recurring Email Reports & Exports for Google Sheets™
 — Recurring Email Reports for Google Sheets™
 — Recurring Email Scheduler for Google Sheets™
 — Recurring Email Tool for Google Sheets™
 — Recurring Google Sheets™ Email & Report Sender
 — Recurring PDF & CSV Emailer for Google Sheets™
 — Recurring & Repeating Reports from Google Sheets™
 — Recurring Report & Email Automation for Sheets™
 — Recurring Report & Email Exporter for Google Sheets™
 — Recurring Spreadsheet Reports & Emails Made Easy
 — Repeating Email Alerts & Reports in Google Sheets™
 — Repeating Email & Data Export for Google Sheets™
 — Repeating Email & Report Sender for Google Sheets™
 — Repeating Email Reports for Spreadsheets
 — Repeating Email & Report Tool for Google Sheets™
 — Repeating Email Scheduler for Google Sheets™
 — Repeating Reports & Emails from Google Sheets™
 — Schedule & Automate Emails from Sheets™
 — Schedule Email Reports
 — Schedule Email Spreadsheet
 — Schedule Email Spreadsheets 
 — Schedule Emails & Reports in Google Sheets™
 — Schedule Recurring Emails from Google Sheets™
 — Schedule Recurring Spreadsheet Emails & Reports
 — Schedule Repeating Emails in Google Sheets™
 — Send Emails from Google Sheets™ Automatically
 — Send Recurring Emails from Google Sheets™
 — Send Repeating Spreadsheet Reports Automatically
 — Sheets™ Auto Email & Report Sender
 — Sheets™ Email Scheduler & Attachment Sender
 — Smart Email Reports for Google Sheets™
 — Spreadsheet Email Automation & Reports
 — Spreadsheet Email & Report Automation
 — Send email in sheets
 — Send email in sheet
 — Send emails in sheets
 — Send email in sheets
 — Repeat send reports
 — Repeatedly send reports
 — Weekly reports
 — Monthly reports
 — Yearly reports
 — Send CSV
 — Email CSV

⭐ Premium Features:
— No add-on branding in emails or PNG images
— Priority customer support

🎯 Free Version Limitations:
— Schedule & Email Spreadsheets is available for free with a watermark.

For the full documentation, visit: https://www.dawent.com/sheets/schedule-email-spreadsheets/guide.

Watch the Video Tutorial: https://www.youtube.com/watch?v=1szEsUTf5ko