Email Spreadsheets vs Gopher for Groups

Email Spreadsheets automatically exports and emails your Google Sheets™ on a schedule — as PDF, Excel (xlsx), CSV, or PNG images. Send the entire spreadsheet, individual tabs, or a specific range of cells (like B7:F28) to one or more email recipients, on a recurring daily, weekly, or monthly schedule, automatically. Your data stays in your Google account — Nothing is stored on external servers. The add-on is developed by Amit Agarwal, Google Developer Expert and Google Cloud Innovator for Google Workspace™. 👉🏻 KEY FEATURES - Attach sheets as PDF, Excel (xlsx), PNG, or CSV files. - Schedule recurring reports — hourly, daily, weekly, monthly, or yearly. - Embed tables, charts, timelines, and dynamic cell ranges directly in the email body as high-resolution inline images, with original formatting preserved. - Add multiple recipients in the TO, CC, and BCC fields, or pull email addresses dynamically from your sheet. - Personalize the subject and body with live cell values using {{Sheet Name!A1}} markers. - Full control over PDF output: page orientation, margins, paper size, gridlines, and page numbers. - Customize the exported file name, including dates and dynamic cell data. 👉🏻 REAL-WORLD USE CASES - Submit expense reports to your boss on the last weekday of the month. - Email the weekly sales report, with embedded charts and tables, to your sales manager every Monday around noon. - Send social media performance reports to your team, management, or clients every alternating Wednesday. - Send weekly timesheets as CSV files automatically on Friday evening. - Schedule company newsletters to subscribers as a PDF every month. - Deliver client reports in Excel for AdWords, Search Console, CRM, or Google Analytics™. 👉🏻 DYNAMIC MARKERS (A1 notation) Insert live spreadsheet data into your subject line and email body: - {{Spreadsheet name}} — inserts the name of the current spreadsheet - {{Sheet Name!A1}} — inserts the value of cell A1 - {{Sheet Name!A10:G22}} — inserts a range of cells, preserving formatting - {{Date}}, {{LongDate}}, {{Time}}, {{Year}}, {{MonthName}}, {{DayName}} — insert the current date and time in a variety of formats (e.g., {{Date}} → 06-09-26) - {{Chart:Sheet Name!Chart Id}} — embeds a chart in the email body - {{Timeline:Sheet Name!Range}} — embeds a timeline view in the email body - {{NamedRange:Sheet Name!Named Range}} — inserts the data from a named range - {{Image:Sheet Name!Unique id,D11:K24}} — embeds a high-resolution screenshot of the data, tables, and charts in that range 👉🏻 FREE VS. PREMIUM Email Spreadsheets is free for basic use — email sheets and ranges to your own address manually. Every new user gets a 7-day unlimited-use trial, no credit card required. ✅ Upgrade to premium to unlock: - Unlimited scheduled email reports for any spreadsheet. - Recurring schedules — hourly, daily, weekly, monthly, or yearly. - Multiple recipients in the TO, CC, and BCC fields, including dynamic addresses pulled from cells. - No add-on branding in your emails. - Merge all sheets into a single PDF. - Advanced PDF options — gridlines, page numbers, and exporting a specific cell range. - Embedded charts and timelines in the email body. - HTML formatting in the email body (a, br, h1, and more). - Free email support. 👉🏻 Upgrade to premium to unlock all features: https://digitalinspiration.com/buy?sku=GA11 👉🏻 DOCUMENTATION New to Email Spreadsheets? The full documentation walks you through every step: - Getting started guide: https://digitalinspiration.com/docs/email-google-sheets/guide - Create your first workflow: https://digitalinspiration.com/docs/email-google-sheets/guide/create-workflow - Schedule recurring email reports: https://digitalinspiration.com/docs/email-google-sheets/guide/schedule-email - Specify email recipients: https://digitalinspiration.com/docs/email-google-sheets/guide/email-recipients - Build a dynamic email template: https://digitalinspiration.com/docs/email-google-sheets/guide/email-template - Customize PDF layout and page settings: https://digitalinspiration.com/docs/email-google-sheets/guide/pdf-export-settings - Customize the exported file name: https://digitalinspiration.com/docs/email-google-sheets/guide/custom-filename - Dynamic markers and settings reference: https://digitalinspiration.com/docs/email-google-sheets/markers Read the complete documentation at https://digitalinspiration.com/docs/email-google-sheets Questions or feedback? Email us at [email protected]

Google Groups are a very powerful permissions, communications, and collaboration tool in G Suite for EDU districts, but auditing and managing their access settings can be a challenge at scale. Gopher for Groups lets you gain visibility and control of critical Google Groups access and permissions settings that impact the security of domain resources and communications. Group owners sometimes make risky edits to critical settings like “Who can join” or “Who can post” in ways admins can’t easily discover. Default settings for new groups are likely too permissive for a typical school environment. Group settings are overwhelmingly many, and are extremely time-consuming to update at scale via Google’s user interface. How Gopher for Groups boosts your administrative game: - Quickly import all Google Groups settings available via Google’s APIs. - Filter for key privacy or online safety risks, such as permissive join or posting settings. - Perform advanced group membership analysis to account for all owners and managers, identify nested groups, and look for groups with membership set to “all in domain.” - Make all your group settings right in the sheet. Use the power of Sheets filters to limit which groups you want to update. - Preview all changes before bulk-committing them to Google’s APIs