Google スプレッドシートとYoomの連携イメージ
How to Integrate Applications

2025-05-28

How to Automatically Copy Data Between Different Google Sheets

y.matsumoto

Google Sheets is a powerful tool for managing and organizing data, However, there are times where you need to link information across multiple sheets, such as "updating data from the master sheet to related sheets" or "copying data to separate analysis sheets". You can do this manually but it involves the tedious copy and paste work and risk of errors. This only becomes more challenging when your data gets larger or when real-time updates are required.

Imagine if: 

  • You can automatically copy data from one sheet to another whenever a row is added
  • All your important info is synced across sheets

With Yoom, it’s easy to automate these repetitive tasks without a single line of code. Whether you are managing project tasks, collecting data, or streamlining workflows, Yoom can make it possible to do it all automatically.

Meet Yoom: No-Code Automation

Yoom is a next-generation no code automation tool that lets you connect and automate tasks between your favorite apps. Yoom makes automation accessible to everyone.

  • Connect with apps like Google Sheets, Gmail, Slack and more.
  • Use automation templates - no technical set up required
  • Boost productivity and reduce human errors

No need to go through complex set up and IT jargons, Yoom keeps things simple and visual. You can build your automation workflows with just a few clicks, saving hours of time and stress from repetitive work. 

Sign Up for Yoom Here – Quick and Easy in Just 30 Seconds!

In this guide, you’ll learn the step by step process of how to use Yoom to automatically sync among sheets in Google Sheets.

For Those Who Want to Try It Right Away

Yoom offers a ready-made template for easy setup. Click the ”Try it” button to get started!

We’ll also walk you through the step-by-step process of creating this automation flow later in this article.

What You Can Do with Google Sheets & Yoom

Managing data from multiple resources in Google Sheets can become complicated.
To solve this issue, here are different automation templates you can use to help yourself!

Just click on “Try it” button to use the ready-made templates.
Setup takes only a few minutes :)

Record Data from Database/CRM Tools to Google Sheets

When a new page is created in Notion, automatically create a record in Google Sheets and copy it..

Recommended for those who want to organize data from different platforms.

Sync Form Responses to Google Sheets

Automatically record and copy response from Form tools to Google Sheets, with data copied to another sheet. 

Ideal for those who want to separate results from analysis sheets and reduce errors.

Record & Copy Email Data to Google Sheets

When an email is received, extract key information, such as the email body and subject, and automatically add them to Google Sheets, then copy to another sheet.

Perfect for those who want to track customer inquiries or follow-ups without missing important details.

Let’s Create a Flowbot to Auto Copy Rows Between Google Sheets

Let’s walk through the Flowbot of  how to automatically copy the data from Google Sheets to another sheet when a new row is added.

Setup time: 5 minutes

What You’ll Need

  • A free Yoom account
  • Access to Google Sheets

If you do not have a Yoom account yet, you can create one using this registration form.

Setup Overview

  • Connect Google Sheets with Yoom
  • Copy the template
  • Set up the Google Sheets trigger and actions 
  • Activate the Flowbot

Step 1: Register Google Sheets in My App

〈Preparation〉

Before connecting, make sure you’ve created a Google Sheets table. cFor this example, we’ve prepared a sheet summarizing task information (see the image below).
Tip: Create your Google Sheets table before integrating with Yoom, as it may not sync properly if done afterwards. 

Registering Google Sheets in My App

Click the "+ Add" button in the My App screen.Search for Google Sheets and select from the list.

Log in with your Google account, and click Continue.

On the next screen, click "Continue" again to grant access.

This completes the integration of Google Sheets with My App!

Step 2: Copy the Template

Click the "Try it" button to copy the pre-built template into your project.

This template will be copied to your “My Project”. Click "OK" and give this Flowbot a name to recognize.

Step 3: Setup the Google Sheets Trigger

Click on the app trigger, "When a row is added."

Give your trigger a name (anything you like). Select your Google account,  and check the default settings. If there are no issues  click "Next".

Set your trigger interval (frequency of sync) on how frequent Yoom checks Google Sheets for updates.
Note: The trigger interval varies on your Yoom plan. Be sure to check your current plan’s limit.

Choose the spreadsheet ID.(Select the sheet you created during the preparation from the dropdown).

Similarly, select the sheet ID from the available options.

Then set the table range (start to end) and the column with unique values .Check the annotations for guidance and adjust these settings to match your Google Sheets setup.

Once you’ve completed the settings, try adding a record in Google Sheets and run a test.

If successful, you’ll see items displayed below the "Retrieved Values”.
You’ll use these data in the following steps, so check the details are correct!ngs.
Reference: For more details on retrieved values and how to set it up, see the guide here.

Step 4: Configure Google Sheets Actions to Add a Record

Next, click on the "Add a record" action.

Give your action a name (anything you like). Select your Google account again, and check the default settings. If there are no issues, click "Next".

Now setup the fields to automatically pull data from Google Sheets you set in the trigger. 

📚 Reference: For more details on table range settings, check this guide. .Once the setup is complete, run a test.

Map the values for the new record as shown below.

For example:

  • task (Excl trigger)→ task 111 (Excel action)
  • deadline (Excel trigger) → deadline 2025/05/10 (Excel action)

This will pull the “task” from the Excel trigger and include the info in the Excel action. Whenever data is added to the source Google Sheet, it will automatically be copied to the destination sheet you specified.

Once the setup is done, run a test.
If successful, you’ll see the updated data reflected in Google Sheets.
Check if the data is correct and click “Save”.

Step 5: Activate the Flowbot

Toggle the Trigger "ON” to activate your flow!
Add a test record in Google Sheets to see if the specified sheets get updated properly. 

That’s it!
Your Google Sheets is now automatically synching with the specified sheets :)

More  Automation Ideas  Using Google Sheets

Google Sheets isn’t just for data entry. It can also be used as a trigger for automating flows based on updates on your sheets.
Here are some ready-made templates you can use to connect Google Sheets with other tools.

You can link with other tools when a row is added or updated, or add information from other tools to Google Sheets.

Summary

Now you know  how to automatically copy data between sheets in Google Sheets.
Manually copying and pasting between tools can be time-consuming and error-risky.

This is where no-code automation tools like Yoom can make a difference. You don’t need specialized technical skills. 

Ready to simplify your workflow? Sign up for Yoom and try it today!

Create a Yoom account for free

The person who wrote this article
y.matsumoto
Until now, I have experienced sales and sales office work in the human resources industry. Based on my experience in my previous job, I feel that the problems faced by various companies can be reduced by “automating operations.” Through Yoom, we will continue to send out information on a daily basis so that we can solve your problems even a little bit!
Tags
Google Sheets
Automation
Automatic
Integration
Related Apps
App integration
No items found.
What is Yoom hyperautomation?
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated.
With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Don't Just Connect Apps—Automate Everything
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.

Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
Learn more about Yoom
Helpful Materials
I understand Yoom! 3-piece set of materials
Download materials
Understand in 3 minutes! Yoom service introduction materials
Download materials
Find out by Before After! Yoom Case Study Collection
Download materials
See a list of useful materials