AutoCerts is a comprehensive productivity add-on for Google Sheetsâą designed to automate the creation of certificates, diplomas, professional credentials, and personalized email campaigns.
Ideal for teachers, academies, conference organizers, and corporate teams that need to generate PDF documents and send bulk emails quickly, securely, and professionally, directly from Google Workspace.
ââââââââââââââââââââ
KEY FEATURES
ââââââââââââââââââââ
1. CERTIFICATE & DIPLOMA AUTOMATION
âą Custom Templates
Use your own Google Slidesâą or Google Docsâą templates, select a pre-designed template, or start with a blank design.
âą Dynamic Data Mapping
Automatically connect Google Sheetsâą columns with dynamic tags such as {{Name}}, {{Course}}, {{Date}}, or any other data from your spreadsheet.
âą Validation QR Codes
Insert customizable QR codes that can direct recipients to a digital authenticity record, your website, LinkedIn, or other professional resources.
âą Sequential Numbering
Automatically generate unique and sequential certificate numbers, such as CERT-001-2026, and store them directly in your spreadsheet.
âą Flexible Issuing Options
Generate certificates manually, schedule them for a specific date and time, or automate the process when new responses are received through Google Formsâą.
âą Individual or Consolidated PDFs
Generate a separate PDF file for each participant or combine all certificates into a single document ready for printing or distribution.
ââââââââââââââââââââ
2. MAIL MERGE
ââââââââââââââââââââ
âą Integrated Visual Editor
Create rich-format emails, use dynamic variables, and preview personalized messages for each recipient.
âą Attachments from Google Driveâą
Attach personalized files stored in the Google Driveâą folders you authorize.
âą Conditional Filters
Send emails only to rows that meet specific conditions, such as: Grade >= 70.
âą Delivery Controls
Customize the sender name, CC, BCC, Reply-To address, and scheduled delivery options.
ââââââââââââââââââââ
3. MULTILINGUAL EXPERIENCE
ââââââââââââââââââââ
AutoCerts provides native support for 5 languages:
âą Spanish
âą English
âą French
âą German
âą Portuguese
ââââââââââââââââââââ
SECURITY & PRIVACY
ââââââââââââââââââââ
AutoCerts is designed around the principle of least privilege. The add-on requests only the permissions required to perform the functions authorized by the user.
Access to Google Sheetsâą is limited to the active spreadsheet in use, while templates and Google Driveâą files are explicitly selected by the user through Google's authorization and file-selection mechanisms.
Data is processed within the Google Workspace ecosystem. AutoCerts does not sell user data or use it to train third-party artificial intelligence models.
ââââââââââââââââââââ
WHY USE AUTOCERTS?
ââââââââââââââââââââ
Turn spreadsheet data into professional certificates, diplomas, verifiable documents, and personalized communications without manually copying and pasting information.
Automate repetitive tasks, reduce errors, and save valuable time while keeping your documents and communications organized directly within Google Workspace.
Install AutoCerts and transform your spreadsheets into professional documents and personalized email campaigns in minutes.
ââââââââââââââââââââ
TRADEMARK DISCLAIMER
ââââââââââââââââââââ
Google Sheetsâą, Google Slidesâą, Google Docsâą, Google Driveâą, and Google Formsâą are trademarks of Google LLC.
AutoCerts is an independent solution and is not affiliated with, endorsed by, or sponsored by Google LLC.