Generate bulk certificates from Google Sheets and Google Slides

Bulk certificate generator from Google Sheets and Slides

Categories: Productivity, Education, Google, Automation

Automate the creation of personalized certificates, diplomas, or event invitations at scale. This workflow takes a list of recipients from Google Sheets, generates customized PDFs from a Google Slides template, and tracks completion—perfect for course completions, event attendance, or team recognition programs.

Benefits

- Save 95% of manual time - Generate hundreds of certificates in minutes instead of hours of copy-paste work - Zero design skills needed - Create your template once in Google Slides (or download from Canva and import), then let automation handle the rest - Built-in tracking - Automatically marks processed recipients and stores Drive links in your spreadsheet - Rate-limit safe - Includes intelligent delays to respect Google API quotas - Clean workspace - Automatically deletes temporary files after PDF generation

How It Works

The workflow processes recipients one at a time in a loop:

1. Read recipients - Fetches unprocessed rows from your Google Sheet (filtered by "Processed = FALSE") 2. Copy template - Creates a temporary copy of your Google Slides template for each recipient 3. Personalize content - Replaces placeholders ({{name}}, {{date}}, {{certificateid}}) with actual recipient data 4. Export to PDF - Converts the personalized slide to a high-quality PDF 5. Save to Drive - Stores the final PDF in your designated Google Drive folder 6. Update tracker - Marks the row as processed and adds the Drive link to your sheet 7. Cleanup - Deletes the temporary slide copy to avoid clutter 8. Rate limiting - Waits 2 seconds before processing the next recipient (prevents API quota issues)