In this article:

How to Use Autocrat Add-on (2025 Guide)

April 18, 2025

What Is Autocrat?

Autocrat is a powerful add-on that automates the creation of documents and reports by merging data from a spreadsheet into document or presentation 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 a spreadsheet into document or presentation templates, creating personalized documents automatically.

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

Multiple Output Formats: Offers the flexibility to generate documents in formats like text documents, PDFs, and presentations.

Automated Sharing and Emailing: Autocrat can automatically share generated documents through cloud storage and send them as email 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

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

Step 1: Install Autocrat

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

autocrat add on

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

how to use autocrat
what is autocrat

Step 2: Launch Autocrat

In your spreadsheet, go to Extensions > Autocrat > Open. Autocrat no longer uses a sidebar; instead, a dialog box guides you through the merge process​.

using autocrat

Step 3: Create and Configure Your Merge Job

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

autocrat guide
how to use autocrat add on

Select your template.

autocrat tutorial

Map the data from your spreadsheet to the placeholders in your template.

Specify output document naming convention and choose a cloud storage 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​.

Related Articles

How to Get the Word Count in Google Sheets (Best Method 2025)
How to Format Phone Number in Google Sheets

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages