{"id":9204,"date":"2021-09-21T17:12:00","date_gmt":"2021-09-21T15:12:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9204"},"modified":"2021-09-21T17:12:00","modified_gmt":"2021-09-21T15:12:00","slug":"complementos-do-google-sheets-recursos-humanos","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/human-resources-processes\/google-sheets-add-ons-human-resources\/","title":{"rendered":"Os 5 principais add-ons do Google Sheets para Recursos Humanos"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;54px|0px|0|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Human Resources departments have a lot of tasks to manage. Whether you are a small team or a large business, the same kinds of tasks still need to be completed. HR departments plan, coordinate and execute the administrative aspect of employee management. This means managing employee salary, payment, benefits, training, performance, and accomplishments. It can also include managing conflicts between employees or teams. Human resources professionals are also responsible for recruiting, hiring, and training new employees. That\u2019s a lot of work!<\/p>\n<p>Maintaining files, employee information, and salary\/benefits data is a lot of work. Hopefully, by now, your office has gone paperless and you are utilizing online tools to make your job easier. The G Suite is one of the most powerful tools that human resources professionals are using to manage companies. Google Sheets on its own is a tool most of us couldn&#8217;t live without. However, add-ons for human resources are changing the way we work and the way we work with others. From tracking employee information to setting up advanced training for new hires, these add-ons have you covered.<\/p>\n<p>It is time to check out some of these Google add-ons and see how they can transform your workflow.<\/p>\n<h2>How to access Google Add-ons:<\/h2>\n<p>It is really simple to get add-ons for Sheets. The easiest way is to click the links below.\u00a0This will take you to the Google Workspace Marketplace.\u00a0 Just click the <b>Install<\/b>button, and the add-on will be added to your Sheets account. Alternatively, you can get the add-on by following these steps:<\/p>\n<ol>\n<li>Open a spreadsheet<\/li>\n<li>Click the <strong>Add-ons<\/strong> button in the navigation menu<\/li>\n<li>Click the <strong>Get add-ons<\/strong> button<\/li>\n<li>A window will pop up for you to browse<\/li>\n<li>Click on any add-on to get more details about it<\/li>\n<li>Click the <b>Install<\/b>\u00a0button to get an Add-on<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Best add-ons for Human Resources<\/h3>\n<h4>1. Sheetgo<\/h4>\n<p>Not to toot our own horn, but <a href=\"https:\/\/www.sheetgo.com\/\" target=\"_blank\" rel=\"noopener\">Sheetgo<\/a> is loved by HR departments. Sheetgo users know there are a lot of different ways to boost their spreadsheets with the add-on. Consolidate, filter, append, and distribute data.<\/p>\n<p>Employees can track hours or expenses on a single sheet, and you can consolidate them all into one master sheet and dashboard.<\/p>\n<p>Alternatively, take a look at Sheetgo&#8217;s ready-to-use HR templates: <a href=\"https:\/\/app.sheetgo.com\/templates\/okrs\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">OKR tracking<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"https:\/\/app.sheetgo.com\/templates\/employee-timesheet\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Employee timesheet<\/span><\/a><span style=\"font-weight: 400;\"> and <\/span><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1NsV8_ivClH028HO0U2Jm0xutrENXlgEwyuTBHtb2WYY\/copy\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Holiday tracking.<\/span><\/a><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Sheetgo-1.png&#8221; alt=&#8221;best add-ons for human resources Sheetgo&#8221; title_text=&#8221;Sheetgo 1&#8243; url=&#8221;https:\/\/app.sheetgo.com\/explore\/templates&#8221; url_new_window=&#8221;on&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>2. Employee Onboarding App<\/h3>\n<p>This <a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/employee_onboarding_app\/55865453655\" target=\"_blank\" rel=\"noopener noreferrer\">Employee Onboarding App<\/a> can help you accomplish two things: streamline your onboarding process and save time.<\/p>\n<p>You can use it to hire interns or employees, or even onboard new clients. It automates welcome or offer letters, IT setup, and training information. For example, you can send a candidate an offer letter and then set them up with email, contacts, a calendar, etc.<\/p>\n<p>Have a streamlined process to speed up onboarding while making sure you don\u2019t miss any important steps. It is super easy to set up \u2014 it takes about two minutes, only requires basic Google Sheets knowledge, and integrates seamlessly with Google Workspace.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/Employee-onboarding-app-1.png&#8221; alt=&#8221;best add-ons for human resources Employee onboarding app&#8221; title_text=&#8221;Employee onboarding app 1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>3. TimeOwl<\/h3>\n<p><a href=\"https:\/\/workspace.google.com\/marketplace\/app\/timeowl_google_sheets_plugin\/636264256064\" target=\"_blank\" rel=\"noopener noreferrer\">TimeOwl<\/a> is a whole new approach to how we track our time! This great add-on for human resources uses Google Calendar as a time recording tool. It sounds complicated, but it is super easy to set-up, track time, and manage.<\/p>\n<p>This add-on would be great for both in-house employees and remote teams. Remote teams often have to meet at various times throughout the day depending on time zones. And this add-on can help employees successfully track all of their time. Users can create a separate Google calendar for work, and use this add-on to create reports that they can easily share with the HR department.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Time-Owl.png&#8221; alt=&#8221;best add-ons for human resources TimeSheet&#8221; title_text=&#8221;Time Owl&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>4. AppSheet<\/h3>\n<p>The <a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/appsheet\/376242260902\" target=\"_blank\" rel=\"noopener noreferrer\">AppSheet<\/a> add-on is a dream come true. Now, anyone can create an app just using a spreadsheet. It sounds a bit intimidating at first, but it is designed for people who don\u2019t know how to code.<\/p>\n<p>So what does a Human Resources department need an app for? There are so many possibilities! You can create a contact list, a checklist, or a calendar for your company. You could also create an app that allows employees to review company rules, benefits, etc. If you really wanted to be creative, you could even create training modules!<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/AppSheet-1.png&#8221; alt=&#8221;best add-ons for human resources AppSheet&#8221; title_text=&#8221;AppSheet 1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>5. Linkedin Prospector<\/h3>\n<p>The <a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/linkedin_prospector_linkedin_marketing_t\/1075983527499\" target=\"_blank\" rel=\"noopener noreferrer\">Linkedin Prospector<\/a> add-on allows you to search Linkedin profiles in bulk. This is another great way to begin to automate and speed up processes. Recruiting good employees can take a lot of time and energy if you are manually searching the web for candidates.<\/p>\n<p>Use this tool to find profiles in bulk, and automatically put them into a convenient spreadsheet.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/LinkedIn-Prospector-1.png&#8221; alt=&#8221;best add-ons for human resources Linkedin Prospector&#8221; title_text=&#8221;LinkedIn Prospector 1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h3>Top add-ons for Human Resources<\/h3>\n<p>This was our selection of some of the best Google Sheets add-ons for Human Resources. Use them to automate your manual work going from tracking employee working hours, updating contract information, to hiring new employees.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.22.2&#8243; background_color=&#8221;#f9f9ff&#8221; custom_margin=&#8221;40px||40px||false|false&#8221; custom_padding=&#8221;15px|25px|15px|25px|true|true&#8221; border_width_left=&#8221;3px&#8221; border_color_left=&#8221;#808e95&#8243; global_module=&#8221;26540&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><em><strong>Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Human Resources departments have a lot of tasks to manage. Whether you are a small team or a large business, the same kinds of tasks still need to be completed. HR departments plan, coordinate and execute the administrative aspect of employee management. This means managing employee salary, payment, benefits, training, performance, and accomplishments. It can [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":44270,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"<span style=\"font-weight: 400;\">Human Resources departments have a lot of tasks to manage. Whether you are a small team or a large business, the same kinds of tasks still need to be completed. HR departments plan, coordinate and execute the administrative aspect of employee management. This means managing employee salary, payment, benefits, training, performance, and accomplishments. It can also include managing conflicts between employees or teams. Human resources professionals are also responsible for recruiting, hiring, and training new employees. That\u2019s a lot of work!<\/span>\n\n<span style=\"font-weight: 400;\">Maintaining files, employee information, and salary\/benefits data is a lot of work. Hopefully, by now, your office has gone paperless and you are utilizing online tools to make your job easier. The G Suite is one of the most powerful tools that human resources professionals are using to manage companies. Google Sheets on its own is a tool most of us couldn't live without. However, add-ons for human resources are changing the way we work and the way we work with others. From tracking employee information to setting up advanced training for new hires, these add-ons have you covered.<\/span>\n<h6><span style=\"font-weight: 400;\">It is time to check out some of these Google add-ons and see how they can transform your workflow.<\/span><\/h6>\n<h3><span style=\"font-weight: 400;\">How to Access Google Add-ons:<\/span><\/h3>\n<span style=\"font-weight: 400;\">It is really simple to get add-ons for Sheets. The easiest way is to click on the link for the add-on, this will take you to the Google web store, \u00a0just click the <\/span><b>Free <\/b><span style=\"font-weight: 400;\">button, and the add-on will be added to your Sheets account. Alternatively, you can get the add-on by following these steps:<\/span>\n<ol>\n \t<li style=\"list-style-type: none\">\n<ol>\n \t<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Open a spreadsheet<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n \t<li style=\"list-style-type: none\">\n<ol>\n \t<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click the Add-ons button in the navigation menu<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n \t<li style=\"list-style-type: none\">\n<ol>\n \t<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click the Get add-ons button<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n \t<li style=\"list-style-type: none\">\n<ol>\n \t<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A window will pop up for you to browse<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n \t<li style=\"list-style-type: none\">\n<ol>\n \t<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on any add-on to get more details about it<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n \t<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click the Free button to get an Add-on<\/span><\/li>\n<\/ol>\n<h3><span style=\"font-weight: 400;\">Best Add-ons for Human Resources<\/span><\/h3>\n<h3><span style=\"font-weight: 400;\">Employee Onboarding App<\/span><\/h3>\n<span style=\"font-weight: 400;\">This employee onboarding app can help you accomplish two things: <strong>streamline your onboarding process and save time<\/strong>. You can use it to hire interns or employees, or even onboard new clients. It automates welcome or offer letters, IT setup, and training information. For example, you can send a candidate an offer letter and then set them up with email, contacts, a calendar, etc. Have a streamlined process to speed up onboarding while making sure you don\u2019t miss any important steps. It is super easy to set up <\/span><span style=\"font-weight: 400;\">\u2014 it takes about two minutes, only requires basic Google Sheets knowledge, and integrates seamlessly with Gsuite.<\/span>\n<h3><a href=\"https:\/\/chrome.google.com\/webstore\/detail\/timesheet\/nebngbhpfeiihkkpkgfignmdfikfpclb?hl=en\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">TimeSheet <\/span><\/a><\/h3>\n<span style=\"font-weight: 400;\">Timesheet is a whole new approach to how we track our time! This great add-on for human resources uses Google Calendar as a time recording tool. It sounds complicated, but it is super easy to set-up, track time, and manage. This add-on would be great for both in-house employees and remote teams. Remote teams often have to meet at various times throughout the day depending on time zones, this add-on can help employees successfully track all of their time. Users can create a separate Google calendar for work, and use this add-on to create reports that they can easily share with the HR department.<\/span>\n<h3><a href=\"https:\/\/chrome.google.com\/webstore\/detail\/appsheet\/apemmfgpjhplakdihblplkjbakedfehh\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">AppSheet<\/span><\/a><\/h3>\n<span style=\"font-weight: 400;\">This add-on is a dream come true. Now, anyone can create an app just using a spreadsheet. It sounds a bit intimidating at first, but it is designed for people who don\u2019t know how to code. So what does a human resources department need an app for? There are so many possibilities! You can create a contact list, a checklist, or a calendar for your company. You could also create an app that allows employees to review company rules, benefits, etc. If you really wanted to be creative, you could even create training modules!<\/span>\n<h3><a href=\"https:\/\/chrome.google.com\/webstore\/detail\/linkedin-profiles-search\/ohjocjfapdhbekkbiegfhdionaihcgbo\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Linkedin Profiles Search<\/span><\/a><\/h3>\n<span style=\"font-weight: 400;\">This add-on allows you to search Linkedin profiles in bulk. This is another great way to begin to automate and speed up processes. Recruiting good employees can take a lot of time and energy if you are manually searching the web for candidates. Use this tool to find profiles in bulk, and automatically put them into a convenient spreadsheet.<\/span>\n<h3><a href=\"https:\/\/app.sheetgo.com\/login\"><span style=\"font-weight: 400;\">Sheetgo<\/span><\/a><\/h3>\n<span style=\"font-weight: 400;\">Not to toot our own horn, but Sheetgo is loved by human resources departments. Sheetgo users know there are a lot of different ways to boost their spreadsheets with our add-on. Consolidate, filter, append, and distribute data. If you are just getting started with Sheetgo, you may be trying to figure out how it can help automate your processes. One way I recommend is creating peer-to-peer spreadsheet sharing to reduce the amount of email and attachments you need to send each month. Employees can track hours or expenses on a single sheet, and you can consolidate them all into one workbook. If you use Sheetgo in your HR department, let us know how it has improved the way you work! We\u2019d love to add it to our wall of happiness.<\/span>","_et_gb_content_width":"","footnotes":""},"categories":[41],"tags":[44],"class_list":["post-9204","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-human-resources-processes","tag-human-resources"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9204","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=9204"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/44270"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}