Automatically generate and send course certificates when new participants are added to Google Sheets

This workflow creates PDF certificates using Stencil, stores them in Google Drive, and emails them to participants.

How it works

1. A new row is added to the Google Sheets document (via form, webhook, or manual entry)
2. The workflow generates a PDF certificate using the Stencil API
3. The PDF is uploaded to a Google Drive folder for archiving
4. The certificate is sent to the participant via Outlook
5. The Google Sheet is updated with the file link and send timestamp

Setup steps

1. Create a free account at stencilpdf.com and set up a certificate template
2. Connect your Google account and select the target Sheet and Drive folder
3. Connect your Outlook account for sending emails
4. Configure the Stencil API credentials (Bearer Auth)
5. Adjust the email template text as needed

Prerequisites

• Free Stencil account with certificate template
• Google account (Sheets + Drive)
• Outlook/Microsoft 365 account