{"id":169,"date":"2021-02-05T22:14:54","date_gmt":"2021-02-06T02:14:54","guid":{"rendered":"http:\/\/wdp.g-integrator.com\/docs\/?p=169"},"modified":"2023-11-13T08:36:24","modified_gmt":"2023-11-13T12:36:24","slug":"hubspot-tutorial-create-new-sheet-append-to-current-sheet-when-pulling-data","status":"publish","type":"post","link":"https:\/\/wdp.g-integrator.com\/docs\/2021\/02\/05\/hubspot-tutorial-create-new-sheet-append-to-current-sheet-when-pulling-data\/","title":{"rendered":"HubSpot tutorial : Create new sheet\/Append to current sheet  when pulling data"},"content":{"rendered":"\n<p class=\"has-large-font-size\">Option 1: Permeant Settings<\/p>\n\n\n\n<p><strong>This will apply to ALL future pulls<\/strong><\/p>\n\n\n\n<p>1. Select Add-ons -> G-Integrator for Hubspot -> Tools -> User Preferences<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"944\" height=\"670\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/100.png\" alt=\"\" class=\"wp-image-170\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/100.png 944w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/100-300x213.png 300w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/100-768x545.png 768w\" sizes=\"(max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/figure>\n\n\n\n<p>2. Under the &#8220;Default Data Pulling Settings, toggle &#8220;Create a new sheet&#8221; option<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"488\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/101.png\" alt=\"\" class=\"wp-image-171\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/101.png 539w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/101-300x272.png 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/figure>\n\n\n\n<p class=\"has-large-font-size\">Option 2: One-time setting<\/p>\n\n\n\n<p><strong>This will apply ONLY to the current pull<\/strong><\/p>\n\n\n\n<p>1. Select Add-ons -> G-Integrator for Hubspot -> Get HubSpot Data<\/p>\n\n\n\n<p>2. Under tab 2: &#8220;Change Pull Settings (optional)&#8221; toggle &#8220;Create a new sheet&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"594\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/102.png\" alt=\"\" class=\"wp-image-172\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/102.png 729w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2021\/02\/102-300x244.png 300w\" sizes=\"(max-width: 729px) 100vw, 729px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Option 1: Permeant Settings This will apply to ALL future pulls 1. Select Add-ons -> G-Integrator for Hubspot -> Tools -> User Preferences 2. Under the &#8220;Default Data Pulling Settings, toggle &#8220;Create a new sheet&#8221; option Option 2: One-time setting This will apply ONLY to the current pull 1. Select Add-ons -> G-Integrator for Hubspot &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/wdp.g-integrator.com\/docs\/2021\/02\/05\/hubspot-tutorial-create-new-sheet-append-to-current-sheet-when-pulling-data\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;HubSpot tutorial : Create new sheet\/Append to current sheet  when pulling data&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[14,11],"_links":{"self":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/169"}],"collection":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":1,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":173,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/169\/revisions\/173"}],"wp:attachment":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}