{"id":283,"date":"2025-03-16T03:14:01","date_gmt":"2025-03-16T03:14:01","guid":{"rendered":"https:\/\/easycommerce.dev\/docs\/?post_type=ek_doc&#038;p=283"},"modified":"2026-03-12T06:18:50","modified_gmt":"2026-03-12T06:18:50","slug":"google-sheets-sync","status":"publish","type":"helpwp_doc","link":"https:\/\/easycommerce.dev\/docs\/addons\/google-sheets-sync\/","title":{"rendered":"Google Sheets Sync"},"content":{"rendered":"\n<p>This integration lets you automatically store and manage your store&#8217;s order data in a Google Sheet, simplifying your order tracking process.<\/p>\n\n\n\n<p>Follow these steps to activate the Google Sheets Sync addon and configure the API settings for seamless synchronization of order data to Google Sheets.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Activate the Addon<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sign in to your WordPress website\u2019s dashboard.<\/li>\n\n\n\n<li>From the left menubar, Go to\u00a0<strong>EasyCommerce > Addons<\/strong>\u00a0section and click \u201c<strong>Enabled<\/strong>\u201d under the <strong>Google Sheets Sync<\/strong> addon.<\/li>\n<\/ul>\n\n\n\n<p><strong>Read another documentation on&nbsp;<strong><a href=\"https:\/\/easycommerce.dev\/docs\/addons\/install-and-activate-addons\/\" target=\"_blank\" rel=\"noreferrer noopener\">how to install and activate an addon on EasyCommerce<\/a><\/strong>.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"986\" height=\"346\" src=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/google-sheet-1.png\" alt=\"\" class=\"wp-image-1045\" srcset=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/google-sheet-1.png 986w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/google-sheet-1-300x105.png 300w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/google-sheet-1-768x270.png 768w\" sizes=\"auto, (max-width: 986px) 100vw, 986px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Create a Google Cloud Account and Set Up API<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp; &nbsp; 1. Create a Google Cloud Account:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the <a href=\"https:\/\/console.cloud.google.com\/\">Google Cloud Console<\/a>.<\/li>\n\n\n\n<li>Sign up or sign in with your Google account.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp; &nbsp; 2. Create a Google Cloud Project:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once logged in, click on <strong>Select a Project<\/strong> at the top of the console, then click <strong>New Project<\/strong>.<\/li>\n\n\n\n<li>Name your project and choose the organization (if applicable).<\/li>\n\n\n\n<li>Click <strong>Create<\/strong>.<\/li>\n<\/ul>\n\n\n\n<iframe loading=\"lazy\" width=\"800\" height=\"400\" src=\"https:\/\/www.youtube.com\/embed\/ovJZvEVdqyA?si=xxuUUUDREy-43ntN\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp; &nbsp; 3. Enable Google Sheets API:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From the Google Cloud Console, go to <strong>API &amp; Services &gt; Library<\/strong>.<\/li>\n\n\n\n<li>Search for <strong>Google Sheets API<\/strong>.<\/li>\n\n\n\n<li>Click on it and enable it for your project.<\/li>\n<\/ul>\n\n\n\n<iframe loading=\"lazy\" width=\"800\" height=\"400\" src=\"https:\/\/www.youtube.com\/embed\/DITdjhWgOOg?si=qOfWF8BTIPc3PQih\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp; &nbsp; &nbsp;4. Create a Service Account:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to <strong>API &amp; Services &gt; Credentials<\/strong>.<\/li>\n\n\n\n<li>Click <strong>Create Credentials<\/strong>, then select <strong>Service Account<\/strong>.<\/li>\n\n\n\n<li>Give the service account a name and description (for example, &#8220;<strong>EasyCommerce Sheets Sync<\/strong>&#8220;).<\/li>\n\n\n\n<li>After creating it, grant the service account the <strong>Owner<\/strong> role (or the necessary role for access).<\/li>\n\n\n\n<li>Finish the process and click <strong>Done<\/strong>.<\/li>\n<\/ul>\n\n\n\n<iframe loading=\"lazy\" width=\"800\" height=\"400\" src=\"https:\/\/www.youtube.com\/embed\/QmJ2JVUrTdo?si=Rbt1Jd7F3QBKIQ7g\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp; &nbsp; &nbsp;5. Create Credentials:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After creating the service account, click on it to manage it.<\/li>\n\n\n\n<li>Under <strong>Keys<\/strong>, click <strong>Add Key<\/strong> and select <strong>JSON<\/strong>. This will download a JSON file containing the necessary credentials for your API integration.<\/li>\n<\/ul>\n\n\n\n<iframe loading=\"lazy\" width=\"800\" height=\"400\" src=\"https:\/\/www.youtube.com\/embed\/enVS2Rv8AHU?si=L3rfVftSrh1s6W0m\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Configure Google Sheets Sync in EasyCommerce<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to WordPress Dashboard <strong>Store &gt; Settings &gt; Google Sheets<\/strong>.<\/li>\n\n\n\n<li>Toggle to <strong>enable Google Sheets Sync<\/strong>.<\/li>\n\n\n\n<li>Fill in the Google Sheets Sync Fields:<\/li>\n<\/ul>\n\n\n\n<p> #<strong>Spreadsheet ID:<\/strong> Find this in the URL of the Google Sheet you want to sync (it\u2019s the long string of characters between <strong>\/d\/<\/strong> and <strong>\/edit<\/strong>).<br> # <strong>Private Key:<\/strong> Open the downloaded JSON file from Google Cloud and find the <strong>private_key<\/strong> field. Copy and paste this key.<br> # <strong>Client Email:<\/strong> From the JSON file, copy the <strong>client_email<\/strong> field.<br> # <strong>Client ID:<\/strong> Also found in the JSON file, copy the <strong>client_id<\/strong> field.<br> # <strong>Range Name:<\/strong> This is the specific range in your Google Sheet but you do not need to specify the range; just insert the sheet&#8217;s name (e.g., <strong>Sheet1<\/strong>).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Save Settings:<\/strong> Once you have entered all the details, click <strong>Save Settings<\/strong> to store the configuration.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"917\" height=\"880\" src=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Screenshot-2025-07-29-at-11.51.34-AM.png\" alt=\"\" class=\"wp-image-661\" style=\"width:592px;height:auto\" srcset=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Screenshot-2025-07-29-at-11.51.34-AM.png 917w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Screenshot-2025-07-29-at-11.51.34-AM-300x288.png 300w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Screenshot-2025-07-29-at-11.51.34-AM-768x737.png 768w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Grant Google Sheets Access<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Share your Google Sheet with the <strong>client_email<\/strong> found in your JSON file:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"490\" src=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-share-1-1024x490.png\" alt=\"\" class=\"wp-image-290\" srcset=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-share-1-1024x490.png 1024w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-share-1-300x144.png 300w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-share-1-768x368.png 768w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-share-1-1536x735.png 1536w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-share-1.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"490\" src=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-editor-1024x490.png\" alt=\"\" class=\"wp-image-289\" srcset=\"https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-editor-1024x490.png 1024w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-editor-300x144.png 300w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-editor-768x368.png 768w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-editor-1536x735.png 1536w, https:\/\/easycommerce.dev\/docs\/wp-content\/uploads\/2025\/03\/Google-Sheets-editor.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now that you have synced your EasyCommerce Store with Google Sheets, you will get your order data in Google Sheets.<\/p>\n","protected":false},"author":5,"featured_media":0,"template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","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":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","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":"var(--ast-global-color-4)","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":""}}},"helpwp_product":[19],"helpwp_topic":[21],"class_list":["post-283","helpwp_doc","type-helpwp_doc","status-publish","hentry","helpwp_topic-addons"],"_links":{"self":[{"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/helpwp_doc\/283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/helpwp_doc"}],"about":[{"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/types\/helpwp_doc"}],"author":[{"embeddable":true,"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/users\/5"}],"wp:attachment":[{"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"helpwp_product","embeddable":true,"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/helpwp_product?post=283"},{"taxonomy":"helpwp_topic","embeddable":true,"href":"https:\/\/easycommerce.dev\/docs\/wp-json\/wp\/v2\/helpwp_topic?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}