Turn quiz results into ready to send certificates without manual work. When a new response lands in a Google Sheet, passing learners get a personalized PDF certificate by email. It fits training, schools, and any team that needs proof of completion fast.

Here is how it runs. A Google Sheets Trigger checks for new rows every minute. A Set step pulls the name, email, and score from the sheet. An If step compares the score to your passing mark. If the person passes, Google Drive copies your Google Slides template, Google Slides replaces the [ name ] placeholder, Google Drive exports the file to PDF, and Gmail sends it to the learner’s email. If the score is below the mark, it stops and sends nothing.

You need a Google Form linked to a Google Sheet, a Slides template with a [ name ] placeholder, and Gmail access. Expect big time savings, fewer mistakes, and faster delivery to large groups. It works well for compliance training, course completion, workshop certificates, and student quizzes. Setup is simple once you map the three fields and paste your template and folder IDs.

• Google Sheets Trigger polls every minute for new quiz responses
• Set step extracts only the name, email, and score fields you need
• If logic checks score against your passing threshold
• Google Drive copies a Slides template and names the file with the learner’s name
• Google Slides replaces the [ name ] placeholder with the actual name
• Google Drive exports the slide copy to a PDF file
• Gmail sends a personalized email with the PDF attached to the learner

• Reduce manual work from hours of editing to a few minutes per batch
• Automate over 90% of the certificate workflow from sheet to inbox
• Eliminate naming and copy paste errors by using structured data
• Handle spikes in submissions and send certificates at scale
• Connect Google Sheets, Google Slides, Google Drive, and Gmail in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Google Drive, Google Slides and Gmail. See the Tools Required section above for links to create accounts with these services.
3. Prepare your data: create a Google Form in quiz mode and link it to a Google Sheet. Submit a test response so your sheet has headers for Name, Email, and Score.
4. Open the Google Sheets Trigger node in n8n. In the credential dropdown, click Create new credential and follow the on screen steps to connect your Google Sheets account. Select the correct spreadsheet and tab. Keep polling every minute.
5. Open the Set node and map your sheet columns to three fields: respondentName, respondentEmail, and respondentScore. Make sure the field names match your sheet headers exactly.
6. Open the If node labeled Score Checker. Set the comparison so respondentScore must be greater than or equal to your passing score value.
7. Create your certificate template in Google Slides with a clear [ name ] placeholder. Note the template file ID and your target Google Drive folder ID.
8. In the Google Drive node Copy from your template, create credentials if prompted. Paste your Slides template file ID, choose the destination folder, and use a file name pattern that includes the learner’s name.
9. Open the Google Slides node Replace text. Connect your Google Slides account if needed. Set the find value to [ name ] and the replace value to the name field from the Set node.
10. Open the Google Drive node Convert to PDF. Ensure it uses the copied slide file from the previous step and exports as PDF. Set a clear output name.
11. Open the Gmail node. Create credentials if needed. Set the To field to the respondentEmail value, write a subject and message, and attach the PDF file from the previous step.
12. Activate the workflow. Submit a new quiz response that meets the passing score. Confirm a PDF certificate is created in your Drive and that Gmail sends the email to the test address.
13. Troubleshoot if needed: check that your sheet headers match the Set node, confirm the Slides placeholder is exactly [ name ], verify file and folder IDs, and make sure each Google credential is authorized in the n8n credentials manager.