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

Sync Outlook calendar events to Harvest for automated time tracking

This automation template allows users to automatically create a corresponding time entry in Harvest, a time tracking and invoicing application, whenever a new calendar event is scheduled in Microsoft Outlook. The automation pulls in key details from the calendar event, such as the title, date, and duration, and uses this information to populate the Harvest time entry. This integration streamlines the process of logging work time, ensuring that billable hours are accurately tracked and recorded. The primary user for this automation would be professionals who rely on both Outlook and Harvest to manage their schedules and finances, seeking a seamless way to bridge these two tools.

26s$0.0703
Email

Streamline Outlook email management with ChatGPT-powered replies

This automation allows Outlook users to generate AI-based email replies by processing incoming messages with ChatGPT. The solution integrates with Microsoft Outlook, analyzing each incoming email and then drafting a personalized response using the power of large language models. Once the AI-generated reply is ready, the automation can either automatically send the message or present it to the user for review before sending. This streamlines the email management process, enabling users to quickly and intelligently respond to a high volume of messages with minimal effort.

26s$0.0703
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