{"id":15307,"date":"2020-10-06T10:42:08","date_gmt":"2020-10-06T08:42:08","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=15307"},"modified":"2025-12-18T00:06:58","modified_gmt":"2025-12-17T23:06:58","slug":"plantilla-de-gestion-de-horas-de-los-empleados-en-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/human-resources-templates\/employee-timesheet-management-template-in-google-sheets\/","title":{"rendered":"Plantilla de hoja de horas de empleado en Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; 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; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; 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 _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Tracking employees&#8217; working hours is essential for HR administration, payroll, calculating overtime and measuring productivity. In many countries, it&#8217;s also a legal requirement.<\/p>\n<p>If you employ freelancers or part-time staff on an hourly basis, you need a simple system for tracking their hours and paying them accordingly.<\/p>\n<p>Even if you manage a full-time workforce, there are many reasons to ask your team to clock in and out. You may want to monitor underperformance or prevent burnout if your staff are being overworked. Unless you are personally present in the office at all times, it can be difficult to get an accurate overview of your team&#8217;s hours. And if they work remotely, a convenient online timesheet system is essential.<\/p>\n<p>It\u2019s possible to purchase specialist time-management software. But for SMEs there\u2019s no need to fork out on anything expensive. You can build your own custom hour-tracking system using an employee timesheet template \u2014 entirely in spreadsheets.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Why use Google Sheets to manage timesheets?<\/h3>\n<ul>\n<li>Flexible: Online spreadsheets are really flexible so they can be used to create a timesheet system that\u2019s tailor-made for your business. You can alter or adapt the files yourself whenever you need changes \u2014 without coding or an IT team.<\/li>\n<li>Accessible: Because Google Sheets is cloud-based, you can monitor your team\u2019s hours from your laptop or mobile from any location. In addition, you\u2019ll save money on unnecessary software by keeping everything in spreadsheets.<\/li>\n<li>Compatible with everything: All other software integrates with Google Sheets. As a result, you can import data from other parts of the business, such as finance, centralizing everything into your Google Sheets.<\/li>\n<li>Simple to use: Most of your team members probably already use spreadsheets, so they will be able to start using a spreadsheet-based timesheet system without any training. As a bonus, the system is future-proof and easy to maintain.<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Sign up for Sheetgo and start tracking <span style=\"background-color: rgba(41,121,255,0.2);\"><span>worked hours<\/span><\/span> automatically<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/employee-timesheet&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; 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_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/10\/employee-timesheet-template-personal-dashboard.png&#8221; alt=&#8221;employee-timesheet-personal dashboard&#8221; title_text=&#8221;employee-timesheet-template-personal-dashboard&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Getting started<\/h3>\n<p>Sheetgo\u2019s Employee timesheet template in Google Sheets is a workflow template. That means it\u2019s a pre-built system for automated timesheet management, for multiple team members.<\/p>\n<p>The template gives each employee a simple and private file in which they can log and monitor their working hours and breaks. At the same time, the manager gets an overview of timesheets for the entire team.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-1.png&#8221; alt=&#8221;employee-timesheets-managers-dashboard&#8221; title_text=&#8221;employee timesheet management \u2013 1&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>What&#8217;s a spreadsheet-based workflow template?<\/h3>\n<p>Whereas a regular spreadsheet template is a single file containing tables, charts, and formulas, a Sheetgo workflow template is an entire system.<\/p>\n<p>It\u2019s a group of connected Google Sheets that send data back and forth between them. This enables users to share data with others without having to share their own personal spreadsheets.<\/p>\n<p>A spreadsheet-based workflow template gives you:<\/p>\n<ul>\n<li>Organization and data privacy: Each spreadsheet is dedicated to one task which keeps data flows secure and separated.<\/li>\n<li>Scalability: Google Sheets\u2019 sharing function is powerful but when you have a lot of people working in the same spreadsheet, the file can become large and slow. Keeping data in individual files helps ensure that the system works smoothly. Every time you need to add another timesheet, you can simply copy one of the spreadsheets and share it with the additional colleague.<\/li>\n<li>Integration: As well as being able to import data from different software, a spreadsheet-based workflow allows HR managers to merge data from departments. In a couple of clicks, you can connect your employee timesheet workflow with your accounting workflow (or those from other departments) to create reports for directors.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-2.png&#8221; alt=&#8221;employee-timesheet-all-timesheet-reports&#8221; title_text=&#8221;employee timesheet management \u2013 2&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>What you get with this template:<\/h3>\n<p>When you install the <a href=\"https:\/\/www.sheetgo.com\/templates\/human-resources\/employee-timesheet-management-template\/\" target=\"_blank\" rel=\"noopener\">Sheetgo Employee timesheet template<\/a>, three Google Sheets files with pre-built Sheetgo connections are saved to your Google Drive:<\/p>\n<p>Two <strong>Employee<\/strong> spreadsheets in a folder. Rename and share these files with team members and make as many copies as you need for additional employees. Each employee uses their personal file to record the hours they work.<\/p>\n<p>One <strong>Employee Timesheet Management<\/strong> master sheet for the HR manager. Data flows into this file from the Employee spreadsheets, providing a summary of everyone\u2019s working hours and automated dashboard charts.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/04\/Employee-timeshee-management-full-1.png&#8221; align=&#8221;center&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to get the workflow template<\/h3>\n<p>Click on the blue button below to install the Sheetgo Employee Timesheet workflow template<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/employee-timesheet&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|30px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ol>\n<li>Login to Sheetgo with your Google, Microsoft, or Dropbox account.<\/li>\n<li>Click <strong>Install template<\/strong>.<\/li>\n<li>Wait a few moments while Sheetgo creates copies of the files and connects them.<\/li>\n<\/ol>\n<p>The Employee Timesheet management master sheet opens inside Sheetgo.<\/p>\n<p>In the <strong>workflow<\/strong> diagram in the side panel on the right of the screen, you will see arrows running from the folder of Employee spreadsheets into the master sheet. These are the Sheetgo connections that transport data from file to file.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-3.png&#8221; alt=&#8221;employee-timesheet-template-opens&#8221; title_text=&#8221;employee timesheet management \u2013 3&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use the Employee Timesheet template<\/h3>\n<h4>Step 1: Delete the sample data<\/h4>\n<p>You\u2019ll notice that the <strong>Employee<\/strong> files contain sample data in the <strong>Timesheet<\/strong> tab \u2014 this is just to show you how the whole template works. You can delete this information or ask your colleagues to do it themselves before they start using the spreadsheet.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 2: Share the spreadsheets with your colleagues<\/h4>\n<p>From inside Sheetgo, open one of the <strong>Employee<\/strong> spreadsheets then click <strong>Share<\/strong> in the top-right hand corner of the screen.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-4.png&#8221; alt=&#8221;employee-timesheet-template-open-in-new&#8221; title_text=&#8221;employee timesheet management \u2013 4&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now rename the spreadsheet and share it with the appropriate colleague using the green <strong>Share<\/strong> button in Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 3: Employees start clocking their hours<\/h4>\n<p>Once they have been allocated a personal spreadsheet, each employee should start to register their working hours in the <strong>Timesheet<\/strong> tab.<\/p>\n<p>There\u2019s no need for them to enter anything in the gray <strong>Column F (Hours Worked)<\/strong> as the template calculates this automatically.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-5.png&#8221; alt=&#8221;employee-timesheet-template-enter-employee-data&#8221; title_text=&#8221;employee timesheet management \u2013 5&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 4: Transfer the data<\/h4>\n<p>When all your team members have started recording their hours you need to pull that data into your master sheet by updating the workflow.<\/p>\n<p>The template contains pre-built Sheetgo connections, so you can do this in one click.<\/p>\n<p>Click on <strong>Workflow<\/strong> to open the sidebar and then click <strong>Run<\/strong>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-6.png&#8221; alt=&#8221;employee-timesheet-run-workflow&#8221; title_text=&#8221;employee timesheet management \u2013 6&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start tracking <span style=\"background-color: rgba(41,121,255,0.2);\"><span>worked hours<\/span><\/span> automatically<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/employee-timesheet&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; 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 _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 5: Automate your timesheet workflow<\/h4>\n<p>If you\u2019re managing a large team and dealing with multiple timesheets, you can schedule the workflow to run automatically so you\u2019ve always got the latest timesheet data from every employee.<\/p>\n<p>Click on <strong>Workflow<\/strong> and then select <strong>Automate<\/strong> from the menu bar.<\/p>\n<p>Choose how often you want automatic transfers: from once an hour to once a month.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/10\/employee-timesheet-template-automate.png&#8221; alt=&#8221;employee-timesheet-template-automate&#8221; title_text=&#8221;employee-timesheet-template-automate&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>How to add more Employee sheets<\/h4>\n<p>You can add more <strong>Employee<\/strong> spreadsheets to the workflow by duplicating one of the input sheets and connecting it with new Sheetgo connections.<\/p>\n<p>1. Go to your Google Drive and open the folder <strong>Sheetgo Templates <\/strong>&gt;<strong> Employee Timesheet management<\/strong>.<\/p>\n<p>2. Right-click on one of the Employee Files and click <strong>Make a Copy<\/strong>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/10\/employee-timesheet-template-copy-input-sheet.png&#8221; alt=&#8221;employee-timesheet-template-copy-employee-sheet&#8221; title_text=&#8221;employee-timesheet-template-copy-input-sheet&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]3. Inside Sheetgo, open the Employee Timesheet management workflow and click <strong>Connection<\/strong>s on the sidebar on the right of the screen.<\/p>\n<p>4.Next to the connection <strong>All Timesheet Reports<\/strong> click on the 3-dots menu (\u22ee) and select <strong>Edit<\/strong>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-7.png&#8221; alt=&#8221;employee-timesheet-template-edit-connection&#8221; title_text=&#8221;employee timesheet management \u2013 7&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Under <strong>Source data<\/strong>: <strong>Multiple files<\/strong>, you will see the two <strong>Employee<\/strong> files that are currently connected.<\/p>\n<p>5. Click <strong>+Add another source file<\/strong><br \/>6. Click <strong>+Select file<\/strong>, locate the new employee file inside Google Drive, and click <strong>Done<\/strong>.<br \/>7. The file appears in Sheetgo. Now select the correct file tab: <strong>Timesheet.<\/strong><br \/>8. Click <strong>Finish and save<\/strong>.<\/p>\n<p>If you take a look at the <strong>Workflow<\/strong>, you will see that the new file is now connected.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/employee-timesheet-management-\u2013-8.png&#8221; alt=&#8221;employee-timesheet-template-workflow-three-files&#8221; title_text=&#8221;employee timesheet management \u2013 8&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#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; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>For more guidance on expanding the template, check out the <a href=\"https:\/\/community.sheetgo.com\/d\/530-how-to-use-the-employee-timesheet-management-template\" target=\"_blank\" rel=\"noopener\">instructions here<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#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.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Start tracking <span style=\"background-color: rgba(41,121,255,0.2);\"><span>worked hours<\/span><\/span> automatically<\/h3>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/employee-timesheet&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tracking employees&#8217; working hours is essential for HR administration, payroll, calculating overtime and measuring productivity. In many countries, it&#8217;s also a legal requirement. If you employ freelancers or part-time staff on an hourly basis, you need a simple system for tracking their hours and paying them accordingly. Even if you manage a full-time workforce, there [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":27429,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[42],"tags":[44],"class_list":["post-15307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-human-resources-templates","tag-human-resources"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/15307","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\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=15307"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/15307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/27429"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=15307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=15307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=15307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}