{"id":692,"date":"2015-12-19T11:42:00","date_gmt":"2015-12-19T16:42:00","guid":{"rendered":"https:\/\/blog2wrkdev.wpenginepowered.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/"},"modified":"2026-09-29T06:25:32","modified_gmt":"2026-09-29T10:25:32","slug":"recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce","status":"publish","type":"post","link":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/","title":{"rendered":"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce"},"content":{"rendered":"\n<div data-ng-transclude=\"\">\n<div class=\"markdown-wrapper ng-scope ng-isolate-scope\" data-markdown=\"flow.description\">\n\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1209\" src=\"https:\/\/blog2workato.wpengine.com\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-19-at-2.27.22-PM.png\" alt=\"Screen Shot 2015-12-19 at 2.27.22 PM\" width=\"406\" height=\"138\" \/>\n\nFor our 3rd day of the countdown, we have one of our most versatile recipes. Automatically create a new lead in Salesforce anytime a new row is created in Google Sheets. Whether you are collecting people who signed up for a webinar or exporting information from another program, this recipe makes keeping your leads in Salesforce a breeze!\n<h4 id=\"wkt-markdown-how-it-works\">How it works<\/h4>\nTrigger: When a new spreadsheet row is added to Google Sheets.\n\nActions:\n<ul>\n\t<li>Data in each row will create a lead.\n**Note: each row must contain the following columns: &#8220;First name&#8221;, &#8220;Last name&#8221;, &#8220;Company&#8221;<\/li>\n<\/ul>\n<h4 id=\"wkt-markdown-customization-options\">Customization Options<\/h4>\nYou can also include other fills such as Job title, Email, Phone Number, LinkedIn, Twitter and other information. Each individual fields should be tabulated in one column in the Google Sheets.\n<h4 id=\"wkt-markdown-what-you-need-to-use-this-recipe\">What you need to use this recipe<\/h4>\nNo special setup or customization is required to run this recipe. You should have a Salesforce and Google Sheets account. Add your credentials in the connections section if you are not already connected to the apps. Go ahead and give it a try!\n\n<\/div>\n<\/div>\n<div class=\"collapsible__border\"><a href=\"https:\/\/www.workato.com\/recipes\/11500\" target=\"_blank\"><strong>\u00a0Get going with this recipe &gt;<\/strong><\/a><\/div>\n<div class=\"collapsible__border\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>For our 3rd day of the countdown, we have one of our most versatile recipes. Automatically create a new lead in Salesforce anytime a new row is created in Google Sheets. Whether you are collecting people who signed up for a webinar or exporting information from another program, this recipe makes keeping your leads in [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[31],"tags":[],"class_list":["post-692","post","type-post","status-publish","format-standard","hentry","category-automation-integration"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce - Workato<\/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:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce - Workato\" \/>\n<meta property=\"og:description\" content=\"For our 3rd day of the countdown, we have one of our most versatile recipes. Automatically create a new lead in Salesforce anytime a new row is created in Google Sheets. Whether you are collecting people who signed up for a webinar or exporting information from another program, this recipe makes keeping your leads in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/\" \/>\n<meta property=\"og:site_name\" content=\"Workato\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-19T16:42:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-29T10:25:32+00:00\" \/>\n<meta name=\"author\" content=\"Kristine Colosimo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kristine Colosimo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/\"},\"author\":{\"name\":\"Kristine Colosimo\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/dfa6b797fa08a0cd50a1a5677dc2c52f\"},\"headline\":\"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce\",\"datePublished\":\"2015-12-19T16:42:00+00:00\",\"dateModified\":\"2026-09-29T10:25:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/\"},\"wordCount\":195,\"image\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog2.workato.com\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Screen-Shot-2015-12-19-at-2.27.22-PM.png\",\"articleSection\":[\"Automation &amp; Integration\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/\",\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/\",\"name\":\"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce - Workato\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog2.workato.com\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Screen-Shot-2015-12-19-at-2.27.22-PM.png\",\"datePublished\":\"2015-12-19T16:42:00+00:00\",\"dateModified\":\"2026-09-29T10:25:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/dfa6b797fa08a0cd50a1a5677dc2c52f\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blog2.workato.com\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Screen-Shot-2015-12-19-at-2.27.22-PM.png\",\"contentUrl\":\"https:\\\/\\\/blog2.workato.com\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/Screen-Shot-2015-12-19-at-2.27.22-PM.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/ja\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#website\",\"url\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/\",\"name\":\"Workato\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/dfa6b797fa08a0cd50a1a5677dc2c52f\",\"name\":\"Kristine Colosimo\",\"description\":\"Kristine oversees Workato's content and works with awesome apps like DocuSign, Zendesk, SurveyMonkey etc. on great automation content.\",\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/author\\\/kristine\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce - Workato","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:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/","og_locale":"en_US","og_type":"article","og_title":"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce - Workato","og_description":"For our 3rd day of the countdown, we have one of our most versatile recipes. Automatically create a new lead in Salesforce anytime a new row is created in Google Sheets. Whether you are collecting people who signed up for a webinar or exporting information from another program, this recipe makes keeping your leads in [&hellip;]","og_url":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/","og_site_name":"Workato","article_published_time":"2015-12-19T16:42:00+00:00","article_modified_time":"2026-09-29T10:25:32+00:00","author":"Kristine Colosimo","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kristine Colosimo","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#article","isPartOf":{"@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/"},"author":{"name":"Kristine Colosimo","@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/dfa6b797fa08a0cd50a1a5677dc2c52f"},"headline":"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce","datePublished":"2015-12-19T16:42:00+00:00","dateModified":"2026-09-29T10:25:32+00:00","mainEntityOfPage":{"@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/"},"wordCount":195,"image":{"@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#primaryimage"},"thumbnailUrl":"https:\/\/blog2.workato.com\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-19-at-2.27.22-PM.png","articleSection":["Automation &amp; Integration"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/","url":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/","name":"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce - Workato","isPartOf":{"@id":"https:\/\/www.workato.com\/the-connector\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#primaryimage"},"image":{"@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#primaryimage"},"thumbnailUrl":"https:\/\/blog2.workato.com\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-19-at-2.27.22-PM.png","datePublished":"2015-12-19T16:42:00+00:00","dateModified":"2026-09-29T10:25:32+00:00","author":{"@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/dfa6b797fa08a0cd50a1a5677dc2c52f"},"breadcrumb":{"@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#primaryimage","url":"https:\/\/blog2.workato.com\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-19-at-2.27.22-PM.png","contentUrl":"https:\/\/blog2.workato.com\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-19-at-2.27.22-PM.png"},{"@type":"BreadcrumbList","@id":"https:\/\/blog2workato.wpengine.com\/recipe-14-a-new-row-in-google-sheets-creates-a-lead-in-salesforce\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog2workato.wpengine.com\/ja\/"},{"@type":"ListItem","position":2,"name":"Recipe 14: A New Row in Google Sheets Creates a Lead in Salesforce"}]},{"@type":"WebSite","@id":"https:\/\/www.workato.com\/the-connector\/#website","url":"https:\/\/www.workato.com\/the-connector\/","name":"Workato","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.workato.com\/the-connector\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/dfa6b797fa08a0cd50a1a5677dc2c52f","name":"Kristine Colosimo","description":"Kristine oversees Workato's content and works with awesome apps like DocuSign, Zendesk, SurveyMonkey etc. on great automation content.","url":"https:\/\/blog2workato.wpengine.com\/author\/kristine\/"}]}},"_links":{"self":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":2,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"predecessor-version":[{"id":5393,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/692\/revisions\/5393"}],"wp:attachment":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}