Canva - Data Merge using Google Sheets and Slides

Поделиться
HTML-код
  • Опубликовано: 7 фев 2025

Комментарии • 48

  • @LaurenHearts1D016
    @LaurenHearts1D016 Год назад +2

    Just used this method for my wedding invitation envelopes instead of hand writing all the names and addresses! Thank you! You made it so easy to follow along

  • @Helen-dk8nx
    @Helen-dk8nx Год назад +4

    You have no idea how helpful this was. Seriously, you just saved me a MONTH of work. I'm using this process to make data cards to populate a HUGE timeline at our local historical society. Now I can do them all in like 5 minutes!! AMAZING!! THANK YOU!!!

  • @Nowittyusername
    @Nowittyusername Год назад +2

    This is genius. Sheer genius! Thanks so much - saved a HEAP of time and I even took it one step further and found how to download a new font to my Google platform to match the one from Canva which I really wanted. I cannot stress enough how helpful this is.

    • @missbeautyaddict07
      @missbeautyaddict07 Год назад

      Would you mind sharing how you did so? I am needing to do this as well!

  • @seanschofield8548
    @seanschofield8548 2 года назад +4

    This was incredibly helpful and worked like a charm. Thank you for posting!

  • @metin.turgay
    @metin.turgay 2 года назад +1

    Helpful! Worked like said! Thank you so much Steven

  • @sumaiyamoola6348
    @sumaiyamoola6348 2 года назад +2

    Thank you - this was such a good tutorial. Worked really well.

  • @wasilaal-busaidi1061
    @wasilaal-busaidi1061 2 года назад +1

    Many many many Thanks. You saved my day. This is exactly what I need. Thank you again

  • @NancySimms-j2l
    @NancySimms-j2l Год назад +1

    LOVE this tutorial. Could this be used in duplex printing items such as a postcard?

  • @robertmontes1468
    @robertmontes1468 Год назад

    Thank you sir! Exactly what I was looking for!

  • @sheilamorrisonrealtor
    @sheilamorrisonrealtor 8 месяцев назад +1

    Thanks so much! Looking to do Name Badges created in Canva. My question is when I go to print the name badges how would I get them all on one sheet thanks again.

  • @kellismith6193
    @kellismith6193 2 года назад +1

    This was amazingly helpful!!! Thank you so much!

  • @appocalypse3012
    @appocalypse3012 2 года назад +1

    Thanks a lot brother 😍. This video is a gem stone

  • @me-td2pu
    @me-td2pu 2 года назад

    Perfect for what I needed- thank you!

  • @Dexxx-ff
    @Dexxx-ff 4 месяца назад

    I want to add image also which is in Excel sheet what should I do??

  • @dianatpretty
    @dianatpretty 2 года назад +2

    Thank you this was so helpful!!!!

  • @staciepiotrowski8303
    @staciepiotrowski8303 2 года назад +1

    Thank you for this!

  • @AnnaMartinkus
    @AnnaMartinkus 2 года назад +1

    Thank you for this! It is WONDERFUL!!! Quick question for you, each one is being created as an individual item - is there anyway to have one bulk group of PDFs?

    • @soneaf
      @soneaf  2 года назад

      There is a setting in autocrat to change it to a Single PDF. Its in setting number for when you are in autocrat editing the job settings

  • @susana_mpf
    @susana_mpf 4 месяца назад

    Love it. Quick question what if I just want to merge from row 24 to 46 from the specific sheet? Not the entire sheet? Let me know thx.

    • @susana_mpf
      @susana_mpf 4 месяца назад

      Found my own answer. ..;)

  • @designpopo5100
    @designpopo5100 2 года назад +1

    Thanks for post this content!

  • @amanzaidi6102
    @amanzaidi6102 Год назад +1

    @Steven, is there a way of getting all those into a single PDF instead of individual ones?

  • @Groupfitnesfanatic
    @Groupfitnesfanatic Год назад

    Is there a way to import a picture into the google slide. I have a bunch of graduating seniors that I want to import their picture, name and where they are attending college. The only thing I can't get to work is their picture.

    • @soneaf
      @soneaf  Год назад

      Yes you can add an image: groups.google.com/g/nv-autocrat-add-on/c/EYK0BONRxKI?pli=1

  • @willsobel2187
    @willsobel2187 2 года назад

    Is there a way to merge things to save into the same document? For example let's say I'm running business cards and I'm trying to print 3 for myself, 3 for a co-worker, and 3 for my boss. I want to fit them all on the same sheet of paper instead of printing 9 sheets.

    • @soneaf
      @soneaf  2 года назад

      You should be able to just repeat the same tags multiple times on a page. So page one would have on each card and so on

  • @rajlaxmiagarwalofficial
    @rajlaxmiagarwalofficial 2 года назад

    Hi, this was great. But can't we save each one as an individual png instead of pdf or a zip file?

    • @soneaf
      @soneaf  2 года назад +1

      This video is old... Canva now has its own Data merge built in

  • @TheDawch
    @TheDawch 2 года назад

    Can you output to a single pdf? And what happens if you choose google slides as the output?

    • @soneaf
      @soneaf  2 года назад +1

      Yes you can output all to a single pdf. If you choose slides, it outputs a slide for each record not a pdf.

  • @cynthiaaguilera8334
    @cynthiaaguilera8334 Год назад

    How can I add more than 1 tag to the document?

    • @soneaf
      @soneaf  Год назад

      You add as many as you like the same way you add one. Just make sure they have unique names form each other and the names match the headers.

  • @nicolasmcrespo
    @nicolasmcrespo 2 года назад

    Brother you can do this directly in Canva with lot creation

    • @soneaf
      @soneaf  2 года назад

      Brother , when I made this video that add on didnt exist.

    • @emilythomas5394
      @emilythomas5394 Год назад

      @@soneaf Also this is very useful for those broke students who cannot afford the Pro version of Canva so thank you. Brother.

  • @deewalsh9322
    @deewalsh9322 2 года назад

    autocrat doesn't come up in the ad ons?

    • @soneaf
      @soneaf  2 года назад

      I just looked... its still there. No sure why it's not showing up for you. That is super odd. I searched for it a few different ways as well and I see it in there.

    • @morganallen2545
      @morganallen2545 2 года назад

      you have to be in google sheets to see it

    • @soneaf
      @soneaf  2 года назад

      @@morganallen2545 Oh yes if you are looking for it in slides you will not find it there it is in Sheets.. Thanks Morgan !

  • @saramisak5652
    @saramisak5652 2 года назад

    I'm inputing it with Slides in the same way, but it keeps giving me an error message that I can't copy and paste tags. I retyped everything manually, but still receiving the same message. I'm not sure what to do

    • @soneaf
      @soneaf  2 года назад

      Would you mind sharing what you have going on. I can take a look and see if I can e work out the issue.

    • @celenamaranda3741
      @celenamaranda3741 2 года назад

      I’m having the same issue, was there a solution to this?

  • @arunbathini2545
    @arunbathini2545 5 месяцев назад

    how to add images