Using Autocrat to create personalized birthday cards

At the beginning of every school year, I usually spend hours writing out birthday cards for all of my students (close to 100). Today I tried the Google Sheets Add-on Autocrat for the first time to create personalized cards in minutes. Example:


Here are the instructions to do this:
(Click here to see the instructions in a Google doc.)

1. Install Chrome Sheets Add-on Autocrat.

2. Create a Google spreadsheet with student names, Class, birthdates, and age. Make sure to put headings on your columns. NOTE: If you don’t have this data, collect it from the students with a Google form which will give you a spreadsheet. NOTE 2: Very interestingly, the dates entered in French as below work fine in the merge, but in English, you can only enter numbers, as in "M/d/yyyy", "MMMM d, yyyy".

Screen Shot 2014-08-29 at 11.42.11 PM.png

3. Create a template for your card in a Google Doc. (You might want to use a Google drawing first to insert an image and add a greeting like I did. Click here to see it. Then do a screenshot of it (or File > Download as > JPEG image) then insert into a Google doc.) 

Add merge tags below the image in your Google doc template like this:
Screen Shot 2014-08-29 at 11.02.55 PM.png

(Click here for the original.) When you create the merge tags, use the fonts you want for the card. 

Templates for foldable cards:






NOTE: Autocrat will not work in a Google Drawing: only in a Google doc. 

4. Return to your spreadsheet and click on Add-ons > autoCrat > Launch:

Screen Shot 2014-08-29 at 11.52.39 PM.png
5. Click on
Screen Shot 2014-08-29 at 11.54.05 PM.png

6. Click on
Screen Shot 2014-08-29 at 11.55.10 PM.png

7. Check off the template, then click “Select” at the bottom:
Screen Shot 2014-08-29 at 11.59.48 PM.png
Screen Shot 2014-08-29 at 11.59.57 PM.png

8. Name the merge job, then click “set”:
Screen Shot 2014-08-30 at 12.01.51 AM.png

9. Next window, click “Save”:
Screen Shot 2014-08-30 at 12.04.23 AM.png

10. Next window, under “File naming convention to use", type "Carte"

11. Click
Screen Shot 2014-08-30 at 12.04.23 AM.png

12. Next window, click
Screen Shot 2014-08-30 at 12.08.40 AM.png

13. If your list is long, it may take a couple of minutes to work. You will see the green bar advancing:
Screen Shot 2014-08-30 at 12.19.37 AM.png

14. When it is done, you will see a link to the Google Doc birthday card for each of your students in your spreadsheet:
Screen Shot 2014-08-30 at 12.14.45 AM.png

VOILA! Simply amazing!!!

