当前位置:首页 > 未分类 > 正文内容

How to Create Personalized Images in Bulk with Google Sheets

ceacer3周前 (05-02)未分类6869

Yesterday marked Friendship Day, and to celebrate, I sent a personalized image to each of my friends via WhatsApp. The images were created in bulk, but each graphic had the person’s name, making the greetings unique and heartfelt.

To achieve this, I did employ some automation. First, I gathered the names of my friends in a Google Sheet. Then, I designed a graphic template in Canva and imported the design in Google Slides. The template had a placeholder - {{Friend's Name}} - that would be replaced with actual values from the Google Sheet.

The Source Template

Here’s the source data and the image template. The placeholder {{Friend's Name}} in a graphic was replaced with actual values from the Google Sheet.

Customer data and image template

The Generated Graphic

And here is the completed deck in Google Slides, where each slide is generated from individual rows of the Google Sheet. You may notice that the names are distinct on every slide for personalization.

The best part is that the customization options aren’t just limited to text - you can also add unique QR Codes, profile pictures and more for more personalization.

Personalized Graphic Designs

How to Auto-Generate Images in Bulk

For those interested in creating personalized images, it’s a simple process.

Start by creating a template with a single slide in Google Slides, adjusting the deck size to match your desired output image size. Then, populate a Google Sheet with the personalization data. Each row of the sheet will generate a unique image.

Install the Document Studio add-on and follow the getting started guide to create a new workflow. For this particular task, I selected the Append (Combine) task, as it allowed me to generate a combined deck containing all the personalized images.

Append Google Slides

  1. Next, select the Google Slides template from your Google Drive that contains your base design. Document Studio will automatically create a new deck to house your auto-generated designs but you can also pick an existing deck from the target presentation field.

Google Slides Template

  1. Save your workflow and choose the Run option to generate your personalized images. Document Studio will automatically generate images for each row of the spreadsheet, but you also have the option to select rows for which the images should be generated.

Create Images from Spreadsheet

Click the Run workflow button, and your personalized images will be ready in no time.

The possibilities are endless. You may use Document Studio to create quiz certificates, business cards, employee IDs, wedding place cards and other designs that necessitate only minimal text changes.

Give Document Studio a try and surprise your friends and family with personalized images for any occasion!

相关文章

How to Email Google Sheets Automatically on a Recurring Schedule

How to Email Google Sheets Automatically on a Recurring Schedule

The Email Spreadsheets add-on for Google Sheets can save office workers a ton of time by automating...

Convert Google Docs and Google Sheets with Apps Script

You can easily convert any Google Spreadsheet or Google Document in your Google Drive to other forma...

How to Generate Dynamic QR Codes to Collect Payments through UPI

How to Generate Dynamic QR Codes to Collect Payments through UPI

The BHIM UPI payment system has transformed the way we pay for goods and services in India. You scan...

How to Extract URLs from HYPERLINK Function in Google Sheets

The HYPERLINK formula of Google Sheets lets you insert hyperlinks into your spreadsheets. The functi...

How to Use Hyperlinks in Google Sheets

How to Use Hyperlinks in Google Sheets

This guide explains how you can easily create and manage hyperlinks in Google Sheets. An entire cell...

How to Create Dynamic Open Graph Images with Google Sheets

How to Create Dynamic Open Graph Images with Google Sheets

An open graph image (OG image) is the image that is displayed when any of your website links are sha...