{"id":3898,"date":"2017-04-13T11:48:09","date_gmt":"2017-04-13T09:48:09","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=3898"},"modified":"2017-04-13T11:48:09","modified_gmt":"2017-04-13T09:48:09","slug":"exportar-google-sheets-com-condicoes","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/how-to-solve-with-sheetgo\/export-google-sheets-with-conditions\/","title":{"rendered":"Exportar dados com condi\u00e7\u00f5es no Planilhas Google"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

In the early days of computing, the spreadsheets programs when initially brought to the scene were revolutionary. To the extent that, even today they continue to be an integral part of our work life. Like everything else, they have evolved into much more powerful, robust and advanced applications. And in the current information age, they are made even more user-friendly, in the sense that they can be accessed from anywhere and any device. Google Sheets<\/a> has been the on the forefront of this innovation. Yet, not all ‘good-to-have’ things are part of it. For instance, from a given spreadsheet, we cannot yet export data with conditions in Google Sheets.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#d3e3ff” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_module=”44972″ global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” header_font_size=”33px” header_4_font_size=”24px” background_color=”RGBA(255,255,255,0)” 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=”{}”]<\/p>\n

Ready to streamline<\/span> your data?<\/h4>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” 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=”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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Why export data with conditions in Google Sheets?<\/h3>\n

Bryan works as a data analyst at a major retail company that has outlets across the country. All the employees use Google Sheets for their spreadsheet needs. His job involves analyzing sales data, identify trends, skim the customer spending patterns and establish the likelihood of their upcoming purchases. Once he has the list ready, he will need to filter out those customers with a high probability of future purchases and send it to Kirk, from the customer services relations (CRM) team. Kirk would then reach out to each of those customers with attractive deals and offers, and persuade them to visit the store. Because those are the ones who can be easily moved with a simple marketing stimulus as opposed to the ones who are not planning to buy anytime soon.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-_38-1.jpg” alt=”Export Google Sheets: Customer Analysis Data in Google Sheets” title_text=”export-data-customer-analysis” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Needless to say, the list of less probable customers is not of much use, and it’s better not to include them in the list.\u00a0So, what can Bryan do? Every time he has a new list, he can filter it\u00a0to retain only the high probable prospects and accordingly shares that filtered list to Kirk. It might look easy. But, what if\u00a0there are a considerable number of\u00a0categories and CRM representatives to deal with (let\u2019s say about 50)? And, if he has to do that every day with the new list? Imagine the effort that Bryan has to put in to get out all the necessary information to the concerned parties. Not very easy! He would rather have this automated than manually deal with it every single day.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Solution: Automatically export the data with Sheetgo<\/h3>\n

There isn’t a native functionality available with which we can export data with conditions in Google Sheets. Therefore, we will need the help of the Sheetgo add-on, to accomplish this automation setup. This\u00a0add-on highly boosts the connectivity of Google Sheets.\u00a0It can automatically manage all the heavy-lifting that Bryan had to manually do (explained above). We can get it by clicking the button below.<\/p>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/workspace.google.com\/marketplace\/app\/sheetgo_connect_filter_merge_sheets_exce\/94172092257″ url_new_window=”on” button_text=”INSTALL 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” 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” global_module=”45040″ theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Configuration: Steps to automatically export data with conditions in Google Sheets<\/h3>\n

For the purposes of demonstration, we will export data from the Customer Analysis<\/strong>\u00a0file that Bryan uses, to the Sales Prospects<\/strong>\u00a0file which Kirk will work on. For this to happen seamlessly, it is a pre-requisite that Kirk grants Bryan necessary edit access control to the file Sales Prospects.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

1. Start\u00a0Sheetgo and initiate a connection<\/h4>\n

Now that we have Sheetgo installed on our Google Sheets application, a new Google Sheets file will automatically open. This will be our\u00a0Sales Prospects\u00a0file where we want to export the filtered data coming from “Customer Analysis” to. 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-39.png” alt=”Export Data With Conditions in Google Sheets: Start Sheetgo Add on” title_text=”export-data-with-conditions-add-on-google-sheets” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Doing so will open the Sheetgo interface on the screen as a sidebar, as shown in the image below. Click on the green +<\/strong>\u00a0sign in the bottom right corner to create the connection with the Customer Analysis file.<\/p>\n

<\/h4>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-42.png” alt=”Export Google Sheets” title_text=”export-google-sheets” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

2. Link with the source file to create the Export connection<\/h4>\n

Clicking the Select file(s)<\/strong>\u00a0option leads us to the list of most recently updated files by default. If we don\u2019t see the file we want, we can use the search module to lookup a file within Google Drive. For this demonstration, we select Customer Analysis<\/strong>\u00a0file as Data Source, and the data will be exported from the first and only tab Sheet1<\/strong>.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-43.png” alt=”Export Data with Conditions in Google Sheets: Select Files” title_text=”select-files-export-data-google-sheets” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

We then arrive at the Settings<\/strong>\u00a0screen. Here we can select the frequency of transfers in the Automatic update<\/strong>\u00a0section. We enable this button and leave it to the default option,\u00a0Daily<\/strong>\u00a0because Bryan transfers the list every day. Also, in the future, if Bryan doesn\u2019t need the automatic transfers anymore, he can turn them off in this section.<\/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=”{}”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” 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=”{}”]<\/p>\n

