How to Create Personalized Images in Bulk with Google Sheets

-

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 - - 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 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!



source:https://ift.tt/ti7eHp2

Comments

Post a Comment

Popular posts from this blog

The 101 Most Useful Websites

-
Image
Presenting the 101 most useful websites on the internet. These sites, well most of them, solve at least one problem really well and they all have simple web addresses (URLs) that you can memorize thus saving you a trip to Google. The Most Useful Websites and Web Apps ctrlq.org/screenshots  – for capturing  screenshots of web pages  on mobile and desktops. dictation.io  – online voice recognition in the browser itself. zerodollarmovies.com  – find full-length movies on YouTube. screenr.com  – record movies of your desktop and send them straight to YouTube. goo.gl  – shorten long URLs and convert URLs into  QR codes . unfurlr.come  – find the original URL that’s hiding behind a short URL. qClock  – find the local time of a city using a  Google Map . copypastecharacter.com  – copy special characters that aren’t on your keyboard. postpost.com  – a better search engine for twitter. lovelycharts.com  – c...
Read more

Compare MacBook Prices Worldwide with Google Sheets

-
Image
Looking to buy the new Macbook Pro with M3 chips? Wondering if it would be cheaper to purchase a Macbook in your local Apple store, or ask a friend who is travelling from Singapore or Japan to bring one for you? Here’s a Google Sheet that can help you compare prices of MacBooks in different countries. It takes the current prices of MacBooks from Apple online stores in different countries and converts them to a common currency (US Dollars). The exchange rates are fetched directly from Google Finance so the prices will update automatically when the exchange rates change. How the Macbook Price Comparison Sheet Works I have written a Node.js script that fetches the current prices of MacBooks from the Apple website and writes them to Google Sheets. Here’s the code that scrapes the Apple website and parses the HTML to extract the prices. Get Macbook Prices from Apple Website Apple uses JSON-LD to embed structured pricing data in their web pages that can be easily parsed using che...
Read more

Interesting Websites to Visit When You’re Bored

-
The 15 Interesting Websites Dear Photograph  – The website features photographs of people holding up old pictures that were taken at the exact spot several years ago. Some of the best photographs are now compiled in a  book  (dearphotograph.me). Textastrophe  – This website is a reminder of why you shouldn’t post your cell phone number on public websites. The creator starts a text conversation with random numbers found on Craigslist ads and publishes the transcript on the internet. The chats are funny and I hope its real because  screenshots can be faked  too (textastrophe.com). Stratocam  – This is like an online self-running slideshow showcasing some of the best satellite images found on Google Maps. Run the website in full-screen mode (Ctrl+Shift+F) and you may discover pretty and unexpected place on our beautiful earth (stratocam.com). Awkward Family Photos  – This is a place where people share embarrassing pictures of their loved ones i...
Read more