Discover Google Workspace (Drive, Docs, Sheets)

Read the entire course carefully in one sitting (approximately 15 minutes). As you progress, pause after each paragraph and mentally connect the described feature to a real task you performed or expect to perform soon. After finishing, open your Google Workspace account and replicate at least three concrete examples (for instance: create a shared drive, write a short Doc with comments, build a simple Sheet using SUM and a chart). Keep your practice files; they will be reused during the upcoming quiz.

Google Workspace is the professional suite of cloud productivity applications offered by Google. For any digital marketer, mastering this suite is essential because it allows you to store assets, write and share documents, and build data dashboards from any device without installing software. You already created a dedicated Gmail address in the previous workshop; that single account is the key that unlocks Drive, Docs, and Sheets, so you do not need any additional licences for what follows.

Google Drive is the central storage space. The moment you sign in at drive.google.com, the interface shows a left-hand navigation panel and a large central pane. The two most frequently used areas are “My Drive” and “Shared drives”. “My Drive” contains files you own personally, while “Shared drives” act like team folders where ownership is transferred to the workspace, not to an individual. This distinction matters when someone leaves the project, because assets in a shared drive remain available to the rest of the team.

Inside Drive you can create folders exactly as on a hard disk. Right-click inside any area, choose “New folder”, name it clearly (example: “Content-Calendar-2024”), and press Create. You can drag and drop files from your computer, or use the “New > File upload” menu. Supported formats include images (JPG, PNG, GIF), videos (MP4, MOV), presentations (Microsoft PowerPoint, Google Slides), spreadsheets (Microsoft Excel, Google Sheets), and compressed archives (ZIP). Everything counts against the 15 gigabytes of free storage offered by the standard account. A marketing campaign often needs large video files, so plan your space: archive raw footage offline once the final edit is approved.

Managing permissions is critical. Any file or folder can be shared by right-clicking and selecting “Share”. Three roles exist: Viewer (read only), Commenter (cannot edit but can leave comments), and Editor (full rights). Example: when outsourcing a copy-writing task you may grant the freelancer Editor access to a single Google Doc but only Viewer access to the strategy folder. To prevent accidental public leaks, always keep “General access” on “Restricted” unless you explicitly want anyone with the link to open the content. Remember that changing the folder permission cascades to all items inside that folder.

Drive also integrates a powerful search bar at the top. You can type keywords, file types, or owners. Typing “type:sheets utm” instantly lists every spreadsheet containing “utm” in its name or body. This habit saves precious minutes when deadlines approach.

Version management happens automatically. Every time you edit a document, Drive keeps older versions. Right-click a non-Google file (for example a delivered Adobe Photoshop PSD) and choose “Manage versions” to upload a corrected version while keeping the original. For native Google files (Docs or Sheets) the mechanism is called “Version history” and is accessed inside the editor, but the principle is similar: you can label milestones such as “Client-approved” and restore them later.

Now let us focus on Google Docs, the online word processor. Open a new document via “New > Google Docs”. The blank canvas looks familiar if you used Microsoft Word, but several cloud-specific functions boost collaboration:

- Real-time co-editing: as soon as you share the document with colleagues, coloured cursors display who is typing where. Up to 100 simultaneous editors are allowed. Example: during a brainstorming session your traffic manager can draft headline ideas while the SEO specialist refines meta descriptions in the same file.
- Comment threads: highlight any text, click the comment icon, and write feedback such as “Add citation”. Mention someone with @username; they receive an email notification and can reply or mark the thread “Resolved”. This eliminates long email chains.
- Suggested edits: switch to “Suggesting” mode. New text appears in green, deletions in strikethrough, and the owner can accept or reject each suggestion. A junior copywriter can thus propose changes without touching the original.
- Integrated citations and explore: click “Explore” (bottom-right) to search the web and insert references without leaving the document—useful when you need quick statistics for a blog post.
- Templates: under “File > New > From template” you find brochures, meeting notes, or project proposals. For digital marketing, start from the “Newsletter” template to structure email content consistently.

Basic formatting commands—headings, bold, numbered lists—sit on the toolbar. For accessibility, always use structured headings (Heading 1, Heading 2) instead of manually resizing fonts. Search engines value this hierarchy when you later export the text to a webpage.

Docs also allows exporting under “File > Download”, with options including Microsoft Word (DOCX) and Portable Document Format (PDF). Example: send the PDF to a client who will not edit, or the DOCX if they prefer desktop revisions.

Moving on to Google Sheets, the spreadsheet tool indispensable for campaign metrics, budget tracking, and performance dashboards. Launch a new sheet via “New > Google Sheets”. The interface displays rows numbered 1, 2, 3… and columns lettered A, B, C… The intersection forms a cell, referenced like A1. At the bottom, sheets tabs let you organise multiple tables in one file.

Data entry feels like Microsoft Excel, yet Sheets adds cloud collaboration features identical to Docs. Multiple people can input figures simultaneously, and you can revert via “Version history > See version history”. Always label checkpoints, for example “Before Black Friday import”.

Core spreadsheet concepts:

- Formulas start with “=”. Typing =SUM(B2:B10) returns the total of cells B2 through B10.
- Basic functions to remember: SUM (totals), AVERAGE (mean), COUNT (number of entries), MIN and MAX (smallest and largest), CONCATENATE (joins text), and TODAY (current date).
- Marketing-specific examples: to calculate click-through-rate (CTR) in cell D2 when clicks are in B2 and impressions in C2, write =B2/C2. Format D2 as percentage with one decimal place using the toolbar.
- Conditional formatting: select column F (Conversion Rate), cho... (download to read the rest 👇)