Note: For quick printing, create a folder ahead of time to hold the documents to be printed. Call it "Cards to be printed". You might want to make sub-folders if you have more than one class. When you are setting up the merge (#10 above), click on "Advanced settings", then "Add folder". Scroll to the folder you created (it should be the first folder that comes up if you just made it).

Click on the folder, then, "Select". Then go back up to #11.

Once your merge is finished, open the folder with the merged documents. Select all the documents (press Shift button and click on first document, then click on last document). Right click, then "Download". A zip folder will be created. Drag it onto your desktop from your downloads. Open the zip folder to show the documents. Highlight them all, then right click, open with Preview (for pdf documents). Now click "File", then "Print".

15. Click here to learn how you can use Autocrat to email feedback immediately to students.




73 comments:

  1. What a wonderful and stunning card! The details are awesome. This could make a wonderful and awesome birthday greetings. Totally love your creation!

    ReplyDelete
    Replies
    1. Etools For Language Teachers: Using Autocrat To Create Personalized Birthday Cards >>>>> Download Now

      >>>>> Download Full

      Etools For Language Teachers: Using Autocrat To Create Personalized Birthday Cards >>>>> Download LINK

      >>>>> Download Now

      Etools For Language Teachers: Using Autocrat To Create Personalized Birthday Cards >>>>> Download Full

      >>>>> Download LINK 0y

      Delete
  2. Wow thanks for sharing informatiob, i love your creation have a beautiful birthday wishes to

    ReplyDelete
  3. Its been true with some positive aspects and values and we would indeed feel more reliable with some other piece of evidence, and it will prove some definite ideas to our own.

    ReplyDelete
  4. Professionals have yet to pick up on using a .tel domain to manage their online image and identity. The only reason must be a lack of knowledge. Never has anything so powerful and cheap been ignored by the business community.http://www.mordocrosswords.com/2016/06/tel-number-add-on.html

    ReplyDelete
  5. Custom Greeting Cards Printing - Spread some love with custom greeting cards from Print247365.com. Our premium greeting cards and custom greeting are made with your own pictures and greetings, so you can be intimate at especial occasions.

    ReplyDelete
  6. Sharing happy moments in any occasion in today's digital world is very easy and Birthday Wishes fill the life with joy and blessings.

    ReplyDelete
  7. Học kế toán ở đâu tốt nhất Tại cầu giấy
    Học kế toán ở đâu tốt nhất Tại từ liêm
    Học kế toán ở đâu tốt nhất Tại thanh xuân
    Học kế toán ở đâu tốt nhất Tại hà đông
    Học kế toán ở đâu tốt nhất Tại long biên
    Học kế toán ở đâu tốt nhất Tại nguyễn chính thanh đống đa
    Học kế toán ở đâu tốt nhất Tại minh khai hai bà trưng
    Học kế toán ở đâu tốt nhất Tại bắc ninh
    Học kế toán ở đâu tốt nhất Tại hải phòng
    Học kế toán ở đâu tốt nhất Tại tphcm
    Học kế toán ở đâu tốt nhất Tại quận 3
    Học kế toán ở đâu tốt nhất Tại thủ đức
    Học kế toán ở đâu tốt nhất Tại đà nẵng
    Học kế toán ở đâu tốt nhất Tại biên hòa
    Học kế toán ở đâu tốt nhất Tại đồng nai
    Học kế toán ở đâu tốt nhất Tại nam định
    Học kế toán ở đâu tốt nhất Tại thái bình
    Học kế toán ở đâu tốt nhất Tại bắc giang
    Học kế toán ở đâu tốt nhất Tại vĩnh phúc
    Học kế toán ở đâu tốt nhất Tại thái nguyên
    Học kế toán ở đâu tốt nhất Tại quảng ninh
    Học kế toán ở đâu tốt nhất Tại hải dương
    Học kế toán ở đâu tốt nhất Tại hưng yên
    Học kế toán ở đâu tốt nhất Tại hà nam
    Học kế toán ở đâu tốt nhất Tại ninh bình
    Học kế toán ở đâu tốt nhất Tại nghệ an
    Học kế toán ở đâu tốt nhất Tại vũng tàu

    ReplyDelete
  8. It is really a helpful blog to find some different source to add my knowledge. I came into aware of new professional blog and I am impressed with suggestions of author. custom made greeting cards

    ReplyDelete
  9. Please delete the comment because it has a link to my website.

    ReplyDelete
  10. Please delete the comment because it has a link to my website.

    ReplyDelete
  11. Thank you for the great article I did enjoyed reading it, I will be sure to bookmark your blog and definitely will come back from again. I want to encourage that you continue your great job, have a good day.
    Letasoft Sound Booster Crack

    ReplyDelete
  12. The creativity level is ten by ten. Your article is one of the best article ever for me. Its just fun to read your article. Your work is awesome. Also, I send it to my friends. Thank you very much for this content.OmniPlan Pro Crack

    ReplyDelete
  13. I'm really impressed with your writing skills, as smart as the structure of your weblog.
    Is this a paid topic or do you change it yourself?
    However, stopping by with great quality writing, it's hard to see any good blog today.


    ableton live crack
    wondershare safeeraser crack
    crackdown pc key crack
    zoner photo studio x crack
    magix vegas movie studio 15 crack

    ReplyDelete
  14. I liked your blog ... very beautiful colors and themes. Did you create this page?
    Did you hire someone or did you hire someone to do that?
    Please reply that I would like to design my own blog
    I want to know where he got this from. Thank you very much

    encryptomatic maildex crack
    wifispoof crack mac

    ReplyDelete
  15. Push Video Wallpaper License KeyYour commitment to your work is causing lead us to progress! thanks is particularly true in that it’s a picture of your live video tutorial. In which you also manage video wallpaper and make it in an amazing design.

    ReplyDelete
  16. Movavi crack
    is a video editing tool that gives you all the options you need to create professional final cuts for all your videos. This program allows you to save files in a variety of formats, including files that are generally not provided by other publishers and are compatible with mobile devices such as tablets and smartphones. You have the option of burning the file directly to the CD.

    ReplyDelete
  17. All In One Toolbox crack
    is a powerful Android toolbox to optimize and maximize the performance of Android devices, you can manage all your work and monitor Internet. All in one toolbox pro APK add-on gives you features such as viewing system, clearing cache, browser history, viewing complete phone information, managing startup applications, installing and removing apps, games and tools. The all-in-one toolbox supports live world languages and offers better phone management.



    ReplyDelete
  18. optimum! I want to do an internship while editing the website, how can I subscribe?
    For blog sites? This account helped me close a deal.
    I am a little familiar with your post, it provides a clear and bright concept.
    cyberlink powerdirector
    windows 7 loader with activator 2020
    avira antivirus pro crack
    google earth pro crack

    ReplyDelete
  19. My partner and I stumbled over here by a different website and thought I might as well check things out. I like what I see so i am just following you. Look forward to finding out about your web page again.|
    advanced-driver-updater

    ReplyDelete
  20. bandicam-crack-product-keyinstals the most recent update to help you adjust to a specific environment within your workplace.
    wondershare-filmora-crack

    ReplyDelete
  21. bandicam-crack-product-keyCapture something on your PC as quality video is Bandicam a lightweight screen recorder programme for Windows. The app can also record a region on a PC screen or catch a game that utilises the graphics technology of DirectX/OpenGL/Vulkan.

    wondershare-filmora-crack

    ReplyDelete
  22. Ohsoft Ocam Crack is an incredible video recording program that can record video to be played on the screen by means of your PC.

    ReplyDelete
  23. Hi there it’s me, I am also visiting this web page on a regular
    basis, this web site is actually good and the users are truly
    sharing fastidious thoughts.
    wondershare editor pro crack
    aaa logo
    anydvd hd crack
    crafting and building apk

    ReplyDelete
  24. I'm not much of an internet reader to be honest,
    but your blogs are really nice, go ahead! I will continue to bookmark your site to get back on track.
    All the best
    avira antivirus pro crack
    movavi video converter crack
    buildbox crack

    ReplyDelete

  25. Hi! This is my first visit to your blog! We are a collection of volunteers and Your blog provided us with valuable information to work on. You have done an outstanding job!
    anydesk-crack/
    pixellu-smartalbums-crack/
    proshow-producer-crack/
    avg-pc-tuneup-crack/
    pdf-combine-crack/
    all-in-one-toolbox-pro-apk-crack/
    nch-debut-video-capture-pro-crack/

    ReplyDelete
  26. Great blog! Is your theme custom made or did you download it from somewhere?
    A design like yours with a few simple tweeks would really make my blog stand out.
    Please let me know where you got your design. Bless you

    ReplyDelete
  27. Hello! One of my Facebook groups shared this site with us.
    I also came to him. I really like this information. I am creating a book and sending it to my fans via Twitter!

    bandizip enterprise crack ,

    ReplyDelete
  28. Wonderful website you have here but I was curious if you knew of any discussion boards
    that cover the same topics discussed in this article?
    I’d really love to be a part of community where I can get responses from other experienced individuals that share the same interest.
    daemon tools ultra crack
    driver booster pro crack
    norton internet security 2019 crack

    ReplyDelete
  29. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
    Very interesting blog.

    CCleaner Professional Key Crack

    ReplyDelete
  30. I don't think I'll be returning to my former participation level; at least not soon. I'm juggling a lot of responsibilities at the moment,

    AntiBrowserSpy Pro Crack

    AMIDuOS Pro Crack

    Express VPN Crack

    TeamViewer Crack

    Wondershare Mobile Trans Crack

    ReplyDelete

  31. You are in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!

    CleanMyMac X Crack

    ReplyDelete
  32. You are in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!

    Windows 10 Activator Final Crack

    ReplyDelete
  33. Very good article! We will be linking to this particularly great post on our website. Keep up the good writing.
    fullcrackedpc.com
    vsthomes.com
    azharpc.org
    SAM Broadcaster PRO Crack
    Total Commander Crack
    Master PDF Editor Crack

    ReplyDelete
  34. You are in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!

    Mirillis Action Crack

    ReplyDelete
  35. You are in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!

    Mirillis Action Crack

    ReplyDelete
  36. http://www.tiebow-tie.com/2015/07/near-dock.html?showComment=1608795027337#c7154135066485463493

    ReplyDelete

  37. After looking through a few blog articles on your website,
    we sincerely appreciate the way you blogged.
    We've added it to our list of bookmarked web pages and will be checking back in the near
    future. Please also visit my website and tell us what you think.
    WinRAR Crack
    Lightworks Pro crack
    Nero Platinum Crack
    WinTool.net Premium Crack

    ReplyDelete
  38. vst crack is a very simple application thanks to which you'll be able to settle certain doubts that you may have about your future, because you will be able to ask a virtual wizard about any matter that may worry you regarding several issues, like work, health or money.








    ReplyDelete
  39. You Can Aldo Download Free Software & Mac
    https://tijacrack.com/tc-games-crack/

    ReplyDelete
  40. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. Getcrack.co I hope to have many more entries or so from you.
    Very interesting blog.
    Panda Antivirus pro Crack
    Hitman Pro Crack
    FlyVPN Crack

    ReplyDelete
  41. Is this a paid topic or do you change it yourself?
    However, stopping by with great quality writing, it's hard to see any good blog today.

    ReplyDelete
  42. I am very impressed with your post because this post is very beneficial for me and provide a new knowledge
    manycam-pro-crack
    tenorshare-4mekey-crack
    efofex-fx-draw-tools-crack

    ReplyDelete

  43. THIS ARTICALE IS HELPING ME. VERY USEFULL INFORMATION.THANKS ADMIN
    FCPX Auto Tracker Crack is an impressive video editor for Mac that enables users to edit videos in the most entertaining and professional ways.
    IPadian Premium Crack is not an emulator but a simulator. You can feel and see the differences between iOS and Android.
    VMware Workstation Pro Crack and BSD virtual machines on your Windows or Linux desktop using VMware Workstation Pro, the most popular desktop hypervisor.

    ReplyDelete
  44. Really Good Work Done By You...However, stopping by with great quality writing, it's hard to see any good blog today.
    ProcrackerPC
    DVDFab Passkey CRACK

    ReplyDelete
  45. Pretty great post. I simply stumbled upon your blog and wanted to mention that I have really loved surfing around your blog posts. Great set of tips from the master himself. Excellent ideas. Thanks for Awesome tips Keep it
    any-video-converter-ultimate-crack
    ntlite-crack
    imazing-crack
    tenorshare-icarefone-crack
    k7-total-security-crack

    ReplyDelete
  46. Really Good Work Done By You...However, stopping by with great quality writing, it's hard to see any good blog today.
    ProcrackerPC
    cracksoftwarefreedownload.com
    Anni Crack
    Wondershare Recoverit CRACK

    ReplyDelete

  47. Wow, amazing block structure! How long
    Have you written a blog before? Working on a blog seems easy.
    The overview of your website is pretty good, not to mention what it does.
    Edraw Max Crack
    Pinnacle Studio Crack

    ReplyDelete

  48. I am very happy to read this article. Thanks for giving us Amazing info. Fantastic post.
    Thanks For Sharing such an informative article, Im taking your feed also, Thanks.slimware-driverupdate-crack/

    ReplyDelete

  49. http://ilmijobs91209.articlesblogger.com/30255382/the-smart-trick-of-ilmijobs-that-no-one-is-discussing
    http://ilmijobs13468.arwebo.com/30204509/the-single-best-strategy-to-use-for-ilmijobs
    http://ilmijobs91346.bloggin-ads.com/30372562/the-greatest-guide-to-ilmijobs
    http://ilmijobs25912.blogpostie.com/30303838/the-single-best-strategy-to-use-for-ilmijobs
    http://ilmijobs45699.blogprodesign.com/30088267/the-best-side-of-ilmijobs
    http://ilmijobs21897.blogdigy.com/top-latest-five-ilmijobs-urban-news-21772107

    ReplyDelete
  50. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
    Very interesting blog.
    exposure-x6-bundle-crack/

    ReplyDelete
  51. I am very happy to read this article. Thanks for giving us Amazing info. Fantastic post.
    Thanks For Sharing such an informative article, Im taking your feed also, Thanks.album-ds-crack

    ReplyDelete
  52. Etools For Language Teachers: Using Autocrat To Create Personalized Birthday Cards >>>>> Download Now

    >>>>> Download Full

    Etools For Language Teachers: Using Autocrat To Create Personalized Birthday Cards >>>>> Download LINK

    >>>>> Download Now

    Etools For Language Teachers: Using Autocrat To Create Personalized Birthday Cards >>>>> Download Full

    >>>>> Download LINK yJ

    ReplyDelete
  53. Many thanks for sharing this informative and interesting post with us. anvsoft-syncios-data-recovery-crack/

    ReplyDelete
  54. Wow, amazing block structure! How long
    Have you written a blog before? Working on a blog seems easy.
    The overview of your website is pretty good, not to mention what it does.
    In the content!
    PhpStorm Crack
    Adobe Acrobat Pro DC Crack
    CCleaner Crack
    Hard Disk Sentinel Pro Crack

    ReplyDelete

  55. I am very happy to read this article. Thanks for giving us Amazing info. Fantastic post.
    Thanks For Sharing such an informative article, Im taking your feed also, Thanks.heavym-pro-crack/

    ReplyDelete
  56. A great offer, I just given this onto a partner who was doing a tad assessment on this. Winter Sale Jackets

    ReplyDelete