Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Anyone who works regularly in Google Docs knows the pain:You paste content from the web, a PDF, an email, or another document—and suddenly your bullets have weird spacing, broken formatting, or mystery blank lines that refuse to go away. You try deleting them manually.You try changing line spacing.You even try Apps Script code others recommend… … Read more
Project source code https://github.com/lsvekis/Gemini-with-Apps-Script 🚀 6 Mini Projects You Can Copy, Learn From, and Use Today AI is transforming the way we work inside Google Workspace. Whether you’re building custom tools for Sheets, automating Gmail, or creating smarter Docs workflows, Gemini makes it possible to add real intelligence to your Apps Script projects with just … Read more
GitHub https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/summarizer 🌐 Building a Web Article Summarizer & Citation Extractor with Google Sheets + Gemini AI Have you ever wished you could drop a list of article URLs into Google Sheets and instantly get structured summaries — complete with titles, key quotes, named entities, and estimated reading time?In this exercise, we’ll create exactly that … Read more
If you’ve ever faced the challenge of translating a Google Doc, you know it can be tedious to copy-paste content into a translation tool. Luckily, Google Apps Script offers a seamless way to integrate translation right into your Google Docs. In this post, we’ll explore how to create a custom Google Apps Script function that … Read more
We’ve all been there. You sit down to write an email, only to find yourself staring at a blank screen, crafting the same basic message you send all the time. What a waste of time, right? Well, fret no more! Google Workspace for Gmail has a handy feature called templates that can be your secret … Read more
Google Docs is a powerful tool for creating and sharing documents online. One of its convenient features is the ability to easily create copies of documents with a simple URL trick. Additionally, you can also change the URL to preview the document. In this blog post, I’ll show you how to do both. Step-by-Step Guide … Read more
Book Source Code on GitHub https://github.com/lsvekis/Sheets-Custom-Formulas-Book Get the Best Selling Book Free for the next 4 days US https://www.amazon.com/dp/B0D59Q4J1T CAN https://www.amazon.ca/dp/B0D59Q4J1T 1 : Mastering Basic Custom Functions In this opening chapter, we introduce the foundational concepts of Google Apps Script for custom functions in Google Sheets. Begin by learning how to create simple functions that … Read more
– Event Name: GDSC Hacks 2024 – Location: University of Guelph, University Centre – Reynolds Walk, Guelph, ON N1G 1Y – Date: May 4th – Your Speaker Slot: 8:00pm – 8:30pm EDT – Session Title: Laurence Svekis: Apps Script for Google Workspace Thank you all to the organizaers and attendees of GDSC Hacks 2024, what an incredible event.
Unlock the Full Potential of Google Workspace with “Coding with Google Apps Script: A Step-by-Step Journey” – Free on Kindle for a Limited Time! Read the first 2 chapters Free at Amazon – Get your free Kindle version of the book today US https://www.amazon.com/dp/B0CXXLMMHQ Can https://www.amazon.ca/dp/B0CXXLMMHQ Over 200 Apps Script Coding Exercises here https://github.com/lsvekis/Coding-with-Google-Apps-Script/ In … Read more
Chapter 2: Essential Editing and Formatting Tools Advanced Text Formatting Options in Google Docs Building on the basics of document formatting, this chapter delves into the advanced text formatting options available in Google Docs. These features allow for more nuanced control over your document’s appearance, helping you to create professional and visually compelling documents. We’ll … Read more