{"id":9740,"date":"2021-10-19T15:50:00","date_gmt":"2021-10-19T13:50:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9740"},"modified":"2021-10-19T15:50:00","modified_gmt":"2021-10-19T13:50:00","slug":"como-usar-o-complemento-do-autocrat-para-o-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/education-processes\/how-to-use-autocrat-add-on-for-google-sheets\/","title":{"rendered":"Como usar o complemento AutoCrat para o Google Sheets"},"content":{"rendered":"

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

AutoCrat is another add-on for Google Sheets that is changing the face of education. At first glance, it might not seem like that interesting of a tool, but its many applications make this a super valuable add-on! AutoCrat is another neat invention of CloudLab, one of the leading innovators in the add-ons for Education developer space. AutoCrat is an add-on that allows you to merge information from your spreadsheets into other formats, like documents or PDFs. It has a simple user interface that makes formatting, storing, and sharing information a breeze.<\/p>\n

Who is using Autocrat?<\/h3>\n

Anyone who uses Google Sheets has access to AutoCrat. It is a free merge tool that is available in the add-ons store. Although AutoCrat was designed for teachers and administrators, just about anyone can use it to automate processes. It is also loved by students, researchers, and businesses.<\/p>\n

What can you do with AutoCrat?<\/h3>\n

With AutoCrat, you can take information stored in spreadsheets and easily convert it into a Google Docs, PDF, or even a slideshow!<\/p>\n

It sounds simple, but many people are taking this tool and using it to enhance their workflows so they can free up time for more important tasks.<\/p>\n

How can you access AutoCrat?<\/h3>\n

It is really simple to get add-ons for Sheets. The fastest way is to click this link to install the Autocrat add-on<\/a> from the Google Workspace Marketplace.<\/p>\n

Simply click the Install<\/b> button and the add-on will be added to your Google Sheets account.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Autocrat-add-on.png” alt=”Autocrat add-on” title_text=”Autocrat add-on” align=”center” _builder_version=”4.10.7″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

Alternatively, you can get the add-on by following these steps:<\/p>\n

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

    \n
  1. Open a spreadsheet.<\/li>\n
  2. Click the Add-ons<\/b> button in the navigation menu.<\/li>\n
  3. Click the Get add-ons<\/b> button.<\/li>\n
  4. A window will pop up for you to browse.<\/li>\n
  5. Type ‘Autocrat’ in the search box.<\/li>\n
  6. Click the Install<\/b> button to get the add-on.<\/li>\n<\/ol>\n

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

    You are ready to start using AutoCrat!<\/p>\n

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

    Get started<\/h3>\n

    First, click Add-ons \u2192 AutoCrat \u2192 Open<\/strong>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-2.png” alt=”autocrat 2″ title_text=”autocrat 2″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]AutoCrat will load, and prompt you to create your first merge job! There is no sidebar in AutoCrat anymore, they got rid of it and swapped it for a dialogue box that takes you step-by-step through the process of each merge.<\/p>\n

    Step 1:<\/h4>\n

    Click New Job,<\/b> then you will be prompted to give your first merge job a name!<\/p>\n

    After naming the job, click Next<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-3-1.png” alt=”autocrat 3″ title_text=”autocrat 3″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 2:<\/h4>\n

    In this step, you will need to choose a template for your merge. Today we will choose to have AutoCrat create an example template for us. When you create your own templates, you can save them to and select them from your drive.<\/p>\n

    In the past, AutoCrat only worked with Google Docs, but now it also integrates with Google Slides. This is really exciting for users who want to create custom presentations from within spreadsheets.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-4-2.png” alt=”autocrat 4″ title_text=”autocrat 4″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 3:<\/h4>\n

    In this step, you need to map the source data from the spreadsheet to its correct place in the template. You can choose from standard text, hyperlinks, or images.<\/p>\n

    You will need to create a corresponding tag for each area of the Doc or Slide you want the information to be populated into.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-5.png” alt=”autocrat 5″ title_text=”autocrat 5″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 4:<\/h4>\n

    Next, give a file name for the output document that the add-on will create.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-6.png” alt=”autocrat 6″ title_text=”autocrat 6″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 5:<\/h4>\n

    Select a folder in your Google Drive that the document will be inserted into.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-7.png” alt=”autocrat 7″ title_text=”autocrat 7″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 6:<\/h4>\n

    (Optional)\u00a0Choose a folder reference.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-8.png” alt=”autocrat 8″ title_text=”autocrat 8″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 7:<\/h4>\n

    (Optional)\u00a0Set conditional rules for your merge.<\/p>\n

    For example, if you are sending out a letter about grades from a student roster, you may choose to only send out letters to students who are receiving failing grades within the course.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-9.png” alt=”autocrat 9″ title_text=”autocrat 9″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 8:<\/h4>\n

    Next, we will select editing\/commenting and sharing settings for our merge.<\/p>\n

    After that, send out any emails to anyone we may want to share the Doc or Slideshow with.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-10.png” alt=”autocrat 10″ title_text=”autocrat 10″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 9:<\/h4>\n

    For the last step of the merge set-up, we have the option to choose if we want this merge to run based on any specific triggers<\/b> like a form submission or at a designated time interval.<\/p>\n

    Some users can fully automate certain processes using these triggers. For example, you can have students submit essay questions via Google Forms, and their answers will populate into a Google Sheet. Reading these answers within a sheet cell could obviously be quite cumbersome!<\/p>\n

    You can set a trigger so that the students submissions are merged right into a PDF or Doc, that go into a specific class folder. Use automatically generated Docs too for grading, commenting, or even peer review! After specifying triggers,\u00a0press Save<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-11.png” alt=”autocrat 11″ title_text=”autocrat 11″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Step 10:<\/h4>\n

    Finally, click the\u00a0play button<\/b> symbol to start the merging sequence.<\/p>\n

    You will see your Google Sheet change a bit\u2014now there will be a cell with a link to the Doc that was created for this demo.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-12.png” alt=”autocrat 12″ title_text=”autocrat 12″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/autocrat-13-2.png” alt=”autocrat 13″ title_text=”autocrat 13″ _builder_version=”4.10.7″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.10.7″ global_colors_info=”{}”]<\/p>\n

    Conclusion<\/h3>\n

    Ok\u2014that does it! Your first AutoCrat merge has been set up, and will now be displayed as an existing job when you run the add-on.<\/p>\n

    For inspiration and ideas, check out our list of the top 5 Google Sheets add ons for education<\/a>. Alternatively, take a look at the related articles below.[\/et_pb_text][et_pb_text _builder_version=”4.4.8″ background_color=”#f9f9ff” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}”]<\/p>\n

    Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n

    \n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

    AutoCrat is another add-on for Google Sheets that is changing the face of education. At first glance, it might not seem like that interesting of a tool, but its many applications make this a super valuable add-on! AutoCrat is another neat invention of CloudLab, one of the leading innovators in the add-ons for Education developer […]<\/p>\n","protected":false},"author":40,"featured_media":27379,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"

    How To Use The autoCrat Add-on For Google Sheets<\/span><\/h3>\n

    <\/h4>\n

    What is autoCrat?<\/span><\/h4>\nautoCrat<\/span><\/a> is another add-on for Google Sheets that is changing the face of education. At first glance, it might not seem like that interesting of a tool, but it\u2019s many applications make this a super valuable add-on! autoCrat is another neat invention of CloudLab, one of the leading innovators in the add-ons for Education developer space. autoCrat is an add-on that allows you to merge information from your spreadsheets into other formats, like documents or PDFs. It has a simple user interface that makes formatting, storing, and sharing information a breeze.<\/span>\n

    <\/h3>\n

    Who is Using Autocrat?<\/span><\/h4>\nAnyone who uses Google Sheets as access to autoCrat, it is a free merge tool that is available in the add-ons store. Although autoCrat was designed for teachers and administrators, just about anyone can use it to automate processes. It is also loved by students, researchers, and businesses. <\/span>\n

    <\/h3>\n

    What Can You Do With autoCrat<\/span><\/h4>\nWith autoCrat, you can take information stored in spreadsheets and easily convert it into a Google Doc, PDF, or even a slideshow! It sounds simple, but many people are taking this tool and using it to enhance their workflows so they can free up time for more important tasks!<\/span>\n

    How to Access autoCrat<\/span><\/h4>\nIt is really simple to get add-ons for Sheets! The fastest way to get autoCrat is to click this link<\/a> that will take you directly to the web store. <\/span>\n\nSimply click the <\/span>Free<\/b> button and the add-on will be added to your Google Sheets account.<\/span>\n\n\"\"<\/a>\n\nAlternatively, you can get the add-on by following these steps:<\/span>\n\n1. Open a spreadsheet<\/span>\n<\/span>2. Click the add-ons button in the navigation menu<\/span>\n<\/span>3. Click the Get add-ons button<\/span>\n<\/span>4. A window will pop up for you to browse<\/span>\n<\/span>5. Type \u201cautoCrat\u201d in the search box.<\/span>\n<\/span>6. Click the Free button to get the add-on<\/span>\n\nYou are ready to start using autoCrat!\n

    Get Started<\/span><\/h4>\nFirst, click add-ons \u2192 autoCrat \u2192 Open<\/strong><\/span>\n\n\"how\n\nautoCrat will load, and prompt you to create your first merge job! There is no sidebar in autoCrat anymore, they got rid of it and swapped it for a dialogue box that takes you step by step through the process of each merge.<\/span>\n

    <\/h3>\n

    Step 1: <\/span><\/h6>\nClick <\/span>New Job,<\/b> then you will be prompted to give your first merge job a name! After naming the job, click <\/span>Next<\/b>.<\/span>\n

    \"how<\/h3>\n

    Step 2: <\/span><\/h6>\nIn this step, you will need to choose a template for your merge. Today we will choose to have autoCrat create an example template for us. When you create your own templates, you can save them to and select them from your drive. <\/span>\n\nIn the past, autoCrat only worked with Google Docs, but now it also integrates with Google Slides. This is really exciting for users who want to create custom presentations from within spreadsheets.<\/span>\n

    \"how<\/h3>\n

    Step 3: <\/span><\/h6>\nIn this step, you need to \u201cmap<\/em>\u201d the source data from the spreadsheet to its correct place in the template. You can choose from standard text, hyperlinks, or images. You will need to create a corresponding tag for each area of the Doc or Slide you want information to be populated into. <\/span>\n

    <\/h3>\n\"how\n

    <\/h3>\n

    Step 4:<\/span><\/h6>\nNext, give a file name for the output document that the add-on will create.<\/span>\n

    <\/h3>\n\"how\n

    <\/h3>\n

    Step 5: <\/span><\/h6>\nSelect a folder in your Google Drive that the document will be inserted into.<\/span>\n\n\"how\n
    Step 6:<\/h6>\nOptional<\/span><\/i> Choose a folder reference<\/span>\n

    \"how<\/h3>\n

    Step 7:<\/h6>\nOptional <\/span><\/i>Set conditional rules for your merge. For example. If you are sending out a letter about grades from a student roster, you may choose to only send out letters to students who are receiving failing grades within the course.<\/span>\n

    <\/h3>\n

    \"how<\/h3>\n \n

    Step 8: <\/span><\/h6>\nNext, we will select editing\/commenting and sharing settings for our merge, and then send out any emails to anyone we may want to share the Doc or Slideshow with. <\/span>\n

    \"how<\/h3>\n

    Step 9: <\/span><\/h6>\nFor the last step of the merge set-up, we have the option to choose if we want this merge to run based on any specific <\/span>triggers,<\/b> like a form submission or at a designated time interval. Some users can fully automate certain processes using these triggers. For example, you can have students submit essay questions via Google Forms, and their answers will populate into a Google Sheet. Reading these answers within a sheet cell could obviously be quite cumbersome! You can set a trigger so that the students submissions are merged right into a PDF or Doc, that go into a specific class folder. Use automatically generated Docs to for grading, commenting, or even peer review! After specifying triggers <\/span>Press Save<\/b>. <\/span>\n\n\"how\n\nFinal step! Ok\u2014that does it! Your first autoCrat merge has been set up, and will now be displayed as an existing job when you run the add-on. Click the <\/span>play button <\/b>symbol to start the merging sequence. You will see your Google Sheet change a bit\u2014now there will be a cell with a link to the Doc that was created for this demo.<\/span>\n\n\"how\n\n\"how \"how","_et_gb_content_width":"","footnotes":""},"categories":[34],"tags":[35],"class_list":["post-9740","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education-processes","tag-education"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9740","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=9740"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9740\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/27379"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}