Site logo

        Google Workspace Services

        Google Workspace Services

        1. Services
        Services
        • Development
        • Training
          • Collaborating with Docs
          • Credits
          • Getting to grips with Sheets
          • Gmail Productivity Tips and Tricks
          • Google Classroom Tips and Tricks
          • Google Workspace Tips and Tricks
          • Working in Google Drive
        Sign in with Google

        Or

        We won't share your email address with any third-parties.
        Please see our Privacy Policy for further information.

        About Us

        G Suite Tips is provided by the team at Overdrive. We’re passionate about Google Workspace and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

        Latest Tips

        • How to Download Images from Google Docs

          Have you ever tried downloading or saving an image from a Google Doc? Here’s an easy way to save images from any document, with just a few clicks. Trying to save an image from a Google Doc can be frustrating because there’s no download button that allows you to save it straight away. Fortunately, we found a couple of workarounds. Method one: Download all images To get started, open the Google Doc and from the menu bar go to File > Download > Web page. Google Docs will compile all the images (and other elements from the document) in a single folder. From there, you can extract the images you need. Method two: Save a single image For some, this method might be easier since you won’t need to download all the images from a document. However, this method is not recommended if you’re working with a sensitive document, since it will require you to make it public for a brief period of time. To get started, open the document and go to File > Share > Publish to web. Once published, open the public link to the document and right-click the image you want to save. Choose “Save image as” to download it. You can then go back to File > Share > Publish to web and unshare the document. If you’re looking for a way to save or download images from any Google Drive files, including Slides, check out our tip about how to edit and extract images from Google Drive files. If you have any Google Docs tips that would help others, feel free to share them with our Workspace Community .

        • How to count characters in Google Sheets

          When you’re using Google Sheets for work or school, you may have to deal with text data. Unlike Google Docs, the spreadsheet app from Google doesn’t have a built-in character counter. However, there’s a dedicated Google Sheets function to count characters. Counting characters in Google Sheets is easier than you may think. The LEN function can be used in many situations to count characters in a spreadsheet. Count all characters in a cell Type in the LEN function and make a reference to the cell you want to count. This method is used to count all characters, including letters, numbers, spaces, punctuation marks, etc. Example: =LEN(A2) Count characters and ignore spaces The LEN function counts all characters, including spaces. If you want the count to ignore spaces and punctuation marks, you can add the SUBSTITUTE function to the syntax; the main purpose of this function is to replace one character with another, so we’re using it in order to replace spaces and other punctuation marks with nothing. Example: =LEN(SUBSTITUTE(A3, " ", "")) Count all characters in a column The LEN function doesn’t work with a range of cells, but you can add the SUMPRODUCT function to sum up the characters in a range. Example: =SUMPRODUCT(LEN(A2:A9)) Remember that the LEN function counts all characters, including spaces. If you want removed spaces and punctuation marks, simply use the SUMPRODUCT function to add up the results from the counting column. Example: =SUMPRODUCT(B2:B9) If you still have questions about counting characters in Google Sheets, ask our community of Google Workspace power users!

        • How to send emails directly from Google Docs

          Google Workspace users (business users) can draft up and send emails right from a Google Docs document, without having to open Gmail. Google Docs is one of the most popular apps for document creation, editing, and sharing. Google has made it incredibly easy to share documents across platforms and collaborate on them in real-time. Moreover, Google Docs constantly expands to include new features, like the one we’re discussing today. This email feature included with Google Docs is perfect for those who like multitasking. It's a great way to speed up your productivity and keep track of the emails linked to a certain document. How to send emails from Google Docs 1. Open any Google Doc and click anywhere you want to start drafting an email. 2. Type in the at sign @ and click on Email draft from the drop-down. If you can’t see the email draft button, you can navigate to the Menu bar > Insert > Building blocks > Email draft. 3. Fill in the email template that appears, including the To, Subject and Message fields. 4. Once you’re ready to send the email, click the blue M icon. A pop-up window will open where you can preview your email before sending it; click Send. If your browser has disabled pop-up windows by default, you will be notified to enable them, at least for the Google Docs website. The email template will stay in the document even after you’ve sent the message; it’s up to you to keep it for the record or delete it. You will also find the emails sent from Docs in the Sent folder in Gmail. Keep in mind that replies won’t appear in the document, so you need to check Gmail for responses. This feature is available to all Google Workspace customers, including legacy G Suite Basic and Business customers. Personal Google accounts (@gmail.com) can’t use this feature. Are you going to make use of this feature? Let us know your thoughts on the Google Workspace community forum .

        © 2016-2021 Refractiv Limited. All Rights Reserved
        Powered by Overdrive
        • Tips
          • Drive
          • Gmail
          • Docs
          • Overdrive
          • Calendar
          • Sheets
          • Sites
          • Chrome
          • Contacts
          • Slides
          • Chat
          • Meet
          • Forms
          • Keep
          • More...
        • Community
          • Member lounge
          • Devops & Admin
          • Power User
          • Workspace Tools
          • User Productivity
        • Tools
          • Change Owner
          • Copy Folder
          • Filename Editor
        • Services
          • Development
          • Training
        • Add-on Apps
          • Website Builders
          • CRM Solutions
          • Backup Solutions
          • Admin and Security
          • HR Software
          • Productivity
        • Blog