Google Workspace

Coordinate project work across Google services by recording progress in Sheets, scheduling recurring meetings, sharing files through Drive, and emailing status updates. A weekly overview helps check upcoming meetings and unread items.

• Reviewing meetings and unread items at the start of the week
• Recording project progress in Sheets
• Scheduling recurring team standups

Set up change notifications for Google Drive files or folders, with update events delivered to a Pub/Sub topic, a message destination. The workflow also covers listing subscriptions and renewing them before they expire.

• Setting up notifications for Drive changes
• Checking registered notification subscriptions
• Renewing subscriptions before they expire

Create a Google Shared Drive, add members with assigned roles, and check the member list. Use it to set up a shared space for a team or project.

• Setting up a shared drive for a new project
• Adding members with assigned roles
• Checking the members of a shared drive

Review unfinished work in Google Tasks by listing task lists and checking task due dates. Identify overdue items that need attention and prioritize them to decide which outstanding tasks to address first.

• Find unfinished tasks that are past due
• Review due dates in a task list
• Prioritize overdue work

Manage sales work across Gmail, Calendar, Sheets, and Drive. Prepare for client calls, record deal updates, turn follow-up emails into tasks, share proposals, and get a weekly summary of the sales pipeline.

• Prepare for client calls by reviewing attendees and agendas
• Record deal updates in a tracking spreadsheet
• Turn follow-up emails into tasks

Create an expense tracker in Google Sheets with columns for date, category, description, and amount. Add an initial expense entry, then give a manager read-only access to the spreadsheet.

• Creating a new expense tracking spreadsheet
• Adding column headers and an initial expense entry
• Sharing expense records with a manager for viewing

Reschedule a Google Calendar meeting and notify every attendee of the change. The workflow finds the event, checks its details, and updates its start and end times with the specified time zone.

• Moving a meeting to a different time
• Notifying all attendees of a schedule change
• Checking event details before rescheduling

Retrieve responses from a Google Form and review them in a table. The workflow covers listing forms when the form ID is unknown, checking form details, and fetching the submitted responses.

• Reviewing survey responses in a table
• Checking a form when its ID is unknown
• Reviewing form details alongside submitted responses

Export data from Google Sheets as CSV for local backups or further processing. The recipe covers checking spreadsheet details, exporting through Google Drive, and reading a specified sheet range directly in CSV format.

• Keeping a local CSV backup of spreadsheet data
• Exporting spreadsheet data for further processing
• Reading a selected sheet range as CSV

Export names, email addresses, and phone numbers from the Google Contacts directory into Google Sheets. The workflow adds column headings and contact rows to a specified spreadsheet, creating a contact list for reference.

• Exporting directory contacts to a spreadsheet
• Listing names, email addresses, and phone numbers together
• Adding contact rows to a designated sheet

Find a Google Docs document by name, give a collaborator editing access, and email them its link. This skill connects document sharing and notification in one workflow so the recipient can open the shared document.

• Sharing a project brief for review
• Giving a collaborator editing access
• Emailing a link after sharing a document

Share a Google Drive folder and its contents with collaborators. Find the folder by name, assign editing or viewing permissions to individual people, and check the resulting permissions after sharing.

• Share project materials with team members
• Give stakeholders viewing access to a folder
• Check folder permissions after sharing

Create a feedback form in Google Forms, retrieve its respondent link, and send that link through Gmail. The workflow connects form creation with an email invitation asking recipients to share feedback.

• Create a form for event feedback
• Retrieve the form's respondent link
• Email participants a feedback request

Send a team announcement through Gmail, then post a notice in a Google Chat space. Use email for the announcement details and a chat message to ask teammates to check their inbox.

• Announce policy changes by email and chat
• Send an important update through both channels
• Ask a team in Google Chat to check an announcement email

Find Google Drive files that consume the most storage by listing 20 files in descending storage usage order. Review their names, sizes, types, and owners to identify candidates for archiving or moving.

• Checking which files use the most Drive storage
• Identifying files to archive or move
• Reviewing large files and their owners

Review Google Meet attendance by finding a recent conference, listing its participants, and retrieving their connection sessions. Follow the steps to check who joined a meeting and how long each person attended.

• Check who attended a recent meeting
• Review how long a participant attended
• Inspect connection sessions for a specific participant

Find Gmail messages that match a search condition, apply a chosen label, and archive them by removing the inbox label. Use this workflow to organize messages such as notifications from a specific sender.

• Organize notification emails from a specific sender
• Apply a chosen label to matching messages
• Archive labeled messages to clear the inbox

Invite several people to an existing Google Calendar event using a list of email addresses. The workflow retrieves the event, updates its attendees, sends update notifications, and checks the event again to verify the changes.

• Inviting several colleagues to an existing meeting
• Adding attendees and sending event update notifications
• Checking the attendee list after an update

Review this week’s Google Calendar agenda, check available time, and add events such as focused work sessions. Review the updated agenda afterward to see how the new blocks fit into the week.

• Reviewing this week’s agenda and available time
• Adding focused work sessions to calendar gaps
• Checking the schedule after adding events

Create a Google Slides presentation with a chosen title and share it with a teammate as an editor. This recipe provides the commands for setting up a presentation before collaborative work begins.

• Setting up a quarterly review presentation
• Sharing a new presentation with an editor
• Preparing a presentation for team collaboration

Prepare an incident review by creating a Google Docs report template, scheduling a review meeting in Google Calendar, and notifying the team through Chat. The template covers the summary, timeline, root cause, and action items.

• Preparing a report template after an incident
• Scheduling a team incident review
• Announcing the review meeting in Chat

Manage Google Meet meeting spaces and conference records through the gws command. Create or update spaces, end active conferences, and work with meeting records and related participants, recordings, smart notes, and transcripts.

• Creating or updating a Meet meeting space
• Finding conference records from past meetings
• Working with participant, recording, and transcript information

Use shared guidance for gws CLI authentication, command structure, and output formats. It covers checking requests without calling an API, retrieving multiple pages of results, handling files, and protecting sensitive information.

• Set up authentication for gws
• Choose JSON, table, YAML, or CSV output
• Check requests before calling an API

Turn a Gmail message into a new Google Tasks entry, using the email subject as the title and its short preview as notes. Add it to the default task list or specify another list.

• Turning an email request into a task
• Keeping an email subject and preview in a task
• Adding email tasks to a specific task list