{"id":7234,"date":"2017-11-24T14:39:56","date_gmt":"2017-11-24T13:39:56","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7234"},"modified":"2017-11-24T14:39:56","modified_gmt":"2017-11-24T13:39:56","slug":"partager-temporairement-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/temporarily-share-google-sheets\/","title":{"rendered":"Comment partager temporairement vos fichiers Google Sheets ?"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”54px|0px|2px|0px|false|false” 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=”{}”]

With\u00a0<\/span>Google Sheets<\/a>, we know we can easily share the spreadsheets with people. And they can effortlessly access and work on them from any device or location. It is noteworthy to see that the Google Sheets\u2019\u00a0Share<\/strong>\u00a0<\/span>functionality, by default, lets people access the files indefinitely. Unless we manually remove the access permissions to the file for any particular user(s).\u00a0In this article, we explain the procedure to allow a maximum time that someone can access our Google Sheets files. Simply put, we can set expiry date to the access we grant to other people.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]

Why allow maximum time that someone can access our Google Sheets?<\/h3>\n

Consider this scenario. A research company hired a contractor and granted him access to certain files he needs to work upon. But even after the contract ended, the contractor will have access to these files. That isn\u2019t an ideal position to be in, given the confidentiality of the information. To avoid that, we will have to explicitly remove the permissions.\u00a0That isn\u2019t a desirable situation because keeping track of such things can become cumbersome and at times unrealistic.<\/p>\n

Or, alternatively, we can simply allow maximum time that someone can access our Google Sheets. After this predefined time, they won\u2019t be able to see these files on their Google Drive. To configure this, we either click on the\u00a0<\/span>Share<\/strong>\u00a0<\/span>button available on the Google Sheets application. Or, on the Google Drive, on the corresponding file,\u00a0<\/span>right click > Share<\/strong>.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/post1-1.webp” alt=”Share Button on the Google Sheets Application” title_text=”share-button” align=”center” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]

Add the emails of the user(s) in the\u00a0<\/span>People<\/strong>\u00a0<\/span>field and click on the\u00a0<\/span>Advanced<\/strong>\u00a0<\/span>option. This will open up the\u00a0<\/span>Share settings<\/strong>\u00a0<\/span>window.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/post2.webp” alt=”Maximum Time That Someone Can Access Our Google Sheets: Advanced Setting Window” title_text=”advanced-settings” align=”center” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]

Now click on the\u00a0<\/span>Send<\/strong>\u00a0<\/span>button to invite them to access the file. Having done that, the user(s) we just invited to access the file will appear in the list of all users in the\u00a0<\/span>Share settings<\/strong>\u00a0<\/span>window pane. On hovering the mouse over to the user(s) we just added, and it will show a corresponding gray colored\u00a0clock<\/strong>\u00a0<\/span>icon.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/post3.webp” alt=”Maximum Time That Someone Can Access Our Google Sheets: Editing Option” title_text=”edit-option” align=”center” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]

We click on this clock icon, and it will let us set the expiration time. From the drop-down list, we can use the existing options or even a custom expiration date. Once done, click on the\u00a0<\/span>Save changes<\/strong>\u00a0<\/span>button. Doing this will ensure the users won\u2019t have the access to the file beyond the time we set for expiry.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/post4.webp” alt=”Maximum Time That Someone Can Access Our Google Sheets: Example Snapshot Showing Number of Days” title_text=”maximum-time-to-access-google-sheets” align=”center” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]

Find out more about the different\u00a0<\/span>Google Sheets permission levels\u00a0in the following\u00a0<\/span>blog post<\/a>.<\/span><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

With\u00a0Google Sheets, we know we can easily share the spreadsheets with people. And they can effortlessly access and work on them from any device or location. It is noteworthy to see that the Google Sheets\u2019\u00a0Share\u00a0functionality, by default, lets people access the files indefinitely. Unless we manually remove the access permissions to the file for any […]<\/p>\n","protected":false},"author":40,"featured_media":7235,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"With Google Sheets application, we know we can easily share the spreadsheets with people. And they can effortlessly access and work on them from any device or location. It is noteworthy to see that the Google Sheets'\u00a0Share<\/strong> functionality, by default, lets people access the files indefinitely. Unless we manually remove the access permissions to the file for any particular user(s).\u00a0In this article, we explain the procedure to allot maximum time that someone can access our Google Sheets files. Simply put, we can set expiry date to the access we grant to other people.\n

Why allot maximum time that someone can access our Google Sheets?<\/h3>\nConsider this scenario. A research company hired a contractor and granted him access to certain files he needs to work upon. But even after the contract ended, the contractor will have access to these files. That isn't an ideal position to be in, given the confidentiality of the information. To avoid that, we will have to explicitly remove the permissions.\u00a0That isn't a desirable situation because keeping track of such things can become cumbersome and at times unrealistic.\n\nOr, alternatively, we can simply allot maximum time that someone can access our Google Sheets. After this predefined time, they won't be able to see these files on their Google Drive. To configure this, we either click on the Share<\/strong> button available on the Google Sheets application. Or, on the Google Drive, on the corresponding file, right click > Share<\/strong>.\n\nExample<\/strong>\n\n\"\"\n\n \n\nAdd the emails of the user(s) in the People<\/strong> field and click on the Advanced<\/strong> option. This will open up the Share settings<\/strong> window.\n\nExample<\/strong>\n\n\"\"\n\n \n\nNow click on the Send<\/strong> button to invite them to access the file. Having done that, the user(s) we just invited to access the file will appear in the list of all users in the Share settings<\/strong> window pane. On hovering the mouse over to the user(s) we just added, and it will show a corresponding gray colored\u00a0clock<\/strong> icon.\n\nExample<\/strong>\n\n\"\"\n\n \n\nWe click on this clock icon, and it will let us set the expiration time. From the drop-down list, we can use the existing options or even a custom expiration date. Once done, click on the Save changes<\/strong> button. Doing this will ensure the users won't have the access to the file beyond the time we set for expiry.\n\nExample<\/strong>\n\n\"\"\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7234","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=7234"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/7234\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/7235"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=7234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=7234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=7234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}