{"id":67082,"date":"2023-05-23T21:01:52","date_gmt":"2023-05-23T13:01:52","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=67082"},"modified":"2023-08-07T20:21:10","modified_gmt":"2023-08-07T12:21:10","slug":"autoupdate-smartsheet-google-sheets","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/","title":{"rendered":"How to Automatically Update Smartsheet from Google Sheets"},"content":{"rendered":"<p>In this tutorial, we will demonstrate how to<strong> automatically add a row to a Smartsheet spreadsheet<\/strong> every time a <strong>new row is added to a Google spreadsheet<\/strong>. This can be particularly useful when you need to share a spreadsheet with multiple users who are utilizing different services, such as Google Sheets and Smartsheet.<\/p>\n<p>The main objective of this tutorial is to ensure seamless collaboration between users of different spreadsheet platforms. By automatically updating the Smartsheet spreadsheet whenever a new row is added to the Google spreadsheet, users <strong>can easily access and work on the same data set<\/strong>, regardless of their preferred platform. This not only simplifies the sharing process but also ensures that everyone stays on the same page and can collaborate effectively.<\/p>\n<h2>How Does This Work?<\/h2>\n<p>When new roles of data are added to a Google Sheet:<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/data-added-in-google-sheets.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg\" alt=\"data add Google Sheets\" width=\"1000\" height=\"454\"><\/span><\/p>\n<p>It will automatically be updated and added to <a href=\"https:\/\/www.hongkiat.com\/blog\/go\/smartsheet-project\" rel=\"nofollow noopener\" target=\"_blank\" class=\"js-aw-brand-link\" data-feed=\"SZvSEGoUwS8NbwUFNmbIhUuSF5pcJFHS\">Smartsheet<\/a>.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/data-reflected-in-smartsheet.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-reflected-in-smartsheet.jpg\" alt=\"data reflected Smartsheet\" width=\"1000\" height=\"524\"><\/span><\/p>\n<p>This integration allows users to focus on keeping their data up-to-date in Google Sheets, without having to worry about double data entry in Smartsheet. As a result, the data in Smartsheet will always be current and accurate, without any additional effort required from the user.<\/p>\n<h2>What You\u2019ll Need:<\/h2>\n<p>To begin integrating between <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.google.com\/sheets\/about\/\">Google Sheets<\/a> and <a href=\"https:\/\/www.hongkiat.com\/blog\/go\/smartsheet-project\" rel=\"nofollow noopener\" target=\"_blank\" class=\"js-aw-brand-link\" data-feed=\"SZvSEGoUwS8NbwUFNmbIhUuSF5pcJFHS\">Smartsheets<\/a>, we will be using <strong>Zapier<\/strong>. If you do not already have an account with these platforms, you can sign up (for free) by clicking the corresponding buttons below.<\/p>\n<p><a href=\"https:\/\/www.hongkiat.com\/blog\/go\/smartsheet-project\" class=\"su-button su-button-style-flat js-aw-brand-link\" style=\"color:#FFFFFF;background-color:#2D89EF;border-color:#246ec0;border-radius:0px\" target=\"__blank\" rel=\"noopener nofollow\"><span style=\"color:#FFFFFF;padding:7px 20px;font-size:16px;line-height:24px;border-color:#6cadf4;border-radius:0px;text-shadow:none\"><i class=\"sui sui-external-link\" style=\"font-size:16px;color:#fff\"><\/i>  Get free Smartsheet account. <\/span><\/a>\n<a href=\"https:\/\/zapier.com\/sign-up\" class=\"su-button su-button-style-flat\" style=\"color:#FFFFFF;background-color:#2D89EF;border-color:#246ec0;border-radius:0px\" target=\"__blank\" rel=\"noopener nofollow\"><span style=\"color:#FFFFFF;padding:7px 20px;font-size:16px;line-height:24px;border-color:#6cadf4;border-radius:0px;text-shadow:none\"><i class=\"sui sui-external-link\" style=\"font-size:16px;color:#fff\"><\/i>  Get free Zapier account. <\/span><\/a><\/p>\n<p>Once you have successfully signed up or if you already have an account, <strong>log in to your Zapier, Google Sheets, and Smartsheets accounts<\/strong>.<\/p>\n<h2>What We\u2019re Going to Do<\/h2>\n<p>For this tutorial, we will be using a Google Sheets spreadsheet that consists of several columns: <em>First Name<\/em>, <em>Last Name<\/em>, <em>Job Title<\/em>, <em>Age<\/em>, and <em>Nationality<\/em>.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/google-sheets-with-col-names.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/google-sheets-with-col-names.jpg\" alt=\"Google Sheets Cols\" width=\"1000\" height=\"172\"><\/span><\/p>\n<p>The goal is to ensure that when a new row of data is added to this spreadsheet, it will automatically be reflected in Smartsheet without the need for manual data entry.<\/p>\n<p>Let\u2019s do it!<\/p>\n<h2>1. Create Spreadsheets in Smartsheet and Google Sheets<\/h2>\n<p>Start by creating a new sheet in both Google Sheets and Smartsheet. Ensure they have identical columns, labeled as \u201c<em>First Name<\/em>\u201c, \u201c<em>Last Name<\/em>\u201c, \u201c<em>Title<\/em>\u201c, \u201c<em>Age<\/em>\u201c, and \u201c<em>Nationality<\/em>\u201c.<\/p>\n<p><a href=\"https:\/\/www.hongkiat.com\/blog\/go\/smartsheet-project\" class=\"su-button su-button-style-flat js-aw-brand-link\" style=\"color:#FFFFFF;background-color:#2D89EF;border-color:#246ec0;border-radius:0px\" target=\"__blank\" rel=\"noopener nofollow\"><span style=\"color:#FFFFFF;padding:7px 20px;font-size:16px;line-height:24px;border-color:#6cadf4;border-radius:0px;text-shadow:none\"><i class=\"sui sui-external-link\" style=\"font-size:16px;color:#fff\"><\/i>  Get free Smartsheet account. <\/span><\/a><\/p>\n<p>Give each spreadsheet a name. For example, name the Google Sheets spreadsheet \u201c<strong>Interviewee Information (GS)<\/strong>\u201d and the Smartsheet spreadsheet \u201c<strong>Interviewee Information (SS)<\/strong>\u201c.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/google-sheets-with-cols.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/google-sheets-with-cols.jpg\" alt=\"Google Sheets with Cols\" width=\"1000\" height=\"416\"><\/span>\n<span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/smartsheet-with-cols.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/smartsheet-with-cols.jpg\" alt=\"Smartsheet with Cols\" width=\"1000\" height=\"375\"><\/span><\/p>\n<p>Enter an example row of data in Google Sheets.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/google-sheets-one-row-data.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/google-sheets-one-row-data.jpg\" alt=\"Google Sheets row 1\" width=\"1000\" height=\"416\"><\/span><\/p>\n<h2>2. Create Integrations with Zapier<\/h2>\n<p>First, we\u2019ll link Zapier to Google Sheets.<\/p>\n<h3>Linking Zapier with Google Sheets.<\/h3>\n<ol>\n<li><strong>Log in<\/strong> to your Zapier account.<\/li>\n<li><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/zapier.com\/webintent\/create-zap?template=2557\"><strong>Click this link<\/strong><\/a> to add the <em>\"Google Sheets-Smartsheet integration template\"<\/em> to your Zapier.<\/li>\n<li>Click on the first row of <em>\u201c1. New Spreadsheet Row in Google Sheets\u201d<\/em> and then click \u201c<strong>Sign in.<\/strong>\u201c<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"zapier-google-sheets-1.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-google-sheets-1.jpg\" alt=\"Zapier sign in Google Shhets\" width=\"1000\" height=\"504\"><\/span><\/p>\n<li>Click \u201c<strong>Continue.<\/strong>\u201c<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"zapier-google-sheets-continue.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-google-sheets-continue.jpg\" alt=\"Google Sheets continue\" width=\"1000\" height=\"513\"><\/span><\/p>\n<li>Now, you need to tell Zapier which spreadsheet to use. Click the dropdown box under \u201c<em>Spreadsheet<\/em>\u201d and select \u201c<em>Interviewee Information (GS).<\/em>\u201c<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-select-google-sheets.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-select-google-sheets.jpg\" alt=\"sleect Google Sheets spreadsheet\" width=\"1000\" height=\"450\"><\/span><\/p>\n<li>Next, tell Zapier which sheet within \u201c<em>Interviewee Information (GS)<\/em>\u201d to use. In the dropdown box for \u201c<em>Worksheet<\/em>,\u201d choose \u201c<em>Sheet1<\/em>\u201d and click \u201c<strong>Continue.<\/strong>\u201c<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-google-sheets-worksheet.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-google-sheets-worksheet.jpg\" alt=\"Google Sheets worksheet\" width=\"1000\" height=\"544\"><\/span><\/p>\n<li>Click \u201c<strong>Test<\/strong>\u201d and then \u201c<strong>Trigger test<\/strong>\u201d to check if the connection between Zapier and the spreadsheet is working.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-google-sheets-test-trigger.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-google-sheets-test-trigger.jpg\" alt=\"Google Sheets test trigger\" width=\"1000\" height=\"618\"><\/span><\/p>\n<li>If successful, you will see the sample data you entered earlier. Click \u201c<strong>Continue<\/strong>\u201c.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-google-sheets-test-success.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-google-sheets-test-success.jpg\" alt=\"Google Sheets test success\" width=\"1000\" height=\"521\"><\/span>\n<\/p><\/ol>\n<p>Next, we will link Zapier to <a href=\"https:\/\/www.hongkiat.com\/blog\/go\/smartsheet-project\" rel=\"nofollow noopener\" target=\"_blank\" class=\"js-aw-brand-link\" data-feed=\"SZvSEGoUwS8NbwUFNmbIhUuSF5pcJFHS\">Smartsheet<\/a>.<\/p>\n<h3>Linking Zapier with Smartsheet.<\/h3>\n<ol>\n<li>First, click \u201c<strong>Sign in<\/strong>\u201d under \u201c<em>2. Add Row to Sheet in Smartsheet<\/em>\u201d to connect Zapier to your Smartsheet account. Then click \u201c<strong>Continue<\/strong>\u201c.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-smartsheet-2.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-smartsheet-2.jpg\" alt=\"\" width=\"1000\" height=\"451\"><\/span><\/p>\n<li>Choose the \u201c<em>Interviewee Information (SS)<\/em>\u201d sheet from the \u201c<em>Action<\/em>\u201d dropdown menu.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-smartsheet-choose-sheet.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-smartsheet-choose-sheet.jpg\" alt=\"Choose sheet in Smartsheet\" width=\"1000\" height=\"631\"><\/span><\/p>\n<li>Decide whether you want new data to be added to the top or bottom of the row. Select \u201c<em>To Top<\/em>\u201d or \u201c<em>To Bottom<\/em>\u201d from the dropdown menu.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-smartsheet-new-data.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-smartsheet-new-data.jpg\" alt=\"Smartsheet new data appearance\" width=\"1000\" height=\"592\"><\/span><\/p>\n<li>Click \u201c<strong>Refresh fields<\/strong>\u201d to match the columns between the two spreadsheets. Make sure the information for \u201c<em>First Name<\/em>\u201c, \u201c<em>Last Name<\/em>\u201c, \u201c<em>Title<\/em>\u201c, \u201c<em>Age<\/em>\u201c, and \u201c<em>Nationality<\/em>\u201d is entered correctly. Then, click \u201c<strong>Continue<\/strong>\u201c.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-smartsheet-match-data.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-smartsheet-match-data.jpg\" alt=\"Smartsheet matching data\" width=\"1000\" height=\"631\"><\/span><\/p>\n<li>Click \u201c<strong>Test action<\/strong>\u201d to check if everything is synced properly. If you see a \u201c<em>SUCCESS<\/em>\u201d message, it means the columns are synced correctly.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-smartsheet-test-success.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-smartsheet-test-success.jpg\" alt=\"Smartsheet test success\" width=\"1000\" height=\"631\"><\/span><\/p>\n<li>Finally, click \u201c<strong>Publish<\/strong>\u201d to finish the process.<\/li>\n<p>  <span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-smartsheet-publish.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-smartsheet-publish.jpg\" alt=\"publish Smartsheet\" width=\"1000\" height=\"491\"><\/span>\n<\/p><\/ol>\n<h2>3. Testing the Automation<\/h2>\n<p>Now that both spreadsheets in Google Sheets and Smartsheets are integrated, you can easily transfer and manage your data.<\/p>\n<p>To transfer existing data from your Google Sheet to Smartsheet, simply click on the \u201c<strong>Transfer existing data<\/strong>\u201d button. This will ensure that any data already present in your Google Sheet is copied over to Smartsheet.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-transfer-existing-data.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-transfer-existing-data.jpg\" alt=\"transfer existing data\" width=\"1000\" height=\"443\"><\/span><\/p>\n<p>Or, you can start populating or entering data in Google Sheets\u2026.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/google-sheets-add-more-data.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/google-sheets-add-more-data.jpg\" alt=\"Google Sheets add data\" width=\"1000\" height=\"442\"><\/span><\/p>\n<p>\u2026and it will be automatically reflected in Smartsheet.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/smartsheet-data-reflected.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/smartsheet-data-reflected.jpg\" alt=\"Smartsheet data reflected\" width=\"1000\" height=\"536\"><\/span><\/p>\n<h3>Data won\u2019t show up in Smartsheet right away<\/h3>\n<p>Please note that the <strong>data will not be instantly reflected<\/strong> on Smartsheet when using Zapier.<\/p>\n<p>Under the \u201c<em>Free<\/em>\u201d and \u201c<em>Starter<\/em>\u201d plans, the update time is 15 minutes, which means that Zapier checks for new data and <strong>updates your Zap every 15 minutes<\/strong>.<\/p>\n<p><span class=\"su-lightbox\" data-mfp-src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/original\/zapier-plans.jpg\" data-mfp-type=\"image\" data-mobile=\"yes\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/zapier-plans.jpg\" alt=\"Zapier plans\" width=\"1000\" height=\"477\"><\/span><\/p>\n<p>If you require a faster update time, you may want to consider upgrading to the \u201cProfessional\u201d or \u201cTeam\u201d plans, where the update time is reduced to 2 minutes and 1 minute, respectively. This will help ensure that your Smartsheet data is updated more frequently and accurately.<\/p>","protected":false},"excerpt":{"rendered":"<p>Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.<\/p>\n","protected":false},"author":629,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3398],"tags":[4655,4554],"topic":[],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Automatically Update Smartsheet from Google Sheets - Hongkiat<\/title>\n<meta name=\"description\" content=\"Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Automatically Update Smartsheet from Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-23T13:01:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-07T12:21:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg\" \/>\n<meta name=\"author\" content=\"Eoin Wiley\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eoin Wiley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/\"},\"author\":{\"name\":\"Eoin Wiley\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/7b8072818f761549daecd3c5c4c0bfc8\"},\"headline\":\"How to Automatically Update Smartsheet from Google Sheets\",\"datePublished\":\"2023-05-23T13:01:52+00:00\",\"dateModified\":\"2023-08-07T12:21:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/\"},\"wordCount\":1259,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/autoupdate-smartsheet-google-sheets\\\/preview\\\/data-added-in-google-sheets.jpg\",\"keywords\":[\"appwiki\",\"Google Sheets\"],\"articleSection\":[\"Internet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/\",\"name\":\"How to Automatically Update Smartsheet from Google Sheets - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/autoupdate-smartsheet-google-sheets\\\/preview\\\/data-added-in-google-sheets.jpg\",\"datePublished\":\"2023-05-23T13:01:52+00:00\",\"dateModified\":\"2023-08-07T12:21:10+00:00\",\"description\":\"Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/autoupdate-smartsheet-google-sheets\\\/preview\\\/data-added-in-google-sheets.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/autoupdate-smartsheet-google-sheets\\\/preview\\\/data-added-in-google-sheets.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/autoupdate-smartsheet-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Automatically Update Smartsheet from Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/7b8072818f761549daecd3c5c4c0bfc8\",\"name\":\"Eoin Wiley\",\"description\":\"Eoin is an experienced web developer and also a writer for Hongkiat.com. He is a skilled problem-solver with a deep understanding of various programming languages and frameworks.\",\"sameAs\":[\"https:\\\/\\\/www.hongkiat.com\"],\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/eoinwiley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Automatically Update Smartsheet from Google Sheets - Hongkiat","description":"Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.","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:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Automatically Update Smartsheet from Google Sheets","og_description":"Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.","og_url":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2023-05-23T13:01:52+00:00","article_modified_time":"2023-08-07T12:21:10+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg","type":"","width":"","height":""}],"author":"Eoin Wiley","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Eoin Wiley","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/"},"author":{"name":"Eoin Wiley","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/7b8072818f761549daecd3c5c4c0bfc8"},"headline":"How to Automatically Update Smartsheet from Google Sheets","datePublished":"2023-05-23T13:01:52+00:00","dateModified":"2023-08-07T12:21:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/"},"wordCount":1259,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg","keywords":["appwiki","Google Sheets"],"articleSection":["Internet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/","url":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/","name":"How to Automatically Update Smartsheet from Google Sheets - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg","datePublished":"2023-05-23T13:01:52+00:00","dateModified":"2023-08-07T12:21:10+00:00","description":"Step-by-step guide on how to automate data updates from Google Sheets to Smartsheet for easy sharing and use.","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/autoupdate-smartsheet-google-sheets\/preview\/data-added-in-google-sheets.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/autoupdate-smartsheet-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Automatically Update Smartsheet from Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/7b8072818f761549daecd3c5c4c0bfc8","name":"Eoin Wiley","description":"Eoin is an experienced web developer and also a writer for Hongkiat.com. He is a skilled problem-solver with a deep understanding of various programming languages and frameworks.","sameAs":["https:\/\/www.hongkiat.com"],"url":"https:\/\/www.hongkiat.com\/blog\/author\/eoinwiley\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-hrY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/67082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/629"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=67082"}],"version-history":[{"count":3,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/67082\/revisions"}],"predecessor-version":[{"id":67229,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/67082\/revisions\/67229"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=67082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=67082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=67082"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=67082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}