Google Apps Script Tutorial: Letterhead in Google Docs

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

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

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

    Great video! Great channel. Here's a topic suggestion. I'm coming from Microsolf Word, where one has an endless set of custom "styles." I want to add this to Google Docs. I think I can figure it out myself using Apps Script, but maybe you want to do a video.

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

      Thanks for the suggestion. Since joining Google as an employee I don't publish any Google videos on this channels anymore.

  • @GenNextAnalyst
    @GenNextAnalyst 3 года назад

    THank you!

    • @saperis
      @saperis  3 года назад

      You're welcome!

  • @phillipwebb6315
    @phillipwebb6315 3 года назад

    Great content Chanel 👍🏻
    I use an app script to monitor gmail and create a google task using a reference number from the subject line. Would love to see a future video sharing this type of functionality.

    • @saperis
      @saperis  3 года назад

      That's an interesting use case! Thanks for sharing.

  • @jivkogurmanov117
    @jivkogurmanov117 3 года назад

    Great Content tank you this is amazing

    • @saperis
      @saperis  3 года назад

      Glad you enjoy it! 😀

  • @eArminCom
    @eArminCom 11 месяцев назад

    Thanks for great video. Do you have any tutrial how to creat a fullwidth (Auto fit) footer with no margins around the footer image using App Script?

    • @saperis
      @saperis  11 месяцев назад

      No, don't have such a tutorial.

  • @mehmetkaya4330
    @mehmetkaya4330 3 года назад

    Great! Thank you!!

    • @saperis
      @saperis  3 года назад

      You are welcome! 😀

  • @saikiranmorla9518
    @saikiranmorla9518 3 года назад

    I am waiting for your app script tutorials mam

    • @saperis
      @saperis  3 года назад

      Great! I usually upload at least one Google Apps Script video a week.

  • @eArminCom
    @eArminCom 11 месяцев назад

    That was amazing. Thank you! insertImage(0,logo) function adds a blank line after the image in the cell, and appenTable adds a blank line/paragraph before the image in the cell. How can I avoid that?

    • @saperis
      @saperis  11 месяцев назад

      I haven't encountered this issue so I have no definitive answers. What do the developer docs say? Have you checked Stackoverflow?

  • @rushabh99p
    @rushabh99p 3 года назад

    please teach how to set the row height in pixels in google docs via app script

    • @saperis
      @saperis  3 года назад

      Since there are no rows in Google Docs I'm guessing you want to know how to set the height of the table.
      In that case you could use DocumentApp.Attribute.MINIMUM_HEIGHT
      Check the documentation: developers.google.com/apps-script/reference/document/attribute

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

    Hello, is there a way to make a App Script to have a new Google Doc that is added to a folder to be emailed automatically?

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

      Yes, you could write a script that does that. I suggest you check the official documentation to find out how to use Apps Script to achieve your goal: developers.google.com/apps-script/reference

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

    Hi can you tell me how to access Google Docs via Apps Script? I have some 90 pages stuff I have to prepare. My requirement is that between page 10 and 89 I have to give odd pages Title X and even pages Title Y and No title to 3-4 pages at random ....... Same goes with footer. I have to give page number in the footer and leave 3-4 pages with no page number. How can I access header and footer section of each page via code ?

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

      Check the reference guide. Note how you can either set header/footer or get header/footer with Apps Script.
      developers.google.com/apps-script/reference/document/document

  • @immi1498
    @immi1498 3 года назад

    Can you help making a simple project
    In Google Sheet I add value in sheet1 8-9 cells +mail, cc, bcc and mail get sent in pdf form then all value get stored in sheet2 for my views

    • @saperis
      @saperis  3 года назад +1

      Watch this video to get you started with sending out emails: ruclips.net/video/oq-DIAHbTLM/видео.html

  • @muhammedaadhil5645
    @muhammedaadhil5645 3 года назад

    Thank you for this great video :) I would like to have something work when you edit the Google sheet table data which then updates the Google docs table data automatically without opening the Google docs. Is that possible?

    • @saperis
      @saperis  3 года назад +1

      Yes, it's possible that the Google Docs is updated in the background without it being opened by a human or the browser.

    • @muhammedaadhil5645
      @muhammedaadhil5645 3 года назад

      @@saperis waiting for your tutorial 🤗

    • @saperis
      @saperis  3 года назад

      I can't promise I'll make such a tutorial but you never know.

  • @kanagarajkraj-vh1fo
    @kanagarajkraj-vh1fo 3 года назад

    In google sheet I have a range that refer to an external data. This external data is refreshed every one minute . So the data is changing every one minute. I need to copy the content of one fix cell in that range into another cell every one minute, each time copy to a different cell.
    Example: cell A1 has the content that refer to an external data. Cell A1 is updated every one minute. At first A1= 100, I need it to be copied to cell B1 (so B1=100); one minute later, A1=101, I need it to be copied to B2 (so B2=101) and so on
    how to make this in google sheet??

    • @saperis
      @saperis  3 года назад

      We don't do any coding for our viewers or customers.
      But here is a video that can help you with your goal: ruclips.net/video/xmtwWKYLJHs/видео.html

  • @easysolutionsforcomputer.4592
    @easysolutionsforcomputer.4592 3 года назад +1

    Maam which operating system do you run in your pc

    • @saperis
      @saperis  3 года назад +1

      I use a Mac and usually always update as soon as the newest Mac operating system is released.

    • @easysolutionsforcomputer.4592
      @easysolutionsforcomputer.4592 3 года назад +1

      Oh i think now its time to ubdate your mac operating system to windows operating system

  • @elsconsultancyandmanagemen4865
    @elsconsultancyandmanagemen4865 3 года назад

    Please add a footer

    • @saperis
      @saperis  3 года назад

      Well, I shared my know how now it's time to you to practice. 😀
      Check the documentation to see how to add a footnote.