Google Sheets is a powerful tool for managing and organizing data. However, there are times when 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 a 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 setup required
Boost productivity and reduce human error
No need to go through a complex setup and IT jargon, 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.
■Overview Using the "When a row is added in Google Sheets, copy it to another sheet" workflow makes it easy to maintain data consistency. It eliminates the need for manual copying between sheets, improving work efficiency.
■Recommended for ・Those who manage data and share information using Google Sheets ・Those who want to quickly aggregate and link data using multiple sheets ・Those who feel challenged by double management and errors due to manual input or copy-pasting ・Those who want to quickly share the latest data with other members or teams ・Those aiming to streamline data addition tasks and reduce working time ・Those who want to reduce the effort of manual data entry and operate sheets more smartly
■Notes ・Please link Google Sheets with Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
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 the “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, it automatically creates a record in Google Sheets and copies it.
Recommended for those who want to organize data from different platforms.
When a page is created in Notion, add a record to Google Sheets and copy it to another sheet.
■Overview The workflow 'When a page is created in Notion, add a record to Google Sheets and copy it to another sheet' automates data reflection across multiple sheets. It reduces input work when creating pages and streamlines information management.
■Recommended for ・Those who manage information or share knowledge using Notion ・Those who use multiple Google Sheets for distributed data management and sharing ・Those who spend a lot of time on daily data registration tasks and want to proceed with work more quickly ・Those who face trouble with manual page additions or data transcription errors ・Those who want to collaborate with teams or other departments via Google Sheets ・Administrators or business personnel who want to manage and operate data efficiently
■Notes ・Please link both Google Sheets and Notion with Yoom. ・Triggers can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan. ・Branching is a feature (operation) available in plans above the mini plan. In the case of the free plan, the operation of the flow bot set will result in an error, so please be careful. ・Paid plans such as the mini plan offer a 2-week free trial. During the free trial, you can use restricted apps and features (operations).
■Overview By using the workflow "When there is a response in Google Forms, add a record to Google Sheets and also add it to another sheet", the input content to the form is automatically transferred to multiple sheets. This can reduce manual data entry and minimize the risk of recording errors.
■Recommended for ・Those who use Google Forms for surveys or application acceptance ・Those who want to consolidate and manage Google Forms response data in Google Sheets ・Those who want to reflect the same information on multiple sheets to simplify management and aggregation ・Those who are manually transferring data and aim to improve work efficiency and reduce man-hours ・Those who want to visualize the processing of form responses clearly, such as event applications or internal applications ・Those who use different sheets in Google Sheets for each department or person in charge
■Notes ・Please link both Google Forms and Google Sheets with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan. ・For how to obtain the response content when using Google Forms as a trigger, please refer to the following. https://intercom.help/yoom/en/articles/6807133
■Overview The workflow 'When there is a response in Jotform, add a record to Google Sheets and also add it to another sheet' allows you to smoothly reflect collected data in Google Sheets. By automatically adding to multiple sheets, daily record management becomes easier.
■Recommended for ・Those who manage surveys or application forms using Jotform ・Those who want to organize and aggregate form response data in Google Sheets ・Those responsible for tasks that require data to be quickly reflected in multiple sheets ・Those who feel burdened by manual sheet transcription or data copying ・Companies or teams that want to quickly share response content with stakeholders ・Those who want to efficiently add data to each sheet to prevent information update omissions ・Those who use Google Sheets as a project management tool or database
■Notes ・Please link both Jotform and Google Sheets with Yoom. ・For Jotform's Webhook settings, please refer to the following. https://intercom.help/yoom/en/articles/8105581
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.
When you receive an email in Gmail, add a record to a Google Spreadsheet and copy it to another sheet.
■Overview The workflow 'When an email is received in Gmail, add a record to Google Sheets and copy it to another sheet' automatically reflects the content of received emails in a spreadsheet. It allows you to manage information across multiple sheets, reducing the effort of recording tasks.
■Recommended for ・Those who receive many emails daily in Gmail and want to record and manage their content ・Those who want to consolidate email information in Google Sheets but find manual input and management cumbersome or error-prone ・Those who want to organize information by dividing it into multiple spreadsheets or tabs ・Those who want to quickly share information within the company or team when an email is received ・Those who have spent a lot of time on email transcription tasks but want to process them more quickly
■Notes ・Please link Gmail, Google Sheets, and Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
■Overview The workflow "When an email is received in Outlook, add a record to Google Sheets and copy it to another sheet" automatically records the content of received emails. It reduces the effort of manually transferring data and makes information management easier.
■Recommended for ・Those who want to manage the content of emails received in Outlook using Google Sheets ・Those who want to streamline work and quickly transfer and aggregate information ・Those who want to prevent duplicate data entry while simultaneously reflecting information in each sheet ・Those who want to quickly reflect information generated from emails in management ledgers, progress tables, and business reports ・Those who use Google Sheets for business management but want to reduce errors and burdens from manual input
■Notes ・Please link both Outlook and Google Sheets with Yoom. ・You can select the trigger activation interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan. ・Microsoft365 (formerly Office365) has a home plan and a general corporate plan (Microsoft365 Business), and if you are not subscribed to the general corporate plan, authentication may fail.
■Overview Using the "When a row is added in Google Sheets, copy it to another sheet" workflow makes it easy to maintain data consistency. It eliminates the need for manual copying between sheets, improving work efficiency.
■Recommended for ・Those who manage data and share information using Google Sheets ・Those who want to quickly aggregate and link data using multiple sheets ・Those who feel challenged by double management and errors due to manual input or copy-pasting ・Those who want to quickly share the latest data with other members or teams ・Those aiming to streamline data addition tasks and reduce working time ・Those who want to reduce the effort of manual data entry and operate sheets more smartly
■Notes ・Please link Google Sheets with Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
Before connecting, make sure you’ve created a Google Sheets table. For 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.
When a row is added in Google Sheets, copy it to another sheet.
■Overview Using the "When a row is added in Google Sheets, copy it to another sheet" workflow makes it easy to maintain data consistency. It eliminates the need for manual copying between sheets, improving work efficiency.
■Recommended for ・Those who manage data and share information using Google Sheets ・Those who want to quickly aggregate and link data using multiple sheets ・Those who feel challenged by double management and errors due to manual input or copy-pasting ・Those who want to quickly share the latest data with other members or teams ・Those aiming to streamline data addition tasks and reduce working time ・Those who want to reduce the effort of manual data entry and operate sheets more smartly
■Notes ・Please link Google Sheets with Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
This template will be copied to your “My Project”. Click "OK" and give this Flowbot a name to recognize.
Step 3: Set Up 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 frequently Yoom checks Google Sheets for updates. It can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. We recommend setting the trigger to the shortest activation interval available for your plan.
⚠️ Note:
The trigger interval varies depending 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 running a test.
If successful, you’ll see items displayed below the "Retrieved Values”. You’ll use this data in the following steps, so check the details are correct.
📚 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, set up the fields to automatically pull data from the Google Sheets you set in the trigger.
📚 Reference: For more details on table range settings, check this guide.
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 syncing 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.
Add a record to Salesforce when a row is added in Google Sheets.
■Summary When you manage tasks in Asana and copy their contents to Google Sheets to create progress tracking sheets, do you find manual double entry cumbersome? Manual transcription can also cause input errors and missed updates. By using this workflow, when a new task is added to Asana, information is automatically added to the specified Google Sheet, improving the efficiency of task management.
■Recommended for ・Those who manage tasks using both Asana and Google Sheets ・Project managers who find double entry and transcription of task information burdensome ・Those who want to eliminate manual input errors and missed updates to improve data accuracy
■Notes ・Please connect Yoom with both Asana and Google Sheets. ・You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest available interval varies by plan.
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-prone.
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!
I have previously gained experience in sales and sales administration within the human resources industry. Based on my past experience, I have realized that the challenges faced by various companies can be alleviated through "automation of operations." Through Yoom, I will continue to share information daily to help address your concerns as much as possible.
.avif)
