Latenode
Google sheets
Google slides
Google drive
Gmail

Streamline certificate delivery with Google Sheets, Slides, PDF & Gmail

This automated workflow allows users to generate personalized certificates using data from Google Sheets and certificate templates from Google Slides.

It then converts the customized certificates to PDF format and sends them directly to recipients via Gmail. This solution streamlines the process of creating and distributing digital certificates, making it suitable for schools, universities, training programs, and webinars that need to efficiently manage certificate generation and delivery.

Updated Apr 2, 2026Est. run: 15sEst. cost: $0.0009
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Email

Workflow preview

What this template does

  • Extracts data from Google Sheets to populate certificate templates
  • Customizes certificate templates in Google Slides with personalized data
  • Converts personalized certificates to PDF format
  • Sends personalized PDF certificates to recipients via Gmail
  • Generates and distributes digital certificates efficiently

How it works

1
Trigger

Watch Google Sheet

The workflow starts by monitoring a Google Sheet for new rows. It will watch the sheet and detect when new data is added.

2
Action

Personalize Certificate

When new data is detected, the workflow will create a copy of the certificate template slide from Google Slides and replace the [NAME] placeholder with the participant's name from the Google Sheet.

3
Action

Save as PDF

The personalized certificate slide will then be exported as a PDF file.

4
Action

Upload to Drive

The generated PDF certificate will be saved to a Google Drive folder.

5
Action

Clean Up

The temporary copy of the personalized certificate slide will be deleted from Google Slides.

6
Action

Email Certificate

Finally, the PDF certificate will be sent to the participant via Gmail.

Setup guide

1

Connect Google Sheets Credential

Add a Google Sheets credential via OAuth in the Latenode Credentials panel.

2

Connect Google Slides Credential

Add a Google Slides credential via OAuth in the Latenode Credentials panel.

3

Connect Google Drive Credential

Add a Google Drive credential via OAuth in the Latenode Credentials panel.

4

Connect Gmail Credential

Add a Gmail credential via OAuth in the Latenode Credentials panel.

5

Configure Workflow

1. Add a Google Sheets Trigger node and configure it to watch for new rows in your certificate data sheet. 2. Add a Google Slides node and configure it to copy the certificate template file and replace the [NAME] placeholder with the participant's name. 3. Add a Google Drive node to download the customized certificate as a PDF file. 4. Add another Google Drive node to upload the PDF certificate to a destination folder. 5. Add a Gmail node to send the generated certificate to the participant's email address.

Requirements

Google Sheets account with access to the spreadsheet containing certificate data
Google Slides account with access to the certificate template presentations
Google Drive access to store the generated PDF certificates
Gmail account to send the PDF certificates to recipients

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Email

Automatically sync Harvest time entries from new Outlook events

This automation creates time entries in the Harvest time tracking app whenever a new event is added to the user's Microsoft Outlook calendar. This ensures that time spent in meetings and on tasks is accurately logged, boosting productivity and enabling better project management. The workflow starts with a trigger for new calendar events in Outlook, which then automatically creates a corresponding time entry in Harvest, pulling in details like the event title, date, and duration.

8s$0.0005
Email

Automate Outlook email responses with OpenAI ChatGPT

This Latenode automation template allows users to generate AI-based email responses in Microsoft Outlook using the ChatGPT language model. When a new email is received in the user's Outlook inbox, the integration will send the email content to ChatGPT, which will then generate a relevant response. The automation can either automatically send the AI-generated response back to the original contact or draft the response for the user to review before sending. This solution helps save time and effort on composing email replies, particularly for high-volume or repetitive inquiries.

17s$0.0011
Email

Automatically send SurveyMonkey surveys for flagged Outlook emails

This workflow automatically triggers a SurveyMonkey survey to be sent whenever a new email is flagged in a user's Microsoft Outlook mailbox. By streamlining the process of soliciting feedback, this automation helps businesses promptly and systematically gather crucial data from their customers or employees. The workflow is triggered by a 'New Flagged Email' event in Microsoft Outlook, and it then sends the configured SurveyMonkey survey to the relevant recipients. This efficient process saves users time by eliminating the manual steps of identifying flagged emails and sending surveys individually.

7s$0.0004