Connect, merge, filter or split your\u00a0 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.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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

3. Add a filter condition for selective data export, and create a connection<\/h4>\n

Scroll down on the sidebar to reach the Filter by<\/strong>\u00a0section. Enable this button to add a filter condition. The probability related field is on column F on the Customer Analysis<\/strong>\u00a0file (please see the first snapshot). Bryan needs to send the list of all customers with probability greater than or equal to 0.6. Therefore we ensure it is Column F: Probability of next visit<\/strong>\u00a0in the first drop-down, Number greater than or equal to<\/strong>\u00a0in the second. The value in the text field will be, 0.6<\/strong>.<\/p>\n

The\u00a0Filter by<\/strong>\u00a0section now shows Column F number greater than or equal to 0.6<\/strong>. Finally, to establish a link that can\u00a0automatically export filtered data, we click on the\u00a0SAVE\u00a0CONNECTION<\/strong>\u00a0button.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-44.png” alt=”Export Google Sheets” title_text=”export-data-add-filter” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Once we do that, we will notice that in a few seconds Sheetgo creates a new connection whose status shows Last update: Just now. Awesome! We just did export data with conditions in Google Sheets! Here’s the snapshot of the file Sales Prospects.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/01\/frame-_45.jpg” alt=”Export Google Sheets: Sales Prospects Example” title_text=”sales-prospects-google-sheets-export-data” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

We see that the data has appropriately flown in where all the probability values are greater than or equal to 0.6.<\/p>\n

Automatic transfers<\/h3>\n

The data export keeps happening automatically and periodically\u00a0once the appropriate connection is in place. Please note that we can change the frequency with which these data exports happen or even turn off the automatic transfers altogether. Shown below is how we navigate to the corresponding settings pane.<\/p>\n

Click on the 3 dots <\/strong>next to the connection name\u00a0<\/strong>(in this case \u201cSG_Sheet1\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update<\/strong>.<\/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\u00a0on the SAVE CHANGES<\/strong>\u00a0button.<\/p>\n

If you want to learn how to automatically import filtered data in Google Sheets, check out the following blog post<\/a>.<\/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=”44987″ global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” 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=”{}”]<\/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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

In the early days of computing, the spreadsheets programs when initially brought to the scene were revolutionary. To the extent that, even today they continue to be an integral part of our work life. Like everything else, they have evolved into much more powerful, robust and advanced applications. And in the current information age, they […]<\/p>\n","protected":false},"author":40,"featured_media":5527,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In the early days of computing, the spreadsheets programs when initially brought to the scene were revolutionary. To the extent that, even today they continue to be integral part of our work life. Like everything else, they have evolved into much more powerful, robust and advanced applications. And in the current information age, they are made even more user friendly, in the sense that they can be accessed from any where and any device. Google Sheets has been the on the forefront of this innovation. Yet, not all 'good-to-have' things are part of it. For instance, from a a given spreadsheet, we cannot yet export data with conditions in Google Sheets.\n

Why export data with conditions in Google Sheets?<\/h3>\nBryan working as a data analyst at a major retail company that has outlets across the country. All the employees use Google Sheets for their spreadsheet needs. His job involves analyzing sales data, identify trends, skim the customer spending patterns and establish the likelihood of their upcoming purchases. Once he has the list ready, he will need to filter out those customers with high probability of future purchases, and send it to Kirk, from the customer services relations (CRM) team. Kirk would then reach out to each of those customers with attractive deals and offers, and persuade them to visit the store. Because those are the ones who can be easily moved with a simple marketing stimulus as opposed to the ones who are not planning to buy anytime soon.\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\nNeedless to say, the list of less probable customers is not of much use, and it's better not to include them in the list.\u00a0So, what can Bryan do? Every time he has a new list, he can filter it\u00a0to retain only the high probable prospects and accordingly shares that filtered list to Kirk. It might look easy. But, what if\u00a0there are a considerable number of\u00a0categories and CRM representatives to deal with (let\u2019s say about 50)? And, if he has to do that every day with the new list? Imagine the effort that Bryan has to put in to get out all the necessary information to the concerned parties. Not very easy! He would rather have this automated than manually deal with it every single day.\n

