\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ use_custom_gutter=”on” make_equal=”on” _builder_version=”4.24.1″ _module_preset=”default” background_color=”#d3e3ff” custom_margin=”40px||40px||true|false” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_module=”44972″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.23.1″ _module_preset=”default” positioning=”none” vertical_offset=”-44px” custom_css_main_element=”margin:auto;” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” header_font_size=”33px” header_4_text_color=”#071623″ header_4_font_size=”24px” header_4_line_height=”1.4em” background_color=”RGBA(255,255,255,0)” custom_margin=”0px|0px|0px|0px|true|true” custom_padding=”0px|0px|0px|0px|true|true” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Ready to streamline<\/span> your data?<\/span><\/h4>\n[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.23.1″ _module_preset=”default” custom_css_main_element=”margin:auto;” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”center” _builder_version=”4.23.1″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Why export range to another spreadsheet?<\/h3>\n
Amanda is one of the support analysts from the team that registers complaints from users of a CRM software application. At the end of the day, her job requires her to report the list of incidents to her management, who will then analyze which part of the application is posing what kind of problems. Here is how her typical issue tracking spreadsheet looks like.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-_55-1.jpg” alt=”Export Range of Spreadsheets: Report Example in Google Sheets” title_text=”export-range” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The critical information that her management needs come from columns B, F, and G. The client information is not as important. Therefore Amanda doesn’t need to share the data from the columns A, C, D, and E.<\/p>\n
Since there is no direct way to eliminate unnecessary information, to date, Amanda has been doing the following.<\/p>\n
\n- Make a copy of the Issue Tracker spreadsheet<\/li>\n
- Remove columns A, C, D and E<\/li>\n
- Share the copied spreadsheet with her management in which the remainder of the information available.<\/li>\n<\/ul>\n
While doing that helps the situation, it is a repetitive manual process, which fortunately can be averted by making use of the Sheetgo add-on.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Solution: Automatically export range data using Sheetgo add-on<\/h3>\n
Sheetgo add-on for Google Sheets boosts the connectivity of spreadsheets to the next level. It can automatically manage all the heavy-lifting that Amanda had to manually do and even more. Sheetgo allows us to perform all these functions. If not already installed, we can get it by clicking the button below.<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SIGN UP FOR FREE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” global_module=”44753″ saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
With this extremely handy tool, we can configure Google Sheets to automatically export a range of data (and subject to predefined conditions if need be!). Not only that, we can even configure the frequency at which these exports can happen \u2013 hourly, daily, weekly or monthly. The export takes place from the current spreadsheet to other spreadsheets \u2013\u00a0both ours and other users\u2019.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Configuration: Steps to export range automatically with Sheetgo<\/h3>\n
For the purposes of illustration, we are going to export data range from the Issue Tracker<\/strong>\u00a0file to Issues – Master Database<\/strong>\u00a0file. For this to happen, it is a pre-requisite that Amanda’s management grants her write access permissions to the Issues – Master Database<\/strong> file, without which, this automation won’t work.<\/p>\n1. Start Sheetgo and initiate a connection<\/h4>\n
Now that we have Sheetgo installed on our Google Sheets application, we now open the\u00a0Issues – Master Database<\/strong>\u00a0file. To start the add-on, we navigate to the Menu\u00a0Add-ons > Sheetgo > Start.<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-56.png” alt=”Start Sheetgo Add On in Master Database in Google Sheets” title_text=”sheetgo-add-on” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Doing so will open the Sheetgo interface on the screen as a sidebar. Click on the green ‘+<\/strong>‘ sign to create the connection with the “Issue Tracker” file.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44981″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” text_text_color=”#071623″ header_text_color=”#071623″ header_4_font=”|700|||||||” header_4_text_color=”#071623″ header_4_font_size=”22px” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect, merge, filter or split your spreadsheets<\/span><\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.24.1″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|desktop” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
2. Link destination file with the source sheet we need the data from<\/h4>\n
Clicking the Select file(s)<\/strong>\u00a0button leads us to the list of most recently updated files by default.\u00a0If we don\u2019t see the file we want, we can use the search module to lookup the file within Google Drive. For this example, we select Issues Tracker\u00a0<\/strong>file as the data source, and then for source sheet Sheet1<\/strong>.<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-57.png” alt=”Export Range: Select Files to Consolidate” title_text=”export-range” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
We then arrive at the Settings<\/strong>. Here we can select the frequency of updates in the Automatic update<\/strong>\u00a0section. We enable this button and leave it to the default option, Daily<\/strong>\u00a0because Amanda needs to send data from Issue Tracker<\/strong>\u00a0file to the Issues – Master Database<\/strong>\u00a0file every day.<\/p>\nNote that, in case the management wants that the data be preserved rather than refreshed every day, Amanda could go with the\u00a0Append<\/strong> option.<\/span><\/p>\n3. Add the filter condition for selective data import, and create a connection<\/h4>\n
To do this, we scroll down a bit on the sidebar until we see the Filter by<\/strong>\u00a0section. Enable this button and\u00a0choose the option filter by Query Language<\/strong>\u00a0and key in the following statement:<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.16″ text_font=”||||||||” background_color=”rgba(0,113,193,0.19)” custom_padding=”9px||9px|8px|true” border_radii=”on|1px|1px|1px|1px” border_width_all=”2px” border_color_all=”rgba(12,113,195,0.63)” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
SELECT B, F, G<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The Filter by<\/strong>\u00a0section now shows filter by Query \u201cSELECT B, F, G\u201d.<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-58.png” alt=”Filter Condition in Sheetgo Add On for Export Range” title_text=”export-range-sheetgo-add-on” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Finally, to establish a link that can automatically export filtered data, we click the SAVE CONNECTION<\/strong>\u00a0button. Doing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \u201cLast update: Just now\u201d.<\/p>\nCongrats!<\/h4>\n
We see that Sheetgo created a new sheet (name will be same as that of the connection) in the\u00a0Issues – Master Database<\/strong>\u00a0file, and accordingly pulls only B, F, and G column data from the Issue Tracker\u00a0<\/strong>file.<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-59.png” alt=”Export Range of My Sheets to Another: Consolidated Data in Google Sheets” title_text=”export-range” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.24.1″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44987″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” header_4_font=”|700|||||||” header_4_text_color=”#071623″ header_4_font_size=”22px” header_4_line_height=”1.4em” custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Automatic Updates<\/h3>\n
The data import keeps happening automatically and periodically once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.<\/p>\n
Click on the 3 dots next to the connection name (in this case \u201cSG_Sheet1\u201d) > edit (the pencil icon) > Automatic update.<\/p>\n
Click on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click on SAVE\u00a0CHANGES.<\/strong><\/p>\nRead more about the differences between IMPORTRANGE and Sheetgo functionalities in the following blog post<\/a>.<\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Collaboration is the cornerstone of today’s spreadsheets, and Google Sheets has been evolving around that ideology. There’s a small catch though. Using the out of the box Google Sheets application, we can readily share an entire spreadsheet with another user. But, it is not possible to share a specific subset of information from it. We […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Collaboration is the cornerstone of today's spreadsheets, and Google Sheets has been evolving around that ideology. There's a small catch though. Using the out of the box Google Sheets application, we can readily share an entire spreadsheet with another user. But, it is not possible to share a specific subset of information from it. We do have the IMPORTRANGE<\/a> function which we can use<\/a> to import specific range from another spreadsheet. But we cannot just do the opposite. The reason being that, currently, there is no native Google Sheets functionality that lets us export range of data to another spreadsheet.\nWhy export range to another spreadsheet?<\/h3>\nAmanda is a one of the support analysts from the team that registers complaints from users of a CRM software application. At the end of the day, her job requires her to report the list of incidents to her management, who will then analyze which part of the application is posing what kind of problems. Here is how her typical issue tracking spreadsheet looks like.\n\n[panel type=\"default\"] Example<\/strong> ![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportrange1.png\")
[\/panel]\n\nThe critical information that her management needs is usually from the columns B, F and G. The client information is not as important. Therefore Amanda doesn't need to share the data from the columns A, C, D and E.\n\nSince there is no direct way to eliminate the unnecessary information, to date, Amanda has been doing the following.\n\n \t- Make a copy of the Issue Tracker spreadsheet<\/li>\n \t
- Remove columns A, C, D and E<\/li>\n \t
- Share the copied spreadsheet with her management in which the remainder of the information available.<\/li>\n<\/ul>\nWhile doing that helps the situation, it is a repetitive manual process, which fortunately can be averted by making use of the Sheetgo add-on.\n
Solution: Automatically export range data using Sheetgo add-on<\/h3>\nSheetgo add-on for Google Sheets boosts the connectivity of spreadsheets to the next level. With Sheetgo we can import, export, merge, stack or mirror data. It can automatically manage all the heavy-lifting that Amanda had to manually do and even more. Sheetgo has a simple free version that allows us to perform all these functions. If not already installed, we can get it by clicking the button below:\n\n[panel][ccj id=\"Install Widget\"][\/panel]\n\nWith this rather extremely handy tool, we can configure Google Sheets to automatically export range data (and subject to predefined conditions if need be!). Not only that, we can even configure the frequency at which these exports can happen \u2013 hourly, daily, weekly or monthly. The export takes place from the current spreadsheet to other spreadsheets \u2013\u00a0both ours and other users\u2019.\nConfiguration: Steps to export range automatically with Sheetgo<\/h3>\nFor the purposes of illustration, we are going to export data range from the Issue Tracker<\/strong> file to Issues - Master Database<\/strong> file. For this to happen, it is a pre-requisite that Amanda's management grants her write access permissions to the Issues - Master Database<\/strong> file, without which, this automation won't work.\n1. Start Sheetgo and initiate an export link connection<\/h4>\nNow that we have Sheetgo installed on our Google Sheets application, we now open the \u201cIssue Tracker<\/strong>\u201d file. To start the add-on, we navigate to Add-ons > Sheetgo > Start<\/strong>.\n\n[panel type=\"default\"] Example<\/strong> ![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportrange2.png\")
[\/panel]\n\nDoing so will open the Sheetgo interface on the screen as a sidebar. Hover the mouse pointer over the green circle with a plus, and click on the Export<\/strong> option.\n2. Link source sheet with the destination file that we need to send the data to<\/h4>\nClicking the Connect<\/strong> option leads us to the list of most recently updated files by default. In case the management wants that the data be preserved rather than refreshed everyday, Amanda could go with Append<\/strong> option.\n\nIf we don\u2019t see the file we want, we can use the search module to lookup a file within the Google Drive. For this example, we select Issues - Master Database<\/strong> file for destination spreadsheet, and then for source sheet choose Sheet1<\/strong>.\n\n[panel type=\"default\"] Example ![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportrange3.png\")
[\/panel]\n\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \u201cAutomatic update<\/strong>\u201d section. We leave it to the default option, \u2018Daily\u2019, because Amanda, needs to send data from \u2018Issue Tracker<\/strong>\u2019 file every day.\n3. Add the filter condition for selective data import, and create a connection<\/h4>\nTo do this, we may have to scroll down a bit on the sidebar until we see Filter by<\/strong> section. By default, it shows No active filter<\/strong>. Click on \u2018edit<\/strong>\u2018 to add a condition. Choose \u2018Query Language<\/strong>\u2018 option, and key in the following statement.\n\n[panel]SELECT B, F, G<\/strong>[\/panel]\n\nThe Filter by<\/strong>\u00a0section now shows \u201cSELECT B, F, G<\/strong>\u201d. Finally, to establish the link that can automatically export filtered data, we click CONNECT<\/strong>\u00a0button.\n\n[panel]\u00a0Example\u00a0![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportrange4.png\")
<\/strong>[\/panel]\n\nDoing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \u201cLast update: Just now\u201d.\n\nCongratulations! We did export range from the \u2018Issue Tracker<\/strong>\u2019 file to 'Issues - Master Database<\/strong>' file! Let\u2019s check to see if the data has flown out.\n\n[panel type=\"default\"] Example ![\"Export](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/exportrange5.png\")
[\/panel]\n\nSure enough, it has, and rightly so! We see that Sheetgo creates a new sheet (name will be same as that of the connection), and accordingly pulls only B, F and G column data from \u2018Issue Tracker<\/strong>\u2019 file.\n\nThe data import keeps happening automatically and periodically once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.\n\nConnection name<\/strong> (in this case \u201cSG_Sheet1\u201d) > edit<\/strong> (the pencil icon) > Automatic update<\/strong> > edit<\/strong>.\n\nClick on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-2761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=2761"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2761\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=2761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=2761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=2761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
While doing that helps the situation, it is a repetitive manual process, which fortunately can be averted by making use of the Sheetgo add-on.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Solution: Automatically export range data using Sheetgo add-on<\/h3>\n
Sheetgo add-on for Google Sheets boosts the connectivity of spreadsheets to the next level. It can automatically manage all the heavy-lifting that Amanda had to manually do and even more. Sheetgo allows us to perform all these functions. If not already installed, we can get it by clicking the button below.<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SIGN UP FOR FREE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” global_module=”44753″ saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
With this extremely handy tool, we can configure Google Sheets to automatically export a range of data (and subject to predefined conditions if need be!). Not only that, we can even configure the frequency at which these exports can happen \u2013 hourly, daily, weekly or monthly. The export takes place from the current spreadsheet to other spreadsheets \u2013\u00a0both ours and other users\u2019.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Configuration: Steps to export range automatically with Sheetgo<\/h3>\n
For the purposes of illustration, we are going to export data range from the Issue Tracker<\/strong>\u00a0file to Issues – Master Database<\/strong>\u00a0file. For this to happen, it is a pre-requisite that Amanda’s management grants her write access permissions to the Issues – Master Database<\/strong> file, without which, this automation won’t work.<\/p>\n Now that we have Sheetgo installed on our Google Sheets application, we now open the\u00a0Issues – Master Database<\/strong>\u00a0file. To start the add-on, we navigate to the Menu\u00a0Add-ons > Sheetgo > Start.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-56.png” alt=”Start Sheetgo Add On in Master Database in Google Sheets” title_text=”sheetgo-add-on” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Doing so will open the Sheetgo interface on the screen as a sidebar. Click on the green ‘+<\/strong>‘ sign to create the connection with the “Issue Tracker” file.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44981″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” text_text_color=”#071623″ header_text_color=”#071623″ header_4_font=”|700|||||||” header_4_text_color=”#071623″ header_4_font_size=”22px” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.24.1″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|desktop” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Clicking the Select file(s)<\/strong>\u00a0button leads us to the list of most recently updated files by default.\u00a0If we don\u2019t see the file we want, we can use the search module to lookup the file within Google Drive. For this example, we select Issues Tracker\u00a0<\/strong>file as the data source, and then for source sheet Sheet1<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-57.png” alt=”Export Range: Select Files to Consolidate” title_text=”export-range” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We then arrive at the Settings<\/strong>. Here we can select the frequency of updates in the Automatic update<\/strong>\u00a0section. We enable this button and leave it to the default option, Daily<\/strong>\u00a0because Amanda needs to send data from Issue Tracker<\/strong>\u00a0file to the Issues – Master Database<\/strong>\u00a0file every day.<\/p>\n Note that, in case the management wants that the data be preserved rather than refreshed every day, Amanda could go with the\u00a0Append<\/strong> option.<\/span><\/p>\n To do this, we scroll down a bit on the sidebar until we see the Filter by<\/strong>\u00a0section. Enable this button and\u00a0choose the option filter by Query Language<\/strong>\u00a0and key in the following statement:<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ text_font=”||||||||” background_color=”rgba(0,113,193,0.19)” custom_padding=”9px||9px|8px|true” border_radii=”on|1px|1px|1px|1px” border_width_all=”2px” border_color_all=”rgba(12,113,195,0.63)” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n SELECT B, F, G<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Filter by<\/strong>\u00a0section now shows filter by Query \u201cSELECT B, F, G\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-58.png” alt=”Filter Condition in Sheetgo Add On for Export Range” title_text=”export-range-sheetgo-add-on” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Finally, to establish a link that can automatically export filtered data, we click the SAVE CONNECTION<\/strong>\u00a0button. Doing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \u201cLast update: Just now\u201d.<\/p>\n We see that Sheetgo created a new sheet (name will be same as that of the connection) in the\u00a0Issues – Master Database<\/strong>\u00a0file, and accordingly pulls only B, F, and G column data from the Issue Tracker\u00a0<\/strong>file.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-59.png” alt=”Export Range of My Sheets to Another: Consolidated Data in Google Sheets” title_text=”export-range” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.24.1″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44987″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” header_4_font=”|700|||||||” header_4_text_color=”#071623″ header_4_font_size=”22px” header_4_line_height=”1.4em” custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n The data import keeps happening automatically and periodically once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.<\/p>\n Click on the 3 dots next to the connection name (in this case \u201cSG_Sheet1\u201d) > edit (the pencil icon) > Automatic update.<\/p>\n Click on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click on SAVE\u00a0CHANGES.<\/strong><\/p>\n Read more about the differences between IMPORTRANGE and Sheetgo functionalities in the following blog post<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Collaboration is the cornerstone of today’s spreadsheets, and Google Sheets has been evolving around that ideology. There’s a small catch though. Using the out of the box Google Sheets application, we can readily share an entire spreadsheet with another user. But, it is not possible to share a specific subset of information from it. We […]<\/p>\n","protected":false},"author":40,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Collaboration is the cornerstone of today's spreadsheets, and Google Sheets has been evolving around that ideology. There's a small catch though. Using the out of the box Google Sheets application, we can readily share an entire spreadsheet with another user. But, it is not possible to share a specific subset of information from it. We do have the IMPORTRANGE<\/a> function which we can use<\/a> to import specific range from another spreadsheet. But we cannot just do the opposite. The reason being that, currently, there is no native Google Sheets functionality that lets us export range of data to another spreadsheet.\n1. Start Sheetgo and initiate a connection<\/h4>\n
Connect, merge, filter or split your spreadsheets<\/span><\/h4>\n
2. Link destination file with the source sheet we need the data from<\/h4>\n
3. Add the filter condition for selective data import, and create a connection<\/h4>\n
Congrats!<\/h4>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n
Automatic Updates<\/h3>\n
Why export range to another spreadsheet?<\/h3>\nAmanda is a one of the support analysts from the team that registers complaints from users of a CRM software application. At the end of the day, her job requires her to report the list of incidents to her management, who will then analyze which part of the application is posing what kind of problems. Here is how her typical issue tracking spreadsheet looks like.\n\n[panel type=\"default\"] Example<\/strong>
[\/panel]\n\nThe critical information that her management needs is usually from the columns B, F and G. The client information is not as important. Therefore Amanda doesn't need to share the data from the columns A, C, D and E.\n\nSince there is no direct way to eliminate the unnecessary information, to date, Amanda has been doing the following.\n\n \t
Solution: Automatically export range data using Sheetgo add-on<\/h3>\nSheetgo add-on for Google Sheets boosts the connectivity of spreadsheets to the next level. With Sheetgo we can import, export, merge, stack or mirror data. It can automatically manage all the heavy-lifting that Amanda had to manually do and even more. Sheetgo has a simple free version that allows us to perform all these functions. If not already installed, we can get it by clicking the button below:\n\n[panel][ccj id=\"Install Widget\"][\/panel]\n\nWith this rather extremely handy tool, we can configure Google Sheets to automatically export range data (and subject to predefined conditions if need be!). Not only that, we can even configure the frequency at which these exports can happen \u2013 hourly, daily, weekly or monthly. The export takes place from the current spreadsheet to other spreadsheets \u2013\u00a0both ours and other users\u2019.\n
Configuration: Steps to export range automatically with Sheetgo<\/h3>\nFor the purposes of illustration, we are going to export data range from the Issue Tracker<\/strong> file to Issues - Master Database<\/strong> file. For this to happen, it is a pre-requisite that Amanda's management grants her write access permissions to the Issues - Master Database<\/strong> file, without which, this automation won't work.\n
1. Start Sheetgo and initiate an export link connection<\/h4>\nNow that we have Sheetgo installed on our Google Sheets application, we now open the \u201cIssue Tracker<\/strong>\u201d file. To start the add-on, we navigate to Add-ons > Sheetgo > Start<\/strong>.\n\n[panel type=\"default\"] Example<\/strong>
[\/panel]\n\nDoing so will open the Sheetgo interface on the screen as a sidebar. Hover the mouse pointer over the green circle with a plus, and click on the Export<\/strong> option.\n2. Link source sheet with the destination file that we need to send the data to<\/h4>\nClicking the Connect<\/strong> option leads us to the list of most recently updated files by default. In case the management wants that the data be preserved rather than refreshed everyday, Amanda could go with Append<\/strong> option.\n\nIf we don\u2019t see the file we want, we can use the search module to lookup a file within the Google Drive. For this example, we select Issues - Master Database<\/strong> file for destination spreadsheet, and then for source sheet choose Sheet1<\/strong>.\n\n[panel type=\"default\"] Example
[\/panel]\n\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \u201cAutomatic update<\/strong>\u201d section. We leave it to the default option, \u2018Daily\u2019, because Amanda, needs to send data from \u2018Issue Tracker<\/strong>\u2019 file every day.\n3. Add the filter condition for selective data import, and create a connection<\/h4>\nTo do this, we may have to scroll down a bit on the sidebar until we see Filter by<\/strong> section. By default, it shows No active filter<\/strong>. Click on \u2018edit<\/strong>\u2018 to add a condition. Choose \u2018Query Language<\/strong>\u2018 option, and key in the following statement.\n\n[panel]SELECT B, F, G<\/strong>[\/panel]\n\nThe Filter by<\/strong>\u00a0section now shows \u201cSELECT B, F, G<\/strong>\u201d. Finally, to establish the link that can automatically export filtered data, we click CONNECT<\/strong>\u00a0button.\n\n[panel]\u00a0Example\u00a0
<\/strong>[\/panel]\n\nDoing so, we notice that in a few seconds Sheetgo creates a new connection whose status shows \u201cLast update: Just now\u201d.\n\nCongratulations! We did export range from the \u2018Issue Tracker<\/strong>\u2019 file to 'Issues - Master Database<\/strong>' file! Let\u2019s check to see if the data has flown out.\n\n[panel type=\"default\"] Example [\/panel]\n\nSure enough, it has, and rightly so! We see that Sheetgo creates a new sheet (name will be same as that of the connection), and accordingly pulls only B, F and G column data from \u2018Issue Tracker<\/strong>\u2019 file.\n\nThe data import keeps happening automatically and periodically once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic setting altogether. Shown below is how we navigate to the corresponding settings pane.\n\nConnection name<\/strong> (in this case \u201cSG_Sheet1\u201d) > edit<\/strong> (the pencil icon) > Automatic update<\/strong> > edit<\/strong>.\n\nClick on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-2761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=2761"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2761\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=2761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=2761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=2761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}