We can even share the files with other users with appropriate access controls, taking collaborative efforts to the next level. But not everything within the application is seamless, and certainly, there is a lot of room for improvement.<\/span><\/p>\n While we can use the IMPORTRANGE formula to link Google Sheets data automatically, it is not as advanced and flexible as the solution we are going to try here. Therefore, a great alternative to link data is to follow these step-by-step instructions on how to link Google Sheets.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”why” _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Data exchange between colleagues on a daily basis can get tiring and time-consuming when done manually. Looking for ways to automate this process will help them save more valuable time over time.\u00a0<\/span><\/p>\n Let’s say I have a spreadsheet containing customer survey data and I need to share the data with my team members. However, I don’t want to share the entire spreadsheet because I want to keep my source file private and safe.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/link-google-sheets_1.png” alt=”Link Data Automatically in Google Sheets: Connection Creation Page ” title_text=”link-google-sheets_1″ align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”solution” _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Thanks to Sheetgo, we have a much simpler and automatic alternative that makes information exchange happen without manual intervention. With the Sheetgo web app, you can link Google Sheets files to transfer, merge, filter or split data automatically. If we don\u2019t have it yet, click the button below and create your account.<\/span><\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SING 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” 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.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click <\/span>Create connection<\/b> to start linking your Google Sheets files.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-1.png” alt=”Link Google Sheets 1″ title_text=”Link Google Sheets 1″ _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now select your source. As you can see, Sheetgo enables you to transfer data from a wide range of sources: Google Sheets, Excel, CSV, TSV and BigQuery.<\/span><\/p>\n Select <\/span>Google Sheets<\/b>.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-2.png” alt=”Link Google Sheets 2″ title_text=”Link Google Sheets 2″ _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Then choose the file you want to transfer data from. If you want to connect multiple spreadsheets, you can select more than one Google Sheets file. Here I’ll choose my “Customer Survey Data” file.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-3.png” alt=”Link Google Sheets 3″ title_text=”Link Google Sheets 3″ _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you enable the <\/span>Transfer formatting<\/b> feature, Sheetgo will automatically retain the formatting of your source file. By using this feature, you won’t need to reformat your destination file.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-4.png” alt=”Link Google Sheets 4″ title_text=”Link Google Sheets 4″ _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/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.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can select one of the data processors if you want to filter, merge or split your data. Since I just want to transfer data from a spreadsheet to another, I’ll click <\/span>Skip<\/b>.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-5.png” alt=”Link Google Sheets 5″ title_text=”Link Google Sheets 5″ align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.21.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now it’s time to select a destination. Not only can you transfer your data to another file in a variety of formats (Google Sheets, Excel, CSV or TSV), but you can also generate Google Docs files, PDFs or emails.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-6.png” alt=”Link Google Sheets 6″ title_text=”Link Google Sheets 6″ _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n I’ll select <\/span>Google Sheets<\/b>. Then you can either create a new Google Sheets file for the data to be imported into or add the data to an existing file.<\/span><\/p>\n Here, you can also change the destination of the Root folder (top right-hand side of the pop-up), allowing you to access any of your desired cloud-based storage solutions. Don’t forget to name your Google Sheets file and tab.<\/span><\/p>\n When you click <\/span>Finish and save<\/b>, Sheetgo will automatically transfer the data from your source file to your destination file.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-7.png” alt=”Link Google Sheets 7″ title_text=”Link Google Sheets 7″ _builder_version=”4.21.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/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.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, Sheetgo has created an automated workflow to link these Google Sheets files.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-8.png” alt=”Link Google Sheets 8″ title_text=”Link Google Sheets 8″ align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.21.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n By clicking <\/span>Automate<\/b>, you can create your own automation schedule. You can choose what days to automate your workflow, up to every hour. Once you\u2019ve created your schedule, click <\/span>Save<\/b>.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Link-Google-Sheets-9.png” alt=”Link Google Sheets 9″ title_text=”Link Google Sheets 9″ align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.21.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You have successfully connected your spreadsheets using the Sheetgo add-on.\u00a0<\/span>If you want to connect your Google Sheets to Excel, check out <\/span>this article<\/span><\/a>.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Google Sheets needs no introduction. The Cloud-based spreadsheets application made our work lives so easy. Previously, organizing and sharing the information files was a problem to reckon with. Now we can access Google Sheets from anywhere and on any device. We can even share the files with other users with appropriate access controls, taking collaborative […]<\/p>\n","protected":false},"author":40,"featured_media":41381,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sheets needs no introduction. This Cloud based spreadsheets application made our work lives so easy. Previously, organizing and sharing the information files was a problem to reckon with. But, we can access Google Sheets\u00a0from anywhere and any device. We can even share the files to other users with appropriate access controls, who can then work on them either to use the existing information or add to it. Thereby, taking collaborative efforts to the next level. But not everything within the application is seamless and certainly there is room for further advancements. While we can use the IMPORTRANGE<\/a> formula to link data automatically, it is not as advanced and flexible as the solution we are going to try here.\nWhy should we link Google Sheets spreadsheets?<\/span><\/h2>\n
Solution: Automate the process with Sheetgo<\/span><\/h2>\n
Step 1. Create a connection<\/span><\/h3>\n
Step 2. Select source<\/span><\/h3>\n
Step 3. Select a data processor<\/span><\/h3>\n
Step 4. Select a destination<\/span><\/h3>\n
Step 5. Schedule automatic transfers<\/span><\/h3>\n
Conclusion<\/span><\/h4>\n
Why link data automatically?<\/h3>\nRafael works as a data analyst for in a processed food supply company that uses Google Sheets for their spreadsheet needs. Kirk is a research assistant who reports to Rafael. Rafael's job requires him to analyze the end-customer survey data he receives from Kirk. He then draws insights and shares them with his management. There are two different spreadsheet related tasks in this entire process.\n
\n \t
![\"Link](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/linkdata.png\")
[\/panel]\nSolution: Automate the process with Sheetgo add-on<\/h3>\nThanks to Sheetgo, we fortunately have a much simpler and automatic alternative using which the information exchange happens without manual intervention.\u00a0This\u00a0add-on for Google Sheets highly boosts the connectivity between spreadsheets. With Sheetgo we\u00a0can import, export, merge, stack or mirror data. It can automatically manage all the heavy-lifting that Rafael had to manually do (explained above). If we don't have it yet, we can get it by clicking the button below.\n\n[panel][ccj id=\"Install Widget\"][\/panel]\n
Configuration process<\/h3>\nRafael usually uses a temporary file called Staging<\/strong> to import the data, perform analysis, and once done, uses the same file to export his insights.\n
I. Link data automatically by creating an import connection<\/h4>\nThis is the first leg of the process in which we will link data automatically, where in Rafael imports the survey data from Kirk. Please note that it is a pre-requisite that Kirk grant Rafael necessary read access permissions for this link to work.\n
\n \t
![\"Link](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/linkdata1.png\")
[\/panel]\n\nNow, Rafael will derive the insights as to how each food category is doing in terms of customer satisfaction. Here's the result of his analysis. He will use the Sheet1<\/strong> of Staging file to generate insights for the purposes of convenience, as shown below.\n\n[panel type=\"default'] Staging file after deriving insights<\/b>![\"Link](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/linkdata2.png\")
[\/panel]\nII. Link data automatically by creating an export connection<\/h4>\nThe final step of the process is to export these data insights to his management. On the 'Customer Insights<\/strong>' file, they have granted write access permissions to Rafael for him to be able to setup and export link.\n
\n \t
![\"Link](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/linkdata3.png\")
[\/panel]\n\nAnd below is the snapshot of the Customer Insights file that management will be able to see.\n\n[panel type=\"default\"] Customer Insights file that management sees<\/strong>![\"Link](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/linkdata4.png\")
[\/panel]\n\nCongratulations! We just did link data automatically, both for importing and exporting!\nAutomatic updates<\/h3>\nThe data import and export keeps happening automatically and periodically\u00a0once the appropriate connections are 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 either \u201cSurvey_Data_Import\u201d or \"Insights_Export\")\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-3807","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\/fr\/wp-json\/wp\/v2\/posts\/3807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=3807"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/3807\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/41381"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=3807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=3807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=3807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}