Solution: Automatically export the data with Sheetgo<\/h3>\nThere isn't a native functionality available using which we can export data with conditions in Google Sheets. Therefore, we will need the help of the Sheetgo add-on, to accomplish this automation setup. This\u00a0add-on highly boosts the connectivity of Google Sheets. With Sheetgo we\u00a0can import, export, merge, stack or mirror data. It can automatically manage all the heavy-lifting that Bryan had to manually do (explained above). We can get it by clicking the button below:\n\n[panel][ccj id=\"Install Widget\"][\/panel]\n

Configuration: Steps to automatically export data with conditions in Google Sheets<\/h3>\nFor the purposes of demonstration, we will export data from \"Customer Analysis<\/strong>\" file that Bryan uses, to \"Sales Prospects<\/strong>\" file which Kirk will work on. For this to happen seamlessly, it is a pre-requisite that Kirk grant Bryan necessary edit access control to the file \"Sales Prospects<\/strong>\".\n

1. Start\u00a0Sheetgo and initiate an export link connection<\/h4>\nNow that we have Sheetgo installed on our Google Sheets application, we now\u00a0open the \u201cCustomer Analysis<\/strong>\u201d file. To start the add-on, we navigate to\u00a0Add-ons > Sheetgo > Start<\/strong>.\n
\n
\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\n<\/div>\n<\/div>\nDoing so will open the Sheetgo interface on the screen as a sidebar, as shown in the image below. Hover the mouse pointer over the green circle with a plus, and click on the Export option.\n

2. Link source sheet with the destination file that we need to send the data to<\/h4>\nClicking the \u2018Connect<\/strong>\u2019 option leads us to the list of most recently updated files by default. If we don\u2019t see the file we want, we can use the search module to lookup a file within the Google Drive. For this demonstration, we select \u201cSales Prospects<\/strong>\u201d file for \u2018Destination spreadsheet\u2019, and then for \u2018source sheet\u2019 choose \u201cSheet1<\/strong>\u201d.\n
\n
\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\n<\/div>\n<\/div>\nWe then arrive at the settings screen. Here we can select the frequency of updates in the \u201cAutomatic update\u201d section. We leave it to the default option,\u00a0\u2018Daily\u2019, because Bryan updates the list every day. Also, in the future, if Bryan doesn\u2019t need the automatic updates any more, he can turn them off in this section.\n

3. Add a filter condition for selective data export, and create a connection<\/h4>\nScroll down on the sidebar to reach \u201cFilter by<\/strong>\u201d section. It shows \u201cNo active filter\u201d by default. Click on \u2018edit<\/strong>\u2019. The probability related field is on column F on the Customer Analysis<\/strong> file (please see the first snapshot). Bryan needs to send the list of all customers with probability greater than or equal to 0.6. Therefore we ensure it is \u201cColumn F: Probablity of next visit<\/strong><\/em>\u201d in the first drop-down, 'Number greater than or equal to<\/strong><\/em>' in the second. The value in the text field will be, 0.6<\/strong><\/em>. Then we click on \u201cOK\u201d.\n\nThe\u00a0\u201cFilter by<\/strong>\u201d section now shows \u201cColumn F number greater than or equal to 0.6<\/strong><\/em>\u201d. Finally, to establish the link that can\u00a0automatically export filtered data, we click \u201cCONNECT<\/strong>\u201d button.\n
\n
\n\n[panel type=\"default\"] Example<\/strong> \"Export[\/panel]\n\n<\/div>\n<\/div>\nOnce we do that, we will notice that in a few seconds Sheetgo creates a new connection whose status shows \u201cLast update: Just now\u201d. Awesome! We just did export data with conditions in Google Sheets! Here's the snapshot of the file \"Sales Prospects<\/strong>\".\n
\n
\n\n[panel type=\"default\"] Example \"Export[\/panel]\n\n<\/div>\n<\/div>\nWe see that the data has appropriately flown in where all the probability values are greater than or equal to 0.6.\n

Automatic updates<\/h3>\nThe data export keeps happening automatically and periodically\u00a0once the appropriate connection is in place. Please note that we can change the frequency with which these data exports happen or even turn off the automatic updates altogether. Shown below is how we navigate to the corresponding settings pane.\n\nConnection name\u00a0<\/strong>(in this case \u201cSG_Sheet1\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update > 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-3898","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\/pt\/wp-json\/wp\/v2\/posts\/3898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=3898"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3898\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/5527"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=3898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=3898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=3898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}