Bear Brown
← All N8N workflows
Data & databasesGmailGoogle DriveGoogle Sheets TriggerGoogle SlidesIf

DSP Certificate w/ Google Forms

Configured with Gmail, Google Drive, Google Sheets Trigger, Google Slides. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗8 nodes · MIT
Workflow preview
TriggerGoogle Sheets TriggerGoogle Sheets TriggerRoutingNo Operation, donothingNo OpTransformExtract essential dataEdit FieldsRoutingScore CheckerIfFiles / mediaCopy from your templateGoogle DriveFiles / mediaReplace textGoogle SlidesFiles / mediaConvert to PDFGoogle DriveMessagingSend to user's emailGmail

Node categories in this workflow

  • Trigger
  • Routing
  • Transform
  • Files / media
  • Messaging

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Google Sheets TriggerTriggerGoogle Sheets TriggerSee node parameters
No Operation, do nothingRoutingNo OpSee node parameters
Extract essential dataTransformEdit FieldsSee node parameters
Score CheckerRoutingIfSee node parameters
Copy from your templateFiles / mediaGoogle Drivecopy
Replace textFiles / mediaGoogle SlidesreplaceText
Convert to PDFFiles / mediaGoogle Drivedownload
Send to user's emailMessagingGmailSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • gmailOAuth2
  • googleDriveOAuth2Api
  • googleSheetsTriggerOAuth2Api
  • googleSlidesOAuth2Api

Workflow notes

1) Start here

1) Start here

  • Create a Google Form and then enable quiz mode.
  • Publish it, submit 1 text data.
  • In response section, you'll see "Link to Google Sheet" option.
  • Press, and it will create a new sheet.
4) Passing Score

4) Passing Score

  • Adjust your passing score here
2) Trigger Node

2) Trigger Node

  • Replace your Google Sheet id's in this node.
3) Extract Node

3) Extract Node

  • Select the data we want to use to proceed.
  • For this case, i'll select only Name, Email, Score (Because this is only what we need)
4.2) Score > passing criteria

4.2) Score > passing criteria

  • Create new Google Slide
  • Decorate it as you desired (This will be certificate's template)
  • Use [ name ] to be a placeholder for user's name
  • Replace it with your Google Slide's id
5) Replace text

5) Replace text

  • This node will replace [ name ] with user's input name.
6) To PDF

6) To PDF

  • Change file name as you desire.
7) Send email

7) Send email

  • Send to user's email
  • Customize your message here.
DSP Certificate w/ Google Forms

DSP Certificate w/ Google Forms

Purpose and structure

This folder contains the DSP Certificate w/ Google Forms workflow. Its executable nodes use gmail, googleDrive, googleSheetsTrigger, googleSlides, if, noOp, set. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Google Sheets Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Googleslides/0754_Googleslides_Noop_Automation_Triggered.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • 4.1) Score < passing criteria

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales