The #1 App for document automation
Design your certificate in Google Slides, connect a roster in Google Sheets, add column tags with Portant Data Merge, and automatically generate every certificate in one run.
No credit card required · Setup in minutes
·
900,000+ Installs
·
4.8 stars ★★★★★
Trusted by teams at
You can make certificates using Google Slides in a few easy steps. It is simple to place images, dates, awards and names into your certificates. After you have installed Portant Data Merge, you open the add-on in your Google Slides certificate file, then connect a spreadsheet, after that you add column tags, and then click ‘Create’, and voila!, you have just made a batch of certificates!
With Portant’s easy-to-use automation tools that work with Google Workspace, you can create batches of certificates in minutes, no coding experience needed!
With Portant you can connect a spreadsheet to a template, click a few buttons and certificates will be magically generated. You can automatically share them via email or export them as PDFs. Just select the options you require and place your certificates on autopilot.
01
Select the Google Slides certificate template
02
Connect a file that holds the data for each certificate
03
Add tags into the template and select your settings
04
Create certificates for each row in your spreadsheet
Step 1
Open your certificate design in Google Slides, then launch Portant Data Merge from the Extensions menu after you have installed it from Google Workspace Marketplace.
Install Portant Data Merge*Only works on desktops
Step 2
Connect the Google Sheet that stores one row per certificate. Portant links each column to your template so names, dates and awards stay in sync.
Step 3
Insert merge tags into your Slides template, choose outputs such as PDF or email, and fine tune options before you create documents.
.gif)
Step 4
Click Create to generate a certificate for every row. Files are saved in Google Drive and can be emailed automatically based on your settings.
Give people the recognition they deserve without manually creating each certificate, saving you the time and effort of copy and pasting. Whether you are awarding employees for their loyalty or certifying the completion of your online training course, automate your certificates that they will remember.
There is nothing more embarrassing than a typo in a certificate. With Portant, all data is sourced from the original spreadsheet. This means you will not have to worry about mistakes from copying and pasting or manual data entry. Plus, your formatting is guaranteed to be consistent on all your certificates.
Make certificates with the tools you already use: Google Docs, Sheets, Slides and Forms. Portant is integrated into Google Workspace, so it is available on the platforms you are comfortable with. Portant will help to turbo charge your certificate workflows so you can hit all your goals.
Yes. Open your certificate template in Google Slides, connect a Google Sheet with your recipient data, add column tags using Portant Data Merge, and click Create. Portant automatically generates a personalised certificate for every row in your spreadsheet, ready to share or print.
Yes. You have full control of the template design using Google Slides editing tools. If you need different images per certificate, for example by award type, Portant handles that too. Simply insert a merge tag as an image in your template.
Yes. Before clicking Create, check the ‘save copy as PDF’ option. Portant automatically exports each certificate as both a Google Slides file and a PDF saved to your chosen Drive folder. PDF export is a paid feature that requires Portant Pro.
Yes. In Data Merge Settings, select Combine mode to merge every row from your spreadsheet into a single file. This is ideal when you need to print or present all your certificates as one document, saving time on formatting.
Yes. You can save certificates to any Google Drive folder your account can access. Update the destination in your document output settings before clicking Create. All generated files, including PDFs, will be stored in your chosen location.
Yes. Enable the ‘Automatically email created docs’ option in the Share via Email settings. Portant sends each certificate from your personal email address, so recipients see it coming directly from you. You can customise the subject line and message body too.
Yes. Portant connects Google Forms to a Docs template and automatically generates a personalised document for every response. You can also export as PDF and share via email. See our step-by-step guide: Google Forms to Docs.
You can do a lot more than make certificates with Portant. Portant is a fully fledged online document automation solution that can optimise many different document flows. You can use our online document automation platform to optimise your repetitive work, so you can get back to doing the work you enjoy.
Most popular templates
Transform your work life with responsive, fully customisable, and easy-to-use templates.
Select a Google Doc agreement template, add an eSignature placeholder and put your contract signing on auto-pilot.
Try it now
Select a Google Sheet of invoice data, add a Google Docs invoice template, and generate 10, 100 or even 1000's of invoices at a time.
Try it now
Select a Google Form, add tags to a Google Doc template, and generate Docs every time you receive a Google Form response.
Try it now
Every time a Google Form is submitted an incident report PDF is automatically generated and shared via email.
Try it now
Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.
Try it now
Systemise your contracts so they are consistent and accurate. Perfect for sales and legal operations.
Try it now