Google Workspace how-to guides

This page includes guides and resources that can help you learn how to create automations using the activities in this package.

Tutorials

Step-by-step guides on how to create automations from scratch.

Tutorial	Description	Application
Merge multiple sheets into a new summary spreadsheet	Concatenate data from multiple sheets into one new Google Sheet.	Google Sheets
Notify me by email when a new file is created	When a file is added to a Google Drive folder, notify me by email and send me a link to the file.	Google Drive, Gmail
Notify me on Slack when an email is received in Gmail	When an email is received in Gmail, notify me through a message in Slack.	Google Drive, Slack

Studio Web templates

Preconfigured projects that automate common scenarios. You can use a template as is or you can use it as a starting point for a new project to avoid starting from scratch. Templates are also a good way to learn how to automate.

Here are some templates with activities from this package available in Studio Web:

Template	Description	Activities
Table Data Extraction for Sales Opportunities to Google Sheets	Take data from rpasamples.com/opportunities, write it to a new Google Sheets spreadsheet, and send the spreadsheet to your Inbox via Gmail.	Create spreadsheet, Write range, Download file
Upload email attachments from Gmail to Google Drive	When a new email arrives in Gmail, save its attachments to a Google Drive and then move the email to a different folder.	Email received, Download email attachments, Move email
Extract the first 1000 Gmail Emails from the current month in a new Google Sheets report	Extract the latest 1000 email from Gmail from the current month and creates a Google Sheets Report, storing the sender, received date, subject, CC, body, and number of attachments.	Create spreadsheet, Write range, For each email
Merge PDF files from Google Drive folder	Merge all PDF files in a Google Drive folder into one PDF file and upload it to a folder.	Get file/folder list, Upload files