• Autocrat - Google Sheets Add-On

    What is it?

    • Autocrat is an Add-On in Google Sheets that lets you merge the spreadsheet data with a Google Doc, Sheet, or Slide.
    • Create a Google Form to gather information from a group of people (students, teachers, parents, etc.), then run Autocrat in the Google Sheet of results that merges the fields into a Google docs/slides template you created.
    • Set it up so the Google Doc/Slide is automatically emailed to the participant when they complete the form. (Or run it manually)

    Examples

    • Your students/teachers complete a Google Form when they've finished a project/training.
    • Upon submitting the Form, they receive an email with a certificate of completion to acknowledge their accomplishment.
    • It's all automated using the Autocrat you applied to the Google Sheet of form responses!
    • Great for administrators to use for teacher walkthrough feedback, too!

    How do I get it?

    Install the Autocrat add-on from the Google Workspace Marketplace

    How does it work?

    Step 1: Create your Google Form*

    *not necessary if you're running the Autocrat from spreadsheet data that you already have

    Step 2: Create your template letter/certificate in Google Docs/Slides

    Step 3: Set up Autocrat in the Form's Google Sheet of responses

    User Guide

    Autocrat User Guide

    Video Instructions

  • Sheet Share add-on

    • Share individual sheets/tabs easily.
    • Allow two-way editing and keep data synchronized.
    • Google sheets only allows sharing the whole spreadsheet. If you want to share a single sheet, you either use "publish to web" or "import range" as workarounds. These have limitations. Sheet Share can help!

    How do I get it?

    Install the Sheet Share add-on from the Google Workspace Marketplace