Coassemble + Gmail + Formatter by Zapier + Google Slides

Generate course certificates from Coassemble via Google Slides and send them via Gmail

Looking for a way to create certificates for students who complete courses in Coassemble? After setting up this handy Coassemble-Google Sheets-Gmail integration, when a student completes a course, Zapier will send the results and student details over to your Google Slides certificate template, automatically populating the document and sending it to the student via Gmail.

When this happens...
Course Completed
Triggers when a student completes a course.
TriggerInstant
automatically do this...
Date / Time
Work with dates and times to change formatting or add/subtract time (with line-item support).
ActionWrite
then do this...
Create Presentation From Template
Creates a new presentation based on an existing one and can replace any placeholder variables found in your template presentation, like {{name}}, {{email}}, etc.
ActionWrite
then do this!
Send Email
Triggers when a new email appears in the specified mailbox.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Course
Triggers when a new course is created.
Trigger
Scheduled
Try It
New Enrollment
Triggers when a new enrollment is added.
Trigger
Instant
Try It
New User
Triggers when a new user is added.
Trigger
Scheduled
Try It
Course Completed
Triggers when a student completes a course.
Trigger
Instant
Try It
- TitleRequired
- FolderRequired
- Code
- Overview
Action
Write

- TitleRequired
Action
Write
- Course Or GroupRequired
- UserRequired
- RoleRequired
Action
Write

- UsernameRequired
- Password
- EmailRequired
- User Type
- First NameRequired
- Last Name
- Avatar
- Timezone
- Activate this user immediately
- Disable Course Enrolment Notification
Action
Write
- Course
- Group NameRequired
Action
Search
- Course Title or Code
- FolderRequired
- TitleRequired
- Code
- Overview
Action
Search or write
- EmailRequired
- UsernameRequired
- Password
- User Type
- First NameRequired
- Last Name
- Avatar
- Timezone
- Activate this user immediately
- Disable Course Enrolment Notification
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
- Title of New Presentation
- Is Shared?
- Template PresentationRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Label or mailbox
- Search keywords
Trigger
Scheduled
Try It
- Label or mailboxRequired
Trigger
Scheduled
Try It
- Search keywordsRequired
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
- Email message to be DeletedRequired
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Body type
- BodyRequired
- Label or mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Search or write

New Folder
Triggers when a new folder is added.
Trigger
Scheduled
Try It
New Group
Triggers when a new group is added.
Trigger
Scheduled
Try It
Module Completed
Triggers when a student completes a module.
Trigger
Instant
Try It
- UsersRequired
- Groups
- Courses
Action
Write
- UserRequired
Action
Write
- GroupRequired
- CourseRequired
Action
Write
- NameRequired
- CourseRequired
Action
Write
- Course Title or Code
- Folder
Action
Search
- EmailRequired
Action
Search
- CourseRequired
- Group NameRequired
- NameRequired
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
New Presentation
Triggers when a new presentation is created.
Trigger
Scheduled
Try It
- PresentationRequired
Action
Write
- Name
Action
Search
New Label
Triggers when you add a new label.
Trigger
Scheduled
Try It
- Label or mailbox
Trigger
Scheduled
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
Try It
- Label
- MessageRequired
Action
Write
- Recipient Instructions
- To
- Cc
- Bcc
- SubjectRequired
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Name of labelRequired
Action
Write
- MessageRequired
- Label(s) to removeRequired
Action
Write
- Search StringRequired
Action
Search

About Coassemble

Coassemble is a friendly yet powerful cloud-based platform that simplifies all aspects of online training.

Learn more Help

Related categories

Online Courses

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Learn more Help

Related categories

Similar apps

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Learn more Help

Related categories

About Google Slides

Google Slides allows you to create, edit, and share presentations with anyone, online, for free.

Learn more Help

Coassemble + Gmail + Formatter by Zapier + Google Slides

Generate course certificates from Coassemble via Google Slides and send them via Gmail

New Course

New Enrollment

New User

Course Completed

Create Course

Code

Overview

Create Folder

Create Enrollment

Create User

Password

User Type

Last Name

Avatar

Timezone

Activate this user immediately

Disable Course Enrolment Notification

Find Group

Course

Find or Create Course

Course Title or Code

Code

Overview

Find or Create User

Password

User Type

Last Name

Avatar

Timezone

Activate this user immediately

Disable Course Enrolment Notification

Numbers

Utilities

Create Presentation From Template

Title of New Presentation

Is Shared?

API Request (Beta)

Api Docs Info

Query String Parameters

Headers

Additional Request Headers

Body

New Attachment

Label or mailbox

Search keywords

New Labeled Email

New Email Matching Search

New Thread

Label/Mailbox

Delete Email

Create Draft Reply

Trigger Instructions

To

Cc

Bcc

From

From Name

Body type

Add signature default

Label or mailbox

Attachments

Send Email

To

Cc

Bcc

From

From Name

Reply To

Body type

Add signature default

Label or mailbox

Attachments

Reply to Email

Trigger Instructions

To

Cc

Bcc

From