In this article:

How to Use Autocrat With Google Sheets (2024 Guide)

May 8, 2024

What Is Autocrat in Google Sheets?

Autocrat is a powerful Google Sheets add-on that automates the creation of documents and reports by merging data from Google Sheets into Google Docs or Google Slides templates. It's particularly useful for generating personalized documents in bulk, such as certificates, invoices, or customized letters. 

Key Features of Autocrat

Below, we outline 5 key features of Autocrat:

Automated Document Merging: Autocrat merges data from Google Sheets into Google Docs or Slides templates, creating personalized documents automatically​​.

Dynamic Template Markers: It utilizes placeholders within templates to dynamically insert data from Sheets, ensuring customized document content​​.

Multiple Output Formats: Offers the flexibility to generate documents in formats like Google Docs, PDFs, and Google Slides​​.

Automated Sharing and Emailing: Autocrat can automatically share generated documents via Google Drive and email them as attachments​​.

Scheduled Merges and Trigger-Based Automation: Enables automated workflows through scheduled merges or triggers, like form submissions, for hands-off document creation​.

How to Use Autocrat with Google Sheets

Below, we outline the steps on how to use Autocrat with Google Sheets:

Step 1: Install Autocrat

Go to your Google Sheets. Navigate to Extensions > Add-ons > Get add-ons.

autocrat google sheets

Search for "Autocrat" and click "Install". Grant the necessary permissions.

how to use autocrat with google sheets
what is autocrat in google sheets

Step 2: Launch Autocrat

Back in Google Sheets, go to Extensions > Autocrat > Open. Autocrat no longer uses a sidebar; instead, a dialog box guides you through the merge process​.

google sheets autocrat

Step 3: Create and Configure Your Merge Job

Click "New Job" and give your merge job a name. 

autocrat for google sheets
how to use autocrat for google sheets

Select your template from Google Docs or Slides.

autocrat google sheets guide

Map the data from your Google Sheets to the placeholders in your template.

Specify output document naming convention and choose a Google Drive folder for saving the documents.

You can also set up conditional merging rules and email sharing settings.

Optionally, set triggers for automating the merge process based on form submissions or at set time intervals​.

We hope that this article has helped you and given you a better understanding of how to use Autocrat with Google Sheets. If you enjoyed this article, you might also like our articles on how to do a chi square test in Google Sheets and how to set up a grade calculator in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->