{"id":2133,"date":"2025-09-28T09:54:38","date_gmt":"2025-09-28T09:54:38","guid":{"rendered":"https:\/\/itxperts.co.in\/blog\/?p=2133"},"modified":"2025-09-28T09:56:23","modified_gmt":"2025-09-28T09:56:23","slug":"auto-send-certificates-google-forms-apps-script","status":"publish","type":"post","link":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/","title":{"rendered":"Auto-generate &#038; Auto-send Certificates from Google Forms"},"content":{"rendered":"\n<p><strong>Short description:<\/strong> Step-by-step tutorial to auto-create PDF certificates from a Google Slides template and email them automatically when someone submits your Google Form. Includes ready-to-use Google Apps Script, troubleshooting tips, and optional extras you can add.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Auto Generate &amp; Send Certificates from Google Form | Google Sheets + Slides + Apps Script Tutorial\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/iVvCLgxYeNU?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Why this? Who it&#8217;s for<\/h2>\n\n\n\n<p>If you run workshops, online classes, events, or assessments and want to automatically give participants a certificate when they complete a Google Form, this tutorial shows a simple, free method using:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Google Forms (collect responses)<\/li>\n\n\n\n<li>Google Sheets (response storage)<\/li>\n\n\n\n<li>Google Slides (certificate template)<\/li>\n\n\n\n<li>Google Apps Script (automation + email)<\/li>\n<\/ul>\n\n\n\n<p>Perfect for teachers, trainers, event organizers, and small course creators.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A Google account with permission to create Forms\/Slides\/Sheets.<\/li>\n\n\n\n<li>A Google Form that collects at least <strong>Name<\/strong> and <strong>Email<\/strong> (both required). If your Form uses different field names, this tutorial shows how to adapt.<\/li>\n\n\n\n<li>A Google Slides presentation you will use as the certificate template (placeholders required \u2014 details below).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Quick overview of steps<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create and link your Google Form to a Google Sheet.<\/li>\n\n\n\n<li>Design a Google Slides certificate template with placeholders (e.g., <code>{{Name}}<\/code>, <code>{{Event}}<\/code>, <code>{{Date}}<\/code>).<\/li>\n\n\n\n<li>Open the linked Google Sheet \u2192 Extensions \u2192 Apps Script and paste the script below.<\/li>\n\n\n\n<li>Add an <strong>Installable trigger<\/strong>: <em>On form submit<\/em> \u2192 <code>sendCertificate<\/code>.<\/li>\n\n\n\n<li>Test a form submission and verify the emailed PDF certificate.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1) Create the Google Form &amp; link to a Sheet<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create a Google Form (forms.google.com).<\/li>\n\n\n\n<li>Add required fields: <strong>Name<\/strong> and <strong>Email<\/strong> (exact header names are helpful but not required).<\/li>\n\n\n\n<li>Click the <strong>Responses<\/strong> tab \u2192 click the green <strong>Sheets<\/strong> icon to create or choose a linked Google Sheet. The Sheet will receive each submission as a new row (timestamp + fields).<\/li>\n<\/ol>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Tip: Keep the first sheet (tab) as the response sheet (it\u2019s where the script will look by default).<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2) Create a Google Slides certificate template<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open Google Slides (slides.google.com) and create a new presentation.<\/li>\n\n\n\n<li>Set the page size: <code>File \u2192 Page setup \u2192 Custom<\/code> \u2014 I like <code>11 x 8.5 in<\/code> (landscape).<\/li>\n\n\n\n<li>Design your certificate. Wherever you want to insert dynamic text, write placeholders exactly like these (including braces):<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>{{Name}}<\/code><\/li>\n\n\n\n<li><code>{{Event}}<\/code><\/li>\n\n\n\n<li><code>{{Date}}<\/code><\/li>\n<\/ul>\n\n\n\n<p>You can add additional placeholders such as <code>{{Serial}}<\/code> or <code>{{Score}}<\/code> if you want to merge more fields.<\/p>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Get the <strong>Slides file ID<\/strong> from the URL, for example:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>https:&#47;&#47;docs.google.com\/presentation\/d\/XXXXXXXXXXXXXXXXXXXXXXXXXXXX\/edit\n<\/code><\/pre>\n\n\n\n<p>Copy the long <code>XXXXXXXXXXXXXXXX...<\/code> part \u2014 that is your template ID.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3) The Apps Script (paste into the linked Google Sheet)<\/h2>\n\n\n\n<p>Open the linked Google Sheet \u2192 <code>Extensions<\/code> \u2192 <code>Apps Script<\/code>. In the code editor replace any default content with the script below. <strong>Update the configuration variables at the top<\/strong>: <code>TEMPLATE_SLIDES_ID<\/code>, <code>EVENT_NAME<\/code>, and optionally <code>CERTIFICATES_FOLDER_ID<\/code>.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Important:<\/strong> This script is written to be resilient: it will try to find <code>Name<\/code> and <code>Email<\/code> using common header names. If your Sheet uses different column titles, either change them or edit the header-name lists inside the script.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">Copy\u2011paste ready script<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ ===================== CONFIG =====================\nvar TEMPLATE_SLIDES_ID = 'YOUR_SLIDES_TEMPLATE_ID'; \/\/ replace with your Slides template ID\nvar EVENT_NAME = 'AI Workshop 2025';                \/\/ replace with your event name\nvar CERTIFICATES_FOLDER_ID = '';                    \/\/ optional: Google Drive folder ID to save copies (leave blank to skip)\n\n\/\/ ==================================================\n\nfunction sendCertificate(e) {\n  try {\n    var ss = SpreadsheetApp.getActiveSpreadsheet();\n    var sheet = ss.getActiveSheet();\n\n    \/\/ Determine the row that was just submitted.\n    var row;\n    if (e &amp;&amp; e.range &amp;&amp; typeof e.range.getRow === 'function') {\n      row = e.range.getRow();\n    } else {\n      \/\/ fallback \u2014 use last row in sheet\n      row = sheet.getLastRow();\n    }\n\n    var lastColumn = sheet.getLastColumn();\n    var headers = sheet.getRange(1, 1, 1, lastColumn).getValues()&#91;0];\n    var rowData = sheet.getRange(row, 1, 1, lastColumn).getValues()&#91;0];\n\n    \/\/ Build a normalized header -&gt; value map (lowercased keys)\n    var normalized = {};\n    for (var i = 0; i &lt; headers.length; i++) {\n      var key = headers&#91;i] ? headers&#91;i].toString().trim().toLowerCase() : ('column' + (i+1));\n      normalized&#91;key] = rowData&#91;i];\n    }\n\n    function getByHeaders(candidates) {\n      for (var j = 0; j &lt; candidates.length; j++) {\n        var test = candidates&#91;j].toLowerCase();\n        if (normalized&#91;test]) return normalized&#91;test];\n      }\n      return null;\n    }\n\n    \/\/ Try common header names for name and email\n    var name = getByHeaders(&#91;'name', 'full name', 'participant name', 'your name', 'student name']) || rowData&#91;1] || 'Participant';\n    var email = getByHeaders(&#91;'email', 'e-mail', 'email address', 'your email', 'email id']) || rowData&#91;2];\n\n    if (!email) {\n      Logger.log('No email address found in row ' + row + '. Aborting sending certificate.');\n      return;\n    }\n\n    \/\/ Extra dynamic placeholders you can set here\n    var dateStr = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'dd MMM yyyy');\n    var certSerial = 'CERT-' + new Date().getTime(); \/\/ unique-ish serial\n\n    \/\/ Make a copy of the Slides template\n    var templateFile = DriveApp.getFileById(TEMPLATE_SLIDES_ID);\n    var copyFile = templateFile.makeCopy('Certificate - ' + name + ' - ' + certSerial);\n    var copyId = copyFile.getId();\n\n    \/\/ Open the copy and replace placeholders on every slide\n    var presentation = SlidesApp.openById(copyId);\n    var slides = presentation.getSlides();\n    for (var s = 0; s &lt; slides.length; s++) {\n      slides&#91;s].replaceAllText('{{Name}}', name);\n      slides&#91;s].replaceAllText('{{Event}}', EVENT_NAME);\n      slides&#91;s].replaceAllText('{{Date}}', dateStr);\n      slides&#91;s].replaceAllText('{{Serial}}', certSerial);\n\n      \/\/ If you added other placeholders in your Slides (e.g. {{Score}}), replace them here.\n      \/\/ Example: slides&#91;s].replaceAllText('{{Score}}', getByHeaders(&#91;'score','marks']) || '');\n    }\n    presentation.saveAndClose();\n\n    \/\/ Convert the copy to PDF\n    var pdfBlob = DriveApp.getFileById(copyId).getAs('application\/pdf').setName('Certificate - ' + name + '.pdf');\n\n    \/\/ Optionally move\/add the copy to a folder (if CERTIFICATES_FOLDER_ID is set)\n    if (CERTIFICATES_FOLDER_ID &amp;&amp; CERTIFICATES_FOLDER_ID.length &gt; 5) {\n      try {\n        var folder = DriveApp.getFolderById(CERTIFICATES_FOLDER_ID);\n        folder.addFile(DriveApp.getFileById(copyId));\n      } catch (folderErr) {\n        Logger.log('Error adding file to folder: ' + folderErr);\n      }\n    }\n\n    \/\/ Email the PDF\n    var subject = 'Your Certificate - ' + EVENT_NAME;\n    var body = 'Dear ' + name + ',\\n\\nThank you for participating in ' + EVENT_NAME + '. Please find attached your certificate.\\n\\nRegards,\\n&#91;Your Organization]';\n\n    MailApp.sendEmail({\n      to: email,\n      subject: subject,\n      body: body,\n      attachments: &#91;pdfBlob]\n    });\n\n    \/\/ Optional cleanup: put the copy in trash if you don't want to store it\n    \/\/ DriveApp.getFileById(copyId).setTrashed(true);\n\n    \/\/ Optional: write \"Certificate Sent\" status into a column (create column if needed)\n    var statusColIndex = -1;\n    for (var h = 0; h &lt; headers.length; h++) {\n      if (headers&#91;h] &amp;&amp; headers&#91;h].toString().trim().toLowerCase() === 'certificate sent') {\n        statusColIndex = h + 1; \/\/ 1-based\n        break;\n      }\n    }\n    if (statusColIndex === -1) {\n      \/\/ create the column at the end\n      statusColIndex = lastColumn + 1;\n      sheet.getRange(1, statusColIndex).setValue('Certificate Sent');\n    }\n    sheet.getRange(row, statusColIndex).setValue('Yes - ' + new Date());\n\n  } catch (err) {\n    Logger.log('Error in sendCertificate: ' + err);\n  }\n}\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4) Install the trigger (so script runs automatically on form submit)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the Apps Script editor click the <strong>Triggers<\/strong> icon (clock) on the left.<\/li>\n\n\n\n<li>Click <strong>Add trigger<\/strong> (bottom right).<\/li>\n\n\n\n<li>Configure:\n<ul class=\"wp-block-list\">\n<li><strong>Choose which function to run:<\/strong> <code>sendCertificate<\/code><\/li>\n\n\n\n<li><strong>Select event source:<\/strong> <code>From spreadsheet<\/code><\/li>\n\n\n\n<li><strong>Select event type:<\/strong> <code>On form submit<\/code><\/li>\n\n\n\n<li>Leave the rest default and save.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The first time you run or trigger the script you&#8217;ll be asked to authorize permissions \u2014 follow prompts and accept.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">5) Test the flow<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fill the Google Form with a test name and your email.<\/li>\n\n\n\n<li>Check the linked Sheet: a new row should appear.<\/li>\n\n\n\n<li>After form submission the script should run (triggered) and you should receive an email with the attached certificate PDF.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">6) Optional improvements &amp; ideas<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Add more placeholders<\/strong> to your Slides template (e.g. <code>{{Score}}<\/code>, <code>{{Roll}}<\/code>, <code>{{Organization}}<\/code>) and replace them in the script.<\/li>\n\n\n\n<li><strong>Store certificates in a dedicated Drive folder<\/strong> by setting <code>CERTIFICATES_FOLDER_ID<\/code>.<\/li>\n\n\n\n<li><strong>Add a QR code<\/strong> or certificate verification link (requires additional API or service).<\/li>\n\n\n\n<li><strong>Use GmailApp with htmlBody<\/strong> if you want prettier emails (but watch quotas).<\/li>\n\n\n\n<li><strong>Limit sending to unique submissions<\/strong> by checking if the email already has <code>Certificate Sent<\/code> set.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">7) Troubleshooting<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>No email sent \/ script doesn&#8217;t run:<\/strong> Check that you added an <em>installable<\/em> trigger (On form submit). Also open the Apps Script editor and look at <strong>Executions<\/strong> or <strong>Logs<\/strong> for errors.<\/li>\n\n\n\n<li><strong>Authorization required:<\/strong> The script uses DriveApp and MailApp \u2014 grant permission when prompted.<\/li>\n\n\n\n<li><strong>Wrong name\/email picked:<\/strong> The script tries to find common header names. If your sheet uses custom headers, either rename them or update the <code>getByHeaders([...])<\/code> candidate lists in the script.<\/li>\n\n\n\n<li><strong>Quotas:<\/strong> Google Apps Script has daily email\/Drive quotas for consumer accounts. For large mailings, consider batching or use a G Suite\/Workspace account.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">9) Licensing &amp; credit<\/h2>\n\n\n\n<p>You are free to reuse and modify this script for your organization. If you publish it publicly, a short credit back (e.g., &#8220;Tutorial adapted from <strong>Itxperts<\/strong>&#8220;) is appreciated.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Short description: Step-by-step tutorial to auto-create PDF certificates from a Google Slides template and email them automatically when someone submits your Google Form. Includes ready-to-use Google Apps Script, troubleshooting tips, and optional extras you can add. Why this? Who it&#8217;s for If you run workshops, online classes, events, or assessments and want to automatically give [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2134,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"googlesitekit_rrm_CAow44u0DA:productID":"","footnotes":""},"categories":[170],"tags":[],"class_list":["post-2133","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Auto-generate &amp; Auto-send Certificates from Google Forms - Itxperts<\/title>\n<meta name=\"description\" content=\"Learn how to automatically send certificates using Google Forms, Google Sheets, and Apps Script. Step-by-step tutorial with code to generate and email PDF certificates for free.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto-generate &amp; Auto-send Certificates from Google Forms - Itxperts\" \/>\n<meta property=\"og:description\" content=\"Learn how to automatically send certificates using Google Forms, Google Sheets, and Apps Script. Step-by-step tutorial with code to generate and email PDF certificates for free.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\" \/>\n<meta property=\"og:site_name\" content=\"Itxperts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/itxperts.co.in\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-28T09:54:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-28T09:56:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"@mritxperts\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"@mritxperts\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\"},\"author\":{\"name\":\"@mritxperts\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6\"},\"headline\":\"Auto-generate &#038; Auto-send Certificates from Google Forms\",\"datePublished\":\"2025-09-28T09:54:38+00:00\",\"dateModified\":\"2025-09-28T09:56:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\"},\"wordCount\":746,\"publisher\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png\",\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\",\"url\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\",\"name\":\"Auto-generate & Auto-send Certificates from Google Forms - Itxperts\",\"isPartOf\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png\",\"datePublished\":\"2025-09-28T09:54:38+00:00\",\"dateModified\":\"2025-09-28T09:56:23+00:00\",\"description\":\"Learn how to automatically send certificates using Google Forms, Google Sheets, and Apps Script. Step-by-step tutorial with code to generate and email PDF certificates for free.\",\"breadcrumb\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage\",\"url\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png\",\"contentUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png\",\"width\":1536,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/itxperts.co.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auto-generate &#038; Auto-send Certificates from Google Forms\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#website\",\"url\":\"https:\/\/itxperts.co.in\/blog\/\",\"name\":\"Itxperts\",\"description\":\"Leading Website Design Company in Madhya Pradesh\",\"publisher\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\"},\"alternateName\":\"Itxperts | Website Development in Madhya Pradesh\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/itxperts.co.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\",\"name\":\"Itxperts\",\"alternateName\":\"Leading Website Design Company in Madhya Pradesh \u2013 Itxperts\",\"url\":\"https:\/\/itxperts.co.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png\",\"contentUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png\",\"width\":512,\"height\":512,\"caption\":\"Itxperts\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/itxperts.co.in\",\"https:\/\/www.linkedin.com\/company\/itxpertsshivpuri\/\",\"https:\/\/www.instagram.com\/itxperts.co.in\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6\",\"name\":\"@mritxperts\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g\",\"caption\":\"@mritxperts\"},\"description\":\"I am a full-stack web developer from India with over 8 years of experience in building dynamic and responsive web solutions. Specializing in both front-end and back-end development, I have a passion for creating seamless digital experiences. When I'm not coding, I enjoy sharing insights and tutorials on the latest web technologies, helping fellow developers stay ahead in the ever-evolving tech landscape.\",\"sameAs\":[\"https:\/\/itxperts.co.in\/blog\"],\"url\":\"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Auto-generate & Auto-send Certificates from Google Forms - Itxperts","description":"Learn how to automatically send certificates using Google Forms, Google Sheets, and Apps Script. Step-by-step tutorial with code to generate and email PDF certificates for free.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/","og_locale":"en_US","og_type":"article","og_title":"Auto-generate & Auto-send Certificates from Google Forms - Itxperts","og_description":"Learn how to automatically send certificates using Google Forms, Google Sheets, and Apps Script. Step-by-step tutorial with code to generate and email PDF certificates for free.","og_url":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/","og_site_name":"Itxperts","article_publisher":"https:\/\/www.facebook.com\/itxperts.co.in","article_published_time":"2025-09-28T09:54:38+00:00","article_modified_time":"2025-09-28T09:56:23+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png","type":"image\/png"}],"author":"@mritxperts","twitter_card":"summary_large_image","twitter_misc":{"Written by":"@mritxperts","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#article","isPartOf":{"@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/"},"author":{"name":"@mritxperts","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6"},"headline":"Auto-generate &#038; Auto-send Certificates from Google Forms","datePublished":"2025-09-28T09:54:38+00:00","dateModified":"2025-09-28T09:56:23+00:00","mainEntityOfPage":{"@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/"},"wordCount":746,"publisher":{"@id":"https:\/\/itxperts.co.in\/blog\/#organization"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png","articleSection":["Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/","url":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/","name":"Auto-generate & Auto-send Certificates from Google Forms - Itxperts","isPartOf":{"@id":"https:\/\/itxperts.co.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png","datePublished":"2025-09-28T09:54:38+00:00","dateModified":"2025-09-28T09:56:23+00:00","description":"Learn how to automatically send certificates using Google Forms, Google Sheets, and Apps Script. Step-by-step tutorial with code to generate and email PDF certificates for free.","breadcrumb":{"@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#primaryimage","url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png","contentUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/How-to-Auto-Send-Certificates-from-Google-Forms-Free-Google-Apps-Script-Method.png","width":1536,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/itxperts.co.in\/blog\/auto-send-certificates-google-forms-apps-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/itxperts.co.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Auto-generate &#038; Auto-send Certificates from Google Forms"}]},{"@type":"WebSite","@id":"https:\/\/itxperts.co.in\/blog\/#website","url":"https:\/\/itxperts.co.in\/blog\/","name":"Itxperts","description":"Leading Website Design Company in Madhya Pradesh","publisher":{"@id":"https:\/\/itxperts.co.in\/blog\/#organization"},"alternateName":"Itxperts | Website Development in Madhya Pradesh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itxperts.co.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/itxperts.co.in\/blog\/#organization","name":"Itxperts","alternateName":"Leading Website Design Company in Madhya Pradesh \u2013 Itxperts","url":"https:\/\/itxperts.co.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png","contentUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png","width":512,"height":512,"caption":"Itxperts"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/itxperts.co.in","https:\/\/www.linkedin.com\/company\/itxpertsshivpuri\/","https:\/\/www.instagram.com\/itxperts.co.in\/"]},{"@type":"Person","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6","name":"@mritxperts","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g","caption":"@mritxperts"},"description":"I am a full-stack web developer from India with over 8 years of experience in building dynamic and responsive web solutions. Specializing in both front-end and back-end development, I have a passion for creating seamless digital experiences. When I'm not coding, I enjoy sharing insights and tutorials on the latest web technologies, helping fellow developers stay ahead in the ever-evolving tech landscape.","sameAs":["https:\/\/itxperts.co.in\/blog"],"url":"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/2133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/comments?post=2133"}],"version-history":[{"count":2,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/2133\/revisions"}],"predecessor-version":[{"id":2137,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/2133\/revisions\/2137"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/media\/2134"}],"wp:attachment":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/media?parent=2133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/categories?post=2133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/tags?post=2133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}