<div class='ui dimmer modals page' style='display: none;'><div id='helpie-password-modal' class='pauple_helpie ui modal small' style='display: none;'><div class='ui header'><i class='circular lock icon'></i> Password Protected</div><div class='item-content'><br /><label for='password_check'>Enter Password : </label><p><input type='password' id='password_check' name='password_check' class='password' value='' required></p></div><div class='actions'><div class='ui black deny button'>Nope</div><div class='ui positive right labeled icon button'>Yep, that's right!<i class='checkmark icon'></i></div></div><div class='clear'></div></div></div>{"id":63683,"date":"2026-01-07T10:55:39","date_gmt":"2026-01-07T13:55:39","guid":{"rendered":"https:\/\/reportei.com\/?post_type=pauple_helpie&#038;p=63683"},"modified":"2026-09-29T17:47:53","modified_gmt":"2026-09-29T20:47:53","slug":"integration-with-sheets-can-i-make-changes-to-my-spreadsheet-after-integrating-with-reportei","status":"publish","type":"pauple_helpie","link":"https:\/\/reportei.com\/en\/central-de-ajuda\/integration-with-sheets-can-i-make-changes-to-my-spreadsheet-after-integrating-with-reportei\/","title":{"rendered":"Integration with Sheets: Can I make changes to my spreadsheet after integrating with Reportei"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">After integrating a Google Sheets spreadsheet into Reportei  <strong>structural changes to the original spreadsheet<\/strong>  such as reordering, deleting, or adding columns or rows can directly affect the data in the reports and cause  <strong>errors<\/strong>  in the metrics  <strong>Therefore  <\/strong><strong>we recommend that after integration, changes to the spreadsheet structure be avoided<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If it is necessary to change the spreadsheet structure, such as adding, deleting, or reorganizing columns\/rows, it will be necessary to  <strong>reintegration it<\/strong>  and go through the entire setup process again<\/p>\n\n\n\n<h2 id=\"h-changes-that-may-affect-the-data\" class=\"wp-block-heading\"><span id=\"helpie-sp-1\"><span id=\"helpie-sp-1\"><strong>  Changes that may affect the data<\/strong><\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>If your spreadsheet is vertical, data organized in columns<\/strong><strong>\n<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li> Delete or reorder columns<\/li>\n\n\n\n<li> Insert columns in the middle of the structure<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>If your spreadsheet is horizontal, data organized in rows<\/strong><strong>\n<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li> Delete or reorder rows<\/li>\n\n\n\n<li> Insert rows in the middle of the structure<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">These changes may compromise the correct reading of data in reports and metrics<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 id=\"h-what-to-do-if-i-need-to-change-the-spreadsheet\" class=\"wp-block-heading\"><span id=\"helpie-sp-2\"><span id=\"helpie-sp-2\"><strong>What to do if I need to change the spreadsheet<\/strong><\/span><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you need to change the spreadsheet structure or add new columns\/rows, it will be necessary to  <strong>reintegration the spreadsheet<\/strong>.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Steps to reintegrate the spreadsheet and update integrations<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Access Manage Integrations<\/strong>  in the desired project<\/li>\n\n\n\n<li><strong>Remove the previous integration  <\/strong>optional but recommended since there were changes in the spreadsheet and compromise of the previous integration<\/li>\n\n\n\n<li><strong>Add the new integration<\/strong>  from the modified spreadsheet<\/li>\n\n\n\n<li><strong>Go through the mapping process again<\/strong>  of the new spreadsheet, defining which columns or rows will be used and how the data should be interpreted. Remember that once you save the data at this stage, it will not be possible to change it later  <a href=\"https:\/\/reportei.com\/en\/central-de-ajuda\/integration-with-sheets-necessary-precautions-during-the-validation-stage-of-spreadsheet-data\/\">learn more here<\/a>):\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/reportei.com\/en\/?post_type=pauple_helpie&#038;p=82677\" target=\"_blank\" rel=\"noreferrer noopener\">See how to classify columns or rows in the integration with Sheets<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Create your metrics<\/strong>  charts and tables according to the new configuration<\/li>\n\n\n\n<li><strong>Add the new integration<\/strong>  to your reports and dashboards\n<ul class=\"wp-block-list\">\n<li>For old reports and dashboards you can  <strong>replace the old integration with the new one  <\/strong>and add the metrics created in the new integration<\/li>\n\n\n\n<li>Or if you prefer  <strong>create new reports\/dashboards<\/strong>  with the new integration<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h4 id=\"h-final-tip\" class=\"wp-block-heading\"><span id=\"helpie-sp-2-1\"><span id=\"helpie-sp-2-1\"><strong>  Final tip<\/strong><\/span><\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To avoid needing to reintegrate  <strong>carefully review the structure of your spreadsheet<\/strong>  before integrating it into Reportei. Ensure that all necessary data is organized and ready for use so that the integration process is as efficient as possible<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After integrating a Google Sheets spreadsheet into Reportei structural changes to the original spreadsheet such as reordering, deleting, or adding columns or rows can directly affect the data in the reports and cause errors in the metrics Therefore we recommend that after integration, changes to the spreadsheet structure be avoided. If it is necessary to [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"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":"set","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":""}},"footnotes":""},"helpdesk_category":[4179],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-63683","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-google-sheets"],"_links":{"self":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/63683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/comments?post=63683"}],"version-history":[{"count":9,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/63683\/revisions"}],"predecessor-version":[{"id":82689,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/63683\/revisions\/82689"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/media?parent=63683"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpdesk_category?post=63683"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_tag?post=63683"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_add_tag?post=63683"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_up_tag?post=63683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}