{"id":7414,"date":"2020-06-09T18:04:21","date_gmt":"2020-06-10T01:04:21","guid":{"rendered":"https:\/\/simplecert.net\/help\/?p=7414"},"modified":"2022-04-14T16:24:07","modified_gmt":"2022-04-14T23:24:07","slug":"simplecert-api-integration-with-google-forms","status":"publish","type":"post","link":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/","title":{"rendered":"SimpleCert<sup>&reg;<\/sup> API integration with Google Forms"},"content":{"rendered":"<p>The easiest method to add recipients to your SimpleCert<sup>\u00ae<\/sup> account with a Google form is to use our <a href=\"https:\/\/simplecert.net\/help\/zapier-integration-using-the-simplecert-api\/\">Zapier integration<\/a>. There is both a direct Google Forms integration available as well as a Google Sheets integration. If you do not wish to use the Zapier method, there is a direct integration you can do within Google Forms\/Sheets.\u00a0 This method does require a minor amount of programming knowledge to accomplish, so only proceed with this option if you are comfortable with accessing code.<\/p>\n<p>We will do this by setting up a Google Form and linking it to a Google Sheet that will store the submissions.\u00a0 Inside that Google Sheet we will need to add some code that sends new entries to SimpleCert<sup>\u00ae<\/sup> through our API. The API is simply a way to send data to our system from external sources using a specific API Key that is generated for your account.<\/p>\n<h2>Getting an API Key<\/h2>\n<p>You can generate an API Key within our API testing tool by entering your username and password here <a href=\"https:\/\/app.simplecert.net\/api-docs#!\/User\/getApiKey\">https:\/\/app.simplecert.net\/api-docs#!\/User\/getApiKey<\/a>.\u00a0 The Key will be returned in the response body below the \u201cTry It Out\u201d button.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-large wp-image-7415\" src=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1024x237.png\" alt=\"\" width=\"770\" height=\"178\" srcset=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1024x237.png 1024w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-300x69.png 300w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-768x178.png 768w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1536x355.png 1536w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-770x178.png 770w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1.png 1600w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/a><\/p>\n<p>Copy that key (just the string of letters and numbers highlighted above) and save it in a notepad for later.\u00a0 Every time you run this tool it will overwrite your previous keys, so getting a new key will make all of your old keys invalid.<\/p>\n<p>&nbsp;<\/p>\n<h2>Setting Up Your Google Form<\/h2>\n<p>Your Google form needs to have all of the fields associated with a specific project\u2019s certificate, so it is important to review your certificate and most likely create a new project before continuing.\u00a0 When a project is first created it makes a copy of the certificate template and all of its required fields. If you add new fields to your certificate after a project has been created, that project will not have those new fields in it.<\/p>\n<h3>Copy Your Certificate Fields<\/h3>\n<p>In order to send the correct data from our integration we will want to go to the certificate builder and look at the certificate we are going to be using on our project. In the editor you should see all of the fields that will be used to create it. Write those fields down exactly as they are entered between the \u201c[ ]\u201d brackets.\u00a0 The following certificate would have \u201cFIRST_NAME\u201d, \u201cLAST_NAME\u201d, \u201cDate\u201d, and \u201cMERGE FIELD1\u201d.\u00a0 Make sure you copy these down exactly as they are all required and must match precisely. There will also be an \u201cEMAIL_ADDRESS\u201d field but that will be present on all projects.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google2.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7416\" src=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google2.png\" alt=\"\" width=\"637\" height=\"492\" srcset=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google2.png 637w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google2-300x232.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/a><\/p>\n<h3>Create a New Project<\/h3>\n<p>Creating a new project is the safest way to know what fields are required.\u00a0 The easiest way to do this and to get the list of required fields is to go to the \u201cSend\u201d section of the app, select your desired certificate template and manually import one recipient.\u00a0 This will let you test that all of the fields are up to date and there isn\u2019t anything unknown or missing in your project certificate.\u00a0 Click Add to Recipient List and then \u201cSave Project\u201d on the following screen.\u00a0 That will bring a popup that lets you set the Project ID Name.\u00a0 When you hit submit it will take you to a page where you can send your certificates, but it will also add the actual Project ID number to the urls in the following format:\u00a0 app.simplecert.net\/send\/<b>123456<\/b>\/send.\u00a0 Copy the bolded 6-7 digit number and add it to your notes.<\/p>\n<p>&nbsp;<\/p>\n<h2>Creating Your Form<\/h2>\n<p>Now we have all of our data, it&#8217;s time to create the actual form.\u00a0 Go to Google Forms and create a new blank form.\u00a0 Add all of the fields you need and match them with your certificate\u2019s fields.\u00a0 For any date field it is easier to use a \u201cshort answer\u201d field instead of a date field due to how Google Sheets formats dates.\u00a0 Once all of your fields are ready, click on the \u201cResponses\u201d tab and then on the Google Sheets icon to \u201cCreate Spreadsheet\u201d.<\/p>\n<p>You should now have a spreadsheet with all of your questions in individual columns along with a timestamp column.<\/p>\n<p>&nbsp;<\/p>\n<h2>Enter in The Custom Script.<\/h2>\n<p>To enter the script you simply need to go to \u201cTools\u201d &gt; \u201cScript Editor\u201d, and then replace the sample code displayed there with the following:<\/p>\n<div class=\"wp-block-codemirror-blocks code-block alignfull\">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;javascript&quot;,&quot;mime&quot;:&quot;text\/javascript&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;full&quot;}\">\/**\r\n * Enter your accounts API-Key.\r\n * A new api key can be generated here https:\/\/app.simplecert.net\/api-docs#!\/User\r\n *\/\r\nvar api_key =  \"IS63MQQquPggfJNMkXx01zK695dsdyieJla8utamSw1y8gghisjgH82hS9qeru\";\r\n\r\n\/**\r\n * Enter your Project ID Number (Not the Project ID, but the 4-6 digit ID Number)\r\n * To find this you can go to https:\/\/app.simplecert.net\/store\/ and select the project you want the id for.  \r\n * The ID Number will be at the end of the url like https:\/\/app.simplecert.net\/store\/projects\/12345\r\n *\/ \r\nvar project_id = \"12345\";\r\n\r\n\/**\r\n * Enter the individual fields and their corresponding column in the Google Forms Spreadsheet.\r\n * The following fields will be in most all of the integrations and the field names must match exactly what is here:\r\n *   \"FIRST_NAME\"\r\n *   \"LAST_NAME\" (Or \"FIRST_NAME LAST_NAME\" if you are using the single data field option for names)\r\n *   \"EMAIL_ADDRESS\"\r\n *   \"PROGRAM_TITLE\"\r\n *   \"DATE\"\r\n *\/\r\nvar spreadsheet_rows = {\r\n    \"FIRST_NAME\": 2,\r\n    \"LAST_NAME\": 3,\r\n    \"EMAIL_ADDRESS\": 4,\r\n    \"PROGRAM_TITLE\":  5,\r\n    \"DATE\": 6,\r\n};\r\n \r\n\r\n\/\/Do not edit below this point\r\nfunction Initialize() {\r\n  try {\r\n    var triggers = ScriptApp.getProjectTriggers();\r\n\r\n    for (var i in triggers)\r\n      ScriptApp.deleteTrigger(triggers[i]);\r\n\r\n    ScriptApp.newTrigger(\"SubmitGoogleFormData\")\r\n      .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())\r\n      .onFormSubmit().create();\r\n\r\n  } catch (error) {\r\n    throw new Error(\"Please add this code in the Google Spreadsheet\");\r\n  }\r\n}\r\n\r\nfunction SubmitGoogleFormData(e) {\r\n\r\n  if (!e) {\r\n    throw new Error(\"Please go the Run menu and choose Initialize\");\r\n  }\r\n\r\n  try {\r\n    var ss = SpreadsheetApp.getActiveSheet();\r\n    var lr = ss.getLastRow(); \r\n\r\n    var payload = {};\r\n    \r\n    for (var k in spreadsheet_rows){\r\n      if (typeof spreadsheet_rows[k] !== 'function') {\r\n      \tpayload[k] = ss.getRange(lr, spreadsheet_rows[k], 1, 1).getValue();\r\n      }\r\n    }\r\n\r\n    \/\/ set up authorisation\r\n    var headers = {\r\n      \"api-key\" : api_key\r\n    };\r\n    \/\/build up options\r\n    var options = {\r\n      'method': 'post',\r\n      \"contentType\" : \"application\/json\",\r\n      'headers': headers,\r\n      'payload': JSON.stringify(payload),\r\n      'muteHttpExceptions': false\r\n    }\r\n\t\t\/\/ set API method URL  - requestbin\r\n    var url = \"https:\/\/app.simplecert.net\/api\/projects\/\" + project_id + \"\/recipient\/add\";\r\n\t\t\/\/ make the call\r\n    var response = UrlFetchApp.fetch(url, options);\r\n\t\t\/\/ log the response (useful for debugging )\r\n    Logger.log(JSON.stringify(response));\r\n\r\n  } catch (error) {\r\n    Logger.log(error.toString());\r\n  }\r\n}<\/pre>\n<\/div>\n<p><a href=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google3.png\"><img decoding=\"async\" class=\" wp-image-7417 aligncenter\" src=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google3.png\" alt=\"\" width=\"630\" height=\"533\" srcset=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google3.png 890w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google3-300x254.png 300w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google3-768x650.png 768w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google3-770x651.png 770w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p>Within that code we need to replace the api_key and project_id variable with the ones you got earlier.\u00a0 Then we need to update the code starting on line 23 to match your spreadsheet columns and add any merge fields.\u00a0 Copy and paste the field names to match yours by adding a new line for any missing fields.\u00a0 The number after them is the column number in the spreadsheet.\u00a0 So the \u201cFIRST_NAME\u201d is in the 2nd column according to the provided code.<\/p>\n<p>When you are done you go to \u201cFile\u201d &gt; \u201cSave\u201d and enter a project name.\u00a0 Then make sure the selector in the tool bar is set to \u201cInitialize\u201d <a href=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-thumbnail wp-image-7418\" src=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google4-150x34.png\" alt=\"\" width=\"150\" height=\"34\" \/><\/a> then click the \u201cRun\u201d button (the triangle \u201cplay button\u201d as seen in the previous image).<\/p>\n<p>Depending on your current accounts permissions it may give you an \u201cAuthorization required\u201d popup.\u00a0 If that happens, click review permissions and then select your google account and continue through until you click \u201cAllow.\u201d<\/p>\n<p>&nbsp;<\/p>\n<h2>Test your Form<\/h2>\n<p>Test your form by going to your form editor and clicking the preview button in the top right of the screen (eye icon).<\/p>\n<p><a href=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7419\" src=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google5.png\" alt=\"\" width=\"391\" height=\"67\" srcset=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google5.png 391w, https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google5-300x51.png 300w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/a><\/p>\n<p>Fill out the form and check in your account to make sure the new recipient was added correctly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The easiest method to add recipients to your SimpleCert\u00ae account with a Google form is to use our Zapier integration. There is both a direct Google Forms integration available as well as a Google Sheets integration. If you do not wish to use the Zapier method, there is a direct integration you can do within [&hellip;]<\/p>\n","protected":false},"author":831286,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[466],"tags":[],"class_list":["post-7414","post","type-post","status-publish","format-standard","hentry","category-api"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SimpleCert&reg; API integration with Google Forms - SimpleCert\u00ae<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SimpleCert&reg; API integration with Google Forms - SimpleCert\u00ae\" \/>\n<meta property=\"og:description\" content=\"The easiest method to add recipients to your SimpleCert\u00ae account with a Google form is to use our Zapier integration. There is both a direct Google Forms integration available as well as a Google Sheets integration. If you do not wish to use the Zapier method, there is a direct integration you can do within [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/\" \/>\n<meta property=\"og:site_name\" content=\"SimpleCert\u00ae\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-10T01:04:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-14T23:24:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1024x237.png\" \/>\n<meta name=\"author\" content=\"Zipline Interactive\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zipline Interactive\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/\"},\"author\":{\"name\":\"Zipline Interactive\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#\\\/schema\\\/person\\\/a841a3d5dfe7eeb6818698a11eeb6947\"},\"headline\":\"SimpleCert&reg; API integration with Google Forms\",\"datePublished\":\"2020-06-10T01:04:21+00:00\",\"dateModified\":\"2022-04-14T23:24:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/\"},\"wordCount\":942,\"publisher\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/simplecert.net\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/google1-1024x237.png\",\"articleSection\":[\"API\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/\",\"url\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/\",\"name\":\"SimpleCert&reg; API integration with Google Forms - SimpleCert\u00ae\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/simplecert.net\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/google1-1024x237.png\",\"datePublished\":\"2020-06-10T01:04:21+00:00\",\"dateModified\":\"2022-04-14T23:24:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#primaryimage\",\"url\":\"https:\\\/\\\/simplecert.net\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/google1.png\",\"contentUrl\":\"https:\\\/\\\/simplecert.net\\\/help\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/google1.png\",\"width\":1600,\"height\":370},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/simplecert-api-integration-with-google-forms\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/simplecert.net\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SimpleCert&reg; API integration with Google Forms\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/simplecert.net\\\/help\\\/\",\"name\":\"SimpleCert\u00ae\",\"description\":\"Knowledge Base\",\"publisher\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/simplecert.net\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#organization\",\"name\":\"SimpleCert\u00ae, LLC\",\"url\":\"https:\\\/\\\/simplecert.net\\\/help\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/simplecert.net\\\/help\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/v2_Asset-2logo-registered.png\",\"contentUrl\":\"https:\\\/\\\/simplecert.net\\\/help\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/v2_Asset-2logo-registered.png\",\"width\":638,\"height\":132,\"caption\":\"SimpleCert\u00ae, LLC\"},\"image\":{\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/simplecert.net\\\/help\\\/#\\\/schema\\\/person\\\/a841a3d5dfe7eeb6818698a11eeb6947\",\"name\":\"Zipline Interactive\",\"url\":\"https:\\\/\\\/simplecert.net\\\/help\\\/author\\\/ziplineinteractive\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SimpleCert&reg; API integration with Google Forms - SimpleCert\u00ae","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:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/","og_locale":"en_US","og_type":"article","og_title":"SimpleCert&reg; API integration with Google Forms - SimpleCert\u00ae","og_description":"The easiest method to add recipients to your SimpleCert\u00ae account with a Google form is to use our Zapier integration. There is both a direct Google Forms integration available as well as a Google Sheets integration. If you do not wish to use the Zapier method, there is a direct integration you can do within [&hellip;]","og_url":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/","og_site_name":"SimpleCert\u00ae","article_published_time":"2020-06-10T01:04:21+00:00","article_modified_time":"2022-04-14T23:24:07+00:00","og_image":[{"url":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1024x237.png","type":"","width":"","height":""}],"author":"Zipline Interactive","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zipline Interactive","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#article","isPartOf":{"@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/"},"author":{"name":"Zipline Interactive","@id":"https:\/\/simplecert.net\/help\/#\/schema\/person\/a841a3d5dfe7eeb6818698a11eeb6947"},"headline":"SimpleCert&reg; API integration with Google Forms","datePublished":"2020-06-10T01:04:21+00:00","dateModified":"2022-04-14T23:24:07+00:00","mainEntityOfPage":{"@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/"},"wordCount":942,"publisher":{"@id":"https:\/\/simplecert.net\/help\/#organization"},"image":{"@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#primaryimage"},"thumbnailUrl":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1024x237.png","articleSection":["API"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/","url":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/","name":"SimpleCert&reg; API integration with Google Forms - SimpleCert\u00ae","isPartOf":{"@id":"https:\/\/simplecert.net\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#primaryimage"},"image":{"@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#primaryimage"},"thumbnailUrl":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1-1024x237.png","datePublished":"2020-06-10T01:04:21+00:00","dateModified":"2022-04-14T23:24:07+00:00","breadcrumb":{"@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#primaryimage","url":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1.png","contentUrl":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2020\/06\/google1.png","width":1600,"height":370},{"@type":"BreadcrumbList","@id":"https:\/\/simplecert.net\/help\/simplecert-api-integration-with-google-forms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/simplecert.net\/help\/"},{"@type":"ListItem","position":2,"name":"SimpleCert&reg; API integration with Google Forms"}]},{"@type":"WebSite","@id":"https:\/\/simplecert.net\/help\/#website","url":"https:\/\/simplecert.net\/help\/","name":"SimpleCert\u00ae","description":"Knowledge Base","publisher":{"@id":"https:\/\/simplecert.net\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/simplecert.net\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/simplecert.net\/help\/#organization","name":"SimpleCert\u00ae, LLC","url":"https:\/\/simplecert.net\/help\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/simplecert.net\/help\/#\/schema\/logo\/image\/","url":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2021\/05\/v2_Asset-2logo-registered.png","contentUrl":"https:\/\/simplecert.net\/help\/wp-content\/uploads\/2021\/05\/v2_Asset-2logo-registered.png","width":638,"height":132,"caption":"SimpleCert\u00ae, LLC"},"image":{"@id":"https:\/\/simplecert.net\/help\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/simplecert.net\/help\/#\/schema\/person\/a841a3d5dfe7eeb6818698a11eeb6947","name":"Zipline Interactive","url":"https:\/\/simplecert.net\/help\/author\/ziplineinteractive\/"}]}},"_links":{"self":[{"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/posts\/7414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/users\/831286"}],"replies":[{"embeddable":true,"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/comments?post=7414"}],"version-history":[{"count":8,"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/posts\/7414\/revisions"}],"predecessor-version":[{"id":7795,"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/posts\/7414\/revisions\/7795"}],"wp:attachment":[{"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/media?parent=7414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/categories?post=7414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/simplecert.net\/help\/wp-json\/wp\/v2\/tags?post=7414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}