Angus owns an exquisite condominium close to the college campus. With the brand new semester across the nook, he desires to create brochures to draw college students as tenants.
However right here’s the problem: the college has college students from everywhere in the world who communicate totally different languages. Angus must create brochures that talk to everybody—from college students from Japan to these from France, and in all places in between.
Whereas he may create PDF brochures in a number of languages manually, that course of can be each time-consuming and error-prone. This information explains how one can automate all of it with the assistance of Google Sheets, Google Slides and the Document Studio add-on.
Right here’s a sample PDF brochure in a number of languages generated utilizing this method.
Step 1: Create Google Slides Template
We’ll use Google Slides to create a brochure template just like the one under.
The markers like {{ Title }} or {{ Line 1 }} are placeholders that can be changed with the translated textual content from the Google Sheet. The {{ Embed QRCODE }} is a particular marker that can be changed with a QR code picture that on scanning will take the person to the condominium’s location on Google Maps.
Step 2: Add information to Google Sheet
Subsequent, we’ll create a Google Sheet the place every row represents a distinct language model of your brochure. The primary column comprises the language code (like fr for French or es for Spanish), whereas the remaining columns maintain the translated content material that can populate your Slides template.
We’re utilizing the built-in GOOGLETRANSLATE operate to mechanically translate the textual content from English to the opposite languages. Thus, once you edit the textual content within the supply language row, the opposite rows can be mechanically up to date with the translated textual content.
=GOOGLETRANSLATE(B$2,$A$2,$A3)
Step 3: Configure Doc Studio Workflow
Now that we have now the Google Slides template and the Google Sheet with the information, we are able to use Doc Studio to generate the PDF brochures in a number of languages.
Contained in the Google Sheet, go to the Extensions menu and launch Document Studio.
Give your workflow a reputation, choose the Google Sheet that comprises your translated language pairs. From the duties panel, choose the Append process – it will add the slides for every language one after one other right into a single presentation, making it good for printing.
If you need to generate separate PDF information for every language, use the
Create Fileprocess however we’ll go together with Append as that can make it simpler to ship the PDF to the printer.
Subsequent, choose the Google Slides template that we created within the earlier step. Run the workflow and also you’ll have a brand new file in your Google Drive containing the multilingual brochure.
With only a single Google Slides template and a Google Sheet, Doc Studio makes it straightforward to generate multilingual brochures at scale. Whether or not you’re constructing actual property flyers, faculty notices, or advertising supplies to focus on worldwide viewers, this method dramatically reduces translation effort and eliminates guide formatting – letting you ship correct, print-ready paperwork in minutes.
