When a Google Sheet is updated, copy the sheet and send the sheet name and ID via Gmail

Launch this workflow to connect Google Sheets !

■Overview

Do you find it time-consuming to manually copy a Google Sheets spreadsheet, create an email, and send it whenever you need to share updates with stakeholders? These routine yet important tasks not only take time but also carry the risk of human error, such as copy mistakes and missed notifications. With this workflow, you can fully automate everything from copying the sheet to sending a Gmail notification whenever a row in Google Sheets is updated, smoothly eliminating these challenges.

■Who is this template for?

Anyone who manually copies Google Sheets data as a backup after updating it
Team leaders who notify stakeholders of updates via Gmail each time and want to reduce the effort involved
Anyone who wants to automate the sheet duplication and sharing process and eliminate manual errors

■Benefits of using this template

Automatically copy the sheet and send an email notification when a row in the spreadsheet is updated, reducing the time previously spent on manual tasks.
Prevent human errors such as missed copies and notification mistakes caused by manual copy-and-paste work and email creation, improving operational accuracy.

■Flowbot steps

First, connect Google Sheets and Gmail to Yoom.
Next, select Google Sheets as the trigger, set the action to “When a row is updated,” and specify the spreadsheet you want to monitor.
Then, set up the Google Sheets “Copy sheet (tab)” action and specify the source spreadsheet and sheet.
Finally, set up the Gmail “Send email” action to send an email containing the ID and name of the sheet copied in the previous step.

※“Trigger”: An action that starts the flow. “Operation”: An action that performs processing within the flow after the trigger starts.

■Customizing this workflow

In the Gmail email-sending action, set the email addresses of the recipients you want to notify in To, Cc, and Bcc as needed.
You can freely edit the subject and body of the email. Insert information obtained in the previous step, such as the name or ID of the copied sheet, into the body to provide more specific notifications.

■Notes

‍‍Connect Google Sheets and Gmail to Yoom.
You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
Note that the shortest available trigger interval varies by plan.
For important notes when using Google Sheets as an app trigger, see “[App Trigger] Important Notes for Google Sheets Triggers.”

Check Out Similar Templates!

A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.

Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.

View template

Add order information to WooCommerce when a row is added in Google Sheets.

This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.

View template

Add a new tab to the Google Spreadsheet at the beginning of each month.

You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.

View template

Use OCR to extract text from PDFs and images uploaded to Box, then add the results to Google Sheets

Upload files to Box to automatically extract text with OCR and log it in Google Sheets. Reduce manual data entry time, prevent input errors, and keep your document management organized.

View template

Add a record to Notion when a row is added in Google Sheets.

In this workflow, simply adding a new row in Google Sheets automatically creates a corresponding record in Notion. This automation eliminates the need for manual data entry and dual management, ensuring consistency of information.

View template

Add a record to Salesforce when a row is added in Google Sheets.

This is a flow that adds a record to Salesforce when a row is added in Google Sheets. By referencing the registration details in Google Sheets, you can also register them in Salesforce, preventing manual errors and saving effort.

View template

About the Apps

Google Sheets

At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.

Related apps