Find out how to Create Customized Photos in Bulk with Google Sheets

Shubham
3 Min Read

Yesterday marked Friendship Day, and to rejoice, I despatched a personalised picture to every of my buddies by way of WhatsApp. The photographs had been created in bulk, however every graphic had the particular person’s identify, making the greetings distinctive and heartfelt.

To attain this, I did make use of some automation. First, I gathered the names of my buddies in a Google Sheet. Then, I designed a graphic template in Canva and imported the design in Google Slides. The template had a placeholder – {{Pal's Identify}} – that may get replaced with precise values from the Google Sheet.

The Supply Template

Right here’s the supply information and the picture template. The placeholder {{Pal's Identify}} in a graphic was changed with precise values from the Google Sheet.

The Generated Graphic

And right here is the finished deck in Google Slides, the place every slide is generated from particular person rows of the Google Sheet. You might discover that the names are distinct on each slide for personalization.

The most effective half is that the customization choices aren’t simply restricted to textual content – it’s also possible to add unique QR Codes, profile pictures and extra for extra personalization.

Personalized Graphic Designs

Find out how to Auto-Generate Photos in Bulk

For these curious about creating customized photos, it’s a easy course of.

Begin by making a template with a single slide in Google Slides, adjusting the deck dimension to match your required output picture dimension. Then, populate a Google Sheet with the personalization information. Every row of the sheet will generate a novel picture.

Set up the Document Studio add-on and comply with the getting started guide to create a brand new workflow. For this specific job, I chosen the Append (Mix) job, because it allowed me to generate a mixed deck containing all of the customized photos.

Append Google Slides

  1. Subsequent, choose the Google Slides template out of your Google Drive that comprises your base design. Doc Studio will robotically create a brand new deck to accommodate your auto-generated designs however it’s also possible to choose an current deck from the goal presentation subject.

Google Slides Template

  1. Save your workflow and select the Run choice to generate your customized photos. Doc Studio will robotically generate photos for every row of the spreadsheet, however you even have the choice to pick out rows for which the pictures needs to be generated.

Create Images from Spreadsheet

Click on the Run workflow button, and your customized photos might be prepared very quickly.

The chances are limitless. You might use Doc Studio to create quiz certificates, business cards, employee IDs, wedding ceremony place playing cards and different designs that necessitate solely minimal textual content modifications.

Give Doc Studio a try to shock your family and friends with customized photos for any event!

Share This Article
Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *